Home › Quizzes › DBMS

DBMS

Covers database management system concepts including data abstraction, ER diagrams, database architecture, and SQL command types (DDL, DML, TCL, DCL)

20 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

In which level of data abstraction is data stored?

  1. View level
  2. Physical level
  3. Logical level
  4. Virtual level
  5. None of these
Question 2 Multiple Choice (Single Answer)

Which sign is used to represent entity set in ER-diagram?

  1. Rectangle
  2. Ellipse
  3. Diamond
  4. Line
  5. Double ellipse
Question 3 Multiple Choice (Single Answer)

The process of designating sub grouping within an entity set is called

  1. generalization
  2. aggregation
  3. attribute inheritance
  4. specialization
  5. none of these
Question 4 Multiple Choice (Single Answer)

Which of the following is represented by double lines in ER-diagram?

  1. Multi-valued attribute
  2. Relationship status
  3. Derived attribute
  4. Total participation of an entity set
  5. None of these
Question 5 Multiple Choice (Single Answer)

Which sign is used to represent derived attribute?

  1. Line
  2. Ellipse
  3. Double ellipse
  4. Dashed ellipse
  5. None of these
Question 6 Multiple Choice (Single Answer)

What is the function of view level in DBMS?

  1. Simplifies how data is stored
  2. Simplifies what data is stored in the database
  3. Collects the information stored in the database at a particular moment
  4. Simplifies database interaction with the system
  5. None of these
Question 7 Multiple Choice (Single Answer)

What is described by the sub-schema?

  1. Database design at logical level
  2. Different views of the database
  3. Database design at physical level
  4. Complex low-level data structure
  5. None of these
Question 8 Multiple Choice (Single Answer)

The interface between low-level data stored in the data base and the application program is provided by

  1. storage manager
  2. query processor
  3. data model
  4. only 2 and 3
  5. none of these
Question 9 Multiple Choice (Single Answer)

What is represented by double rectangles?

  1. Weak entity sets
  2. Total participation of an entity in a relationship set
  3. Relationship set
  4. Link attribute to entity set and entity set to the relationship set
  5. None of these
Question 10 Multiple Choice (Single Answer)

Which of the following is used to write database schema?

  1. XML
  2. HTML
  3. DDL
  4. DML
  5. None of these
Question 11 Multiple Choice (Single Answer)

Find the odd one out.

  1. Selection
  2. Rename
  3. Projection
  4. Union
  5. None of these
Question 12 Multiple Choice (Single Answer)

DDL and DML statements are compiled and executed by

  1. query processor
  2. storage manager
  3. data model
  4. only 1 and 3
  5. none of these
Question 13 Multiple Choice (Single Answer)

Which of the following is a DML command?

  1. CREATE
  2. COMMIT
  3. ALTER
  4. SELECT
  5. None of these
Question 14 Multiple Choice (Single Answer)

What is/are instance(s) of database?

  1. The relationship among data
  2. The collection of conceptual tools for describing data
  3. The collection of information stored at a particular moment
  4. Only 1 and 3
  5. None of these
Question 15 Multiple Choice (Single Answer)

Which type(s) of attribute(s) is/are phone number?

  1. Composite attribute
  2. Single-valued attribute
  3. Multi-valued attribute
  4. Derived attribute
  5. Only 2 and 4
Question 16 Multiple Choice (Single Answer)

Which type of command is DROP?

  1. Data Definition Language (DDL) command
  2. Transaction Control Language (TCL) command
  3. Data Query Language (DQL) command
  4. Data Manupulation Language (DML) command
  5. None of these
Question 17 Multiple Choice (Single Answer)

What is the function of the SAVEPOINT command?

  1. To save information in a database after updation
  2. To identify a point in a transaction to which you can later roll back
  3. To save a table
  4. To save after RENAME a table
  5. None of these
Question 18 Multiple Choice (Single Answer)

Which of the following is/are example(s) of Transaction Control Language (TCL) command?

  1. TRANCATE
  2. COMMIT
  3. ROLLBACK
  4. GRANT
  5. Only 2 and 3
Question 19 Multiple Choice (Single Answer)

What function(s) is/are done by the Transaction Control Language (TCL) command?

  1. Used for managing data within schema objects
  2. Used to manage the changes made by DML statements and allows statements to be grouped together into logical transactions.
  3. Statements are used to define the database structure or schema.
  4. Only 1 and 2
  5. None of these
Question 20 Multiple Choice (Single Answer)

Which type of command is GRANT?

  1. Transaction Control Language (TCL) command
  2. Data Query Language (DQL) command
  3. Data Control language (DCL) command
  4. Data Definition Language (DDL) command
  5. None of these
← Back to Quizzes