Computers

Database Management

mcq test

What can Structured Query Language (SQL) be used for?

A. Create Databases

B. Create & Modify Databases

C. Create, Modify & Query Databases

D. None of the above

MCQ -1

C. Create, Modify & Query Databases

10

09

08

07

06

05

04

03

02

01

Which among the following are not Objects in an Access Database?

A. Table

B. Form

C. Query

D. Pivot table

MCQ -2

D. Pivot table

10

09

08

07

06

05

04

03

02

01

Which of the following is used as an application programming interface with RDBMS?

A. VB

B. COBOL

C. SQL

D. All of the Above

MCQ -3

C. SQL

10

09

08

07

06

05

04

03

02

01

What is the full form of IMDBMS?

A. In-Memory database management system

B. In-Module database management system

C. Indian Memory database management system

D. None of these

MCQ -4

A. In-Memory database management system

10

09

08

07

06

05

04

03

02

01

Which of the following DBMS is well-suited for data warehouses with a large number of similar data items?

A. Columnar database management system

B. In-memory database management system

C. RDBMS

D. NOSQL DBMS

MCQ -5

A. Columnar database management system

10

09

08

07

06

05

04

03

02

01

What are the advantages of using a DBMS?

A. Data security

B. Data abstraction

C. Data integrity

D. All of the Above

MCQ -6

D. All of the Above

10

09

08

07

06

05

04

03

02

01

Who is known as the father of the DBMS?

A. Van Neumann

B. E.F.Codd

C. Steve Jobs

D. Bill Gates

MCQ -7

B. E.F.Codd

10

09

08

07

06

05

04

03

02

01

What are the basic components of a relational database model?

A. Table

B. Record

C. Field

D. All of the Above

MCQ -8

D. All of the Above

10

09

08

07

06

05

04

03

02

01

Who is the father of MySQL?

A. Charles Babbage

B. Michael Wideneus

C. Allen Jobs

D. Madam Kama

MCQ -9

B. Michael Wideneus

10

09

08

07

06

05

04

03

02

01

What is the name given to the skilled professional who directs all activities related to an organisation's database?

A. System Administrator

B. System Manager

C. Database administrator

D. Database Manager

MCQ -10

C. Database administrator

10

09

08

07

06

05

04

03

02

01

next story

next story