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

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 type of join is needed when you wish to include rows that do not have matching values?

  • (A) Equi-join
  • (B) Natural join
  • (C) Outer join
  • (D) All of the Mentioned

A

Admin • 833.24K Points
Coach

Q. What type of join is needed when you wish to return rows that do have matching values?

  • (A) Equi-join
  • (B) Natural join
  • (C) Outer join
  • (D) All of the Mentioned

A

Admin • 833.24K Points
Coach

Q. Which of the following is one of the basic approaches for joining tables?

  • (A) Subqueries
  • (B) Union Join
  • (C) Natural join
  • (D) All of the Mentioned

A

Admin • 833.24K Points
Coach

Q. The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T WHERE CUSTOMER_T. CUSTOMER_ID = ORDER_T. CUSTOMER_ID?

  • (A) Equi-join
  • (B) Natural join
  • (C) Outer join
  • (D) Cartesian join

A

Admin • 833.24K Points
Coach

Q. A UNION query is which of the following?

  • (A) Combines the output from no more than two queries and must include the same number of columns
  • (B) Combines the output from no more than two queries and does not include the same number of columns
  • (C) Combines the output from multiple queries and must include the same number of columns
  • (D) Combines the output from multiple queries and does not include the same number of columns

A

Admin • 833.24K Points
Coach

Q. Which of the following statements is true concerning subqueries?

  • (A) Involves the use of an inner and outer query
  • (B) Cannot return the same result as a query that is not a subquery
  • (C) Does not start with the word SELECT
  • (D) All of the mentioned

A

Admin • 833.24K Points
Coach

Q. Which of the following is a correlated subquery?

  • (A) Uses the result of an inner query to determine the processing of an outer query
  • (B) Uses the result of an outer query to determine the processing of an inner query
  • (C) Uses the result of an inner query to determine the processing of an inner query
  • (D) Uses the result of an outer query to determine the processing of an outer query

A

Admin • 833.24K Points
Coach

Q. The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T?

  • (A) Equi-join
  • (B) Natural join
  • (C) Outer join
  • (D) Cartesian join

A

Admin • 833.24K Points
Coach

Q. Which is not a type of join in T-SQL?

  • (A) Equi-join
  • (B) Natural join
  • (C) Outer join
  • (D) Cartesian join

A

Admin • 833.24K Points
Coach

Q. What is a view?

  • (A) A view is a special stored procedure executed when certain event occurs
  • (B) A view is a virtual table which results of executing a pre-compiled query
  • (C) A view is a database diagram
  • (D) None 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.