> > Database MCQs > Database Management System (DBMS) MCQs

Database Management System (DBMS) MCQ

1. Databases that not related or linked to other data are called ________ databases.

Flat

Globe

Four

Design

Answer

Correct Answer: Flat

Note: This Question is unanswered, help us to find answer for this one

2. Database management systems _____.

Are used to create, organize, and manage databases

Thin clients have no processing power.

They use natural language processing.

It is an independent program that can spread itself without attaching itself to a host program

Answer

Correct Answer: Are used to create, organize, and manage databases

Note: This Question is unanswered, help us to find answer for this one

3. Data integrity problems are likely to occur when __________.

Data is duplicated

The data design has a N:M relationship

Minimum cardinalities are not met

Attribute conflicts are not resolved

Normal forms are used

Answer

Correct Answer: Data is duplicated

Note: This Question is unanswered, help us to find answer for this one

4. Data in a multidimensional database is organized in a ________ format.

Linear

Modular

Cube

Cellular

Answer

Correct Answer: Cube

Note: This Question is unanswered, help us to find answer for this one

5. Data elements in a relational database are organized into ____.

Tuple

False

Tables

Attribute

Answer

Correct Answer: Tables

Note: This Question is unanswered, help us to find answer for this one

6. Data ________ helps to ensure data integrity by maintaining information in only one place

Flexibility

Redundancy

Mapping

Centralization

Answer

Correct Answer: Centralization

Note: This Question is unanswered, help us to find answer for this one

7. Corporate databases are an example of a(n) _________ source of data.

Internal

Master data

A database

Data marts

Answer

Correct Answer: Internal

Note: This Question is unanswered, help us to find answer for this one

8. Controlled ____ makes a relational database work.

Relations

Logic

Chaos

Redundancy

Answer

Correct Answer: Redundancy

Note: This Question is unanswered, help us to find answer for this one

9. Which of the following method can be used to add more tables in a database?

Table Wizard

By Entering Data

Design View

All of these

Answer

Correct Answer: All of these

Note: This Question is unanswered, help us to find answer for this one

10. Which filter method lets you filter the records that match the selected field?

Advanced filter

Filter by selection

Filter by form

Auto filter

Answer

Correct Answer: Filter by selection

Note: This Question is unanswered, help us to find answer for this one

11. A logical schema

Is the entire database

Describes how data is actually stored on disk.

All of these

Is a standard way of organizing information into accessible parts.

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

12. You can filter the display of different Access objects in navigation pane from

Drop down menu at the top of navigation pane

Sort & Filter group in Home menu

Database tab

View tab in ribbon

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

13. What type of relationship exists between a Student table and Fees table?

Many to many

One to One

One to many and many to many

One to Many

Answer

Correct Answer: One to Many

Note: This Question is unanswered, help us to find answer for this one

14. DBMS is a collection of ………….. that enables user to create and maintain a database.

Language Activity

Translators

Keys

Program

Answer

Correct Answer: Program

Note: This Question is unanswered, help us to find answer for this one

15. .......... keyword is used to find the number of values in a column.

SUM

Add

COUNT

TOTAL

Answer

Correct Answer: COUNT

Note: This Question is unanswered, help us to find answer for this one

16. The options like Save, Open Database, Print are available in

File menu

Home tab

Database Tools tab

Backstage View tab

Answer

Correct Answer: File menu

Note: This Question is unanswered, help us to find answer for this one

17. Arrange according to the size

Bit, field, byte, record

Byte, bit, record, field

Field, byte, record, bit

Record, field, byte, bit

Answer

Correct Answer: Record, field, byte, bit

Note: This Question is unanswered, help us to find answer for this one

18. Why do you pin an item in list?

None of these

To mark it to delete from list

To move it up and make it always available

To make it default database when you open Access

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

19. A locked file can be?

Accessed by only one user

Modified by users with the correct password

None of these

Is used to hide sensitive information

Modified by users with the correct password and Is used to hide sensitive information

Answer

Correct Answer: Accessed by only one user

Note: This Question is unanswered, help us to find answer for this one

20. Grant and revoke are ....... statements.

DML

DDL

TCL

DCL

Answer

Correct Answer: DCL

Note: This Question is unanswered, help us to find answer for this one

21. Circular button with Office icon in it is

Control menu box

Office box

Company box

Control box

Answer

Correct Answer: Office box

Note: This Question is unanswered, help us to find answer for this one

22. From which version Microsoft introduced Backstage View for Access Interface?

Access 2007

Access does not have Backstage View

Access 2003

Access 2010

Answer

Correct Answer: Access 2007

Note: This Question is unanswered, help us to find answer for this one

23. In a large DBMS?

Each sub schema contains every field in the logical schema

None of these

All of these

Each user can see only a small part of the entire database

Each user can access every sub schema

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

24. What type of relationship exists between a Teacher table and Class table?

One to Many

One to One

Many to many

Two to two

Answer

Correct Answer: Many to many

Note: This Question is unanswered, help us to find answer for this one

25. Which filter method lets you filter records based on criterion you specify?

Filter by selection

Advanced filter

Auto filter

Filter by form

Answer

Correct Answer: Filter by form

Note: This Question is unanswered, help us to find answer for this one

26. A second Normal form does not permit ...... dependency between a non prime attribute and the relation key?

Multi

Functional

Valued

Partial

Answer

Correct Answer: Partial

Note: This Question is unanswered, help us to find answer for this one

27. A condition that led to the development of database was?

None of these

The poliferation of data files

A demand for more data to support information needs

An increase in the amount of data handled by organizations

All of these

Answer

Correct Answer: All of these

Note: This Question is unanswered, help us to find answer for this one

28. TRUNCATE statement in SQL is a?

DCL statement

DML statement

DDL statement

None of these

Answer

Correct Answer: DDL statement

Note: This Question is unanswered, help us to find answer for this one

Database MCQs | Topic-wise

MCQ on Advance Database	MCQ on Basic Database
MCQ on Database Administration	MCQ on Database Application
MCQ on Database Concepts	MCQ on Database Management System
MCQ on Database Management System (DBMS)	MCQ on Database Organization & Design
MCQ on Introduction to Database	MCQ on Modern Database Management
MCQ on SQL Server DBA	MCQ on SQL Server Database
MCQ on Window Server 2003	General Database MCQs