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

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 of the following is IBM’s first RDBMS?

  • (A) DB2
  • (B) IMS
  • (C) SQL/DS
  • (D) Oracle Software Inc.

A

Admin • 833.24K Points
Coach

Q. Which of the following company now known as the Oracle Corporation?

  • (A) Stepware Inc.
  • (B) Relational Software Inc.
  • (C) Rational Inc.
  • (D) Optimizing

A

Admin • 833.24K Points
Coach

Q. What is the process that is done to SQL before execution, to check for proper syntax and to optimize the request called?

  • (A) Syntax checking
  • (B) Performance tuning
  • (C) Parsing
  • (D) All of the above

A

Admin • 833.24K Points
Coach

Q. Which of the following is a valid SQL data type?

  • (A) CHARACTER
  • (B) NUMERIC
  • (C) FLOAT
  • (D) SELECT

A

Admin • 833.24K Points
Coach

Q. Which of the following is not a data definition language statement?

  • (A) CREATE
  • (B) ALTER
  • (C) DROP
  • (D) None of the above

A

Admin • 833.24K Points
Coach

Q. Which of the following is not a DCL statement?

  • (A) GRANT
  • (B) REVOKE
  • (C) ROLLBACK
  • (D) All of the above

A

Admin • 833.24K Points
Coach

Q. Which of the following is a comparison operator?

  • (A) =
  • (B) LIKE
  • (C) BETWEEN
  • (D) None of the above

A

Admin • 833.24K Points
Coach

Q. Which of the following index is made up of more than one column?

  • (A) Composite index
  • (B) Clustered index
  • (C) Simple index
  • (D) Clustered index

A

Admin • 833.24K Points
Coach

Q. Which of the following index can occur only one per table?

  • (A) Distinct index
  • (B) Unique index
  • (C) Simple index
  • (D) Select two columns from the COURSES table, of which the second one has a constantvalue, i.e. “ = PRICE”. Sort the data according to the second column, in ascending order

A

Admin • 833.24K Points
Coach

Q. Which question corresponds best to the following query? SELECT CID, CDUR - 1,' = PRICE' FROM COURSES ORDER BY 2

  • (A) Select three columns from the COURSES table, of which the third one has a constantvalue, i.e. “ = PRICE”. Leave an empty line after every second line.
  • (B) Select two columns from the COURSES table, the second one gets as title “ =PRICE”.Sort the data according to the second column, in ascending order.
  • (C) Select three columns from the COURSES table, of which the third one has a constantvalue, i.e. “ = PRICE”. Sort the data according to the second column, in ascending order.
  • (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.