ROLLBACK in a database is ____ statement.
TCL
Well Done. Your Answer is Correct Keep it Up!
DCL
DML
DDL
Tag: Databases MCQs
External database is
External database is
Database created using DBMS package
Well Done. Your Answer is Correct Keep it Up!
Database created in MS-Word
Database created in EXCEL
All options are correct
Unlike filters queries can be saved as in a database.
Unlike filters queries can be saved as in a database.
Objects
Well Done. Your Answer is Correct Keep it Up!
Filters
Database
None of the options are correct
The method of file organization in which data records in a file are arranged in a specified order according to key field is known as the
The method of file organization in which data records in a file are arranged in a specified order according to key field is known as the
Sequential access method
Well Done. Your Answer is Correct Keep it Up!
Queuing method
Predetermined method
Direct access method
A collection of interrelated records is called a
A collection of interrelated records is called a
Database
Well Done. Your Answer is Correct Keep it Up!
Spreadsheet
Management information system
Text file
A data dictionary is a repository that manages _____
A data dictionary is a repository that manages _____
Metadata
Well Done. Your Answer is Correct Keep it Up!
Data Validator
Memory
Spell Checker
The overall description of a database is called______.
The overall description of a database is called______.
Database schema
Well Done. Your Answer is Correct Keep it Up!
Data integrity
Data manipulation
Data definition
Which one is the guideline of Referential integrity in a relationship ?
Which one is the guideline of Referential integrity in a relationship ?
Do not enter a value in the foreign key field of a child table if that value does not exist in the primary key of the parent table
Well Done. Your Answer is Correct Keep it Up!
Do not enter a value in the primary key field of chield table if that value does not exist inthe primary key of the parent table
Do not enter a value in the foreign key field of a parent table if that value doesnot exist in the primary key of the child table
Do not enter a value in the foreign key field of child table if that value does not exist inthe foreign key of the parent table
Which of the following is not a database object?
Which of the following is not a database object?
Relationships
Well Done. Your Answer is Correct Keep it Up!
Tables
Queries
Reports
Two tables can be linked with relationship to _____
Two tables can be linked with relationship to _____
Ensure data integrity
Well Done. Your Answer is Correct Keep it Up!
Ensure Foreign Key
Ensure data entry
Create Primary Key