4003016
Descrição
Quiz por Jairo Jairo, atualizado more than 1 year ago
|
Criado por Jairo Jairo
aproximadamente 9 anos atrás
|
|
Questão 1
Questão
Identify the SELECT statements that execute successfully.
Responda
-
SELECT first_name, last_name, job_id, salary*12 AS Yearly Sal FROM employees;
-
SELECT first_name, last_name, job_id, salary*12 "yearly sal" FROM employees;
-
SELECT first_name, last_name, job_id, salary AS "yearly sal" FROM employees;
-
SELECT first_name+last_name AS name, job_Id, salary*12 yearly sal FROM employees;
Questão 2
Questão
Which of the following are valid operators for the WHERE clause?
Responda
-
>=
-
IS NULL
-
!=
-
IS LIKE
-
IN BETWEEN
-
<>
Questão 3
Questão
Which of the following statements are true about single-row
functions?
Responda
-
Manipulate data items
-
Accept arguments and return one value per argument
-
Act on each row that is returned
-
Return one result per set of rows
-
May not modify the data type
-
Can be nested
-
Accept arguments that can be a column or an expression
Questão 4
Questão
The TO_NUMBER function converts either character strings or date values to a number in the format specified by the optional format model.
Responda
-
True
-
False
Questão 5
Questão
Identify the guidelines for group functions and the GROUP BY clause.
Responda
-
You cannot use a column alias in the GROUP BY clause.
-
The GROUP BY column must be in the SELECT clause.
-
By using a WHERE clause, you can exclude rows before dividing them into groups.
-
The GROUP BY clause groups rows and ensures order of the result set.
-
If you include a group function in a SELECT clause, you cannot select individual results as well.
Questão 6
Questão
The SQL:1999 standard join syntax supports the following types of joins. Which of these join types does Oracle join syntax
support?
Responda
-
Equijoins
-
Nonequijoins
-
Left OUTER join
-
Right OUTER join
-
Full OUTER join
-
Self joins
-
Natural joins
-
Cartesian products
Questão 7
Questão
Using a subquery is equivalent to performing two sequential queries and using the result of the first query as the search
value(s) in the second query.
Responda
-
True
-
False
Questão 8
Questão
Identify the set operator guidelines.
Responda
-
The expressions in the SELECT lists must match in number.
-
Parentheses may not be used to alter the sequence of execution.
-
The data type of each column in the second query must match the data type of its corresponding column in the first query.
-
The ORDER BY clause can be used only once in a compound query, unless a UNION ALL operator is used.
Questão 9
Questão
The following statements produce the same results:
Responda
-
True
-
False
Questão 10
Questão
You can use constraints to do the following:
Responda
-
Enforce rules on the data in a table whenever a row is inserted, updated, or deleted.
-
Prevent the deletion of a table.
-
Prevent the creation of a table.
-
Prevent the creation of data in a table.
Questão 11
Questão
To do which three of the following can you use constraints?
Responda
-
Enforce rules on the data in a table whenever a row is inserted, updated, or deleted.
-
Prevent the dropping of a table.
-
Prevent the creation of a table.
-
Prevent the creation of data in a table.
Questão 12
Questão
Indexes must be created manually and serve to speed up access to rows in a table.
Responda
-
True
-
False
Quer criar seus próprios Quizzes gratuitos com a GoConqr? Saiba mais.