Database Management System Set 1

Database Management System (DBMS)

Questions 1 to 10

1.	A collection of data designed to be used by different people is called a/an  (a) Organization (b) Database (c) Relationship (d) Schema (e) None of the above.
2.	Which of the following is the oldest database model? (a) Relational (b) Deductive (c) Physical (d) Network (e) Hierarchical.
3.	Which of the following schemas does define a view or views of the database for particular users? (a) Internal schema (b) Conceptual schema (c) Physical schema (d) External schema (e) Outer schema.
4.	Which of the following is an attribute that can uniquely identify a row in a table? (a) Secondary key (b) Candidate key (c) Foreign key (d) Alternate key (e) None of the above.
5.	Which of the following is the process of selecting the data storage and data access characteristics of the database? (a) Logical database design (b) Physical database design (c) Testing and performance tuning (d) Evaluation and selecting (e) External database design.
6.	Which of the following terms does refer to the correctness and completeness of the data in a database? (a) Data security (b) Data constraint (c) Data independence (d) Data model (e) Data integrity.
7.	The relationship between DEPARTMENT and EMPLOYEE is a (a) One-to-one relationship (b) One-to-many relationship (c) Many-to-many relationship (d) Many-to-one relationship (e) None of the above.
8.	A table can be logically connected to another table by defining a (a) Super key (b) Candidate key (c) Primary key (d) Unique key (e) Common attribute.
9.	If the state of the database no longer reflects a real state of the world that the database is supposed to capture, then such a state is called  (a) Consistent state (b) Parallel state  (c) Durable state  (d) Atomic state (e) Inconsistent state.
10.	Ensuring isolation property is the responsibility of the (a) Recovery-management component of the DBMS (b) Concurrency-control component of the DBMS (c) Transaction-management component of the DBMS (d) Buffer management component in DBMS (e) Query processor in DBMS.

Answers

1.	Answer : (b) Reason:  A collection of data designed to be used by different people is called a data base.
2.	Answer : (d) Reason:  Network Model is the oldest database model.
3.	Answer : (d) Reason:  External Schema define a view or views of the database for particular users.
4.	Answer : (b) Reason:  Candidate Key following is an attribute that can uniquely identify a row in a table.
5.	Answer : (b) Reason:  Physical database design is the process of selecting the data storage and data access characteristics of the database.
6.	Answer : (e) Reason:  Data integrity refer to the correctness and completeness of the data in a database.
7.	Answer : (b) Reason:  The relationship between DEPARTMENT and EMPLOYEE is a  one-to-many relationship.
8.	Answer : (c) Reason:  A table can be logically connected to another table by defining a Primary Key.
9.	Answer : (e) Reason:  If the state of the database no longer reflects a real state of the world that the database is supposed to capture, then such a state is called  in consistent state.
10.	Answer : (b) Reason:  Ensuring isolation property is the responsibility of the  concurrency-control component of the DBMS

1...  2...  3...  4...  5...  6...  7...  8...  9...  10...  11...  12...  13...  14...  15...  16...  17...  18...  19...  20...  21...  22...  23...  24...  25...  26...  27...  28...  29...  30...  31...  32...  33...  34...  35...  36...  Next >>

Read More

Database Management Systems Set 2

Database Management Systems

Questions 11 to 20

11.	A transaction completes its execution is said to be (a) Committed (b) Aborted (c) Rolled back (d) Failed (e) Partially committed.
12.	The process of managing simultaneous operations on the database without having them interfere with one another is (a) Serializability (b) Recoverability (c) Concurrency control (d) Transaction management (e) None of the above.
13.	A schedule where the operations of each transaction are executed consecutively without any other interference from other transactions is called  (a) Non-serial schedule (b) Serial schedule (c) Recoverable schedule (d) Non-recoverable schedule (e) Concurrent schedule.
14.	Which of the following is not a deadlock handling strategy? (a) Deadlock prevention (b) Timeout (c) Deadlock detection and recovery  (d) Deadlock annihilation (e) None of the above.
15.	Which of the following does refer to the size of the data item chosen as the unit of protection by a concurrency control program? (a) Granularity (b) Lock (c) Starvation (d) Timestamp (e) Time based.
16.	Which of the following hashing techniques does allow a hash file to expand and shrink its number of buckets dynamically without needing a directory? (a) Linear hashing (b) Extensible hashing (c) Internal hashing (d) External hashing (e) Non-linear hashing.
17.	Which of the following indexes is based on the values being uniformly distributed using a mathematical function? (a) Ordered index (b) Hashed index (c) Dense index (d) Sparse index (e) Secondary index.
18.	A join in which the joining condition is based on equality between values in the common columns is called (a) Equi-join (b) Uni-lateral join (c) Natural join (d) Both (a) and (c) above (e) Both (b) and (c) above.
19.	A type of query that is placed within a WHERE or HAVING clause of another query is called (a) Master query (b) Query (c) Superquery (d) Multi-query (e) Subquery.
20.	The entity integrity rule states that (a) No primary key attribute can be null  (b) Referential integrity must be maintained across all entities (c) Each entity must have a primary key (d) A primary key must have only one attribute (e) Foreign key attribute can be Null.

Answers

11.	Answer : (a) Reason:  A transaction the completes its execution is said to be Committed.
12.	Answer : (c) Reason:  The process of managing simultaneous operations on the database without having them interfere with one another is Concurrency control.
13.	Answer : (b) Reason:  A schedule where the operations of each transaction are executed consecutively without any other interference from other transactions is called  Serial schedule.
14.	Answer : (d) Reason:  Deadlock annihilation  is NOT a deadlock handling strategy.
15.	Answer : (a) Reason:  Granularity refer to the size of the data item chosen as the unit of protection by a concurrency control program.
16.	Answer : (b) Reason:  Extensible hashing techniques does allow a hash file to expand and shrink its number of buckets dynamically without needing a directory.
17.	Answer : (b) Reason:  Extensible hashing techniques does allow a hash file to expand and shrink its number of buckets dynamically without needing a directory.
18.	Answer : (d) Reason:  The equi-join is a join in which records are retrieved based on whether the join fields have matching values in both tables. That may seem like just a definition of a join, but it isn't. An example of a non-equal join is a join where records in the first table are joined to those records in the second table where the joined field in the first table is greater than (instead of equal to) the joined field in the second table (or less than, or anything besides equal to). Naturally, this returns more records than an equi-join.               A natural join is one in which only one of the two tables’ joined fields is returned. Since these two fields are by definition identical in an equi-join, it is redundant to include both. For a non-equal join, it is important to include both of those fields. So, equi-joins and natural joins go together.
19.	Answer : (e) Reason:  A type of query that is placed within a WHERE or HAVING clause of another query is called Sub query
20.	Answer : (a) Reason:  The entity integrity rule states that no primary key attribute can be null

<< Prev  1...  2...  3...  4...  5...  6...  7...  8...  9...  10...  11...  12...  13...  14...  15...  16...  17...  18...  19...  20...  21...  22...  23...  24...  25...  26...  27...  28...  29...  30...  31...  32...  33...  34...  35...  36...  Next >>

Read More