DBTHON-23 Round-1

Which type of data can be stored in the Database ?

• Text

• Files

• Audio or Video

• All the Above

According to _______ integrirty constraint, 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

• Entity Integrity

• Domain Integrity

• Referential Integrity

• Data Integrity

_________________ operations do not preserve non-matched tuples.

• Left Outer Join

• Natural Join

• Inner Join

• Full Join

Which of the following statements contains an error?

•  Select * from emp where empid = 10003;

• Select empid from emp;

• Select empid where empid = 1009 and lastname = ‘GELLER’;

• Select empid from emp where empid = 10006;

Which of the following is the property of transaction that protects data from system failure?

• Atomicity

• Durability

• Consistency

• Isolation

"AS" Clause is used with following operation

• Selection

• Projection

• Union

• Rename

Number of tuples in the relation is known as its

• Degree

• Granularity

• Cardinality

• Marginality

NATURAL JOIN can also be termed as combination of

• Union and Cartesian Product

• Selection and Cartesian Product

• Projection and Cartesian Product

• None

_____________ is a hardware component that is most important for the operation of a database management system.

• Microphone

• High Resolution Screen

• High Capacity Disk

• Flash Drive

Which of the following is not the utility of DBMS?

i) Backup ii) Loading iii) Process Organization iv) File organization

• i,ii and iv only

• i,ii and iii only

• i,iii and iv only

• ii,iii only