In order to maintain transactional integrity and database consistency, what technology does a DBMS deploy?

The current copy of the database is identified by a pointer, called ____________ which is stored on disk.

A special redo-only log record <Ti , Xj , V1> is written to the log, where V1 is the value being restored to data item Xj during the rollback. These log records are sometimes called

The actions which are played in the order while recording it is called ______________ history?

Selecting the victim to be roll backed to the previous state is determined by the minimum cost. The factors determining cost of rollback is

_______________ provides option for entering SQL queries as execution time, rather than at the development stage.

SELECT course_id

FROM SECTION

WHERE semester = ’Fall’ AND YEAR= 2009)

EXCEPT

(SELECT course_id

FROM SECTION

WHERE semester = ’Spring’ AND YEAR= 2010);

This query displays _____

Which of the following is not a integrity constraint ?

CREATE TABLE Manager(ID NUMERIC, Name VARCHAR(20), budget NUMERIC, Details VARCHAR(30));

Inorder to ensure that the value of budget is non-negative, which of the following should be used?

CREATE TABLE course

( . . .

FOREIGN KEY (dept_name) REFERENCES department

. . . );

Which of the following is used to delete the entries in the referenced table when the tuple is deleted in course table?

Consider the following two tables and four queries in SQL.

Book (isbn, bname), Stock (isbn, copies)

Query 1:

SELECT B.isbn, S.copies

FROM Book B INNER JOIN Stock S

ON B.isbn = S.isbn;

Query 2:

SELECT B.isbn, S.copies

FROM B B LEFT OUTER JOIN Stock S

ON B.isbn = S.isbn;

Query 3:

SELECT B.isbn, S.copies

FROM Book B RIGHT OUTER JOIN Stock S

ON B.isbn = S.isbn;

Query 4:

SELECT B.isbn, S.copies

FROM B B FULL OUTER JOIN Stock S

ON B.isbn = S.isbn;

Which one of the queries above is certain to have an output that is a superset of the outputs of the other three queries?

What is the output of the following SQL query?

select count(*) from ((select Employee, Department from Overtime_allowance) as S

natural join (select Department, OT_allowance from Overtime_allowance) as T);

The relation book (title,price) contains the titles and prices of different books. Assuming that no two books have the same price, what does the following SQL query list?

select title

from book as B

where (select count(*)

from book as T

where T.price>B.price)<5

DFD stands for__________.

The union operation automatically __________, unlike the select clause.

The subset of super key is a candidate key under what condition?

Relation R has eight attributes ABCDEFGH. Fields of R contain only atomic values. F = {CH -> G, A -> BC, B -> CFH, E -> A, F -> EG} is a set of functional dependencies (FDs) so that F+ is exactly the set of FDs that hold for R.

How many candidate keys does the relation R have?

The maximum number of superkeys for the relation schema R(E,F,G,H) with E as the key is

Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database?

Which of the following statement(s) is/are FALSE in the context of Relational DBMS ?

I. Views in a database system are important because they help with access control by allowing users to see only a particular subset of the data in the database.

II. E-R diagrams are useful to logically model concepts.

III. An update anomaly is when it is not possible to store information unless some other, unrelated information is stored as well.

IV. SQL is a procedural language.