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

Q. The ______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate.

View solution

Q. Select ID, name, dept name, salary * 1.1
where instructor;

The query given below will not give an error. Which one of the following has to be replaced to get the desired output?

View solution

Q. The ________ clause is used to list the attributes desired in the result of a query.

View solution

Q. Select name, course_id
from instructor, teaches

where instructor_ID= teaches_ID;

This Query can be replaced by which one of the following ?

View solution

Q. Select * from employee where salary>10000 and dept_id=101;
Which of the following fields are displayed as output?

View solution

Q. Which of the following statements contains an error?

View solution

Q. Insert into employee _____ (1002,Joey,2000);
In the given query which of the keyword has to be inserted ?

View solution

Q. SELECT * FROM employee WHERE dept_name="Comp Sci";

In the SQL given above there is an error . Identify the error .

View solution

Q. ’_ _ _ ’ matches any string of ______ three characters. ’_ _ _ %’ matches any string of at ______ three characters.

View solution

Q. In SQL the spaces at the end of the string are removed by _______ function .

View solution