DBMS MCQ 02

1.  Which can choose from several approaches to manage data:

1. DBMS
2. DDL
3. SDL
4. CDL

2. Which provides mechanisms to structure data in the data base being modeled:

1. DBMS
2. DDL
3. SDL
4. CDL

3. E-R stands for:

1. Entry relationship
2. Entity relationship
3. Both
4. None

4. Which models a collection of various concepts that are use to describe the structure of a data base:

1. Data base
2. Data model
3. Data
4. Recorded

5.  Data  at the conceptual level and view level can be describe with the help of____:
1. Data model
2. Relation model
3. Record based logical model
4. All of these
6. How many types of record based logical models:

1. 1
2. 2
3. 3
4. 4

7. Which are the types of record based logical models:

1. Relational
2. Network
3. Hierarchical
4. All of these

8. E-R model entities and their relationship are corresponded as ___ dimensional tables:

1. 2
2. 4
3. 5
4. 6

9. Which are the not properties of a relation are:
1. Row order are insignificant
2. Column order are insignificant
3. The values are atomic
4. None of these
10. Which is the various key:

1. Super key
2. Primary key
3. Secondary key
4. Alternate key
5. Candidate key
6. Foreign key
7. Concatenated key
8. All off these
9. None f these

11. Which is a primary domain:

1. Domain
2. Data
3. Register
4. Models

12. In which year the relational model introduced:

1. 1969
2. 1970
3. 1971
4. 1972

13. In which person introduced the relational model:

1. E.F. codd
2. F.F. codd
3. E.E. codd
4. None of these

14. How many  components in relational model:

1. 1
2. 2
3. 3
4. 4

15. Which components are use in make up the relational model:

1. Structural
2. Manipulative
3. Integrity
4. All off these

16.  Who is represent a data base as a collection of relation value:

1. Data model
2. Relation model
3. Record based logical model
4. All of these

17. The heading of a relation is also referred to as ________:

1. Relation schema
2. Intension
3. Both
4. None

18. In relational model the body of the relation is referred to as_______:

1. Extension
2. Criterion
3. Relation
4. None of these

19.  Which is the set of defined atomic values for an attribute:

1. Domain
2. Data
3. Register
4. Models

20. Which is the name of role played by a domain in the relation:

1. Relational schema
2. Domain
3. Attribute
4. Relation

21.  Which is made up of relation name and a list of attributes:

1. Relational schema
2. Domain
3. Attribute
4. Relation

22. A ______ is defined as the subset of the subset of the Cartesian product of domains:

1. Extension
2. Criterion
3. Relation
4. None of these

23. SQL schema is how many types of relation schema may be defined:

1. 2
2. 3
3. 4
4. 5

24. In a SQL schema may be defined as which types:

1. VIEWS
2. BASE RELATION
3. BOTH
4. NONE

25. CAD stands for:

1. Computer aided design
2. Computer aided data
3. Computer aided database
4. None of these

26. Which is refers to knowledge about the meaning of data:

1. Data types
2. Base relation
3. Semantic knowledge
4. All of these

27. In which is do not fully support the domain concept:

1. DBMS
2. DBS
3. RDBMS
4. All of these

28. Which is used for searching and retrieving records from the database:

1. DBS
2. DBMS
3. DDL
4. DML

29.  How many types of data structures used in hierarchical model:

1. 2
2. 3
3. 4
4. 5

30. PCR stands for:
1. Primary child relationship
2. Parent child relationship
3. Both
4. None
31. Which types of data structures used in Hierarchical model:

1. PCR
2. Records
3. Both
4. None

32. _____it is an1:N relationship between two different record types:

1. DATA
2. RELTION
3. PCR
4. All of these

33. Which is a database model used to represent objects and the relationship among these objects:

1. Data model
2. Relation model
3. Hierarchical model
4. Network  model

34. RDBMS stands for:
1. Relational database management system
2. Relational database management structured
3. Relational database management search

Relational database management sum