Acct 553 Quiz

Which of these query will demonstrate the table given above ?
a) Select employee from name
b) Select name
c) Select name from employee
d) Select employee
Answer:c
22. Select ________ dept_name from lecturer;
Here which of the following demonstrates the distinctive values of the column ?
a) All
b) From
c) Distinct
d) Name
Answer:c
23. The ______ section permits us to select only those rows in the effect relation of the ____ section that satisfy a specified predicate.
a) Where, from
b) From, select
c) Select, from
d) From, where
Answer:a

24. 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 interchanged to get the preferred output?
a) Salary*1.1
b) ID …show more content…
Which clause is used to list the attributes desired in the result of a query?
a) Where
b) Select
c) From
d) Distinct
Answer:b

26. Select name, course_idfrom tutor, teaches where instructor_ID= teaches_ID;
This Query can be replaced by which one of the following ?
a) Select name,course_id from teaches, tutor where instructor_id=course_id;
b) Select name, course_id from tutor natural join teaches;
c) Select name ,course_id from tutor;
d) Select course_id from tutor join teaches;
Answer:b
27. Select * from worker where salary>10000 and dept_id=101;Which of the following fields are displayed as output?
a) Salary, dept_id
b) Worker
c) Salary
d) All the field of worker relation
Answer:d
28.
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 showed?
a) 1009, 1001, 1018
b) 1009, 1018
c) 1001
d)