4003016
Beschreibung
Quiz von Jairo Jairo, aktualisiert more than 1 year ago
|
Erstellt von Jairo Jairo
vor etwa 9 Jahre
|
|
Frage 1
Frage
Identify the SELECT statements that execute successfully.
Antworten
-
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;
Frage 2
Frage
Which of the following are valid operators for the WHERE clause?
Antworten
-
>=
-
IS NULL
-
!=
-
IS LIKE
-
IN BETWEEN
-
<>
Frage 3
Frage
Which of the following statements are true about single-row
functions?
Antworten
-
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
Frage 4
Frage
The TO_NUMBER function converts either character strings or date values to a number in the format specified by the optional format model.
Antworten
-
True
-
False
Frage 5
Frage
Identify the guidelines for group functions and the GROUP BY clause.
Antworten
-
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.
Frage 6
Frage
The SQL:1999 standard join syntax supports the following types of joins. Which of these join types does Oracle join syntax
support?
Antworten
-
Equijoins
-
Nonequijoins
-
Left OUTER join
-
Right OUTER join
-
Full OUTER join
-
Self joins
-
Natural joins
-
Cartesian products
Frage 7
Frage
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.
Antworten
-
True
-
False
Frage 8
Frage
Identify the set operator guidelines.
Antworten
-
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.
Frage 9
Frage
The following statements produce the same results:
Antworten
-
True
-
False
Frage 10
Frage
You can use constraints to do the following:
Antworten
-
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.
Frage 11
Frage
To do which three of the following can you use constraints?
Antworten
-
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.
Frage 12
Frage
Indexes must be created manually and serve to speed up access to rows in a table.
Antworten
-
True
-
False
Möchten Sie mit GoConqr kostenlos Ihre eigenen Quiz erstellen? eigenen Mehr erfahren.