InstaQB

Home
Institutions
- Institutions
  
  Polytechnic Colleges
  
  Medical Colleges
  
  Arts & Science Colleges
  
  Universities
  
  Engineering Colleges
  
  Agricultural Colleges
  
  Research Institute
  
  Law Colleges
  
  Audiology and Speech Colleges
  
  Business & Management colleges
  
  Nursing colleges
  
  Hotel Management institutes
  
  Aeronautical Colleges
  
  Bachelor's Degree
Syllabus
Courses
Stateboard
- 12th Standard English Medium
  
  Maths
  
  Physics
  
  Chemistry
  
  Biology
  
  Computer Science
  
  Business Maths
  
  Economics
  
  Commerce
  
  Accountancy
  
  History
  
  Computer Applications
  
  Computer Technology
  12th Standard Tamil Medium
  
  உயிரியல்
  
  கணினி பயன்பாடுகள்
  
  கணினி அறிவியல்
  
  வணிகக் கணிதம்
  
  வணிகவியல்
  
  பொருளியல்
  
  கணிதவியல்
  
  வேதியியல்
  
  இயற்பியல்
  
  கணினி தொழில்நுட்பம்
  
  வரலாறு
  
  கணக்குப்பதிவியல்
  11th Standard English Medium
  
  Maths
  
  Commerce
  
  Economics
  
  Biology
  
  Business Maths
  
  Accountancy
  
  Computer Science
  
  Physics
  
  Chemistry
  
  Computer Applications
  
  History
  
  Computer Technology
  
  Bio - Zoology
  11th Standard Tamil Medium
  
  கணிதவியல்
  
  உயிரியல்
  
  பொருளியல்
  
  இயற்பியல்
  
  வேதியியல்
  
  வணிகக் கணிதம்
  
  கணினி அறிவியல்
  
  கணக்குப்பதிவியல்
  
  வணிகவியல்
  
  கணினி பயன்பாடுகள்
  10th Standard English Medium
  
  Mathematics
  
  Science
  
  Social Science
  
  9th Standard English Medium
  
  Mathematics
  
  Science
  
  Social Science
  
  8th Standard English Medium
  
  Mathematics
  
  Science
  
  Social Science
  7th Standard English Medium
  
  Mathematics
  
  Science
  
  Social Science
ICSE/ISC
- Class XII
  
  Mathematics
  
  Physics
  
  Accountancy
  
  Biology
  
  History
  
  Geography
  
  Psychology
  
  chemistry
  
  Economics
  
  Computer Science
  
  Political Science
  
  Business Studies
  Class XI
  
  Accountancy
  
  Chemistry
  
  Mathematics
  
  Biology
  
  Geography
  
  Physics
  
  History
CBSE
- 12Th Standard
  
  Physics
  
  Chemistry
  
  Maths
  
  Biology
  
  History
  
  Economics
  
  Commerce
  
  Geography
  
  Socialogy
  
  Business Studies
  
  Computer Science
  
  Biotechnology Class
  
  Political Science
  
  Home Science
  11Th Standard
  
  Physics
  
  Chemistry
  
  Maths
  
  Biology
  
  History
  
  Economics
  
  Commerce
  
  Socialogy
  
  Business Studies
  
  Geography
  
  Home Science
  
  Computer Science
  
  Biotechnology Class
  
  Political Science
  10Th Standard
  
  Physics
  
  Chemistry
  
  Biology
  
  Mathematics
  
  Economics
  
  Geography
  
  History & Civics
  
  Computer Application
  9Th Standard
  
  Physics
  
  Chemistry
  
  Biology
  
  mathematics
  
  Computer Application
  
  Economics
  
  Geography
  
  History & Civics

12th Computer Science Monthly Test - 2 ( Database Concepts )

St. Britto Hr. Sec. School - Madurai

12th Computer Science Monthly Test - 2 ( Database Concepts )-Aug 2020

Time : 2.30 Hours

Part - A

Multiple Choice Question - Answer All Question

One ,classroom has many students is an example of a relationships

one to one
one to many
many to one
many to many

Which of the following data model handles Geographic Information System?

Object
ER model
Relational
None of these

Which of the following allows users to store, process and analyze data easily?

MySQL
Relational Algebra
Datamodels
DBMS

Relational database model was first proposed by

E F Codd
E E Codd
E F Cadd
E F Codder

In which of the following data organized in a way that, it can be easily accessed, managed and updated?

Database
DBMS
Structure
Object

___ is the entire collection of related data

Square
Procedures
Table
Table or file

The basic structure of data in relational model is

Tables
rows
columns
tuples

__________data model provides a clear modular structure of a data

object
Relational
Hierarchical/ER-model
All of these

Which of the following is not a type of data model?

Hierarchical model
Entity Relationship model
Object model
Redundancey model

________database model is an extended form of hierarchical data model

object
Relational
ER model
Network

Which of the following database model is useful in developing a conceptual sign for the database?

Hierarchical
Object
Relational
ER model

Database normalization was first proposed by

Chen
Edgar F Cadd
Edgar IF Codd
Hugh Darwen

The rule "reduce data redundancy and improve data integrity" is known as

Chen rule
E F Codd rule
Edgar rule
Edgar Frank rule

Which of the following removes the duplicate rows in database?

SELECT
PROJECT
PRODUCT
INTERSECTION

DBA expansion is

Data Base Analyst
Data Base Administrators
Digital Bound Administrations
Database Analyser

Part - B

Generic 2 - Answer All Question

List the types of RDBMS software.

Π_course (STUDENT)

What is normalization?

Write a note on
(i) SELECT Operation
(ii) PROJECT Operation

What is data consistency?

What is the difference between Hierarchical and Network data model?
List some examples of RDBMS.

Mention few examples of a database.

Part - C

Generic 3 - Answer All Question

Explain Cartesian Product with a suitable example.

Explain Object Model with example.

Identity which is a DBMS and RDBMS software from the following.

(i) SQlite

(ii) Foxpro

(iii) MySQL

(iv) Dbase

Write the advantages of DBMS.

Write a short note on the· database model, in which relationship are created by dividing the object into entity.

Write the symbol used for the following.
(i) SELECT (ii) PROJECT
(iii) Union (iv) Intersection
(v) Difference (vi) PRODUCT

What is Relational Algebra?
Write a note on different types of DBMS users.

Part - D

Generic 5 - Answer All Question

Explain the different types of data model.

Π_{studno, course} (STUDENT)

Explain the components of DBMS.
Explain the different operators in Relational algebra with suitable examples.

Explain the different types of relationship mapping.

Differentiate DBMS and RDBMS.

Comment

Add Comment

Tamilnadu Stateboardszs - Class