MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 1294 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.
| 501. |
DBMS is a collection of ………….. that enables user to create and maintain a database. |
| A. | Keys |
| B. | Translators |
| C. | Programs |
| D. | Language Activity |
| Answer» D. Language Activity | |
| 502. |
SGA stands for |
| A. | System Go Ahead |
| B. | Software Global Area |
| C. | System Global Area |
| D. | None of the above |
| Answer» D. None of the above | |
| 503. |
In the ........... normal form, a composite attribute is converted to individual attributes. |
| A. | First |
| B. | Second |
| C. | Third |
| D. | Fourth |
| Answer» B. Second | |
| 504. |
Transaction ends |
| A. | Only when it is Committed |
| B. | Only when it is Rolledback |
| C. | When it is Committed or Rolledback |
| D. | None of the above |
| Answer» D. None of the above | |
| 505. |
If a node is locked in the subtree rooted by that node is locked explicitly in shared mode, and that explicit locking is being done at a lower level with exclusive-mode locks. |
| A. | intention lock modes |
| B. | shared and intention-exclusive (six) mode |
| C. | intention-exclusive (ix) mode |
| D. | intention-shared (is) mode |
| Answer» C. intention-exclusive (ix) mode | |
| 506. |
In ……….. normal forms, any multivalued attributes have been removed. |
| A. | First |
| B. | Second |
| C. | Third |
| D. | Fourth |
| Answer» B. Second | |
| 507. |
A is the smallest unit of information that can be read from or written to the disk. |
| A. | track |
| B. | spindle |
| C. | sector |
| D. | platter |
| Answer» D. platter | |
| 508. |
A is a program running on the server machine, which accepts requests from a Web browser and sends back results in the form of HTML documents. |
| A. | html |
| B. | http |
| C. | web server |
| D. | web browser |
| Answer» D. web browser | |
| 509. |
A system is in a state if there exists a set of transactions such that every transaction in the set is waiting for another transaction in the set. |
| A. | idle |
| B. | waiting |
| C. | deadlock |
| D. | ready |
| Answer» D. ready | |
| 510. |
The is the one in which the primary key of one relation is used as a normal attribute in another relation. |
| A. | referential relation |
| B. | referencing relation |
| C. | referenced relation |
| D. | referred relation |
| Answer» D. referred relation | |
| 511. |
In which end is really just any application that runs on top of the DBMS and acts as a user interface: |
| A. | Back end |
| B. | Front end |
| C. | Both |
| D. | None |
| Answer» C. Both | |
| 512. |
Which of the following trigger will be executed before modifying each row affected bythe triggering statement? |
| A. | Before Statement Trigger |
| B. | After Row Trigger |
| C. | Before Row Trigger |
| D. | None of the above |
| Answer» D. None of the above | |
| 513. |
Rollback of transactions is normally used to: |
| A. | recover from transaction failure |
| B. | update the transaction |
| C. | retrieve old records |
| D. | repeat a transaction |
| Answer» B. update the transaction | |
| 514. |
The disk controller uses at each sector to ensure that the data is not corrupted on data retrieval. |
| A. | checksum |
| B. | unit drive |
| C. | read disk |
| D. | readsum |
| Answer» B. unit drive | |
| 515. |
To delete a database ................... command is used |
| A. | delete database database_name |
| B. | Delete database_name |
| C. | drop database database_name |
| D. | drop database_name |
| Answer» D. drop database_name | |
| 516. |
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 | |
| 517. |
is preferred method for enforcing data integrity |
| A. | constraints |
| B. | stored procedure |
| C. | triggers |
| D. | cursors |
| Answer» B. stored procedure | |
| 518. |
McFadden has defined normalization in his which book |
| A. | database modern management |
| B. | management database of modern |
| C. | modern database management |
| D. | database management |
| Answer» D. database management | |
| 519. |
If a1, a2, a3 are attributes in a relation and S is another relation, which of the following isan incorrect specification of an integrity constraint? |
| A. | primary key(a1, a2, a3) |
| B. | primary key(a1) |
| C. | foreign key(a1, a2) references S |
| D. | foreign key(a1, a2) |
| Answer» E. | |
| 520. |
Which are the not user in End-user: |
| A. | Naïve users |
| B. | Casual users |
| C. | Sophisticated user |
| D. | All of these |
| Answer» E. | |
| 521. |
In the........... Normal form, a composite attribute is converted to individual attributes. |
| A. | First |
| B. | Second |
| C. | Third |
| D. | Fourth |
| Answer» B. Second | |
| 522. |
The intersection operator is used to get the tuples. |
| A. | different |
| B. | common |
| C. | all |
| D. | repeating |
| Answer» C. all | |
| 523. |
Given the following relation it is not 3 NF because Student (roll no, name, course no, course max. marks, year of study, address) |
| A. | it is not in 2 NF |
| B. | it does not have composite key |
| C. | non-key attributes course no and course max. marks are functionally dependent |
| D. | it has more than 3 non-key attributes |
| Answer» D. it has more than 3 non-key attributes | |
| 524. |
For a weak entity set to be meaningful, it must be associated with another entity set, calledthe |
| A. | Identifying set |
| B. | Owner set |
| C. | Neighbour set |
| D. | Strong entity set |
| Answer» B. Owner set | |
| 525. |
Data are stored in________ as database: |
| A. | Data files |
| B. | Data dictionary |
| C. | Database |
| D. | Data administrator |
| Answer» B. Data dictionary | |
| 526. |
Which of the following is a cursor operation? |
| A. | DECLARE |
| B. | OPEN and FETCH |
| C. | CLOSE |
| D. | All of the above |
| Answer» E. | |
| 527. |
Which is proper subset designed to support ‘views’ belonging to different classes of users in order tohid or protect information: |
| A. | Schema |
| B. | Subschema |
| C. | Non-schema |
| D. | None-subschema |
| Answer» C. Non-schema | |
| 528. |
…………………… is the process of organizing data into related tables. |
| A. | Normalization |
| B. | Generalization |
| C. | Specialization |
| D. | None of the above |
| Answer» B. Generalization | |
| 529. |
In a index, an index entry appears for only some of the search-key values. |
| A. | dense |
| B. | sparse |
| C. | straight |
| D. | continuous |
| Answer» B. sparse | |
| 530. |
Which of the following is an aggregate function in SQL? |
| A. | Union |
| B. | Like |
| C. | Group By |
| D. | Max |
| Answer» E. | |
| 531. |
Which of the following retains duplicate rows in the result of a query or in an Aggregate expression? |
| A. | ALL |
| B. | DISTINCT |
| C. | PRIOR |
| D. | None of the above |
| Answer» B. DISTINCT | |
| 532. |
which increases the number of I/O operations needed to write a single logical block, pays a significant time penalty in terms of write performance. |
| A. | raid level 1 |
| B. | raid level 2 |
| C. | raid level 5 |
| D. | raid level 3 |
| Answer» B. raid level 2 | |
| 533. |
Which is stored information about description of data in the database: |
| A. | Data files |
| B. | Data dictionary |
| C. | Database |
| D. | Data administrator |
| Answer» C. Database | |
| 534. |
Which of the following is a valid SQL data type? |
| A. | CHARACTER |
| B. | NUMERIC |
| C. | FLOAT |
| D. | All of the above |
| Answer» E. | |
| 535. |
For which Exception, if a SELECT statement attempts to retrieve data based on its conditions, this exception is raised when no rows satisfy the SELECT criteria? |
| A. | TOO_MANY_ROWS |
| B. | NO_DATA_FOUND |
| C. | VALUE_ERROR |
| D. | DUP_VAL_ON_INDEX |
| Answer» E. | |
| 536. |
The operation, denoted by −, allows us to find tuples that are in one relation but are not in another. |
| A. | union |
| B. | set-difference |
| C. | difference |
| D. | intersection |
| Answer» C. difference | |
| 537. |
Entity Relationship model consists of collection of basic objects called _________ andrelationship among these objects. |
| A. | functions |
| B. | models |
| C. | None of these |
| D. | entities |
| Answer» E. | |
| 538. |
The airline reservation system, the enables are date, flight number, place of departure, destination, type of plane & seats available. The primary key is |
| A. | Flight number |
| B. | Flight number + place of departure |
| C. | Flight number+ date |
| D. | Flight number + destination |
| Answer» D. Flight number + destination | |
| 539. |
Although the ____ locking approach improves the availability of data, itsmanagement requires high overhead. |
| A. | database-level |
| B. | table-level |
| C. | page-level |
| D. | row-level |
| Answer» E. | |
| 540. |
If you don’t specify ASC or DESC after a SQL ORDER BY clause, the following is usedby default ______________ |
| A. | ASC |
| B. | DESC |
| C. | There is no default value |
| D. | None of the mentioned |
| Answer» B. DESC | |
| 541. |
View the Exhibit and examine the structure of the EMPLOYEES andDEPARTMENTS tables. Which SET operator would you use in the blank space in the following SQL statement to list the departments where all the employees have managers? SELECT department_id FROM departments ____ SELECT department_id FROM employees WHERE manager_id IS NULL; |
| A. | UNION |
| B. | MINUS |
| C. | INTERSECT |
| D. | UNION ALL |
| Answer» C. INTERSECT | |
| 542. |
For each attribute of a relation, there is a set of permitted values, called the ________ ofthat attribute. |
| A. | Domain |
| B. | Relation |
| C. | Set |
| D. | Schema |
| Answer» B. Relation | |
| 543. |
Which of the following is used to get all the columns of a table? |
| A. | * |
| B. | @ |
| C. | % |
| D. | # |
| Answer» B. @ | |
| 544. |
In domain relaional calculus “there exist” |
| A. | (p1(x)) |
| B. | (p1(x)) Э x |
| C. | v x (p1(x)) |
| D. | Э x (p1(x)) |
| Answer» E. | |
| 545. |
Which of the following consists of a row of column headings, together with zero or morerows of data values? |
| A. | COMPOSITE INDEX |
| B. | UNIQUE INDEX |
| C. | TABLE |
| D. | None of the above |
| Answer» D. None of the above | |
| 546. |
The attribute name could be structured as an attribute consisting of first name, middle initial, and last name. This type of attribute is called |
| A. | simple attribute |
| B. | composite attribute |
| C. | multivalued attribute |
| D. | derived attribute |
| Answer» C. multivalued attribute | |
| 547. |
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) | |
| 548. |
The refinement from an initial entity set into successive levels of entity subgroupings represents a design process in which distinctions are made explicit. |
| A. | hierarchy |
| B. | bottom-up |
| C. | top-down |
| D. | radical |
| Answer» D. radical | |
| 549. |
The related and interconnected software components of a DBMS are described by the _______: |
| A. | Logical architecture |
| B. | Physical architecture |
| C. | Both |
| D. | None |
| Answer» D. None | |
| 550. |
The following are functions of a DBMS except ________ |
| A. | creating and processing forms |
| B. | processing data |
| C. | creating databases |
| D. | administrating databases |
| Answer» B. processing data | |