4003016
Description
Quiz by Jairo Jairo, updated more than 1 year ago
|
Created by Jairo Jairo
over 8 years ago
|
|
Question 1
Question
Identify the SELECT statements that execute successfully.
Answer
-
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;
Question 2
Question
Which of the following are valid operators for the WHERE clause?
Answer
-
>=
-
IS NULL
-
!=
-
IS LIKE
-
IN BETWEEN
-
<>
Question 3
Question
Which of the following statements are true about single-row
functions?
Answer
-
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
Question 4
Question
The TO_NUMBER function converts either character strings or date values to a number in the format specified by the optional format model.
Answer
-
True
-
False
Question 5
Question
Identify the guidelines for group functions and the GROUP BY clause.
Answer
-
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.
Question 6
Question
The SQL:1999 standard join syntax supports the following types of joins. Which of these join types does Oracle join syntax
support?
Answer
-
Equijoins
-
Nonequijoins
-
Left OUTER join
-
Right OUTER join
-
Full OUTER join
-
Self joins
-
Natural joins
-
Cartesian products
Question 7
Question
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.
Answer
-
True
-
False
Question 8
Question
Identify the set operator guidelines.
Answer
-
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.
Question 9
Question
The following statements produce the same results:
Answer
-
True
-
False
Question 10
Question
You can use constraints to do the following:
Answer
-
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.
Question 11
Question
To do which three of the following can you use constraints?
Answer
-
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.
Question 12
Question
Indexes must be created manually and serve to speed up access to rows in a table.
Answer
-
True
-
False
Want to create your own Quizzes for free with GoConqr? Learn more.