data

Question 1

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

Accepted Answer

*

Answer

+

Answer

All

Answer

%

Question 2

Which is right order of the following clauses?

Accepted Answer

SELECT … FROM … WHERE … GROUP BY … ORDER BY

Answer

SELECT … FROM … GROUP BY … ORDER BY … WHERE

Answer

SELECT … WHERE … ORDER BY … GROUP BY

Answer

SELECT … FROM … WHERE … ORDER BY … GROUP BY

Question 3

Which symbol is used to create a substitution variable?

Accepted Answer

&

Answer

*

Answer

_

Answer

%

Question 4

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

Accepted Answer

AS

Answer

COLUMN

Answer

ALIAS

Answer

IS

Question 5

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

Accepted Answer

DESCRIBE LOCATIONS

Answer

SELECT * FROM LOCATIONS

Answer

SHOW STRUCTURE LOCATIONS

Answer

PRINT LOCATIONS

Question 6

Which of the following is a concatenation operator?

Accepted Answer

||

Answer

*

Answer

+

Answer

&

Question 7

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

Accepted Answer

DISTINCT

Answer

DESCRIBE

Answer

GROUP BY

Answer

HAVING

Question 8

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

Accepted Answer

||

Answer

+

Answer

LIKE

Answer

IN

Question 9

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

Accepted Answer

%

Answer

*

Answer

+

Answer

_

Question 10

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

Accepted Answer

_

Answer

*

Answer

+

Answer

%

Question 11

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

Accepted Answer

WHERE

Answer

FROM

Answer

ORDER BY

Answer

GROUP BY

Question 12

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

Accepted Answer

ORDER BY

Answer

WHERE

Answer

FROM

Answer

GROUP BY

Question 13

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

Accepted Answer

SUBSTR

Answer

INSTR

Answer

CONCAT

Answer

TRIM

Question 14

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

Accepted Answer

INSTR

Answer

SUBSTR

Answer

CONCAT

Answer

TRIM

Question 15

Which of the following functions joins two strings together?

Accepted Answer

CONCAT

Answer

TRIM

Answer

SUBSTR

Answer

INSTR

Question 16

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

Accepted Answer

SUM

Answer

UPPER

Answer

CONCAT

Answer

ROUND

Question 17

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

Accepted Answer

TRUNC

Answer

SUM

Answer

AVG

Answer

COUNT

Question 18

FULL OUTER JOIN is used when

Accepted Answer

the rows from both tables must be displayed even if they do not satisfy the JOIN condition

Answer

each row of one table must be join with each row of another table

Answer

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

Answer

a Cartesian product of the two tables must be displayed

Question 19

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

Accepted Answer

Single-row subqueries

Answer

Single-column subqueries

Answer

Multiple-column subqueries

Answer

Multiple-row subqueries

Question 20

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

Accepted Answer

Multiple-row subqueries

Answer

Single-row subqueries

Answer

Multiple-column subqueries

Answer

Single-column subqueries

Question 21

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

Accepted Answer

ANY

Answer

ALL

Answer

NOT

Answer

SOME

Question 22

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

Accepted Answer

ALL

Answer

ANY

Answer

NOT

Answer

SOME

Question 23

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

Accepted Answer

I, II, and III

Answer

I and III

Answer

I and II

Answer

I only

Question 24

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

Accepted Answer

subquery

Answer

inner query

Answer

outer query

Answer

main query

Question 25

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

Accepted Answer

I, II and III

Answer

I and III

Answer

I and II

Answer

I only

Question 26

Comparison conditions fall into two classes:

Accepted Answer

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

Answer

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

Answer

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

Answer

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

Question 27

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

Accepted Answer

first, outer

Answer

last, outer

Answer

first, inner

Answer

last, inner

Question 28

A subquery must be enclosed in_________________.

Accepted Answer

parentheses

Answer

curly braces

Answer

double quotes

Answer

single quotes

Question 29

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

Accepted Answer

ORDER BY

Answer

HAVING

Answer

WHERE

Answer

GROUP BY

Question 30

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

Accepted Answer

= ANY

Answer

< ANY

Answer

= ALL

Answer

> ANY

Question 31

Queries containing set operators are called______________.

Accepted Answer

compound queries

Answer

outer queries

Answer

subqueries

Answer

inner queries

Question 32

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

Accepted Answer

UNION

Answer

INTERSECT

Answer

MINUS

Answer

UNION ALL

Question 33

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

Accepted Answer

UNION

Answer

UNION ALL

Answer

MINUS

Answer

INTERSECT

Question 34

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

Accepted Answer

UNION ALL

Answer

NTERSECT

Answer

MINUS

Answer

UNION

Question 35

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

Accepted Answer

INTERSECT

Answer

UNION

Answer

UNION ALL

Answer

MINUS

Question 36

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

Accepted Answer

MINUS

Answer

INTERSECT

Answer

UNION

Answer

UNION ALL

Question 37

Which statement discards all pending data changes

Accepted Answer

ROLLBACK

Answer

DISCARD

Answer

SAVEPOINT

Answer

COMMIT

Question 38

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

Accepted Answer

DROP TABLE

Answer

REMOVE TABLE

Answer

ALTER TABLE

Answer

DELETE TABLE

Question 39

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

Accepted Answer

SELECT

Answer

TRUNCATE

Answer

DROP

Answer

ALTER

Question 40

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

Accepted Answer

CREATE

Answer

DELETE

Answer

UPDATE

Answer

SELECT

Question 41

Which of the following constraints does not exist?

Accepted Answer

DEFAULT

Answer

UNIQUE

Answer

CHECK

Answer

NOT NULL

Question 42

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)?

Accepted Answer

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

Answer

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

Answer

SELECT last_name Employee, hire_date Hire Date FROM employees;

Answer

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

Question 43

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?

Accepted Answer

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

Answer

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

Answer

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

Answer

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

Question 44

What will be the result of the following SQL statement?

Accepted Answer

The unique department ids will be displayed

Answer

he number of employees within each department will be displayed

Answer

An error will occur since the GROUP BY clause is missing

Answer

The number of departments will be displayed

Question 45

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

Accepted Answer

SELECT last_name Name FROM employees ORDER BY Name

Answer

SELECT department_id Dep, COUNT(last_name) Num FROM employees GROUP BY department_id HAVING Num > 5

Answer

SELECT department_id Dep, COUNT(last_name) FROM employees GROUP BY Dep

Answer

SELECT last_name Name FROM employees WHERE Name like 'K%'

Question 46

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?

Accepted Answer

WHERE salary > 5000 AND salary < 18000

Answer

WHERE salary > 5000 AND salary > 18000

Answer

WHERE salary < 5000 AND salary > 18000

Answer

WHERE salary > 5000 OR salary < 18000

Question 47

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

Accepted Answer

WHERE salary > 5000 AND job_id = 'IT_PROG'

Answer

WHERE salary > 5000 OR job_id = 'IT_PROG'

Answer

WHERE salary > 5000 AND job_id = "IT_PROG"

Answer

WHERE salary > 5000 AND job_id = IT_PROG

Question 48

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

Accepted Answer

WHERE department_id = 90 OR department_id = 60

Answer

WHERE department_id BETWEEN 60 AND 90

Answer

WHERE department_id BETWEEN 90 AND 60

Answer

WHERE department_id = 90 AND department_id = 60

Question 49

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?

Accepted Answer

WHERE department_id NOT IN (90, 60)

Answer

WHERE department_id = 90 OR department_id = 60

Answer

WHERE department_id = 90 AND department_id = 60

Answer

WHERE department_id IN (90, 60)

Question 50

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’?

Accepted Answer

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

Answer

WHERE last_name LIKE 'K_' and first_name LIKE 'K_'

Answer

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

Answer

WHERE last_name and first_name = 'K%'

data

Create a free account to finish this quiz

Questions in this quiz (50)

Information

Feedback

What do you think of the new look?