Database Management System (DBMS) MCQ
Databases that not related or linked to other data are called ________ databases.
Note: This Question is unanswered, help us to find answer for this one
Database management systems _____.
Answer
Correct Answer:
Are used to create, organize, and manage databases
Note: This Question is unanswered, help us to find answer for this one
Data integrity problems are likely to occur when __________.
Answer
Correct Answer:
Data is duplicated
Note: This Question is unanswered, help us to find answer for this one
Data in a multidimensional database is organized in a ________ format.
Note: This Question is unanswered, help us to find answer for this one
Data elements in a relational database are organized into ____.
Note: This Question is unanswered, help us to find answer for this one
Data ________ helps to ensure data integrity by maintaining information in only one place
Answer
Correct Answer:
Centralization
Note: This Question is unanswered, help us to find answer for this one
Corporate databases are an example of a(n) _________ source of data.
Note: This Question is unanswered, help us to find answer for this one
Controlled ____ makes a relational database work.
Answer
Correct Answer:
Redundancy
Note: This Question is unanswered, help us to find answer for this one
Which of the following method can be used to add more tables in a database?
Answer
Correct Answer:
All of these
Note: This Question is unanswered, help us to find answer for this one
Which filter method lets you filter the records that match the selected field?
Answer
Correct Answer:
Filter by selection
Note: This Question is unanswered, help us to find answer for this one
A logical schema
Answer
Correct Answer:
Is a standard way of organizing information into accessible parts.
Note: This Question is unanswered, help us to find answer for this one
You can filter the display of different Access objects in navigation pane from
Answer
Correct Answer:
Drop down menu at the top of navigation pane
Note: This Question is unanswered, help us to find answer for this one
What type of relationship exists between a Student table and Fees table?
Answer
Correct Answer:
One to Many
Note: This Question is unanswered, help us to find answer for this one
DBMS is a collection of ………….. that enables user to create and maintain a database.
Note: This Question is unanswered, help us to find answer for this one
.......... keyword is used to find the number of values in a column.
Note: This Question is unanswered, help us to find answer for this one
The options like Save, Open Database, Print are available in
Answer
Correct Answer:
File menu
Note: This Question is unanswered, help us to find answer for this one
Arrange according to the size
Answer
Correct Answer:
Record, field, byte, bit
Note: This Question is unanswered, help us to find answer for this one
Why do you pin an item in list?
Answer
Correct Answer:
To move it up and make it always available
Note: This Question is unanswered, help us to find answer for this one
A locked file can be?
Answer
Correct Answer:
Accessed by only one user
Note: This Question is unanswered, help us to find answer for this one
Grant and revoke are ....... statements.
Note: This Question is unanswered, help us to find answer for this one
Circular button with Office icon in it is
Answer
Correct Answer:
Office box
Note: This Question is unanswered, help us to find answer for this one
From which version Microsoft introduced Backstage View for Access Interface?
Answer
Correct Answer:
Access 2007
Note: This Question is unanswered, help us to find answer for this one
In a large DBMS?
Answer
Correct Answer:
Each user can see only a small part of the entire database
Note: This Question is unanswered, help us to find answer for this one
What type of relationship exists between a Teacher table and Class table?
Answer
Correct Answer:
Many to many
Note: This Question is unanswered, help us to find answer for this one
Which filter method lets you filter records based on criterion you specify?
Answer
Correct Answer:
Filter by form
Note: This Question is unanswered, help us to find answer for this one
A second Normal form does not permit ...... dependency between a non prime attribute and the relation key?
Note: This Question is unanswered, help us to find answer for this one
A condition that led to the development of database was?
Answer
Correct Answer:
All of these
Note: This Question is unanswered, help us to find answer for this one
TRUNCATE statement in SQL is a?
Answer
Correct Answer:
DDL statement
Note: This Question is unanswered, help us to find answer for this one