Q. The problem of ordering the update in multiple update is avoided using

View solution

Q. Which of the following is the correct format for case statements.

View solution

Q. Which of the following relation updates all instructors with salary over $100,000 receive a 3 percent raise, whereas all others receive a 5 percent raise.

View solution

Q. SELECT *
FROM student JOIN takes USING (ID);

The above query is equivalent to

View solution

Q. In SQL the statement select * from R, S is equivalent to

View solution

Q. For the view Create view instructor_info as

SELECT ID, name, building
FROM instructor, department
WHERE instructor.dept name= department.dept name;

If we insert tuple into the view as insert into instructor info values (’69987’, ’White’, ’Taylor’);

What will be the values of the other attributes in instructor and department relations?

View solution

Q. A _________ consists of a sequence of query and/or update statements.

View solution

Q. Which of the following makes the transaction permanent in the database ?

View solution

Q. In order to undo the work of transaction after last commit which one should be used ?

View solution

Q. Consider the following action:

TRANSACTION.....
Commit;
ROLLBACK;

What does Rollback do?

View solution

Q. In case of any shut down during transaction before commit which of the following statement is done automatically?

View solution

Q. In order to maintain the consistency during transactions database provides

View solution

Q. Which of the following is used to get back all the transactions back after rollback ?

View solution

Q. ______ will undo all statements up to commit?

View solution

Q. Domain constraints, functional dependency and referential integrity are special forms of _________

View solution

Q. Create index studentID_index on student(ID);
Here which one denotes the relation for which index is created ?

View solution

Q. Values of one type can be converted to another domain using which of the following ?

View solution

Q. CREATE DOMAIN YearlySalary NUMERIC(8,2)
CONSTRAINT salary VALUE test __________;

In order to ensure that an instructor’s salary domain allows only values greater than a specified value use:

View solution

Q. In contemporary databases the top level of the hierarchy consists of ______ each of which can contain _____

View solution

Q. The database administrator who authorizes all the new users, modifies database and takes grants privilege is

View solution