Welcome to TestAdda

Please wait....

Loading
DBMS Short Test 1
|
Mark For Review

_____ operator is used for appending two strings.

|
Mark For Review

To include integrity constraint in a existing relation use :

|
Mark For Review

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

|
Mark For Review

Employee_id Name Salary
1001 Annie 6000
1009 Ross 4500
1018 Zeith 7000

This is Employee table. Select * from employee where employee_id>1009; Which of the following employee_id will be displayed?

|
Mark For Review

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

|
Mark For Review

Select name, course_id from instructor, teaches where instructor_ID= teaches_ID; This Query can be replaced by which one of the following ?

|
Mark For Review

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

|
Mark For Review

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?

|
Mark For Review

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

|
Mark For Review

Select ________ dept_name from instructor; Here which of the following displays the unique values of the column ?

|
Mark For Review

Name
Annie
Bob
Callie
Derek

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

|
Mark For Review

______ will undo all statements up to commit?

|
Mark For Review

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

|
Mark For Review

A transaction completes its execution is said to be

|
Mark For Review

Which of the following is not a integrity constraint ?

|
Mark For Review

Foreign key is the one in which the ________ of one relation is referenced in another relation.

|
Mark For Review

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

|
Mark For Review

Select instructor.* from instructor, teaches where instructor.ID= teaches.ID; This query does which of the following operation?

|
Mark For Review

Select name from instructor where salary <= 100000 and salary >= 90000; This query can be replaced by which of the following ?

|
Mark For Review

Select * from instructor order by salary ____, name ___; To display the salary from greater to smaller and name in ascending order which of the following options should be used ?

|
Mark For Review

Select name from instructor where dept name = ’Physics’ order by name; By default, the order by clause lists items in ______ order.

|
Mark For Review

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

|
Mark For Review

Select emp_name from department where dept_name like ’ _____ Computer Science’; Which one of the following has to be added into the blank to select the dept_name which has Computer Science as its ending string ?

|
Mark For Review

Select * from employee where dept_name=”Comp Sci”; In the SQL given above there is an error . Identify the error .

|
Mark For Review

Select name ____ instructor name, course id from instructor, teaches where instructor.ID= teaches.ID; Which keyword must be used here to rename the field name ?

|
Mark For Review

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

|
Mark For Review

Data integrity constraints are used to:

|
Mark For Review

Which of the following is the right syntax for assertion?

|
Mark For Review

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

|
Mark For Review

Transaction processing is associated with everything below except

TestAdda OMR