Database Management System Mock Test 2

10%

Question 1 of 10

1. Which of the following is used to access large objects from a database ?

all of the mentioned

setBlob()

getBlob()

getClob()

Question 1 of 10

Question 2 of 10

With max_budget (value) as
(select max(budget)
from department)
select budget
from department, max_budget
where department.budget = max budget.value;

In the query given above which one of the following is a temporary relation?

Value

Max_budget

Department

Budget

Question 2 of 10

Question 3 of 10

3. Which of the following closely resembles Create view?

Create table . . . as

Create table . . .like

Create view as

With data

Question 3 of 10

Question 4 of 10

4. The ________ keyword is used to access attributes of preceding tables or subqueries in the from clause.

Having

With

Lateral

Question 4 of 10

Question 5 of 10

5. Which of the following can be addressed by enforcing a referential integrity constraint?

Information on the customer must be known before anything can be sold to that customer

All phone numbers must include the area code

Certain fields are required (such as the email address, or phone number) before the record is accepted

When entering an order quantity, the user must input a number and not some text (i.e., 12 rather than ‘a dozen’)

Question 5 of 10

Question 6 of 10

6. A Delete command operates on ______ relation.

Two

Null

One

Several

Question 6 of 10

Question 7 of 10

7. Data integrity constraints are used to:

Control who is allowed access to the data

Improve the quality of data entered for a specific property (i.e., table column)

Prevent users from changing the values stored in the table

Ensure that duplicate records are not entered into the table

Question 7 of 10

Question 8 of 10

8. _________ are useful in SQL update statements, where they can be used in the set clause.

Multiple queries

Sub queries

Scalar subqueries

Update

Question 8 of 10

Question 9 of 10

9. Consider the following action:

Transaction.....
Commit;
Rollback;

What does Rollback do?

Undoes the transactions before commit

Redoes the transactions before commit

No action

Clears all transactions

Question 9 of 10

Question 10 of 10

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

Super user

Administrator

Operator of operating system

All of the mentioned

Question 10 of 10