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

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. The ______ is the one in which the primary key of one relation is used as a normal attribute in another relation.

  • (A) Referential relation
  • (B) Referencing relation
  • (C) Referenced relation
  • (D) Referred relation

A

Admin • 833.24K Points
Coach

Q. A _________ integrity constraint requires that the values appearing in specified attributes
of any tuple in the referencing relation also appear in specified attributes of at least one tuple in
the referenced relation.

  • (A) Referential
  • (B) Referencing
  • (C) Specific
  • (D) Primary

A

Admin • 833.24K Points
Coach

Q. A relational database consists of a collection of

  • (A) Tables
  • (B) Fields
  • (C) Records
  • (D) Keys

A

Admin • 833.24K Points
Coach

Q. A ________ in a table represents a relationship among a set of values.

  • (A) Column
  • (B) Key
  • (C) Row
  • (D) Entry

A

Admin • 833.24K Points
Coach

Q. Choose the correct command to delete an attribute A from a relation R

  • (A) alter table R delete A
  • (B) alter table R drop A
  • (C) alter table drop A from R
  • (D) delete A from R

A

Admin • 833.24K Points
Coach

Q. create table apartment(ownerID varchar (5), ownername varchar(25), floor numeric(4,0),
primary key (ownerID:));
Choose the correct option regarding the above statement

  • (A) The statement is syntactically wrong
  • (B) It creates a relation with three attributes ownerID, ownername, floor in which floor cannot be null.
  • (C) It creates a relation with three attributes ownerID, ownername, floor in which ownerID cannot be null.
  • (D) It creates a relation with three attributes ownerID, ownername, floor in which ownername must consist of at least 25 characters.

A

Admin • 833.24K Points
Coach

Q. What does the notnull integrity constraint do?

  • (A) It ensures that at least one tuple is present in the relation
  • (B) It ensures that at least one foreign key is present in the relation
  • (C) It ensures that all tuples have a finite value on a specified attribute
  • (D) It ensures that all tuples have finite attributes on all the relations

A

Admin • 833.24K Points
Coach

Q. Which SQL function is used to count the number of rows in a SQL query?

  • (A) COUNT()
  • (B) NUMBER()
  • (C) SUM()
  • (D) COUNT(*)

A

Admin • 833.24K Points
Coach

Q. Which SQL keyword is used to retrieve a maximum value?

  • (A) MOST
  • (B) TOP
  • (C) MAX
  • (D) UPPER

A

Admin • 833.24K Points
Coach

Q. ___________removes all rows from a table without logging the individual row deletions.

  • (A) DELETE
  • (B) REMOVE
  • (C) DROP
  • (D) TRUNCATE

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.