Your success in Oracle 1Z0-053 is our sole target and we develop all our 1Z0-053 braindumps in a way that facilitates the attainment of this target. Not only is our 1Z0-053 study material the best you can find, it is also the most detailed and the most updated. 1Z0-053 Practice Exams for Oracle 1Z0-053 are written to the highest standards of technical accuracy.


♥♥ 2017 NEW RECOMMEND ♥♥

Free VCE & PDF File for Oracle 1Z0-053 Real Exam (Full Version!)

★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions

Free Instant Download NEW 1Z0-053 Exam Dumps (PDF & VCE):
Available on: http://www.surepassexam.com/1Z0-053-exam-dumps.html

Q391. An online tablespace, TEST_TBS, is full and you realize that no server-managed tablespace threshold alerts were generated for the TEST_TBS tablespace. What could be the reason, if the TEST_TBS tablespace does not include autoextensible data files?

A. TEST_TBS is a small file tablespace.

B. TEST_TBS is a bigfile tablespace (BFT).

C. TEST_TBS is the default temporary tablespace.

D. TEST_TBS is a dictionary-managed tablespace.

Answer: D


Q392. Which of the following is not a valid setting for the PROGRAM_TYPE parameter in a program object or the JOB_TYPE parameter in a job object?

A. PLSQL_BLOCK

B. JAVA_STORED_PROCEDURE

C. STORED_PROCEDURE

D. EXECUTABLE

E. None of the above are invalid settings.

Answer: B


Q393. Which pseudocolumn could you use to identify a unique row in a Flashback Versions Query?

A. XID

B. VERSIONS_PK

C. VERSIONS_XID

D. VERSIONS_UNIQUE

Answer: C


Q394. You are managing the APPPROD database as a DBA. You plan to duplicate this database in the same system with the name DUPDB.

You issued the following RMAN commands to create a duplicate database:

RMAN> CONNECT target sys/sys@APPPROD

RMAN> DUPLICATE TARGET DATABASE

TO dupdb

FROM ACTIVE DATABASE

DB_FILE_NAME_CONVERT '/oracle/oradata/prod/',

'/scratch/oracle/oradata/dupdb/'

SPILE

PARAMETER_VALUE_CONVERT '/oracle/oradata/prod/',

'/scratch/oracle/oradata/dupdb/'

SET SGA_MAX_SIZE = '300M'

SET SGA_TARGET = '250M'

SET LOG_FILE_NAME_CONVERT '/oracle/oradata/prod/redo/',

'/scratch/oracle/oradata/dupdb/redo/'

Which three are the prerequisites for the successful execution of the above command? (Choose three.)

A. The source database should be open.

B. The target database should be in ARCHIVELOG mode if it is open.

C. RMAN should be connected to both the instances as SYSDBA.

D. The target database backups should be copied to the source database backup directories.

E. The password file must exist for the source database and have the same SYS user password as the target.

Answer: BCE


Q395. Which DBMS_SCHEDULER procedure(s) can be used to alter an existing job? (Choose all that apply.)

A. SET_ATTRIBUTE_NULL

B. ALTER_JOB

C. ALTER_JOB_PARAMETERS

D. ALTER

E. SET_ATTRIBUTE

Answer: AE


Q396. If you back up a database without connecting to the recovery catalog, which operations will cause the recovery catalog to be updated? (Choose all that apply.)

A. The next time you back up the database when you are also connected to the recovery catalog and the target database

B. The next time you are connected to the target database and the recovery catalog database and issue the resync command

C. The next time you connect RMAN to just the recovery catalog

D. The next time you connect to the recovery catalog and the target database with RMAN

E. Connecting to the recovery catalog and issuing the resync all databases command

Answer: AB


Q397. Which type of backup backs up only data blocks modified since the most recent backup at the same level or lower?

A. Differential incremental backup

B. Different incremental backup

C. Cumulative backup

D. Cumulative incremental backup

Answer: A


Q398. User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash back the transactions? (Choose four.)

A. ALTER DATABASE FLASHBACK ON;

B. GRANT SELECT any transaction TO scott;

C. GRANT EXECUTE ON dbms_flashback TO scott;

D. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

E. ALTER TABLESPACE undots1 RETENTION GUARANTEE;

F. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;

Answer: BCDF


Q399. By setting the value of MEMORY_TARGET to zero and setting the value of SGA_TARGET to a nonzero value, you will enable which of the following memory-management options?

A. Automatic PGA Memory Management

B. Automatic SGA Memory Management

C. Automatic Shared Memory Management

D. Automatic Memory Management

E. Manual SGA Memory Management

F. None of the above

Answer: C


Q400. On the development database rac0, there are six raw devices: /dev/raw/raw1 through /dev/raw/raw6. /dev/raw/raw1 and /dev/raw/raw2 are 8GB each, and the rest are 6GB each. An existing disk group +DATA1, of NORMAL REDUNDANCY, uses /dev/raw/raw1 and /dev/raw/raw2. Which series of the following commands will drop one of the failure groups for +DATA1, create a new disk group +DATA2 using two of the remaining four raw devices, and then cancel the drop operation from +DATA1?

A. ALTER DISKGROUP DATA1 DROP DISK DATA1_0001;CREATE DISKGROUP DATA2 NORMAL

REDUNDANCY FAILGROUP DATA1A DISK `/dev/raw/raw3' FAILGROUP DATA1B DISK `/dev/raw/raw4'ALTER DISKGROUP DATA1 UNDROP DISKS;

B. ALTER DISKGROUP DATA1 DROP DISK DATA1_0001;CREATE DISKGROUP DATA2 HIGH REDUNDANCY FAILGROUP DATA1A DISK '/dev/raw/raw3' FAILGROUP DATA1B DISK '/dev/raw/raw4;'ALTER DISKGROUP DATA1 UNDROP DISKS;

C. ALTER DISKGROUP DATA1 DROP DISK DATA1_0001;CREATE DISKGROUP DATA2 NORMAL

REDUNDANCY FAILGROUP DATA1A DISK '/dev/raw/raw3' FAILGROUP DATA1B DISK 

'/dev/raw/raw4'ALTER DISKGROUP DATA1 UNDROP DATA1_0001;

D. ALTER DISKGROUP DATA1 DROP DISK DATA1_0001 ADD DISK GROUP DATA2 NORMAL REDUNDANCY FAILGROUP DATA1A DISK '/dev/raw/raw3' FAILGROUP DATA1B DISK '/dev/raw/raw4'ALTER DISKGROUP DATA1 UNDROP DISKS;

Answer: A