data

Pregunta 1

Pregunta

Which symbol do you use if you need to choose all the columns from the table to the result query?

Respuesta

Pregunta 2

Pregunta

Which is right order of the following clauses?

Respuesta

SELECT … FROM … GROUP BY … ORDER BY … WHERE
SELECT … WHERE … ORDER BY … GROUP BY
SELECT … FROM … WHERE … GROUP BY … ORDER BY
SELECT … FROM … WHERE … ORDER BY … GROUP BY

Pregunta 3

Pregunta

Which symbol is used to create a substitution variable?

Respuesta

Pregunta 4

Pregunta

Which keyword is used to provide an alias to a column?

Respuesta

COLUMN
ALIAS
IS
AS

Pregunta 5

Pregunta

Which command is used to view the structure of the table LOCATIONS?

Respuesta

DESCRIBE LOCATIONS
SELECT * FROM LOCATIONS
SHOW STRUCTURE LOCATIONS
PRINT LOCATIONS

Pregunta 6

Pregunta

Which of the following is a concatenation operator?

Respuesta

Pregunta 7

Pregunta

Which keyword is used to eliminate duplicate rows in the result?

Respuesta

DESCRIBE
GROUP BY
HAVING
DISTINCT

Pregunta 8

Pregunta

Which of the following operations is an analogue to the CONCAT function?

Respuesta

Pregunta 9

Pregunta

When using LIKE conditions which symbol is used to denote zero or many characters?

Respuesta

Pregunta 10

Pregunta

When using LIKE conditions which symbol is used to denote one character?

Respuesta

Pregunta 11

Pregunta

Which of the following clauses is used to limit the rows that are retrieved by the query?

Respuesta

WHERE
FROM
ORDER BY
GROUP BY

Pregunta 12

Pregunta

Which of the following clauses is used to sort the rows that are retrieved by the query?

Respuesta

WHERE
FROM
ORDER BY
GROUP BY

Pregunta 13

Pregunta

Which of the following functions extracts a string of determined length?

Respuesta

SUBSTR
INSTR
CONCAT
TRIM

Pregunta 14

Pregunta

Which of the following functions finds the numeric position of a named character?

Respuesta

SUBSTR
INSTR
CONCAT
TRIM

Pregunta 15

Pregunta

Which of the following functions joins two strings together?

Respuesta

CONCAT
TRIM
SUBSTR
INSTR

Pregunta 16

Pregunta

Which of the following functions is not single-row function?

Respuesta

SUM
UPPER
CONCAT
ROUND

Pregunta 17

Pregunta

Which of the following functions is not multiple-row function?

Respuesta

TRUNC
SUM
AVG
COUNT

Pregunta 18

Pregunta

FULL OUTER JOIN is used when

Respuesta

each row of one table must be join with each row of another table
each row of one table must be join with each row of another table even if the tables do not have any columns in common
the rows from both tables must be displayed even if they do not satisfy the JOIN condition
a Cartesian product of the two tables must be displayed

Pregunta 19

Pregunta

Queries that return only one row from the inner SELECT statement are called

Respuesta

Single-column subqueries
Multiple-column subqueries
Multiple-row subqueries
Single-row subqueries

Pregunta 20

Pregunta

Queries that return more than one row from the inner SELECT statement are called

Respuesta

Multiple-row subqueries
Single-row subqueries
Multiple-column subqueries
Single-column subqueries

Pregunta 21

Pregunta

The _______operator compares a value to each value returned by a subquery.

Respuesta

ANY
ALL
NOT
SOME

Pregunta 22

Pregunta

The ________operator compares a value to every value returned by a subquery.

Respuesta

ALL
ANY
NOT
SOME

Pregunta 23

Pregunta

Subqueries have the following characteristics: I. Can pass one row of data to a main statement that contains a single-row operator, such as =, <>, >, >=, <, or <= II. Can pass multiple rows of data to a main statement that contains a multiple-row operator, such as IN III. Are processed first by the Oracle server, after which the WHERE or HAVING clause uses the results

Respuesta

I and III
I, II, and III
I and II
I only

Pregunta 24

Pregunta

A SELECT statement that is embedded in a clause of another SELECT statement is called

Respuesta

subquery
inner query
outer query
main query

Pregunta 25

Pregunta

You can place the subquery in a number of SQL clauses, including the following: I. WHERE clause II. HAVING clause III. FROM clause

Respuesta

I and III
I, II and III
I and II
I only

Pregunta 26

Pregunta

Comparison conditions fall into two classes:

Respuesta

single-row operators (>, =, >=, <, <>, <=) and multiple-column operators (IN, ANY, ALL)
single-column operators (>, =, >=, <, <>, <=) and multiple-column operators (IN, ANY, ALL)
multiple-row operators (>, =, >=, <, <>, <=) and single-row operators (IN, ANY, ALL)
single-row operators (>, =, >=, <, <>, <=) and multiple-row operators (IN, ANY, ALL)

Pregunta 27

Pregunta

The subquery generally executes_________, and its output is used to complete the query condition for the main (or_________) query.

Respuesta

last, outer
first, inner
last, inner
first, outer

Pregunta 28

Pregunta

A subquery must be enclosed in_________________.

Respuesta

curly braces
double quotes
single quotes
parentheses

Pregunta 29

Pregunta

_________ clause can be used and is required in the subquery to perform Top-N analysis.

Respuesta

ORDER BY
HAVING
WHERE
GROUP BY

Pregunta 30

Pregunta

Which of the following operators is equivalent to the IN operator?

Respuesta

< ANY
= ALL
= ANY
> ANY

Pregunta 31

Pregunta

Queries containing set operators are called______________.

Respuesta

outer queries
compound queries
subqueries
inner queries

Pregunta 32

Pregunta

The _____________operator returns all rows that are selected by either query eliminating duplicates.

Respuesta

INTERSECT
UNION
MINUS
UNION ALL

Pregunta 33

Pregunta

Use the ________________operator to return all rows from multiple tables and eliminate any duplicate rows.

Respuesta

UNION ALL
UNION
MINUS
INTERSECT

Pregunta 34

Pregunta

_______________ returns all rows selected by either query, including all duplicates.

Respuesta

NTERSECT
MINUS
UNION
UNION ALL

Pregunta 35

Pregunta

Use the __________________operator to return all rows that are common to multiple queries.

Respuesta

UNION
UNION ALL
MINUS
INTERSECT

Pregunta 36

Pregunta

Use the ______________operator to return rows returned by the first query that are not present in the second query.

Respuesta

MINUS
INTERSECT
UNION
UNION ALL

Pregunta 37

Pregunta

Which statement discards all pending data changes

Respuesta

DISCARD
SAVEPOINT
ROLLBACK
COMMIT

Pregunta 38

Pregunta

Which of the following commands removes rows and a table structure?

Respuesta

REMOVE TABLE
ALTER TABLE
DROP TABLE
DELETE TABLE

Pregunta 39

Pregunta

Which of the following commands is a part of the Data Manipulation Language?

Respuesta

TRUNCATE
DROP
ALTER
SELECT

Pregunta 40

Pregunta

Which of the following commands is a part of the Data Definition Language?

Respuesta

DELETE
UPDATE
SELECT
CREATE

Pregunta 41

Pregunta

Which of the following constraints does not exist?

Respuesta

UNIQUE
CHECK
NOT NULL
DEFAULT

Pregunta 42

Pregunta

Consider the EMPLOYEES table. Which of the following SQL statements is correct to display the last name of the employee with its hire date providing the Employee and Hire Date aliases (case is important)?

Respuesta

SELECT last_name AS 'Employee', hire_date AS 'Hire Date' FROM employees;
SELECT last_name "Employee", hire_date "Hire Date" FROM employees;
SELECT last_name Employee, hire_date Hire Date FROM employees;
SELECT last_name AS Employee, hire_date AS Hire Date FROM employees;

Pregunta 43

Pregunta

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?

Respuesta

SELECT last_name || ' has been working since ' || hire_date Employee Information FROM employees;
SELECT last_name || ' has been working since ' || hire_date 'Employee Information' FROM employees;
SELECT last_name || " has been working since " || hire_date "Employee Information" FROM employees;
SELECT last_name || ' has been working since ' || hire_date "Employee Information" FROM employees;

Pregunta 44

Pregunta

What will be the result of the following SQL statement?

Respuesta

he number of employees within each department will be displayed
An error will occur since the GROUP BY clause is missing
The unique department ids will be displayed
The number of departments will be displayed

Pregunta 45

Pregunta

Which of the following SQL statements will not generate an error?

Respuesta

SELECT department_id Dep, COUNT(last_name) Num FROM employees GROUP BY department_id HAVING Num > 5
SELECT department_id Dep, COUNT(last_name) FROM employees GROUP BY Dep
SELECT last_name Name FROM employees WHERE Name like 'K%'
SELECT last_name Name FROM employees ORDER BY Name

Pregunta 46

Pregunta

Consider the EMPLOYEES table. Which condition in the WHERE clause limit the employees to those whose salary is greater than 5000 but less than 18000?

Respuesta

WHERE salary > 5000 AND salary > 18000
WHERE salary > 5000 AND salary < 18000
WHERE salary < 5000 AND salary > 18000
WHERE salary > 5000 OR salary < 18000

Pregunta 47

Pregunta

Consider the EMPLOYEES table. Which condition in the WHERE clause limit the employees to IT programmers with salary greater than 5000?

Respuesta

WHERE salary > 5000 AND job_id = 'IT_PROG'
WHERE salary > 5000 OR job_id = 'IT_PROG'
WHERE salary > 5000 AND job_id = "IT_PROG"
WHERE salary > 5000 AND job_id = IT_PROG

Pregunta 48

Pregunta

Consider the EMPLOYEES table. Which condition in the WHERE clause limit the employees to those who work in the departments 90 and 60?

Respuesta

WHERE department_id BETWEEN 60 AND 90
WHERE department_id BETWEEN 90 AND 60
WHERE department_id = 90 OR department_id = 60
WHERE department_id = 90 AND department_id = 60

Pregunta 49

Pregunta

Consider the EMPLOYEES table. Which condition in the WHERE clause limit the employees to those who do not work in the departments 90 and 60?

Respuesta

WHERE department_id = 90 OR department_id = 60
WHERE department_id NOT IN (90, 60)
WHERE department_id = 90 AND department_id = 60
WHERE department_id IN (90, 60)

Pregunta 50

Pregunta

Consider the EMPLOYEES table. Which condition in the WHERE clause limit the employees to those whose last name and first name starts with the letter ‘K’?

Respuesta

WHERE last_name LIKE 'K%' and first_name LIKE 'K%'
WHERE last_name LIKE 'K_' and first_name LIKE 'K_'
WHERE last_name = 'K%' and first_name = 'K%'
WHERE last_name and first_name = 'K%'

	Creado por Алмат Мейржан hace más de 6 años

Siguiente

Descripción

Resumen del Recurso

Pregunta 1

Pregunta 2

Pregunta 3

Pregunta 4

Pregunta 5

Pregunta 6

Pregunta 7

Pregunta 8

Pregunta 9

Pregunta 10

Pregunta 11

Pregunta 12

Pregunta 13

Pregunta 14

Pregunta 15

Pregunta 16

Pregunta 17

Pregunta 18

Pregunta 19

Pregunta 20

Pregunta 21

Pregunta 22

Pregunta 23

Pregunta 24

Pregunta 25

Pregunta 26

Pregunta 27

Pregunta 28

Pregunta 29

Pregunta 30

Pregunta 31

Pregunta 32

Pregunta 33

Pregunta 34

Pregunta 35

Pregunta 36

Pregunta 37

Pregunta 38

Pregunta 39

Pregunta 40

Pregunta 41

Pregunta 42

Pregunta 43

Pregunta 44

Pregunta 45

Pregunta 46

Pregunta 47

Pregunta 48

Pregunta 49

Pregunta 50

Similar