33) Consider the EMPLOYEES table. Which of the following SQL statements is correct to provide the sentence in the format "King has been working since 01.01.1987" with "Employee Information" alias?
SELECT last_name || ' has been working since ' || hire_date "Employee Information" FROM employees;
The UNION and UNION ALL set operators have the opposite effect of each other.
False
The subquery generally executes_________, and its output is used to complete the query condition for the main (or_________) query.
First,outer
To obtain a list of last names that students and instructors share, you use the MINUS set operator.
False
37) The follwong query is correct:
select firstname, item from customers, items_ordered where customer_id=customer_id;
Неверно
38) Consider the EMPLOYEES table. Which of the following statements calculate the minimum salary within each department, displaying only those rows where minimum salary is greater than 5000?
SELECT department_id, MIN (salary) FROM employees GROUP BY department_id HAVING MIN (salary) > 5000
The _____________operator returns all rows that are selected by either query.
UNION
40) Which of the following functions is not multiple-row function?
TRUNC
41) Consider the DEPARTMENTS table. Which condition in the WHERE clause limit the departments to those which department id equals to 10 or 90 and department name contains letter 'u'?
WHERE department_id in (10, 90) and department_name like '%u%'
42) The _______operator compares a value to each value returned by a subquery.
ANY
43) Which of the following functions joins two strings together?
CANCAT
44) Consider the EMPLOYEES table. Which of the following statements displays the maximum average salary among all the departments?
SELECT MAX(AVG(salary)) FROM employees GROUP BY department_id
45) It is possible to combine data from two tables that do not have a primary key/foreign key relationship into one result using a set operation.
True
A DISTINCT must always be used in the top-most SELECT statement of a set operation.
False
47) Consider the EMPLOYEES table. Which condition in the WHERE clause limit the employees to those whose last name ends with the letter 'K'?
WHERE last_name = '%K'
48) Consider the EMPLOYEES table. Which condition in the WHERE clause limit the employees to IT programmers with salary greater than 5000?
WHERE salary > 5000 AND job_id = 'IT_PROG'
49) What will be the result of the following query?
50) Which of the following statements will NOT generate an error?
SELECT e.last_name, d.department_name
FROM employees e, departments d
51) Which of the following functions finds the numeric position of a named character?
INSTR
52) Write the question for the following query:
SELECT course_no, description
FROM course
WHERE course_no IN
(SELECT course_no
FROM section
WHERE location = 'L111')
OR prerequisite = 20
List the course number and description of courses with either the course number 20 as a prerequisite or a location of L111.
Queries containing set operators are called______________.
Compound queries
54) When using LIKE conditions which symbol is used to denote zero or many characters?
%
55) Which of the following functions is not multiple-row function?
TRUNC
56) Write the question for the following query: <br>
SELECT first_name, last_name<br>
FROM instructor<br>
WHERE zip NOT IN<br>
(SELECT zip<br>
FROM zipcode)</div>
List the first and last name of the instructors with zip codes that do not exist in the ZIPCODE table. Instructors with NULL values in the zip column do not show in the result.