Database Management System and Design Multiple Choice Questions (MCQs)

We have compiled a list of 100+ questions with answers from Database Management System and Design that help you to check your basic knowledge of Database Management System and prepare for competitive exams. All these multiple choice questions are prepared by the subject experts from authentic resources. Attempt all the questions and check your Database Management System knowledge online.

This category includes the topics such as Introduction, A Database Model, Relational Database Model, Integrity, RDBMS, SQL and Embedded SQL, Writing Basic SQL SELECT Statements, Restricting and Sorting data, Single Row Functions, Displaying Data from Multiple Tables, Aggregation Data Using Group Functions, Sub Queries, Manipulating Data and Creating &Managing Tables, Creating Views and Controlling User Access, Using Set Operators, Date time Function, Database Design: Logical Design, Conceptual Design, Mapping Conceptual to Logical, Pragmatic issues, Physical Design, Integrity and Correctness, Relational Algebra, Relational Calculus. Normalization: 1NF, 2NF, 3NF, BCNF, 4NF, 5NF, DKNF. Architecture of DBMS: Client-server, Open Architectures, Transaction Processing, Multi-User & Concurrency, and Backup & Recovery Database, Basic Concept of major RDBMS products: Oracle, Sybase, DB2, SQL Server and other Databases.

Following are the important multiple choice questions with answers from the Database Management System and Design section. You can choose the correct answer from option A, B, C and D.

Database MCQs Practice MCQ Question and Answer

31

By Grouped Report you understand

A. Type of report generated by the Report Wizard

B. Type of report that present records sorted in ascending or descending order as you specify

C. Type of report that displays data grouped by fields you specified

D. None of above

32

The text you typed in Description column in Table Design View is displayed on

A. Description bar in forms

B. Report Footer when printed

C. Title bar of MS Access while entering data

D. Status bar while entering data

33

What is the maximum allowed field size for Boolean (Yes/No) fields?

A. 1

B. 8

C. 50

D. 255

34

What is the size of Data & Time field type?

A. 1

B. 8

C. 255

D. 50

35

Which of the following field type can store maximum data?

A. Yes/No fields

B. Date/Time fields

C. Text fields

D. Memo fields

36

To display associated record from related table in datasheet view, you can

A. Double click the record

B. Apply filter by form command

C. Single click on expand indicator (+) next to the record

D. Double click on expand indicator (+) next to the record

37

Arrange according to the size

A. Record, field, byte, bit

B. Bit, field, byte, record

C. Field, byte, record, bit

D. Byte, bit, record, field

38

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

A. One to one

B. One to many

C. Many to many

D. One to many and many to many

39

Identify the relationship between a Movie table and Stars table:

A. One to one

B. One to many

C. Many to many

D. None of above

40

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

A. One to many

B. Many to many

C. One to one

D. Two to two

41

Which of following relationship type is not possible to realize in Access Database directly?

A. One to one

B. One to many

C. Many to many

D. None of above

42

For which kind of relationship you need a junction table to reflect real world situation?

A. One to one

B. One to many

C. Many to many

D. None of above

43

What do you need if you should enforce many-to-many relationship between two tables?

A. Parent table

B. Child table

C. Junction table

D. Many-to-many relationship can't be created in database

44

You can display data from multiple tables by using

A. Page break

B. Sub form

C. Columnar form

D. Tabular form

45

Which database model organizes data in tree-like structure?

A. Relational model

B. Hierarchical model

C. Network model

D. Document model

Database Management System and Design Multiple Choice Questions (MCQs)

Database MCQs Practice MCQ Question and Answer

31

By Grouped Report you understand

Answer & Solution

32

The text you typed in Description column in Table Design View is displayed on

Answer & Solution

33

What is the maximum allowed field size for Boolean (Yes/No) fields?

Answer & Solution

34

What is the size of Data & Time field type?

Answer & Solution

35

Which of the following field type can store maximum data?

Answer & Solution

36

To display associated record from related table in datasheet view, you can

Answer & Solution

37

Arrange according to the size

Answer & Solution

38

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

Answer & Solution

39

Identify the relationship between a Movie table and Stars table:

Answer & Solution

40

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

Answer & Solution

41

Which of following relationship type is not possible to realize in Access Database directly?

Answer & Solution

42

For which kind of relationship you need a junction table to reflect real world situation?

Answer & Solution

43

What do you need if you should enforce many-to-many relationship between two tables?

Answer & Solution

44

You can display data from multiple tables by using

Answer & Solution

45

Which database model organizes data in tree-like structure?

Answer & Solution

Categories

Random Posts

About

Important Link

Company

Others

Social Media

Database Management System and Design Multiple Choice Questions (MCQs)

Database MCQs Practice MCQ Question and Answer

31 By Grouped Report you understand

Answer & Solution

32 The text you typed in Description column in Table Design View is displayed on

Answer & Solution

33 What is the maximum allowed field size for Boolean (Yes/No) fields?

Answer & Solution

34 What is the size of Data & Time field type?

Answer & Solution

35 Which of the following field type can store maximum data?

Answer & Solution

36 To display associated record from related table in datasheet view, you can

Answer & Solution

37 Arrange according to the size

Answer & Solution

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

Answer & Solution

39 Identify the relationship between a Movie table and Stars table:

Answer & Solution

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

Answer & Solution

41 Which of following relationship type is not possible to realize in Access Database directly?

Answer & Solution

42 For which kind of relationship you need a junction table to reflect real world situation?

Answer & Solution

43 What do you need if you should enforce many-to-many relationship between two tables?

Answer & Solution

44 You can display data from multiple tables by using

Answer & Solution

45 Which database model organizes data in tree-like structure?

Answer & Solution

Categories

Random Posts

Social Media

31

By Grouped Report you understand

32

The text you typed in Description column in Table Design View is displayed on

33

What is the maximum allowed field size for Boolean (Yes/No) fields?

34

What is the size of Data & Time field type?

35

Which of the following field type can store maximum data?

36

To display associated record from related table in datasheet view, you can

37

Arrange according to the size

38

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

39

Identify the relationship between a Movie table and Stars table:

40

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

41

Which of following relationship type is not possible to realize in Access Database directly?

42

For which kind of relationship you need a junction table to reflect real world situation?

43

What do you need if you should enforce many-to-many relationship between two tables?

44

You can display data from multiple tables by using

45

Which database model organizes data in tree-like structure?