Allows definitions and query language statements to be entered; query results are formatted and displayed.
Terminal Interface
Well Done. Your Answer is Correct Keep it Up!
Query Processor
Schema Processor
None of the Option is Correct
Category: Databases MCQs
The main task carried out in the …………… is to remove repeating attributes to separate tables.
The main task carried out in the …………… is to remove repeating attributes to separate tables.
Fourth Normal Form
Well Done. Your Answer is Correct Keep it Up!
Third Normal Form
Second Normal Form
First Normal Form
Is the powerful language for working with RDBMS.
Is the powerful language for working with RDBMS.
Query Language
Well Done. Your Answer is Correct Keep it Up!
Embedded Programs
Dynamic Programs
Static Language Programs
The file in DBMS is called as ……………… in RDBMS.
The file in DBMS is called as ……………… in RDBMS.
table
Well Done. Your Answer is Correct Keep it Up!
console
schema
object
In ………………… , we have a strict parent-child relationship only.
In ………………… , we have a strict parent-child relationship only.
hierarchical databases
Well Done. Your Answer is Correct Keep it Up!
network databases
object oriented databases
relational databases
Which normal form is considered adequate for relational database design?
Which normal form is considered adequate for relational database design?
3 NF
Well Done. Your Answer is Correct Keep it Up!
2 NF
4 NF
BCNF
What operator tests column for the absence of data?
What operator tests column for the absence of data?
IS NULL operator
Well Done. Your Answer is Correct Keep it Up!
ASSIGNMENT operator
LIKE operator
NOT operator
Which contain information about a file needed by system programs for accessing file records?
Which contain information about a file needed by system programs for accessing file records?
File headers
Well Done. Your Answer is Correct Keep it Up!
File operators
File blocks
None of the Option is Correct
DBMS distributes data processing tasks between the workstation and network server
DBMS distributes data processing tasks between the workstation and network server
Client Server
Well Done. Your Answer is Correct Keep it Up!
Hierarchical
Relational
Network
______ is a statement that is executed automatically by the system.
______ is a statement that is executed automatically by the system.
trigger
Well Done. Your Answer is Correct Keep it Up!
assertion
durability
integrity constraint