Exam Code: 1Z0-053 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: Oracle Database 11g: Administration II
Certification Provider: Oracle
Free Today! Guaranteed Training- Pass 1Z0-053 Exam.

2016 Jun 1Z0-053 Study Guide Questions:

Q181. Globalization support is implemented through the text- and character-processing functions provided by which Oracle feature?

A. RSTLNE

B. NLSRTL

C. LISTENER

D. NLSSORT

E. Linguistic sorts

Answer: B


Q182. Examine the output of the query that you executed to list the objects in the recycle bin:


You verified that no table named SALES_TAB exists in the schema. Then you executed the following command to purge the objects in the recycle bin:

SQL> PURGE TABLE sales_tab;

What would be the outcome of this command?

A. All three tables in the recycle bin are purged

B. Only the table with the oldest DROPSCN is purged

C. The command returns an error because multiple entries with the same name exist in the recycle bin

D. Only the table with the latest DROPSCN is purged

Answer: B


Q183. 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


2passeasy.com

Most recent 1z0-053 itpub:

Q184. When performing a database duplication, which duplicate database parameter would you set to ensure that the online redo logs are created in the correct location?

A. log_file_name_convert

B. convert_log_file_name

C. file_name_convert_log

D. redo_log_file_name_convert

E. logfile_convert_directory

Answer: A


Q185. You enable block change tracking. You issue the following command:

BACKUP INCREMENTAL LEVEL 0 DATABASE;

The next day, you issue the following command:

BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;

Which statement about the use of the change tracking file is true?

A. RMAN reads the block change tracking file only when it performs the incremental level 0 backup.

B. RMAN reads the block change tracking file when it performs both incremental backups.

C. RMAN reads the block change tracking file only when it performs the incremental level 1 backup.

D. RMAN does not read the block change tracking file when it performs either incremental backup.

Answer: C


Q186. When performing a full database disaster recovery with RMAN, in what order would you execute these steps?

a. Restore the control file from autobackups.

b. Run the RMAN restore and recover command.

c. Restore the database spfile from autobackups.

d. Make the RMAN backup set pieces available.

e. Open the database with the alter database open resetlogs command.

f. Open the database with the alter database open command.

A. a, b, c, d, e, f

B. c, d, a, b, f

C. d, c, a, b, f

D. d, b, d, c, e

E. d, c, a, b, e

Answer: E


2passeasy.com

Breathing 1z0-053 pdf:

Q187. Which of the following most closely represents an image copy?

A. Unix cp command of a file

B. Bit-by-bit copy of a file

C. Windows COPY command of a file

D. All of the above

Answer: D


Q188. Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist? (Choose two.)

A. failures because a data file is renamed by error

B. failures when no standby database is configured

C. failures that require no archive logs to be applied for recovery

D. failures due to loss of connectivity-for example, an unplugged disk cable

Answer: AD


Q189. When creating a SQL tuning set, which of the following steps allows the DBA to reduce the size of the SQL set by selecting specific operators and values?

A. Filter versions

B. Filter loads

C. Filter tasks

D. Filter options

Answer: D


Q190. When setting arguments for a job, which procedure do you use for types that cannot be implicitly converted to and from a VARCHAR2 datatype?

A. SET_JOB_ARGUMENT_VALUE

B. SET_JOB_VALUE_ANYDATA

C. SET_JOB_ANYDATA_VALUE

D. SET_SPECIAL_JOB_VALUE

E. SET_JOB_ANYTYPE_VALUE

Answer: C