The ________ states that a foreign key must either match a primary key
Practice Foreign Key Questions – The ________ states that a foreign key must either match a primary key value in another relation or it must be null.
Database Questions
Which of the following applies to a class rather than an object?
Practice Query Optimization – Which of the following applies to a class rather than an object?
Database redesign is not terribly difficult if the:
Practice Database Aggregation – Database redesign is not terribly difficult if the:
A ……………… normal form normalization will be needed where al
Practice Normalization Questions – A ……………… normal form normalization will be needed where all attributes in a relation tuple are not functionally dependent only on the key attribute.
Which one is correct statement? Logical data independence provides
Practice Two-Phase Locking Questions –
Which one is correct statement? Logical data independence provides following without changing application programs:
(i) Changes in access methods.
(ii) Adding new entities in database
(iii) Splitting an existing record into two or more records
(iv) Changing storage medium
A logical schema
Practice ER Diagram Questions –
A logical schema
Before any changes to database structure are attempted one should firs
Practice ER Diagram Questions – Before any changes to database structure are attempted one should first:
The DBMS utility, …………………. allows to reconstruct the cor
Practice Database Recovery Questions – The DBMS utility, …………………. allows to reconstruct the correct state of database from the backup and history of transactions.
Which of the following products was the first to implement true relati
Practice Database Rollback Questions – Which of the following products was the first to implement true relational algebra in a PC DBMS?
In a multi-user database, if two users wish to update the same reco
Practice Database Decomposition –
In a multi-user database, if two users wish to update the same record at the same time, they are prevented from doing so by
Which one of the following statements about normal forms is FALSE?<
Practice BCNF Questions –
Which one of the following statements about normal forms is FALSE?
Suppose the user finds the usage of room number
Practice ER Diagram Questions –
Suppose the user finds the usage of room number and phone number in a relational schema there is confusion.This is reduced by :-
Storage devices like tertiary storage , magnetic disk comes u
Practice Database Security Questions –
Storage devices like tertiary storage , magnetic disk comes under
Which level of RAID refers to disk mirroring with block striping?
Practice Database Security Questions –
Which level of RAID refers to disk mirroring with block striping?
A transparent DBMS ?
Practice Database Transaction – A transparent DBMS ?