4003016
Descripción
Test por Jairo Jairo, actualizado hace más de 1 año
|
Creado por Jairo Jairo
hace alrededor de 9 años
|
|
Pregunta 1
Pregunta
Identify the SELECT statements that execute successfully.
Respuesta
-
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;
Pregunta 2
Pregunta
Which of the following are valid operators for the WHERE clause?
Respuesta
-
>=
-
IS NULL
-
!=
-
IS LIKE
-
IN BETWEEN
-
<>
Pregunta 3
Pregunta
Which of the following statements are true about single-row
functions?
Respuesta
-
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
Pregunta 4
Pregunta
The TO_NUMBER function converts either character strings or date values to a number in the format specified by the optional format model.
Respuesta
-
True
-
False
Pregunta 5
Pregunta
Identify the guidelines for group functions and the GROUP BY clause.
Respuesta
-
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.
Pregunta 6
Pregunta
The SQL:1999 standard join syntax supports the following types of joins. Which of these join types does Oracle join syntax
support?
Respuesta
-
Equijoins
-
Nonequijoins
-
Left OUTER join
-
Right OUTER join
-
Full OUTER join
-
Self joins
-
Natural joins
-
Cartesian products
Pregunta 7
Pregunta
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.
Respuesta
-
True
-
False
Pregunta 8
Pregunta
Identify the set operator guidelines.
Respuesta
-
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.
Pregunta 9
Pregunta
The following statements produce the same results:
Respuesta
-
True
-
False
Pregunta 10
Pregunta
You can use constraints to do the following:
Respuesta
-
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.
Pregunta 11
Pregunta
To do which three of the following can you use constraints?
Respuesta
-
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.
Pregunta 12
Pregunta
Indexes must be created manually and serve to speed up access to rows in a table.
Respuesta
-
True
-
False
¿Quieres crear tus propios Tests gratis con GoConqr? Más información.