MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 95 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.
| 51. |
A primary key if combined with a foreign key creates |
| A. | Parent-Child relationship between the tables that connect them. |
| B. | Many to many relationship between the tables that connect them. |
| C. | Network model between the tables that connect them. |
| D. | None of the above. |
| Answer» B. Many to many relationship between the tables that connect them. | |
| 52. |
Which one of the following is not true for a view: |
| A. | View is derived from other tables. |
| B. | View is a virtual table. |
| C. | A view definition is permanently stored as part of the database. |
| D. | View never contains derived columns. |
| Answer» D. View never contains derived columns. | |
| 53. |
The natural join is equal to : |
| A. | Cartesian Product |
| B. | Combination of Union and Cartesian product |
| C. | Combination of selection and Cartesian product |
| D. | Combination of projection and Cartesian product |
| Answer» D. Combination of projection and Cartesian product | |
| 54. |
An instance of relational schema R (A, B, C) has distinct values of A including NULL values. Which one of the following is true? |
| A. | A is a candidate key |
| B. | A is not a candidate key |
| C. | A is a primary Key |
| D. | Both (A) and (C) |
| Answer» C. A is a primary Key | |
| 55. |
Consider the join of a relation R with relation S. If R has m tuples and S has n tuples, then the maximum size of join is: |
| A. | mn |
| B. | m+n |
| C. | (m+n)/2 |
| D. | 2(m+n) |
| Answer» B. m+n | |
| 56. |
Cross Product is a: |
| A. | Unary Operator |
| B. | Ternary Operator |
| C. | Binary Operator |
| D. | Not an operator |
| Answer» D. Not an operator | |
| 57. |
In E-R Diagram derived attribute are represented by |
| A. | Ellipse |
| B. | Dashed ellipse |
| C. | Rectangle |
| D. | Triangle |
| Answer» E. | |
| 58. |
Which structure is the hierarchical model based |
| A. | Tree |
| B. | Graph |
| C. | Linked List |
| D. | None of the above |
| Answer» B. Graph | |
| 59. |
A table joined with itself is called |
| A. | Join |
| B. | Self Join |
| C. | Outer Join |
| D. | Equi Join |
| Answer» C. Outer Join | |
| 60. |
The method of access which uses key transformation is known as |
| A. | Direct |
| B. | Hash |
| C. | Random |
| D. | Sequential |
| Answer» C. Random | |
| 61. |
Enterprise Resource Planning (ERP) is an example of a single user database. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 62. |
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. | 1 |
| B. | |
| Answer» B. | |
| 63. |
The purpose of a database is to help people stop using spreadsheets. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 64. |
A database design may be based on existing data. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 65. |
Database applications are seldom intended for use by a single user. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 66. |
Structured Query Language (SQL) is an internationally recognized standard language that is understood by all commercial database management system products. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 67. |
Applications are programs that interact directly with the database. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 68. |
A database has a built-in capability to create, process and administer itself. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 69. |
The DBMS ranked as being the "hardest to use" in the text is Microsoft's SQL Server. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 70. |
Prior to 1970, all data was stored in separate files, which were mostly stored on reels of magnetic tape. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 71. |
Microsoft Access is an enterprise-class database product. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 72. |
The XML family of standards is very important in database processing today. |
| A. | 1 |
| B. | |
| C. | 1 |
| D. | |
| Answer» B. | |
| 73. |
One of the reasons why OODBMSs have not been widely used for business information systems is that OOP is obsolete. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 74. |
In a database, data is stored in spreadsheets which have rows and columns. |
| A. | 1 |
| B. | |
| Answer» C. | |
| 75. |
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 | |
| 76. |
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 | |
| 77. |
In an enterprise-class database system, business users interact directly with database applications, which directly access the database data. |
| A. | 1 |
| B. | |
| C. | 1 |
| D. | |
| Answer» C. 1 | |
| 78. |
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 | |
| 79. |
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 | |
| 80. |
Helping people keep track of things is the purpose of a(n) ________ . |
| A. | database |
| B. | table |
| C. | instance |
| D. | relationship |
| Answer» B. table | |
| 81. |
A database is called "self-describing" because it contains a description of itself. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 82. |
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 | |
| 83. |
SQL stands for ________ . |
| A. | Structured Query Language |
| B. | Sequential Query Language |
| C. | Structured Question Language |
| D. | Sequential Question Language |
| Answer» B. Sequential Query Language | |
| 84. |
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. | |
| 85. |
The DBMS ranked as being the "easiest to use" in the text is Oracle Corporation's Oracle. |
| A. | 1 |
| B. | |
| C. | 1 |
| D. | |
| Answer» C. 1 | |
| 86. |
A database has data and relationships. |
| A. | 1 |
| B. | |
| Answer» B. | |
| 87. |
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. | |
| 88. |
Which of the following products was an early implementation of the relational model developed by E.F. Codd of IBM? |
| A. | IDMS |
| B. | DB2 |
| C. | dBase-II |
| D. | R:base |
| Answer» C. dBase-II | |
| 89. |
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 | |
| 90. |
Which of the following products implemented the CODASYL DBTG model? |
| A. | IDMS |
| B. | DB2 |
| C. | dBase-II |
| D. | R:base |
| Answer» B. DB2 | |
| 91. |
The relational database model was created by E.F. Codd. |
| A. | 1 |
| B. | |
| C. | 1 |
| D. | |
| Answer» B. | |
| 92. |
Which of the following products was the first to implement true relational algebra in a PC DBMS? |
| A. | IDMS |
| B. | Oracle |
| C. | dBase-II |
| D. | R:base |
| Answer» E. | |
| 93. |
The following are components of a database except ________ . |
| A. | user data |
| B. | metadata |
| C. | reports |
| D. | indexes |
| Answer» D. indexes | |
| 94. |
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 | |
| 95. |
The DBMS acts as an interface between what two components of an enterprise-class database system? |
| A. | Database application and the database |
| B. | Data and the database |
| C. | The user and the database application |
| D. | Database application and SQL |
| Answer» B. Data and the database | |