Oracle 1Z0-082 問題集

質問 1：
In one of your databases, the user HR has the password HRMGR. You want to connect to a database instance whose listener listens on port 1531 by using this statement:
CONNECT HR/HRMGR@orcl
No name server is used.
Which statement is true about ORCL?
A. It must resolve to a valid connect descriptor in the client's tnsnames.ora file
B. It must resolve to a valid connect descriptor in the server's tnsnames.ora file
C. It must be the value of the SERVICE_NAMES parameter on the client side
D. It must be the name of the server running the database to whose instance HR wishes to connect
E. It must be the name of the database to whose instance HR wishes to connect
正解：D

質問 2：
Which two are true about complete and incomplete recovery? (Choose two.)
A. Only incremental backups can be used to roll forward the database while performing complete recovery.
B. The database must have FLASHBACK enabled in order to perform incomplete recovery.
C. Uncommitted transactions will be rolled back after complete recovery completes.
D. Incomplete recovery is possible only when the database is open.
E. Uncommitted transactions will be rolled back after incomplete recovery completes.
正解：A,C

質問 3：
Examine the description of the SALES1 table:

SALES2 is a table with the same description as SALES1.
Some sales data is duplicated in both tables.
You want to display the rows from the SALES1 table which are not present in the SALES2 table.
Which set operator generates the required output?
A. INTERSECT
B. UNION ALL
C. SUBTRACT
D. UNION
E. MINUS
正解：E

質問 4：
Which two statements are true about substitution variables?
A. A substitution variable prefixed with & always prompts only once for a value in a session.
B. A substitution variable can be used only in a select statement.
C. A substitution variable can be used with any clause in a select statement.
D. A substitution variable prefixed with to prompts only once for a value in a session unless it is set to undefined in the session
E. A substitution variable used to prompt for a column name must be enclosed in single quotation marks.
F. A substitution variable used to prompt for a column name must be enclosed in double quotation marks.
正解：D

質問 5：
Your database instance was shut down normally and then started in NOMOUNT state. You then execute this command:
ALTER DATABASE MOUNT;
Which two actions are performed? (Choose two.)
A. The online data files are opened
B. The Oracle background processes are started
C. The initialization parameter file is read
D. The control file is read
E. The alert log records the execution details
F. The online redo logs are opened
正解：B,D

質問 6：
Examine the description of the PROMOTIONS table:

You want to display the unique promotion costs in each promotion category.
Which two queries can be used? (Choose two.)
A. SELECT promo_category, DISTINCT promo_cost FROM promotions ORDER BY 2;
B. SELECT DISTINCT promo_cost || ' in ` || DISTINCT promo_category FROM promotions ORDER BY 1;
C. SELECT DISTINCT promo_category || ` has ` || promo_cost AS COSTS FROM promotions ORDER BY 1;
D. SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;
E. SELECT promo_cost, promo_category FROM promotions ORDER BY by 1;
正解：A,D