Database Management System (DBMS) MCQs with answers Page - 46

Here, you will find a collection of MCQ questions on Database Management System (DBMS). Go through these questions to enhance your preparation for upcoming examinations and interviews.

To check the correct answer, simply click the View Answer button provided for each question.

Have your own questions to contribute? Click the button below to share your MCQs with others!

+ Add Question

A

Admin • 833.24K Points
Coach

Q. Which SQL keyword is used to sort the result-set?

  • (A) ORDER BY
  • (B) SORT
  • (C) ORDER
  • (D) SORT BY

A

Admin • 833.24K Points
Coach

Q. Which of the following command makes the updates performed by the transaction permanent in the database?

  • (A) ROLLBACK
  • (B) COMMIT
  • (C) TRUNCATE
  • (D) DELETE

A

Admin • 833.24K Points
Coach

Q. Which TCL command undo all the updates performed by the SQL in the transaction?

  • (A) ROLLBACK
  • (B) COMMIT
  • (C) TRUNCATE
  • (D) DELETE

A

Admin • 833.24K Points
Coach

Q. Which of the following is not a SQL Server INFORMATION_SCHEMA view?

  • (A) INFORMATION_SCHEMA.CONSTRAINT_TABLE_USAGE
  • (B) INFORMATION_SCHEMA.DOMAIN_CONSTRAINTS
  • (C) INFORMATION_SCHEMA.KEY_COLUMN_USAGE
  • (D) sys.dm_exec_connections

A

Admin • 833.24K Points
Coach

Q. In the __________ normal form, a composite attribute is converted to individual attributes.

  • (A) First
  • (B) Second
  • (C) Third
  • (D) Fourth

A

Admin • 833.24K Points
Coach

Q. Tables in second normal form (2NF):

  • (A) Eliminate all hidden dependencies
  • (B) Eliminate the possibility of a insertion anomalies
  • (C) Have a composite key
  • (D) Have all non key fields depend on the whole primary key

A

Admin • 833.24K Points
Coach

Q. Which-one ofthe following statements about normal forms is FALSE?

  • (A) BCNF is stricter than 3 NF
  • (B) Lossless, dependency -preserving decomposition into 3 NF is always possible
  • (C) Loss less, dependency – preserving decomposition into BCNF is always possible
  • (D) Any relation with two attributes is BCNF

A

Admin • 833.24K Points
Coach

Q. Functional Dependencies are the types of constraints that are based on______

  • (A) Key
  • (B) Key revisited
  • (C) Superset key
  • (D) None of the mentioned

A

Admin • 833.24K Points
Coach

Q. Which is a bottom-up approach to database design that design by examining the relationship between attributes:

  • (A) Functional dependency
  • (B) Database modeling
  • (C) Normalization
  • (D) Decomposition

A

Admin • 833.24K Points
Coach

Q. Which forms simplifies and ensures that there are minimal data aggregates and repetitive groups:

  • (A) 1NF
  • (B) 2NF
  • (C) 3NF
  • (D) All of the mentioned

Add MCQ in this Category

If you want to share an MCQ question in this category, it's a great idea! It will be helpful for many other students using this website.

Share Your MCQ

Browse Categories

Click on category to learn MCQs of that category.