Home › Quizzes › Database Management Systems

Database Management Systems

This test contains conceptual questions on database management systems covering SQL commands, normalization, database design, and transaction control.

15 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

Which among the following SQL commands is used to delete a table from a database?

  1. DROP
  2. DELETE
  3. TRUNCATE
  4. REMOVE
  5. ERASE TABLE
Question 2 Multiple Choice (Single Answer)

Which of the following SQL queries is not a DDL command?

  1. Alter
  2. Revoke
  3. Grant
  4. Update
  5. Drop
Question 3 Multiple Choice (Single Answer)

Which of the following statements is a function of CREATE TABLE command?

  1. It is used to add an integrity constraint to a table.
  2. It is used to redefine a column of the table.
  3. It is used to change a table's storage characterstics.
  4. It is used to create tables and definine columns.
  5. It enables or disables integrity constraints.
Question 4 Multiple Choice (Single Answer)

Which of the following SQL queries is not a DML statement?

  1. Delete
  2. Select
  3. Create
  4. Insert
  5. Update
Question 5 Multiple Choice (Single Answer)

Which SQL command is used to remove privileges given to a user?

  1. TRIGGER
  2. CREATE VIEW
  3. UPDATE
  4. GRANT
  5. REVOKE
Question 6 Multiple Choice (Single Answer)

Which of the following methods is used for protecting data in the data communication system?

  1. Data encryption
  2. Data integrity
  3. Data encapsulation
  4. Data redundancy
  5. Polymorphism
Question 7 Multiple Choice (Single Answer)

Which of the following commands is used to give access of database objects to other users?

  1. REVOKE
  2. DROP
  3. INSERT
  4. GRANT
  5. ALTER
Question 8 Multiple Choice (Single Answer)

Which of the following commands is used to create a trigger?

  1. CREATE TRIGGER
  2. CREATE VIEW
  3. CREATE TABLESPACE
  4. GRANT
  5. CREATE SYNONYM
Question 9 Multiple Choice (Single Answer)

Which of the following SQL functions is used to find the average of a given record?

  1. AVG
  2. MIN
  3. MAX
  4. SUM
  5. SQRT
Question 10 Multiple Choice (Single Answer)

Which of the following statements is false?

  1. A table in 1st normal form contains no repeating groups.
  2. A table in 2nd normal form contains no partial functional dependency.
  3. 3 NF removes transitive functional dependency.
  4. 3 NF is equivalent to BCNF.
  5. BCNF is a special case of 3 NF.
Question 11 Multiple Choice (Single Answer)

Which of the following commands is a transaction control language?

  1. ALTER
  2. ROLLBACK
  3. GRANT
  4. DROP
  5. REVOKE
Question 12 Multiple Choice (Single Answer)

Which of the following keywords is used to display only the unique entries of the column?

  1. WHERE
  2. DISTINCT
  3. SELECT
  4. LIKE
  5. GROUP BY
Question 13 Multiple Choice (Single Answer)

Which of the following is a key constraint that is used to uniquely identify each row?

  1. PRIMARY KEY
  2. FOREIGN KEY
  3. COMPOSITE KEY
  4. ALTERNATE KEY
  5. DEFAULT
Question 14 Multiple Choice (Single Answer)

Which of the following can be used to retrieve data from a database?

  1. Stack
  2. Queue
  3. Linked list
  4. Query
  5. Data structure
Question 15 Multiple Choice (Single Answer)

What is the meaning of an oval shape in an E-R diagram?

  1. Entity set
  2. Attributes
  3. Straight line
  4. Diamond
  5. Dotted oval
← Back to Quizzes