WorksheetsDBTHON-23 Round-1
Total questions: 20
Worksheet time: 10mins
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
The logical design, and the snapshot of the data at a given instant in time is known as?
Instance and Relation
Relation and Instance
Schema and Instance
Schema and Relation
In the __________ normal form, a composite attribute is converted to individual attributes.
2NF
3NF
1NF
4NF
Table in 2NF Eliminates
Transitive Dependency
Multivalued Dependency
Partial Dependency
Primary Dependency
If every non-key attribute is functionally dependent primary key, then the relation will be in
1NF
3NF
2NF
4NF
The All or Nothing rule of a transaction comes under _____ property
Consistency
Atomicity
Durability
Isolation
