MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 98 Mcqs, each offering curated multiple-choice questions to sharpen your Database Management System knowledge and support exam preparation. Choose a topic below to get started.
| 51. |
A ______ module is typically designed so that it will run on a user workstation or personal computer. |
| A. | Software |
| B. | Server |
| C. | Program |
| D. | Client |
| Answer» E. | |
| 52. |
_______ product was acquired by Informix, integrated into its RDBMS and introduced as the Informix Universal Server an ORDBMS. |
| A. | Star |
| B. | llustar |
| C. | SQL |
| D. | Cygnus |
| Answer» C. SQL | |
| 53. |
The ______ language consists of SQL statements for operating on the data (insert, Modify, Delete) in tables that already exist. |
| A. | Data Manipulation |
| B. | Data Definition |
| C. | C. |
| D. | |
| E. | None |
| Answer» B. Data Definition | |
| 54. |
_____ database is used to provide statistical information or summaries of values based on various criteria. |
| A. | Statistical |
| B. | Mathematical |
| C. | Normalized |
| D. | Un normalized |
| Answer» B. Mathematical | |
| 55. |
Protection of data from unauthorized Disclosure results in loss of _______ |
| A. | Integrity |
| B. | Availability |
| C. | Confidentiality |
| D. | Discretionary Security |
| Answer» D. Discretionary Security | |
| 56. |
E-R Modeling is achieved by using ____ diagrams |
| A. | DFD |
| B. | Flowcharts |
| C. | Gantt Charts |
| D. | D. |
| Answer» E. | |
| 57. |
The ______ key of a relation is the attribute (column) or collection of attributes, which uniquely identify a given tuple. |
| A. | Primary |
| B. | Foreign |
| C. | Candidate |
| D. | Alternate |
| Answer» B. Foreign | |
| 58. |
The middleware databases in which the business rules act are applicable to _______ tier architectures |
| A. | Single |
| B. | Three |
| C. | Two |
| D. | None |
| Answer» C. Two | |
| 59. |
Grant and revoke are _____ statements. |
| A. | TCL |
| B. | DCL |
| C. | DDL |
| D. | DML |
| Answer» C. DDL | |
| 60. |
By ______ an area on disk in certain ways, one can make it represent a bit value of either zero (0) or one (1). |
| A. | Vulcanizing |
| B. | Galvanizing |
| C. | Magnetizing |
| D. | Passing UV rays |
| Answer» D. Passing UV rays | |
| 61. |
The transactions like adding an employee, enrolling a student in a course are examples of _______ |
| A. | Logica |
| B. | Physical |
| C. | None |
| D. | Theoretical |
| Answer» B. Physical | |
| 62. |
Which of the following relational algebra operations do not require the participating tables to be union-compatible? |
| A. | Union |
| B. | Intersection |
| C. | Difference |
| D. | Join |
| Answer» E. | |
| 63. |
Which of the following is not a property of transactions? |
| A. | Atomicity |
| B. | Concurrency |
| C. | Isolation |
| D. | Durability |
| Answer» C. Isolation | |
| 64. |
Employees in a company are each assigned their own office, i.e. for each employee there exists a unique office and for each office there exists a unique employee; This statement is an example of ____ type of relation. |
| A. | 1:1 |
| B. | 1: Many |
| C. | C. |
| D. | |
| E. | Many : Many |
| Answer» B. 1: Many | |
| 65. |
The fact that information in the data warehouse changes far less often and may be regarded as non-real-time with periodic updating; This implies that data warehouses are _______ |
| A. | Volatile |
| B. | Non - Volatile |
| C. | C. |
| D. | D. |
| Answer» C. C. | |
| 66. |
The data in the database at a particular moment of time is called the _______ |
| A. | Snapshot |
| B. | Dynaset |
| C. | Stateless |
| D. | Stateful |
| Answer» B. Dynaset | |
| 67. |
A ____ key specifies a uniqueness constraint that no two distinct tuples in any state r of relation R can have the same value for super key. |
| A. | Sub |
| B. | Parent |
| C. | Candidate |
| D. | Super |
| Answer» E. | |
| 68. |
The fact that all employees of a particular organization should not have salaries more than $10000 is a _____ constraint. |
| A. | Schema |
| B. | Tuple |
| C. | Domain |
| D. | Relational |
| Answer» D. Relational | |
| 69. |
A weak entity has an ______ dependency on its owner entity, which can be used for both ON UPDATE and ON DELETE. |
| A. | Direct |
| B. | Indirect |
| C. | Existence |
| D. | No |
| Answer» D. No | |
| 70. |
The size of a data item is called its _______, which can be a field of some record or may be a larger unit such as a record. |
| A. | Similarity |
| B. | Granularity |
| C. | Dimensionality |
| D. | Arity |
| Answer» C. Dimensionality | |
| 71. |
Between DRAM and magnetic disk storage another form of memory, called ______ memory is becoming common because it is non volatile. |
| A. | RAM |
| B. | Flash |
| C. | Hard Disk |
| D. | D. |
| Answer» C. Hard Disk | |
| 72. |
The _____ category includes storage media that can be operated on directly by the computers central processing unit. |
| A. | Primary storage |
| B. | Secondary Storage |
| C. | C. |
| D. | D. |
| E. | |
| Answer» B. Secondary Storage | |
| 73. |
The concept of mapping of ______ entity types is the concept in which the for each strong entity type E in the ER schema, create a relation R that includes all the simple attributes of E |
| A. | Regular |
| B. | Irregular |
| C. | None |
| D. | Weak |
| Answer» B. Irregular | |
| 74. |
A DBMS is a ____ user if at most one user can use the system and is mostly restricted to personal computer systems. |
| A. | None |
| B. | Multi |
| C. | Single |
| D. | Concurrent |
| Answer» D. Concurrent | |
| 75. |
A data type or format is specified for each _________ |
| A. | Relation |
| B. | Tuple |
| C. | Database |
| D. | Domain |
| Answer» C. Database | |
| 76. |
What are the desirable properties of a decomposition |
| A. | Partition constraint. |
| B. | B. |
| C. | |
| D. | Redundancy. |
| E. | Security. |
| Answer» C. | |
| 77. |
A relation is in attribute of other composite key. if an attribute of a composite key is dependent on an |
| A. | 2NF |
| B. | 3NF |
| C. | BCNF |
| D. | 1NF |
| Answer» C. BCNF | |
| 78. |
The rule that a value of a foreign key must appear as a value of some specific table is called a |
| A. | Referential constraint. |
| B. | B. |
| C. | C. |
| D. | |
| E. | Functional dependency. |
| Answer» B. B. | |
| 79. |
The clause in SQL that specifies that the query result should be sorted in ascending or descending order based on the values of one or more columns is |
| A. | View |
| B. | Order by |
| C. | C. |
| D. | |
| E. | Having |
| Answer» C. C. | |
| 80. |
The division operator divides a dividend A of degree m+n by a divisor relation B of degree n and produces a result of degree |
| A. | m - 1 |
| B. | B. |
| C. | |
| D. | m * m |
| E. | D. |
| Answer» E. D. | |
| 81. |
The normalization was first proposed by . |
| A. | Code |
| B. | Codd |
| C. | Boyce Codd |
| D. | D. |
| Answer» C. Boyce Codd | |
| 82. |
The normal form that is not necessarily dependency preserving is |
| A. | 2NF |
| B. | 3NF |
| C. | BCNF |
| D. | 4NF |
| Answer» B. 3NF | |
| 83. |
The statement that is executed automatically by the system as a side effect of the modification of the database is |
| A. | backup |
| B. | assertion |
| C. | recovery |
| D. | trigger |
| Answer» E. | |
| 84. |
In multiple granularity of locks SIX lock is compatible with |
| A. | IX |
| B. | IS |
| C. | S |
| D. | SIX |
| Answer» C. S | |
| 85. |
A transaction is in state after the final statement has been executed. |
| A. | partially committed |
| B. | B. |
| C. | C. |
| D. | D. |
| E. | |
| Answer» D. D. | |
| 86. |
The keyword to eliminate duplicate rows from the query result in SQL is |
| A. | DISTINCT |
| B. | NO DUPLICATE |
| C. | C. |
| D. | D. |
| E. | |
| Answer» D. D. | |
| 87. |
If the closure of an attribute set is the entire relation then the attribute set is a |
| A. | superkey |
| B. | candidate key |
| C. | C. |
| D. | |
| E. | not a key |
| Answer» B. candidate key | |
| 88. |
DROP is a statement in SQL. |
| A. | Query |
| B. | Embedded SQL |
| C. | C. |
| D. | D. |
| Answer» D. D. | |
| 89. |
The default level of consistency in SQL is |
| A. | repeatable read |
| B. | B. |
| C. | |
| D. | read uncommitted |
| E. | D. |
| Answer» E. D. | |
| 90. |
Which of the following concurrency control schemes is not based on the serializability property? |
| A. | Two - phase locking |
| B. | Graph-based locking |
| C. | Time-stamp based locking |
| D. | None of these . |
| Answer» E. | |
| 91. |
Which of the following is a reason to model data? |
| A. | Understand each user's perspective of data |
| B. | Understand the data itself irrespective of the physical representation |
| C. | Understand the use of data across application |
| D. | All of the above |
| Answer» E. | |
| 92. |
Which of the following statement on the view concept in SQL is invalid? |
| A. | All views are not updateable |
| B. | B. |
| C. | |
| D. | The views are instantiated at the time they are referenced and not when they are defined. |
| E. | D. |
| Answer» E. D. | |
| 93. |
Maximum height of a B+ tree of order m with n key values is |
| A. | Logm(n) |
| B. | (m+n)/2 |
| C. | Logm/2(m+n) |
| D. | None of these |
| Answer» E. | |
| 94. |
Which of the following aggregate functions does not ignore nulls in its results? |
| A. | COUNT . |
| B. | B. |
| C. | |
| D. | MAX |
| E. | MIN |
| Answer» C. | |
| 95. |
If an entity can belong to only one lower level entity then the constraint is |
| A. | disjoint |
| B. | partial |
| C. | overlapping |
| D. | single |
| Answer» C. overlapping | |
| 96. |
In SQL, testing whether a subquery is empty is done using |
| A. | DISTINCT |
| B. | UNIQUE |
| C. | NULL |
| D. | EXISTS |
| Answer» E. | |
| 97. |
In b-tree the number of keys in each node is than the number of its children. |
| A. | one less |
| B. | same |
| C. | one more |
| D. | half |
| Answer» B. same | |
| 98. |
DBMS is a collection of _____ that enables user to create and maintain a database. |
| A. | Keys |
| B. | Program |
| C. | Translators |
| D. | Language Activity |
| Answer» C. Translators | |