1. TCO 5 - A(n) ____ is a single task sent to the database, such as parsing a ne
ID: 654379 • Letter: 1
Question
1. TCO 5 - A(n) ____ is a single task sent to the database, such as parsing a new SQL statement or executing a query. (Points : 3) callcommand
execution
event Question 2.2. TCO 5 - A ____ is a named group of privileges that can be assigned to a user as a set rather than individually. (Points : 3) profile
role
group
block Question 3.3. TCO 5 - The ____ utility is generally the most efficient tool for the mass loading of data into an Oracle database. (Points : 3) Imp
Impdp
SQL Loader
Data Pump Question 4.4. TCO 5 - To drop a user named TREVOR, who owns no tables or other database objects, type the following command: ____. (Points : 3) DROP TREVOR;
DROP USER TREVOR;
DROP TREVOR CASCADE;
DROP USER TREVOR CASCADE; Question 5.5. TCO 5 - The locking mode ____ is similar to ROW SHARE, additionally prohibiting a SHARE lock on the table. (Points : 3) SHARE ROW EXCLUSIVE
SHARE UPDATE
ROW EXCLUSIVE
MODE Question 6.6. TCO 5 - Data Pump (import and export) and ____ are used to perform bulk loads and dumps into and out of an Oracle database. (Points : 3) SQL*Plus
SQL*Plus Worksheet
iSQL*Plus
SQL*Loader Question 7.7. TCO 6 - ____ is used to represent one and only one character. (Points : 3) %
_
*
# Question 8.8. TCO 6 - The ____ statement or clause is the beginning of the SQL command for querying (retrieving) data from a database object, such as a table or view. (Points : 3) QUERY
SELECT
WHERE
RETRIEVE Question 9.9. TCO 6 - It is possible to remove all of the rows from a table by typing:
____ FROM <tablename>; (Points : 3) TRUNCATE
DELETE
DROP
REMOVE Question 10.10. TCO 6 - When creating a relational table with a BLOB column, the ____ parameter tells Oracle 10g to place the LOB values into the data buffer for faster retrieval of frequently accessed data. (Points : 3) CHUNK
RETENTION
STORAGE
CACHE Question 11.11. TCO 6 - The ____ SQL group function returns the lowest value from a group of values. (Points : 3) MIN
MINIMUM
MINM
MNM Question 12.12. TCO 6 - When creating a relational table with a BLOB column, the ____ parameter sets the number of bytes allocated for working with the LOB value. (Points : 3) CHUNK
LOB
STORAGE
STORE AS 1. TCO 5 - A(n) ____ is a single task sent to the database, such as parsing a new SQL statement or executing a query. (Points : 3) call
command
execution
event
Explanation / Answer
1.
CALL : CALL is a statement to execute a routine or procedure or function from within SQL.
COMMAND : COMMAND object is responsible for formulating the request and passing it to the database.
EXECUTION : Processing the request.
EVENT : The database event publication feature allows applications to subscribe to database events just as they subscribe to messages from other applications.
DML events (DELETE, INSERT, UPDATE)
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.