Drop Table cannot be used to drop a table referenced by a …………… constraint.
Foreign Key
Well Done. Your Answer is Correct Keep it Up!
Composite Key
Primary Key
Local Key
Category: Databases MCQs
To delete a database ………………. command is used
To delete a database ………………. command is used
drop database database_name
Well Done. Your Answer is Correct Keep it Up!
Delete database_name
delete database database_name
drop database_name
………….. is a combination of two of more attributes used as a primary key
………….. is a combination of two of more attributes used as a primary key
Composite Key
Well Done. Your Answer is Correct Keep it Up!
Alternate Key
Candidate Key
Foreign Key
Which of the following is not the function of client?
Which of the following is not the function of client?
Query optimization
Well Done. Your Answer is Correct Keep it Up!
Compile queries
Receive queries
Result formatting and presentation
Is a special type of stored procedure that is automatically invoked whenever the data in the table is modified.
Is a special type of stored procedure that is automatically invoked whenever the data in the table is modified.
Trigger
Well Done. Your Answer is Correct Keep it Up!
Procedure
Curser
None of the Option is Correct
Requires that data should be made available to only authorized users.
Requires that data should be made available to only authorized users.
Security
Well Done. Your Answer is Correct Keep it Up!
Privacy
Data integrity
None of the Option is Correct
Processed data is called ………………..
Processed data is called ………………..
Information
Well Done. Your Answer is Correct Keep it Up!
Raw data
Useful data
Source
HSAM stands for ……….
HSAM stands for ……….
Hierarchic Sequential Access Method
Well Done. Your Answer is Correct Keep it Up!
Hierarchic Standard Access Method
Hierarchic Sequential and Method
Hierarchic Standard and Method
Is a utility to capture a continuous record of server activity and provide auditing capability.
Is a utility to capture a continuous record of server activity and provide auditing capability.
SQL server service manager
Well Done. Your Answer is Correct Keep it Up!
SQL server Profile
SQL server setup
SQL server wizard
Approach reduces time and effort required for design and lesser risk in database management.
Approach reduces time and effort required for design and lesser risk in database management.
Multiple databases
Well Done. Your Answer is Correct Keep it Up!
Top-down approach
Single global database
None of the Option is Correct