MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 73 Mcqs, each offering curated multiple-choice questions to sharpen your Computer Science knowledge and support exam preparation. Choose a topic below to get started.
| 51. |
The constraints that are applied on individual tuples and are verified whenever any tuple is modified or new tuple is inserted are called |
| A. | language based constraints |
| B. | tuple based constraints |
| C. | scale based constraints |
| D. | precision based constraints |
| Answer» C. scale based constraints | |
| 52. |
The state in which the database follows all the integrity constraints is classified as |
| A. | valid state |
| B. | candidate state |
| C. | parallel state |
| D. | invalid state |
| Answer» B. candidate state | |
| 53. |
The values which cannot be divided further are classified as |
| A. | formatted values |
| B. | bi-atomic model |
| C. | diatomic values |
| D. | atomic values |
| Answer» E. | |
| 54. |
In a relation |
| A. | Ordering of rows is immaterial |
| B. | No two rows are identical |
| C. | a and b both are true |
| D. | None of these |
| Answer» D. None of these | |
| 55. |
The state in which the database does not follow integrity constraints is classified as |
| A. | parallel state |
| B. | invalid state |
| C. | valid state |
| D. | candidate state |
| Answer» C. valid state | |
| 56. |
The constraint which is used to specify the consistency in two or more relations among tuples is classified as |
| A. | primary integrity constraint |
| B. | entity integrity constraint |
| C. | referential integrity constraint |
| D. | null integrity constraint |
| Answer» C. referential integrity constraint | |
| 57. |
The constraint violated when the given value of attribute is not included in the corresponding domain is |
| A. | domain constraint |
| B. | attribute constraint |
| C. | key constraint |
| D. | lock constraint |
| Answer» B. attribute constraint | |
| 58. |
The multi-valued dependencies and functional dependencies are classified as category of |
| A. | relation dependencies |
| B. | data dependencies |
| C. | entity dependencies |
| D. | attribute dependencies |
| Answer» C. entity dependencies | |
| 59. |
When the primary key is null of the new tuple then the constraint violated is |
| A. | null integrity constraint |
| B. | primary integrity constraint |
| C. | secondary integrity constraint |
| D. | entity integrity constraint |
| Answer» E. | |
| 60. |
The column header of table in relational model terminology is classified as |
| A. | attribute |
| B. | table starter |
| C. | table ender |
| D. | entity domain |
| Answer» B. table starter | |
| 61. |
Which one of the following cannot be taken as a primary key ? |
| A. | Id |
| B. | Register number |
| C. | Dept_id |
| D. | Street |
| Answer» E. | |
| 62. |
On a relational database, the kind of constraint which must be specified and does not contain large classes of constraints is considered as |
| A. | referential integrity constraint |
| B. | null integrity constraint |
| C. | semantic integrity constraints |
| D. | secondary integrity constraint |
| Answer» D. secondary integrity constraint | |
| 63. |
A row of table in relational model terminology is classified as |
| A. | range |
| B. | domain |
| C. | relation |
| D. | tuple |
| Answer» E. | |
| 64. |
_______ allow us to identify uniquely a tuple in the relation. |
| A. | Superkey |
| B. | Domain |
| C. | Attribute |
| D. | Schema |
| Answer» B. Domain | |
| 65. |
In mathematical term Table is referred as |
| A. | Relation |
| B. | Attribute |
| C. | Tuple |
| D. | Domain |
| Answer» B. Attribute | |
| 66. |
In mathematical term Row is referred as |
| A. | Relation |
| B. | Attribute |
| C. | Tuple |
| D. | Domain |
| Answer» D. Domain | |
| 67. |
A Relation is a |
| A. | Subset of a Cartesian product of a list of attributes |
| B. | Subset of a Cartesian product of a list of domains |
| C. | Subset of a Cartesian product of a list of tuple |
| D. | Subset of a Cartesian product of a list of relations |
| Answer» C. Subset of a Cartesian product of a list of tuple | |
| 68. |
Minimal Superkeys are called |
| A. | Schema keys |
| B. | Candidate keys |
| C. | Domain keys |
| D. | Attribute keys |
| Answer» C. Domain keys | |
| 69. |
Data Manipulation Language (DML) is not to |
| A. | Create information table in the Database |
| B. | Insertion of new information into the Database |
| C. | Deletion of information in the Database |
| D. | Modification of information in the Database |
| Answer» B. Insertion of new information into the Database | |
| 70. |
Who proposed the relational model? |
| A. | Bill Gates |
| B. | E.F. Codd |
| C. | Herman Hollerith |
| D. | Charles Babbage |
| Answer» C. Herman Hollerith | |
| 71. |
The minimal set of super key is called |
| A. | Primary key |
| B. | Secondary key |
| C. | Candidate key |
| D. | Foreign key |
| Answer» D. Foreign key | |
| 72. |
Which of the following in true regarding Referential Integrity? |
| A. | Every primary-key value must match a primary-key value in an associated table |
| B. | Every primary-key value must match a foreign-key value in an associated table |
| C. | Every foreign-key value must match a primary-key value in an associated table |
| D. | Every foreign-key value must match a foreign-key value in an associated table |
| Answer» D. Every foreign-key value must match a foreign-key value in an associated table | |
| 73. |
How many types of keys in Database Design? |
| A. | Candidate key |
| B. | Primary key |
| C. | Foreign key |
| D. | All of these |
| Answer» E. | |