Q. Which of the following object types below cannot be replicated?

View solution

Q. How to force a log switch?

View solution

Q. In the following query, which expression is evaluated first?

SELECT id_number, (quantity - 100 / 0.15 - 35 * 20) FROM inventory

View solution

Q. The ORDER BY clause can only be used in

View solution

Q. Which of the following rule below are categories of index?

View solution

Q. What is the purpose of SMON background process?

View solution

Q. Which of the following queries are legal?

View solution

Q. Which of the following queries displays the sum of all employee salaries for those employees not making commission, for each job, including only those sums greater than 2500?

View solution

Q. Which one of the following is used to define the structure of the relation ,deleting relations and relating schemas ?

View solution

Q. 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 ?

View solution

Q. Create table employee (name varchar ,id integer)
What type of statement is this ?

View solution

Q. Select * from employee
What type of statement is this?

View solution

Q. The basic data type char(n) is a _____ length character string and varchar(n) is _____ length character.

View solution

Q. An attribute A of datatype varchar(20) has the value “Avi” . The attribute B of datatype char(20) has value ”Reed” .Here attribute A has ____ spaces and attribute B has ____ spaces.

View solution

Q. To remove a relation from an SQL database, we use the ______ command.

View solution

Q. Delete from r; r – relation
This command performs which of the following action ?

View solution

Q. Insert into instructor values (10211, ’Smith’, ’Biology’, 66000);
What type of statement is this ?

View solution

Q. Updates that violate __________ are disallowed.

View solution

Q.
Name

Annie

Bob

Callie

Derek

Which of these query will display the the table given above ?

View solution

Q. Select ________ dept_name
from instructor;

Here which of the following displays the unique values of the column ?

View solution