Plus Two Computer Science

JavaScript isn't enabled in your browser, so this file can't be opened. Enable and reload.

Chapter 8 : Database Management System

Student Name *

School name *

1.________ is an organized collection of inter-related data with minimum redundancy *

1 point

File

DBMS

Database

None of these

2. Which is the Components of DBMS ? *

1 point

Hardware

Software

Database

All of these

3. The smallest unit of stored data is called *

1 point

Field

Database

Record

File

4. _____ is the process of hiding the complexity of database design from the users *

1 point

Data integrity

Data abstraction

Data consistency

Data redundancy

5.Data about data is called ________. *

1 point

Relation

Data base

Metadata

Data dictionary

6. _____ is the ability to modify the schema definition in one level without affecting next higher level *

1 point

Data redundancy

Data integrity

Data independence

Data abstraction

7. Who is the person responsible for the control of the centralized and shared database *

1 point

Application Programmers

Database Administrator

Sophisticated Users

Naive Users

8. Three levels of abstraction are *

1 point

physical level,conceptual level and data level.

physical level,conceptual level and view level.

physical level,concept level and view level.

Logical level,conceptual level and view level.

9. The rows (records) of a relation are called ____ *

1 point

Entity

Attribute

Record

Tuples

10. _____ is a pool of values from which actual values appearing in a given column *

1 point

Relation

Cardinality

Domain

Degree

11.The description or structure of a database is called ___________ *

1 point

Relation

Instance

Schema

Domain

12. Foreign key can be used to link two or more tables then it is called *

1 point

Alternate key

Reference key

Primary key

Candidate key

13. _____ operation is used to select rows from a relation *

1 point

PROJECT

SELECT

UNION

INTERSECTION

14. ____ operation returns a relation containing the tuples appearing in the first relation but not in the second relation *

1 point

UNION

CARTESIAN

INTERSECTION

SET DIFFERENCE

15 In the relational model, degree is the *

1 point

number of tuples

number of attributes

number of tables

number of constraints

16. How many primary keys are possible in a relation? *

1 point

17. If a key consists of more than one attributes then it is called________ *

1 point

Composite Key

Candidate key

Primary key

Alternate key

18. Union operation in relational algebra is *

1 point

Unary operator

Binary operator

Ternary operator

None of these

19. An advantage of the database management approach is *

1 point

Controlling data redundancy

Data consistency

Data integrity

All of these

20. ____ is the symbol used for select operation in relational algebra *

1 point

21.In RDBMS a relation contains 10 rows and 5 columns. What is the degree of the relation? *

1 point

22. Abstraction of the database can be viewed as *

1 point

two levels

four levels

three levels

one levels

23. Duplication of data is known as _______ *

1 point

Data security

Data integrity

Data consistency

Data redundancy

24.Data redundancy may lead to data inconsistency *

1 point

False

True

25.The person who interacts with the database through query language is called ________ *

1 point

Naive users

Sophisticated users

Application programmers

None of these

Type your valuable Suggestion about this Quiz

After Selecting answer of all question,press "SUBMIT" button and press "View Score" Button to know your Score and correct answers

Submit

Clear form

Never submit passwords through Google Forms.

This content is neither created nor endorsed by Google. Report Abuse - Terms of Service - Privacy Policy

Forms