

MCQOPTIONS
Saved Bookmarks
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 | |