DBMS

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

In which of the following formats data is stored in the database management system?

• Image

• Text

• Table

• Graph

Which of the following is not a feature of DBMS?

• Minimum Duplication and Redundancy of Data

• High Level of Security

• Single-user Access only

• Support ACID Property

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

The ability to query data, as well as insert, delete, and alter tuples, is offered by ____________

• TCL (Transaction Control Language)

• DCL (Data Control Language)

• DDL (Data Definition Language

• DML (Data Manipulation Language)

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

• Primary Key

• Foreign key

• Candidate key

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

• Drop table

• Delete

• Purge

• Remove

Which of the following set should be associated with weak entity set for weak entity to be meaningful?

• Neighbor set

• Strong entity set

• Strong entity set

• Identifying set

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;

_________________ operations do not preserve non-matched tuples.

• Left outer join

• Inner join

• Outer join

• Right outer join