34 + Mcqs in Introduction To Database Page 1 McqOptions

1.	In Take Out Financing there is/are how many parties involve ?
A.	One
B.	Two
C.	Three
D.	Four
Answer» D. Four

Discussion

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.

Discussion

3.	They have their own syntax.
A.	DTD.
B.	XSLT.
C.	HTML.
D.	SOAP.
Answer» C. HTML.

Discussion

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

Discussion

5.	The DBMS ranked as being the "hardest to use" in the text is Microsoft's SQL Server.~!
A.	True
B.	False
Answer» C.

Discussion

6.	Database applications are seldom intended for use by a single user.~!
A.	True
B.	False
Answer» C.

Discussion

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.

Discussion

8.	The XML family of standards is very important in database processing today.%!
A.	True
B.	False
Answer» B. False

Discussion

9.	The DBMS ranked as being the "easiest to use" in the text is Oracle Corporation's Oracle.%!
A.	True
B.	False
Answer» C.

Discussion

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.

Discussion

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

Discussion

12.	A database design may be based on existing data.%!
A.	True
B.	False
Answer» B. False

Discussion

13.	A database has data and relationships.%!
A.	True
B.	False
Answer» B. False

Discussion

14.	Microsoft Access is an enterprise-class database product.%!
A.	True
B.	False
Answer» C.

Discussion

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

Discussion

16.	In a database, data is stored in spreadsheets which have rows and columns.%!
A.	True
B.	False
Answer» C.

Discussion

17.	The purpose of a database is to help people stop using spreadsheets.%!
A.	True
B.	False
Answer» C.

Discussion

18.	Enterprise Resource Planning (ERP) is an example of a single user database.%!
A.	True
B.	False
Answer» C.

Discussion

19.	A database is called "self-describing" because it contains a description of itself.%!
A.	True
B.	False
Answer» B. False

Discussion

20.	Applications are programs that interact directly with the database.%!
A.	True
B.	False
Answer» C.

Discussion

21.	A database has a built-in capability to create, process and administer itself.%!
A.	True
B.	False
Answer» C.

Discussion

22.	The relational database model was created by E.F. Codd.%!
A.	True
B.	False
Answer» B. False

Discussion

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.

Discussion

24.	*$_Helping people keep track of things is the purpose of a(n) ________ .?
A.	database
B.	table
C.	instance
D.	relationship
Answer» B. table

Discussion

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.

Discussion

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

Discussion

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

Discussion

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

Discussion

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

Discussion

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

Discussion

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

Discussion

32.	The following are components of a database except ________ .$?
A.	user data
B.	metadata
C.	reports
D.	indexes
Answer» D. indexes

Discussion

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

Discussion

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

Discussion

Explore topic-wise MCQs in Database.

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

XML documents have two sections.

They have their own syntax.

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

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

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

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

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

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

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

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

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

A database has data and relationships.%!

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

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

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

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

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

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

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

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

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

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

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

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

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

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

%_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 ________ ._%

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

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

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

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

SQL stands for ________ .?

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

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