DB Queries constraints and Triggers Mcqs

Our collections of Multiple choice questions and answers focuses on study of DB Queries constraints and Triggers. These questions are chosen from a collection of most authoritative and best reference books on DBMS. Our aim is to prepare an individual for competitive exams like NTS, GAT, ECAT, University and College entrance exams and various tests and job interviews. One should practice our Mcqs to assimilate knowledge on DB Queries constraints and Triggers comprehensively.

  1. Home
  2. »
  3. Computer Science Mcqs
  4. »
  5. DBMS Mcqs
  6. »
  7. DB Queries constraints and Triggers...
  8. »
  9. Page 2

Computer MCQS

Sciences MCQS

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

Select name,course_id from teaches,instructor where instructor_id=course_id,

Select name, course_id from instructor natural join teaches,

Select name ,course_id from instructor,

Select course_id from instructor join teaches,

Answer Discus (0)

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

Salary, dept_id

Employee

Salary

All the field of employee relation

Answer Discus (0)

18.
Which of the following statements contains an error?

Select * from emp where empid = 10003,

Select empid from emp where empid = 10006,

Select empid from emp,

Select empid where empid = 1009 and lastname = ‘GELLER’,

Answer Discus (0)

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

Table

Values

Relation

Field

Answer Discus (0)

21.
SELECT * FROM employee WHERE dept_name=”Comp Sci”;In the SQL given above there is an error . Identify the error .

Dept_name

Employee

From

Answer Discus (0)

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

%

_

||

$

Answer Discus (0)

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

Atleast, Exactly

Exactly, Atleast

Atleast, All

All , Exactly

Answer Discus (0)

25.
To display the salary from greater to smaller and name in ascending order which of the following options should be used ?

Ascending, Descending

Asc, Desc

Desc, Asc

Descending, Ascending

Answer Discus (0)

26.
This query can be replaced by which of the following ?

SELECT name
FROM instructor
WHERE salary BETWEEN 90000 AND 100000,

SELECT name
FROM employee
WHERE salary <= 90000 AND salary>=100000,

SELECT name
FROM employee
WHERE salary BETWEEN 90000 AND 100000,

SELECT name
FROM instructor
WHERE salary BETWEEN 100000 AND 90000,

Answer Discus (0)

27.
This query does which of the following operation?

All attributes of instructor and teaches are selected

All attributes of instructor are selected on the given condition

All attributes of teaches are selected on given condition

Only the some attributes from instructed and teaches are selected

Answer Discus (0)

Engineering MCQS

General Subjects MCQS

error: You are not allowed to do so.....
0Shares
0
Scroll to Top