Quiz - XII CS

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

Quiz - XII CS

Chapter 8 - Database Management System

Name of the Student *

1. Duplication of data is referred to as ................ *

1 point

Data inconsistency

Data redundancy

Data integrity

Data security

2. Choose the level of database abstraction that describes what data is stored in the database and what relationships exist among them *

1 point

External

Physical

Conceptual

View

3. Address of a particular student is stored in two ways in a school record, this situation is known as ...... *

1 point

Data inconsistency

Data redundancy

Data integrity

Data insecurity

4. Unauthorised accessing of data can be prevented from using ......... *

1 point

Data consistency

Data intergrity

Data redundancy

Data security

5. Data about data is called..... *

1 point

data base

meta data

field

record

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

1 point

Database administrator

Application programmers

Sophisticated users

Naive users

7. The billing clerk in a supermarket is a ......................... user *

1 point

Database administrator

Application programmers

Sophisticated user

Naive user

8. Expand RDBMS *

1 point

Relative Data Base Manager Software

Relational Data Base Management Software

Relational Data Base Management System

Relative Data Base Management System

9. In RDBMS, table itself is called .......... *

1 point

entity

relation

tuple

attribute

10. Organization of data in terms of rows and columns is called ...................... *

1 point

entity

relation

tuple

attribute

11. ............................. in a table gives the complete data of a particular entity *

1 point

relation

degree

tuple

attribute

12. Number of rows in a relation is called ............................ *

1 point

entity

degree

cardinality

domain

13. Number of columns in a relation is called .............. *

1 point

entity

degree

cardinality

domain

14. Who is responsible for managing and controlling the activities associated with the database *

1 point

Database administrator

Application programmer

Naive user

Sophisticated User

15. Abstraction of the database can be viewed as *

1 point

two levels

three levels

four levels

six levels

16. An advantage of the database management approach is *

1 point

data is dependent on programs

data redundancy increases

data is integrated and can be accessed by multiple programs

data is inconsitent and can not be secure

17. Key to represent relationship between tables is called *

1 point

primary key

candidate key

alternate key

foreign key

18. Which database level is closest to the users *

1 point

external

internal

physical

conceptual

19. A set of possible data values is called *

1 point

attribute

degree

tuple

domain

20. How many tuples are there in a relation with cardinality 13? *

1 point

21. Which of the following operations need the participating relations to be union compatible? *

1 point

UNION

INTERSECTION

SET DIFFERENCE

All of the above

22. Which of the following operations is used if we are interested only in certain columns of a table? *

1 point

Project

Select

Union

Cartesian Product

23. Consider attributes ID, CITY, and NAME. Which one if this can be considered as a primary key? *

1 point

CITY

NAME

ID,NAME

24. A relational database consists of a collection of *

1 point

Field

Record

Table

Keys

25. Which of the following is NOT Advantages of DBMS *

1 point

Increased data consistency

Reduced data redundancy

Improved data security

Increase data isolation

After Selecting answer of all question,press "SUBMIT" button then 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