Cause all that matters here is passing the Oracle 1Z0-053 exam. Cause all that you need is a high score of 1Z0-053 Oracle Database 11g: Administration II exam. The only one thing you need to do is downloading Actualtests 1Z0-053 exam study guides now. We will not let you down with our money-back guarantee.

2016 Dec 1z0-053 test questions:

Q391. What view might you use to try to determine how long a particular backup will take?

A. V$SESSION_EVENT

B. V$SESSION

C. V$WAITS

D. V$WAITSTAT

E. V$SESSION_LONGOPS

Answer: E


Q392. Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains one redo member. When you attempt to start the database, you receive the following errors:

ORA-00313: open failed for members of log group 1 of thread 1

ORA-00312: online log 1 thread 1: 'D:\REDO01.LOG'

You discover that the online redo log file of the current redo group is corrupted.

Which statement should you use to resolve this issue?

A. ALTER DATABASE DROP LOGFILE GROUP 1;

B. ALTER DATABASE CLEAR LOGFILE GROUP 1;

C. ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;

D. ALTER DATABASE DROP LOGFILE MEMBER 'D:\REDO01.LOG'

Answer: C


Q393. In Oracle 11g, by default which one of the following conditions implicitly enables Automatic PGA Memory Management?

A. Setting a nonzero value for SGA_TARGET

B. Configuring Automatic Shared Memory Management

C. Configuring Automatic Memory Management

D. Setting a nonzero value for SGA_MAX_SIZE and PGA_AGGREGATE_TARGET

E. None of the above

Answer: B


Q394. The DB_BLOCK_CHECKING initialization parameter is set to OFF.

Which block checking would be performed?

A. The Oracle database will perform block checking for the index blocks only

B. The Oracle database will not perform block checking for any of the data blocks

C. The Oracle database will perform block checking for the default permanent tablespace only

D. The Oracle database will perform block checking for the data blocks in all user tablespaces

E. The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only

Answer: E


Q395. You want the Automatic SQL Tuning process to stop accepting and implementing the recommended SQL profiles automatically. Which action would you perform to achieve this?

A. Edit the automatic maintenance window group configuration.

B. Set the CURSOR_SHARING parameter to EXACT for the database instance.

C. Use the DBMS_SQLTUNE.SET_TUNING_TASK_PARAMETERS procedure to set ACCEPT_SQL_PROFILES to FALSE.

D. Set the SQLTUNE_CATEGORY parameter to DEFAULT for the database instance.

Answer: C


Most up-to-date 1z0-053 practice test:

Q396. Examine the following RMAN command:

BACKUP DATABASE

TAG TESTDB

KEEP UNTIL 'SYSDATE+1'

RESTORE POINT TESTDB06;

Which two statements are true regarding the backup taken by using the above RMAN command? (Choose two.)

A. Only data files and the control file are backed up.

B. Archived redo logs are backed up only if the database is open during the backup.

C. The backup is deleted after one day, regardless of the default retention policy settings.

D. The backup becomes obsolete after one day, regardless of the default retention policy settings.

Answer: BD


Q397. A user sends you an email with the following error message:

create table idtable(id number)

*

ERROR at line 1:

ORA-01116: error in opening database file 4

ORA-01110: data file 4: `/oracle01/oradata/orcl/users01.dbf'

ORA-27041: unable to open file

Linux Error: 2: No such file or directory

Additional information: 3

You can choose from the following steps:

a. Restore the missing database datafiles.

b. Take the missing datafile offline.

c. Shut down the database.

d. Issue the recover tablespace USERS command.

e. Issue the Startup Mount command to mount the database.

f. Bring the USERS tablespace online.

g. Issue the alter database open command.

Which is the correct order of these steps in this case?

A. b, a, d, f

B. c, a, e, b, d, f, g

C. c, e, d, g

D. b, d, f

E. e, d, g

Answer: A


Q398. You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace:

ALTER TABLE employees SHRINK SPACE CASCADE;

Which statement is correct in this scenario?

A. The EMPLOYEES table will be changed to read-only mode during the shrink operation.

B. The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over.

C. The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation.

D. Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation.

Answer: C


Q399. The SQL Tuning Advisor has been configured with default configurations in your database instance. Which recommendation is automatically implemented without the DBA's intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework?

A. statistics recommendations

B. SQL profile recommendations

C. index-related recommendations

D. restructuring of SQL recommendations

Answer: B


Q400. What is an obsolete backup set?

A. A backup set that is missing one or more backup set pieces

B. A backup that has exceeded the retention criteria and is no longer needed

C. A backup set that does not include archived redo logs

D. A backup set that can not be recovered due to corruption

E. A backup set superceded by a datafile copy

Answer: B