Data items grouped together for storage purposes are called a
record
Well Done. Your Answer is Correct Keep it Up!
title
list
string
Author: administrator
SQL server stores index information in the ………… system table
SQL server stores index information in the ………… system table
sys indexes
Well Done. Your Answer is Correct Keep it Up!
sysind
system indexes
syst indexes
The one guideline to be followed while designing the database is
The one guideline to be followed while designing the database is
It should avoid/reduce the redundancy.
Well Done. Your Answer is Correct Keep it Up!
Unrelated data should be in the same table so that updating the data will be easy.
A database design may be ambiguous.
An entity should not have attributes
Is a preferred method for enforcing data integrity
Is a preferred method for enforcing data integrity
Constraints
Well Done. Your Answer is Correct Keep it Up!
Stored procedure
Triggers
Cursors
Which of the following is not a logical database structure?
Which of the following is not a logical database structure?
Chain
Well Done. Your Answer is Correct Keep it Up!
Network
Tree
Relational
Which if the following is not the type of data integrity.
Which if the following is not the type of data integrity.
Key integrity
Well Done. Your Answer is Correct Keep it Up!
Domain integrity
Entity integrity
Referential integrity
Which can be used to delete all the rows if a table?
Which can be used to delete all the rows if a table?
Delete * from table_name
Well Done. Your Answer is Correct Keep it Up!
Delete from table_name
Delete table_name
all rows cannot be deleted at a time.
4NF stands for
4NF stands for
Fourth Normal Form
Well Done. Your Answer is Correct Keep it Up!
Fourth Normal File
Fourth Normal Fraction
Fourth Negative File
A ……………… allows to make copies of the database periodically to help in the cases of crashes & disasters.
A ……………… allows to make copies of the database periodically to help in the cases of crashes & disasters.
Backup Utility
Well Done. Your Answer is Correct Keep it Up!
Recovery utility
Monitoring utility
Data loading utility
Allows definitions and query language statements to be entered; query results are formatted and displayed.
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