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

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 one of the following sorts rows in SQL?

  • (A) SORT BY
  • (B) ALIGN BY
  • (C) ORDER BY
  • (D) IN and NOT IN

A

Admin • 833.24K Points
Coach

Q. The SQL keyword(s) ________ is used with wildcards.

  • (A) LIKE only
  • (B) IN only
  • (C) NOT IN only
  • (D) a foreign key

A

Admin • 833.24K Points
Coach

Q. If a relationship has a cascade updates constraint, then if ________ in the parent table is changed, then the same change will automatically be made to any corresponding foreign key value.

  • (A) the primary key
  • (B) any alternate key
  • (C) a surrogate key
  • (D) Six

A

Admin • 833.24K Points
Coach

Q. For every relationship, how many possible types of actions are there when enforcing minimum cardinalities?

  • (A) Two
  • (B) Three
  • (C) Four
  • (D) If there are no syntax errors, you will receive the message "NO ERRORS."

A

Admin • 833.24K Points
Coach

Q. In creating a procedure, you may get a message if you have compile errors. Which of the following is true?

  • (A) The line numbers reported match the line numbers you see in your text editor.
  • (B) SQL*Plus will automatically show the errors to you.
  • (C) To see the errors, enter SHOW ERRORS in SQL*Plus.
  • (D) Indexes are created with the ALTER TABLE command.

A

Admin • 833.24K Points
Coach

Q. Which of the following is not true about indexes?

  • (A) Indexes are created to enforce uniqueness on columns.
  • (B) Indexes are created to enable fast retrieval by column values.
  • (C) Columns that are frequently used with equal conditions in WHERE clauses are good candidates for indexes.
  • (D) Fourth

A

Admin • 833.24K Points
Coach

Q. In ……….. normal forms, any multivalued attributes have been removed.

  • (A) First
  • (B) Second
  • (C) Third
  • (D) Primary key

A

Admin • 833.24K Points
Coach

Q. A (n) …………….. is an attribute in a relation that serves as a primary key of another relation in the same.

  • (A) Composite key
  • (B) Foreign key
  • (C) Identifier key
  • (D) Specalization

A

Admin • 833.24K Points
Coach

Q. In the process of decomposition is called as

  • (A) Normalization
  • (B) Generalization
  • (C) Aggregation
  • (D) BCNF

A

Admin • 833.24K Points
Coach

Q. Who developed QBE?

  • (A) C.J. Date
  • (B) E.F. Codd
  • (C) M.M. Zloof
  • (D) None of the above

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.