Tag Archive: Database Management System

Solved MCQ of Database Management System (DBMS) Set – 2

This set of  Solved Multiple Choice Question (MCQ) on Database Management System (DBMS) includes objective questions on database Normalization, Data Definition Language (DDL), Data Manipulation Language (DML) and Data Control Language (DCL). 1. The candidate key is that you choose to identify each row uniquely is called …………….. A) Alternate Key B) Primary Key C) Foreign Key D) None of the above 2. …………….. is used to determine whether of a table contains duplicate rows. A) Unique predicate B) Like…
Read more

Solved MCQ of Database Management System (DBMS) Set – 1

Here are the collections of top 20 Multiple Choice Questions on Database Management System (DBMS) includes questions of definition of DBMS, Data Flow Diagram (DFD) along with about SQL functions and commands.   1. DBMS is a collection of ………….. that enables user to create and maintain a database. A) Keys B) Translators C) Program D) Language Activity 2. In a relational schema, each tuple is divided into fields called A) Relations B) Domains C) Queries D) All of the…
Read more

Solved MCQ on Database Backup and Recovery in DBMS set-1

1) Which of the following is not a recovery technique? A. Deferred update B. Immediate update C. Two-phase commit D. Recovery management 2)Checkpoints are a part of A. Recovery measures B. Security measures C. Concurrency measures D. Authorization measures 3) ……. deals with soft errors, such as power failures. A. system recovery B. media recovery C. database recovery D. failure recovery 4) ……….. is an essential part of any backup system. A. Filter B. Recovery C. Security D. Scalability 5)…
Read more

Solved MCQ on Distributed Database Transaction Management set-4

1) Commit and rollback are related to ………. A. data integrity B. data consistency C. data sharing D. data security 2) The transaction wants to edit the data item is called as ……. A. Exclusive Mode B. Shared Mode C. Inclusive Mode D. Unshared Mode 3) For committing a transaction, the DBMS might discard all the records. A. after image B. before image C. log D. redo log 4) A sophisticated locking mechanism known as 2-phase locking which includes Growing…
Read more

Solved MCQ on Oracle Distributed Transaction set-3

1) A mechanism which ensures that simultaneous execution of more than one transaction does not lead to any database inconsistencies is called ……………… mechanism. A. transaction control B. transaction management C. concurrency parallelism D. concurrency control 2) The transaction wants only to read the data item of mode is called as ……. A. Exclusive Mode B. Shared Mode C. Inclusive Mode D. Unshared Mode 3) Any execution of a set of transactions is called as its ……… A. non-serial schedule…
Read more

Solved MCQ on Transaction Management in DBMS set-2

1) In the …………, one transaction inserts a row in the table while the other transaction is half way through its browsing of table. A. transaction read problem B. one way read problem C. serial read problem D. phantom read problem 2) Transaction processing is associated with everything below except. A. producing detail, summery, or exception reports B. recording a business activity C. confirming an action or triggering a response D. maintaining data 3) ………. helps solve concurrency problem. A….
Read more

Solved MCQ on Distributed Transaction Management set-1

1) If the transaction is rolled back, all the database changes made inside the transaction are …… A. made permanent B. made temporary C. copied to the log D. undone 2) Which of the following is not a property of transactions? A. Atomicity B. Concurrency C. Isolation D. Durability 3) A ……… ensures that transactions are performed as expected. A. transaction processing monitor B. transaction procedure monitor C. isolation monitor D. transaction log 4) A transaction that completes its execution…
Read more

Solved MCQ on Fundamental of DBMS set-10

1) Which of the following is not a characteristic of a relational database model? A. Table B. Tree like structure C. Complex logical relationship D. Records 2) Field is otherwise called as ……… of the record A. data item B. data type C. value D. variable 3) A table can have only one A. Secondary key B. Alternate key C. Unique key D. Primary key 4) A field can be called as ……….. in relation context. A. random file B….
Read more

Solved MCQ Questions on Structured Query Language set-6

1) ……keyword is used to eliminate the duplicates. A. distinct B. unique C. union D. intersect 2) ……….is a query that has another query embedded within it. A. sub query B. structured query C. nested query D. sequence query 3) Which of the following is not an aggregate operator? A. MAX B. MIN C. TOTAL D. AVG 4) Any SQL statement inside an embedded SQL program must be inside the boundaries of …. A. EXE SQL and END B. EXEC…
Read more

MCQ on Database Design with Answer set-1

1) What is a data integrity? A. It is the data contained in database that is non redundant. B. It is the data contained in database that is accurate and consistent. C. It is the data contained in database that is secured. D. It is the data contained in database that is shared. 2) As per equivalence rules for query transformation, selection operation distributes over A. Union B. Intersection C. Set difference D. All of the above 3) In SQL…
Read more