MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 175 Mcqs, each offering curated multiple-choice questions to sharpen your Computer Science Engineering (CSE) knowledge and support exam preparation. Choose a topic below to get started.
| 151. |
Given the following relation Student (roll no, name, course no, course max. marks, year of study, address) The corresponding 3 NF relations are |
| A. | student (roll no, name, year of study, address) course (course no, course max. marks) |
| B. | student ( roll no, name, year of study, address) student (roll no, course no) course (course no, course max. marks) |
| C. | student (roll no , name, address) year (roll no, year of study) course (course no, course max. marks) |
| D. | student (roll no, name, address) course (course no, course max. marks, year of study) |
| Answer» C. student (roll no , name, address) year (roll no, year of study) course (course no, course max. marks) | |
| 152. |
One aspect that has to be dealt with by the integrity subsystem is to ensure that only valid values can be assigned to each data items. This is referred to as |
| A. | Data Security |
| B. | Domain access |
| C. | Data Control |
| D. | Domain Integrity |
| Answer» E. | |
| 153. |
After conversion of high level queries into low level commands for file access and is called compiled_____: |
| A. | DDL |
| B. | DML |
| C. | SDL |
| D. | VDL |
| Answer» C. SDL | |
| 154. |
Centralizing the integrity checking directly under the DBMS .. duplication and ensures the consistency and validity of the database. |
| A. | Increases |
| B. | Skips |
| C. | Does not reduce |
| D. | Reduces |
| Answer» E. | |
| 155. |
There are two functional dependencies with the same set of attributes on the left side of the arrow:A->BC A->BThis can be combined as |
| A. | A->BC |
| B. | A->B |
| C. | B->C |
| D. | None of the mentioned |
| Answer» B. A->B | |
| 156. |
Relation dept year(dept name, total inst 2007, total inst 2008, total inst 2009). Here the only functional dependencies are from dept name to the other attributes. This relation is in |
| A. | Fourth NF |
| B. | BCNF |
| C. | Third NF |
| D. | Second NF |
| Answer» C. Third NF | |
| 157. |
When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n): |
| A. | Transitive dependency |
| B. | Insertion anomaly. |
| C. | Referential integrity constraint. |
| D. | Normal form |
| Answer» D. Normal form | |
| 158. |
When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n): |
| A. | transitive dependency. |
| B. | insertion anomaly. |
| C. | referential integrity constraint. |
| D. | normal form. |
| Answer» D. normal form. | |
| 159. |
What will be the number of columns of CARTESIAN PRODCUT if the participating relations have 5 and 7 columns respectively? |
| A. | 5 |
| B. | 12 |
| C. | 35 |
| D. | None of the above |
| Answer» C. 35 | |
| 160. |
is a special type of integrity constraint that relates two relations & maintains consistency across the relations. |
| A. | Entity Integrity Constraints |
| B. | Referential Integrity Constraints |
| C. | Domain Integrity Constraints |
| D. | Key Constraints |
| Answer» C. Domain Integrity Constraints | |
| 161. |
If every non-key attribute is functionally dependent on the primary key, then the relation will be in: |
| A. | First normal form |
| B. | Second normal form |
| C. | Third normal form |
| D. | Fourth normal form |
| Answer» D. Fourth normal form | |
| 162. |
defines rules regarding the values allowed in columns and is the standard mechanism for enforcing database integrity. |
| A. | Column |
| B. | Constraint |
| C. | Index |
| D. | Trigger |
| Answer» C. Index | |
| 163. |
Every time attribute A appears, it is matched with the same value of attribute B, but not the same value of attribute C. Therefore, it is true that: |
| A. | A B |
| B. | A C |
| C. | A (B, C). |
| D. | (B,C) A. |
| Answer» B. A C | |
| 164. |
A relation is said to be in 3 NF if (i) it is in 2 NF (ii) non-key attributes are independent of one another (iii) key attribute is not dependent on part of a composite key (iv) has no multi-valued dependency |
| A. | i and iii |
| B. | i and iv |
| C. | i and ii |
| D. | ii and iv |
| Answer» D. ii and iv | |
| 165. |
Pick entities from the following: I. vendor II. student III. attends IV. km/hour |
| A. | i, ii, iii |
| B. | i, ii, iv |
| C. | i and ii |
| D. | iii and iv |
| Answer» D. iii and iv | |
| 166. |
If an attribute of a composite key is dependent on an attribute of the other composite key, normalization called ................ is needed. |
| A. | DKNF |
| B. | BCNF |
| C. | Fourth |
| D. | Third |
| Answer» C. Fourth | |
| 167. |
The number of entities to which another entity can be associated via a relationship set is expressed as: |
| A. | Entity |
| B. | Cardinality |
| C. | Schema |
| D. | Attributes |
| Answer» C. Schema | |
| 168. |
A attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation . |
| A. | Candidate |
| B. | Primary |
| C. | Super |
| D. | Sub |
| Answer» E. | |
| 169. |
n which of the following, a separate schema is created consisting of that attribute and the primary key of the entity set. |
| A. | A many-to-many relationship set |
| B. | A multivalued attribute of an entity set |
| C. | A one-to-many relationship set |
| D. | None of the mentioned |
| Answer» C. A one-to-many relationship set | |
| 170. |
What is the name of the system database that contains descriptions of the data in the database? |
| A. | Metadata |
| B. | Data dictionary |
| C. | Table |
| D. | None of the above |
| Answer» C. Table | |
| 171. |
For a weak entity set to be meaningful, it must be associated with another entity set, called the |
| A. | Identifying set |
| B. | Owner set |
| C. | Neighbour set |
| D. | Strong entity set |
| Answer» B. Owner set | |
| 172. |
What is the process that is done to SQL before execution, to check for proper syntax and to optimize the request called? |
| A. | Syntax checking |
| B. | Performance tuning |
| C. | Parsing |
| D. | Optimizing |
| Answer» D. Optimizing | |
| 173. |
In which of the following, a separate schema is created consisting of that attribute and the primary key of the entity set. |
| A. | A many-to-many relationship set |
| B. | A multivalued attribute of an entity set |
| C. | A one-to-many relationship set |
| D. | All of the mentioned |
| Answer» C. A one-to-many relationship set | |
| 174. |
Which of the following has each related entity set has its own schema and there is an additional schema for the relationship set. |
| A. | A many-to-many relationship set |
| B. | A multivalued attribute of an entity set |
| C. | A one-to-many relationship set |
| D. | All of the mentioned |
| Answer» B. A multivalued attribute of an entity set | |
| 175. |
If a multivalued dependency holds and is not implied by the corresponding functional dependency, it usually arises from one of the following sources. |
| A. | A many-to-many relationship set |
| B. | A multivalued attribute of an entity set |
| C. | A one-to-many relationship set |
| D. | Both A many-to-many relationship set and A multivalued attribute of an entity set |
| Answer» E. | |