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

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. What is an Instance of a Database?

  • (A) The logical design of the database system
  • (B) The entire set of attributes of the Database put together in a single relation
  • (C) The state of the database system at any given point of time
  • (D) The initial values inserted into the Database immediately after its creation

A

Admin • 833.24K Points
Coach

Q. What is a foreign key?

  • (A) A foreign key is a primary key of a relation which is an attribute in another relation
  • (B) A foreign key is a superkey of a relation which is an attribute in more than one other relations
  • (C) A foreign key is an attribute of a relation that is a primary key of another relation
  • (D) A foreign key is the primary key of a relation that does not occur anywhere else in the schema

A

Admin • 833.24K Points
Coach

Q. What action does ⋈ operator perform in relational algebra

  • (A) Output specified attributes from all rows of the input relation and remove duplicate tuples from the output
  • (B) Outputs pairs of rows from the two input relations that have the same value on all attributes that have the same name
  • (C) Output all pairs of rows from the two input relations (regardless of whether or not they have the same values on common attributes)
  • (D) Return rows of the input relation that satisfy the predicate

A

Admin • 833.24K Points
Coach

Q. What does the “x” operator do in relational algebra?

  • (A) Output specified attributes from all rows of the input relation. Remove duplicate tuples from the output
  • (B) Output pairs of rows from the two input relations that have the same value on all attributes that have the same name
  • (C) Output all pairs of rows from the two input relations (regardless of whether or not they have the same values on common attributes)
  • (D) Returns the rows of the input relation that satisfy the predicate

A

Admin • 833.24K Points
Coach

Q. An attribute is a __________ in a relation.

  • (A) Row
  • (B) Column
  • (C) Value
  • (D) Tuple

A

Admin • 833.24K Points
Coach

Q. What is the method of specifying a primary key in a schema description?

  • (A) By writing it in bold letters
  • (B) By underlining it using a dashed line
  • (C) By writing it in capital letters
  • (D) By underlining it using a bold line

A

Admin • 833.24K Points
Coach

Q. Statement 1: A tuple is a row in a relation Statement 2: Existence of multiple foreign keys in a same relation is possible

  • (A) Both the statements are true
  • (B) Statement 1 is correct but Statement 2 is false
  • (C) Statement 1 is false but Statement 2 is correct
  • (D) Both the statements are false

A

Admin • 833.24K Points
Coach

Q. Choose the option that correctly explains in words, the function of the following relational algebra expression σyear≥2009 (book ⋈ borrow)

  • (A) Selects all tuples from the Cartesian product of book and borrow
  • (B) Selects all the tuples from the natural join of book and borrow wherever the year is lesser than 2009
  • (C) Selects all the tuples from the natural join of book and student wherever the year is greater than or equal to 2009
  • (D) Selects all tuples from the Cartesian product of book and borrow wherever the year is greater than or equal to 2009

A

Admin • 833.24K Points
Coach

Q. State true or false: If a relation consists of a foreign key, then it is called a referenced relation of the foreign key dependency.

  • (A) True
  • (B) False
  • (C) none
  • (D) all

A

Admin • 833.24K Points
Coach

Q. Which of the following information does an SQL DDL not specify?

  • (A) The schema for each relation
  • (B) The integrity constraints
  • (C) The operations on the tuples
  • (D) The security and authorization information for each relation

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.