DBMS_SQL Intro

Name

Annie

Bob

Callie

Derek

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

• a) Select employee from name
  b) Select name
  c) Select name from employee
  d) Select employee

• b) Select name
  

• c) Select name from employee
  

• d) Select employee

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

• a) Where
  

• b) Select
  

• c) From
  

• d) Distinct

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

SELECT name, course_id

FROM instructor, teaches

WHERE instructor_ID= teaches_ID;

• a) Select name,course_id from teaches,instructor where instructor_id=course_id;
  

• b) Select name, course_id from instructor natural join teaches;
  

• c) Select name, course_id from instructor;
  

• d) Select course_id from instructor join teaches;

SELECT * FROM employee WHERE salary>10000 AND dept_id=101;

Which of the following fields are displayed as output?

• a) Salary, dept_id
  

• b) Employee
  

• c) Salary
  

• d) All the field of employee relation

This is Employee table.
Which of the following employee_id will be displayed for the given query?

SELECT * FROM employee WHERE employee_id>1009;

• a) 1009, 1001, 1018
  

• b) 1009, 1018
  

• c) 1001
  

• d) 1018

Which of the following statements contains an error?

• a) Select * from emp where empid = 10003;
  

• b) Select empid from emp where empid = 10006;
  

• c) Select empid from emp;
  

• d) Select empid where empid = 1009 and lastname = ‘GELLER’;

In the given query which of the keyword has to be inserted?

INSERT INTO employee _____ (1002,Joey,2000);

• a) Table
  

• b) Values
  

• c) Relation
  

• d) Field

A_____ is a query that retrieves rows from more than one table or view:

• a) Start
  

• b) End
  

• c) Join
  

• d) All of the mentioned