Important MCQ’s on DBMS

MCQ’s on DBMS

Q1. In the relational model cardinality is termed as:

1. A number of tuples
2. A number of attributes
3. A number of tables
4. A number of constraints

Q2. ODBC stands for

1. Object Database Connectivity.
2. Oral Database Connectivity.
3. Oracle Database Connectivity.
4. Open Database Connectivity.

Q3.  Which one of the following is a set of one or more attributes taken collectively to uniquely identify a record?

1. Candidate key
2. Sub key
3. Super key
4. Foreign key

Q4. A logical schema

1. Is the entire database.
2. describe data in terms of relational tables and columns, object-oriented classes, and XML tags.
3. Describes how data is actually stored on disk.
4. Both (A) and (C)

Q5. A relational database developer refers to a record as

1. A criteria.
2. A relation.
3. A tuple.
4. An attribute.

Q6.  A _____ is a property of the entire relation, rather than of the individual tuples in which each tuple is unique.

1. Rows
2. Key
3. Attribute
4. Fields

Q7. Which one of the following cannot be taken as a primary key?

1. Id
2. Register number
3. Dept_id
4. Street

Q8. An attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation.

1. Candidate
2. Primary
3. Super
4. Sub

Q9. Architecture of the database can be viewed as

1. two levels.
2. four levels.
3. three levels.
4. one level.

Q10. In a relational model, relations are termed as

1. Tuples.
2. Attributes
3. Tables.
4. Rows.

Q11. The method in which records are physically stored in a specified order according to a key field in each record is

1. Hash
2. Direct
3. Sequential
4. All of the above.

Q12 An advantage of the database management approach is

1. Data is dependent on programs
2. Data redundancy increases.
3. Data is integrated and can be accessed by multiple programs.
4. None of the above

Q13. Relational calculus is a

1. Procedural language.
2. Non- Procedural language.
3. Data definition language.
4. High level language.

Q14. Cartesian product in relational algebra is

1. a Unary operator.
2. a Binary operator.
3. a Ternary operator.
4. not defined.

Q15.  In an E-R diagram an entity set is represented by a

1. rectangle.
2. ellipse.
3. diamond box.
4. circle.

Q16. The DBMS language component which can be embedded in a program is

1. The data definition language (DDL).
2. The data manipulation language (DML).
3. The database administrator (DBA).
4. A query language.

Q17. The statement in SQL which allows to change the definition of a table is

1. Alter.
2. Update.
3. Create.
4. select.

Q18. In E-R Diagram relationship type is represented by

1. Ellipse
2. Dashed ellipse
3. Rectangle
4. Diamond

Q19. The full form of DDL is

1. Dynamic Data Language
2. Detailed Data Language
3. Data Definition Language
4. Data Derivation Language

Q20. Hierarchical model is also called

1. Tree structure
2. Plex Structure
3. Normalize Structure
4. Table Structure

Recommended Posts: