Home Random Page


CATEGORIES:

BiologyChemistryConstructionCultureEcologyEconomyElectronicsFinanceGeographyHistoryInformaticsLawMathematicsMechanicsMedicineOtherPedagogyPhilosophyPhysicsPolicyPsychologySociologySportTourism






There can be more than one condition in a query

Верно

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.


Date: 2016-01-14; view: 1409


<== previous page | next page ==>
B. implies the absence of transitive functional dependencies | Queries that return more than one row from the inner SELECT statement are called
doclecture.net - lectures - 2014-2024 year. Copyright infringement or personal data (0.007 sec.)