DBMS Quizzz....!

What is the Full form of DBMS?

• Data of Binary Management System

• Database Management System

• Database Management Service

• Data Backup Management System

Which type of data can be stored in the database?

• Image oriented data

• Text, files containing data

• Data in the form of audio or video

• All of the above

Which of the following is not an example of DBMS?

• MySQL

• Microsoft Acess

• IBM DB2

• Google

Which of the following is known as a set of entities of the same type that share same properties, or attributes?

• Relation set

• Tuples

• Entity set

• Entity Relation model

What does an RDBMS consist of?

• Collection of Records

• Collection of Keys

• Collection of Tables

• Collection of Fields

The values appearing in given attributes of any tuple in the referencing relation must likewise occur in specified attributes of at least one tuple in the referenced relation, according to _____________________ integrity constraint.

• Referential

• Primary

• Referencing

• Specific

______________ is a set of one or more attributes taken collectively to uniquely identify a record.

• Primary Key

• Foreign key

• Super key

• Candidate key

Which command is used to remove a relation from an SQL?

• Drop table

• Delete

• Purge

• Remove

Which of the following command is correct to delete the values in the relation teaches?

• Delete from teaches;

• Delete from teaches where Id =’Null’;

• Remove table teaches;

• Drop table teaches;

Which forms have a relation that contains information about a single entity?

• 4NF

• 2NF

• 5NF

• 3NF