11738747
Descrição
Quiz por Алмат Мейржан, atualizado more than 1 year ago
|
Criado por Алмат Мейржан
mais de 6 anos atrás
|
|
Questão 1
Questão
Which symbol do you use if you need to choose all the columns from the table to the result query?
Responda
-
*
-
+
-
All
-
%
Questão 2
Questão
Which is right order of the following clauses?
Responda
-
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
Questão 3
Questão
Which symbol is used to create a substitution variable?
Responda
-
*
-
&
-
_
-
%
Questão 4
Questão
Which keyword is used to provide an alias to a column?
Responda
-
COLUMN
-
ALIAS
-
IS
-
AS
Questão 5
Questão
Which command is used to view the structure of the table LOCATIONS?
Responda
-
DESCRIBE LOCATIONS
-
SELECT * FROM LOCATIONS
-
SHOW STRUCTURE LOCATIONS
-
PRINT LOCATIONS
Questão 6
Questão
Which of the following is a concatenation operator?
Responda
-
*
-
+
-
&
-
||
Questão 7
Questão
Which keyword is used to eliminate duplicate rows in the result?
Responda
-
DESCRIBE
-
GROUP BY
-
HAVING
-
DISTINCT
Questão 8
Questão
Which of the following operations is an analogue to the CONCAT function?
Responda
-
||
-
+
-
LIKE
-
IN
Questão 9
Questão
When using LIKE conditions which symbol is used to denote zero or many characters?
Responda
-
*
-
+
-
_
-
%
Questão 10
Questão
When using LIKE conditions which symbol is used to denote one character?
Responda
-
*
-
+
-
_
-
%
Questão 11
Questão
Which of the following clauses is used to limit the rows that are retrieved by the query?
Responda
-
WHERE
-
FROM
-
ORDER BY
-
GROUP BY
Questão 12
Questão
Which of the following clauses is used to sort the rows that are retrieved by the query?
Responda
-
WHERE
-
FROM
-
ORDER BY
-
GROUP BY
Questão 13
Questão
Which of the following functions extracts a string of determined length?
Responda
-
SUBSTR
-
INSTR
-
CONCAT
-
TRIM
Questão 14
Questão
Which of the following functions finds the numeric position of a named character?
Responda
-
SUBSTR
-
INSTR
-
CONCAT
-
TRIM
Questão 15
Questão
Which of the following functions joins two strings together?
Responda
-
CONCAT
-
TRIM
-
SUBSTR
-
INSTR
Questão 16
Questão
Which of the following functions is not single-row function?
Responda
-
SUM
-
UPPER
-
CONCAT
-
ROUND
Questão 17
Questão
Which of the following functions is not multiple-row function?
Responda
-
TRUNC
-
SUM
-
AVG
-
COUNT
Questão 18
Questão
FULL OUTER JOIN is used when
Responda
-
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
Questão 19
Questão
Queries that return only one row from the inner SELECT statement are called
Responda
-
Single-column subqueries
-
Multiple-column subqueries
-
Multiple-row subqueries
-
Single-row subqueries
Questão 20
Questão
Queries that return more than one row from the inner SELECT statement are called
Responda
-
Multiple-row subqueries
-
Single-row subqueries
-
Multiple-column subqueries
-
Single-column subqueries
Questão 21
Questão
The _______operator compares a value to each value returned by a subquery.
Responda
-
ANY
-
ALL
-
NOT
-
SOME
Questão 22
Questão
The ________operator compares a value to every value returned by a subquery.
Responda
-
ALL
-
ANY
-
NOT
-
SOME
Questão 23
Questão
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
Responda
-
I and III
-
I, II, and III
-
I and II
-
I only
Questão 24
Questão
A SELECT statement that is embedded in a clause of another SELECT statement is called
Responda
-
subquery
-
inner query
-
outer query
-
main query
Questão 25
Questão
You can place the subquery in a number of SQL clauses, including the following:
I. WHERE clause
II. HAVING clause
III. FROM clause
Responda
-
I and III
-
I, II and III
-
I and II
-
I only
Questão 26
Questão
Comparison conditions fall into two classes:
Responda
-
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)
Questão 27
Questão
The subquery generally executes_________, and its output is used to complete the query condition for the main (or_________) query.
Responda
-
last, outer
-
first, inner
-
last, inner
-
first, outer
Questão 28
Questão
A subquery must be enclosed in_________________.
Responda
-
curly braces
-
double quotes
-
single quotes
-
parentheses
Questão 29
Questão
_________ clause can be used and is required in the subquery to perform Top-N analysis.
Responda
-
ORDER BY
-
HAVING
-
WHERE
-
GROUP BY
Questão 30
Questão
Which of the following operators is equivalent to the IN operator?
Responda
-
< ANY
-
= ALL
-
= ANY
-
> ANY
Questão 31
Questão
Queries containing set operators are called______________.
Responda
-
outer queries
-
compound queries
-
subqueries
-
inner queries
Questão 32
Questão
The _____________operator returns all rows that are selected by either query eliminating duplicates.
Responda
-
INTERSECT
-
UNION
-
MINUS
-
UNION ALL
Questão 33
Questão
Use the ________________operator to return all rows from multiple tables and eliminate any duplicate rows.
Responda
-
UNION ALL
-
UNION
-
MINUS
-
INTERSECT
Questão 34
Questão
_______________ returns all rows selected by either query, including all duplicates.
Responda
-
NTERSECT
-
MINUS
-
UNION
-
UNION ALL
Questão 35
Questão
Use the __________________operator to return all rows that are common to multiple queries.
Responda
-
UNION
-
UNION ALL
-
MINUS
-
INTERSECT
Questão 36
Questão
Use the ______________operator to return rows returned by the first query that are not present in the second query.
Responda
-
MINUS
-
INTERSECT
-
UNION
-
UNION ALL
Questão 37
Questão
Which statement discards all pending data changes
Responda
-
DISCARD
-
SAVEPOINT
-
ROLLBACK
-
COMMIT
Questão 38
Questão
Which of the following commands removes rows and a table structure?
Responda
-
REMOVE TABLE
-
ALTER TABLE
-
DROP TABLE
-
DELETE TABLE
Questão 39
Questão
Which of the following commands is a part of the Data Manipulation Language?
Responda
-
TRUNCATE
-
DROP
-
ALTER
-
SELECT
Questão 40
Questão
Which of the following commands is a part of the Data Definition Language?
Responda
-
DELETE
-
UPDATE
-
SELECT
-
CREATE
Questão 41
Questão
Which of the following constraints does not exist?
Responda
-
UNIQUE
-
CHECK
-
NOT NULL
-
DEFAULT
Questão 42
Questão
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)?
Responda
-
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;
Questão 43
Questão
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?
Responda
-
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;
Questão 44
Questão
What will be the result of the following SQL statement?
Responda
-
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
Questão 45
Questão
Which of the following SQL statements will not generate an error?
Responda
-
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
Questão 46
Questão
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?
Responda
-
WHERE salary > 5000 AND salary > 18000
-
WHERE salary > 5000 AND salary < 18000
-
WHERE salary < 5000 AND salary > 18000
-
WHERE salary > 5000 OR salary < 18000
Questão 47
Questão
Consider the EMPLOYEES table. Which condition in the WHERE clause limit the employees to IT programmers with salary greater than 5000?
Responda
-
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
Questão 48
Questão
Consider the EMPLOYEES table. Which condition in the WHERE clause limit the employees to those who work in the departments 90 and 60?
Responda
-
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
Questão 49
Questão
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?
Responda
-
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)
Questão 50
Questão
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’?
Responda
-
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%'
Quer criar seus próprios Quizzes gratuitos com a GoConqr? Saiba mais.