DBMS MCQs Test 8

This Test will cover complete DBMS with very important questions, starting off from basics to advanced level.

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?
Q. What type of statement is the below specified statement?
INSERT into instructor VALUES(10211, 'Smith', 'Biology', 66000);
Q. The __________ clause allows us to select only those rows in the result relation of the __________ clause that satisfy a specified predicate.
Q. Which keyword must be used here to rename the field name?
Select name __________ instructor name, course id from instructor, teaches where instructor.ID= teaches.ID;

Q. In the SQL given below there is an error. Identify the error.
Select * from employee where dept_name="Comp Sci";
Q. '_ _ _' matches any string of __________ three characters. '_ _ _%' matches any string of at __________ three characters.
Q. In SQL the spaces at the end of the string are removed by __________ function.
Q. __________ clause is an additional filter that is applied to the result.
Q. The __________ is essentially used to search for patterns in target string.

Q. If the attribute phone number is included in the relation, all the values need not be entered into the phone number column. This type of entry is given as __________.
Q. In a employee table, to include the attributes whose value always have some value which of the following constraint must be used?
Q. The result of __________ unknown is unknown.
Q. Which one of the following deletes all the entries but keeps the structure of the relation.
Q. __________ are useful in SQL update statements, where they can be used in the set clause.
Q. The problem of ordering the Update in multiple Update is avoided using?