1Z0-053 | 10 Tips For Renew 1Z0-053 exam question
Q151. True or false: tablespace point-in-time recovery is possible only with RMAN.
A. True
B. False
Answer: B
Q152. What elements of globalization can be explicitly defined using the NLS_LANG environment variable? (Choose all that apply.)
A. NLS_LANGUAGE
B. NLS_SORT
C. NLS_CALENDAR
D. NLS_CHARACTERSET
E. NLS_TERRITORY
Answer: ADE
Q153. Which tuning tool recommends how to optimize materialized views so that these views can take advantage of the general query rewrite feature?
A. Segment Advisor
B. SQL Access Advisor
C. Undo Advisor
D. SQL Tuning Advisor
Answer: B
Q154. Which command would you use to determine what database backups are currently available for restore?
A. list database backup;
B. report database backup;
C. list backup of database;
D. list summary backup;
E. report backup of database;
Answer: C
Q155. Which of the following NLS_SORT parameter values would result in case-insensitive and accent- insensitive binary sorts?
A. NLS_SORT = BINARY
B. NLS_SORT = BINARY_AI
C. NLS_SORT = BINARY_CI
D. NLS_SORT = BINARY_AI_CI
E. Binary sorts are case insensitive and accent insensitive by default.
Answer: B
Q156. Evaluate the following command:
SQL> CREATE TABLE design_data (id NUMBER,
doc CLOB)
LOB(doc) STORE AS SECUREFILE(DEDUPLICATE);
Which statement is true regarding the above command?
A. The LOB values are automatically compressed.
B. The LOB values are cached by default in the buffer cache.
C. The LOB values are automatically stored in encrypted mode.
D. All LOB data that is identical in two or more rows in a LOB column share the same data blocks.
Answer: D
Q157. To enable resumable space allocation for the instance, which of the following initialization parameters should you set to a nonzero value?
A. RESUMABLE_SPACE_TIME
B. RESUMABLE_SPACE
C. RESUMABLE_TIME
D. RESUMABLE_TIMEOUT
E. TIME_RESUMABLE
Answer: D
Q158. Consider the following code snippet:
BEGIN
DBMS_SCHEDULER.SET_ATTRIBUTE (
name => `lne_job1',
attribute => `job_priority',
value => 1);
END;
/
If this code were executed, which of the following statements would be true?
A. The priority of the lne_job1 job would be set to 1.
B. The lne_job1 job would be executed synchronously.
C. The lne_job1 job would run immediately in the user's current session.
D. The lne_job1 job would retain its current priority.
E. The job will immediately take priority over all running jobs.
Answer: A
Q159. In what order would you execute the following steps to create a recovery catalog?
a. Issue the create catalog command.
b. Create the recovery-catalog database.
c. Create the recovery-catalog user.
d. Grant the recovery_catalog_owner privilege to the recovery-catalog user.
e. Issue the register database command from the target database.
A. a, b, c, d, e
B. b, a, d, c, e
C. b, c, d, a, e
D. b, c, d, e, a
E. b, d, c, a, e
Answer: C
Q160. You decided to use Direct NFS configuration in a non-RAC Oracle installation and created the oranfstab file in /etc. Which two statements are true regarding this oranfstab file? (Choose two.)
A. Its entries are specific to a single database.
B. It contains file systems that have been mounted by Direct NFS.
C. It is globally available to all Oracle 11g databases on the machine.
D. It contains file systems that have been mounted by the kernel NFS system.
Answer: CD