Explore topic-wise MCQs in Database.

This section includes 34 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.

1.

In Take Out Financing there is/are how many parties involve ?

A. One
B. Two
C. Three
D. Four
Answer» D. Four
2.

XML documents have two sections.

A. XSLT is a declarative transformation language.
B. XSLT uses a set of rules that govern how a document is to be materialized is created.
C. XSLT uses a set of procedures that specify how a document is to be programmed.
D. XSLT is used to transform the input document into another document.
Answer» D. XSLT is used to transform the input document into another document.
3.

They have their own syntax.

A. DTD.
B. XSLT.
C. HTML.
D. SOAP.
Answer» C. HTML.
4.

In an Enterprise-class database system, business users interact directly with database applications that interact with the DBMS, which directly accesses the database data.~!

A. True
B. False
Answer» B. False
5.

The DBMS ranked as being the "hardest to use" in the text is Microsoft's SQL Server.~!

A. True
B. False
Answer» C.
6.

Database applications are seldom intended for use by a single user.~!

A. True
B. False
Answer» C.
7.

In an enterprise-class database system, business users interact directly with database applications, which directly access the database data.~!

A. True
B. False
Answer» C.
8.

The XML family of standards is very important in database processing today.%!

A. True
B. False
Answer» B. False
9.

The DBMS ranked as being the "easiest to use" in the text is Oracle Corporation's Oracle.%!

A. True
B. False
Answer» C.
10.

One of the reasons why OODBMSs have not been widely used for business information systems is that OOP is obsolete.%!

A. True
B. False
Answer» C.
11.

Structured Query Language (SQL) is an internationally recognized standard language that is understood by all commercial database management system products.%!

A. True
B. False
Answer» B. False
12.

A database design may be based on existing data.%!

A. True
B. False
Answer» B. False
13.

A database has data and relationships.%!

A. True
B. False
Answer» B. False
14.

Microsoft Access is an enterprise-class database product.%!

A. True
B. False
Answer» C.
15.

Prior to 1970, all data was stored in separate files, which were mostly stored on reels of magnetic tape.%!

A. True
B. False
Answer» B. False
16.

In a database, data is stored in spreadsheets which have rows and columns.%!

A. True
B. False
Answer» C.
17.

The purpose of a database is to help people stop using spreadsheets.%!

A. True
B. False
Answer» C.
18.

Enterprise Resource Planning (ERP) is an example of a single user database.%!

A. True
B. False
Answer» C.
19.

A database is called "self-describing" because it contains a description of itself.%!

A. True
B. False
Answer» B. False
20.

Applications are programs that interact directly with the database.%!

A. True
B. False
Answer» C.
21.

A database has a built-in capability to create, process and administer itself.%!

A. True
B. False
Answer» C.
22.

The relational database model was created by E.F. Codd.%!

A. True
B. False
Answer» B. False
23.

The DBMS that is most difficult to use is ________ .%!

A. Microsoft's SQL Server
B. Microsoft's Access
C. IBM's DB2
D. Oracle Corporation's Oracle
Answer» E.
24.

*$_Helping people keep track of things is the purpose of a(n) ________ .?

A. database
B. table
C. instance
D. relationship
Answer» B. table
25.

*$_Which of the following is not considered to be a basic element of an enterprise-class database system??

A. Users
B. Database applications
C. DBMS
D. COBOL programs
Answer» E.
26.

*/*_An on-line commercial site such as Amazon.com is an example of a(n) ________ .?

A. single-user database application
B. multiuser database application
C. e-commerce database application
D. data mining database application
Answer» D. data mining database application
27.

%_The following are functions of a DBMS except ________ ._%

A. creating and processing forms
B. creating databases
C. processing data
D. administrating databases
Answer» B. creating databases
28.

%_You have run an SQL statement that asked the DBMS to display data in a table named USER_TABLES. The results include columns of data labeled "TableName," "NumberOfColumns" and "PrimaryKey." You are looking at ________ ._%

A. user data
B. metadata
C. A report
D. indexes
Answer» C. A report
29.

_ An application where only one user accesses the database at a given time is an example of a(n) ________ .$?

A. single-user database application
B. multiuser database application
C. e-commerce database application
D. data mining database application
Answer» B. multiuser database application
30.

_Because it contains a description of its own structure, a database is considered to be ________ .$?

A. described
B. metadata compatible
C. self-describing
D. an application program
Answer» D. an application program
31.

_A DBMS that combines a DBMS and an application generator is ________ .$?

A. Microsoft's SQL Server
B. Microsoft's Access
C. IBM's DB2
D. Oracle Corporation's Oracle
Answer» C. IBM's DB2
32.

The following are components of a database except ________ .$?

A. user data
B. metadata
C. reports
D. indexes
Answer» D. indexes
33.

SQL stands for ________ .?

A. Structured Query Language
B. Sequential Query Language
C. Structured Question Language
D. Sequential Question Language
Answer» B. Sequential Query Language
34.

An Enterprise Resource Planning application is an example of a(n) ________ .?

A. single-user database application
B. multiuser database application
C. e-commerce database application
D. data mining database application
Answer» C. e-commerce database application