1. A SQL keyword that defines a column that can contain ONLY numbers of varying
ID: 3596290 • Letter: 1
Question
1. A SQL keyword that defines a column that can contain ONLY numbers of varying length and precision is a ___ data type.
NUMBER
NULL
Column alias
VARCHAR2
CHAR
2. Giving a column a new name that displays at the top of a result set in a SQL query is an example of a(n) ___.
LIKE
Literal value
Result set
Column alias
3. To get the current date value from the operating system you would use the SQL keyword:
SYSTIME
DATE
SYSDATE
DAYTIME
4. The SQL keyword that is paired with the '%' and '_" operators to search for a range of values is ______________________.
LIKE
SYSDATE
DATE
NULL
5. The SQL keyword combination that changes the way data is arranged in the results set is ___.
LIKE
ORDER BY
DEFINE
WHERE clause
6. Using != in your SQL query would be example of using a(n) ___.
Literal value
equality operator
inequality operator
Column alias
7. The SQL keyword that is used to describe the absence of a value is called _______________.
ORDER BY
LIKE
DEFINE
NULL
UNDEFINE
8. If you wanted to give the SQL object &JOBNAME a value for an entire SQL session you would use the SQL keyword ___.
LIKE
DEFINE
SELECT
VARCHAR2
9. "The output of a SQL query, or what appears when you run a query is called a ___."
schema
equality operator
Result set
Column alias
10. The SQL database object _____ has a series of attributes that describe what it is and what information will be stored for it.
11. SQL system-defined functions will take one or more ___ to work on.
12. "In SQL NUMBER, DATE and VARCHAR2 are all examples of ___."
13. In relational database theory the ______________________ clause is the first selection or restricting clause and can be followed by many AND clauses.
14. To find all of the rows in a given table, including duplicates, you can use this system-defined function________________.
15. To look for a range of values in a SQL statement, you could use the operators '>=' and '<=' or the SQL keyword _____________________ which is paired with the SQL reserved keyword AND.
SELECT
=
IN
BETWEEN
16. If you wanted to WHERE condition to search an ordered list (such as ('BIO','CIS','ENG')) for matches in a table you would use the SQL reserved keyword________________.
IN
IS
!=
LIKE
NUMBER
NULL
Column alias
VARCHAR2
CHAR
Explanation / Answer
1. NUMBER
Number data type will only define numbers of varying length.
2.
3. SYSDATE
It will display current data value from the operating system.
4.
5. ORDER BY
It will change the way of data as ascending or descending.
6. inequality operator
It is a inequality operator
7. NULL
Null value indicates a lack of value.
8. VARCHAR2
It is used to assigned number of character values to JOBNAME.
9. Result set
To will get the result when it is executed
12. Oracle Data types
15. =
Equal to is used as operator.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.