DBMS MCQ SET-2

1. The database schema is written in

(A) HLL
(B) DML
(C) DDL
(D) DCL

2. In the architecture of a database system external level is the

(A) Physical level
(B) Logical level
(C) Conceptual level
(D) View level

3. In a Hierarchical level model records are organized as

(A) Graph
(B) List
(C) Links
(D) Tree

4. The language used in application programs to request data from the DBMS is refered to as the

(A) DML
(B) DDL
(C) VDL
(D) SDL

5. Key to represent relationship between tables is called

(A) Primary key
(B) Secondary key
(C) Foreign key
(D) None of these

6. Hierarchical model is also called

(A) Tree structure
(B) Plex structure
(C) Normalize structure
(D) Table structure

7. Which of the system uses Multidimensional data analysis?

(A) DSS
(B) MIS
(C) ESS
(D) All of the above

8. A view of database that appears to an application program is known as :

(A) Schema
(B) Subschema
(C) Virtual table
(D) None of the above

9. An abstraction concept for building composite object from their component object is called :

(A) Specialization
(B) Normalization
(C) Generalization
(D) Aggregation

10. A set of objects that share a common structure and a common behavior is called

(A) Object
(B) Class
(C) Entity
(D) None of these

11. Every weak entity set can be converted into a strong entity set by :

(A) Using generalization
(B) Adding appropriate attributes
(C) Using aggregation
(D) None of the above

12. The number of entities to which another entity can be associated via a relationship set is expressed as :

(A) Entity
(B) Cardinality
(C) Schema
(D) Attributes

13. Relations produced from an ER model will always be in :

(A) First normal form
(B) Second normal form
(C) Third normal form
(D) Fourth normal form

14. In ER model the details of the entities are hidden from the user. This process is called

(A) Generalization
(B) Specialization
(C) Abstraction
(D) None of these

15. In a relational database a referential integrity constraint can be specified with the help of

(A) Primary key
(B) Foreign key
(C) Secondary key
(D) None of the above

16. 4NF is designed to cope with

(A) Transitive dependency
(B) Join dependency
(C) Multi valued dependency
(D) None of these

17. Which command is used to remove all rows from a table ?

(A) Delete
(B) Remove
(C) Turncate
(D) Both (a) and (b)

18. Which of the following is an aggregate function in SQL ?

(A) Union
(B) Like
(C) Group By
(D) Max

19. Which command is used to add a column to an existing table ?

(A) Create
(B) Update
(C) Alter
(D) None of these

20. A deadlock exists in the system if and only if the wait for graph :

(A) Has a cycle in it
(B) Has a path from first node to last node
(C) is a tree
(D) None of the above