DBMS QUIZ

Which of the following command is used to change data in table?

• Insert

• Update

• Merge

• Delete

What is rows of a relation known as?

• Degree

• Column

• Entity

• Tuple

What is the use of COUNT in SQL?

• Return number of rows.

• Return total values.

• Return number of columns

• Return number of groups

Which command is used to remove a stored function from the database?

• DROP

• DELETE

• ERASE

• REMOVE

Which Normal form deals with Transitive Dependency?

• 2NF

• 3NF

• 4NF

• 1NF

Which of the following allows to uniquely identify a tuple?

• Schema

• Attribute

• Domain

• Super Key

Which of the following is known as minimal super key?

• Primary key

• Candidate key

• Foreign key

• Super key

Which of the following is not a SQL command?

• DELETE

• ORDER BY

• SELECT

• WHERE

During transaction before commit which of the following statement is done automatically in case of shutdown?

• Rollback

• Commit

• view

• Flashback

Rectangles in ER diagram Represent?

• Tables

• Attributes

• Tuples

• Entity sets