Engineering

Database Management System (DBMS) MCQs: 1600+ Questions & Answers in Engineering

1600+ Database Management System (DBMS) MCQs in Engineering with answers & explanations. Page 80. Practice objective questions for competitive exams, intervi… Use the answer toggle below to show or hide all solutions, tap an option to check one question, or open a question for its own page.

Page 80 of 81

Show answers

Answers hidden — tap an option or use “View Answer” on each question.

1581

Database Management System (DBMS) MCQs: 1600+ Questions & Answers in Engineering

BCNF is needed because

A relation project guidance Project Guidance(professor, project, student no. st-name, dept) A professor can give many projects to many students A project will have many students A project may be guided by many professors The 4 NF relation corresponding to this are

A 3 NF relation is split into 4 NF

Using the SQL GROUP BY phrase with a SELECT statement can help detect which of the following problems?

The NOT EXISTS keyword will be true if:

What SQL command will allow you to change the table STUDENT to add the constraint named GradeCheck that states that the values of the Grade column must be greater than 0?

Changing cardinalities in a database is:

Which one of the following sorts rows in SQL?

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

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.

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

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

Which of the following is not true about indexes?

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

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

In the process of decomposition is called as

Who developed QBE?

Which of the following is IBM’s first RDBMS?

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

Study tips for Database Management System (DBMS)