1Z0-053 | The Secret of Oracle 1Z0-053 exam dumps
Q141. Which two initialization parameters would you set to enable Automatic Shared Memory Management? (Choose two.)
A. set SHARED_POOL_SIZE to zero
B. set STATISTICS_LEVEL to BASIC
C. set SGA_TARGET to a non-zero value
D. set DB_CACHE_SIZE to a non-zero value
E. set STATISTICS_LEVEL to TYPICAL or ALL
Answer: AC
Q142. Which statements are true regarding table compression? (Choose all that apply.)
A. It saves disk space and reduces memory usage.
B. It saves disk space but has no effect on memory usage.
C. It incurs extra CPU overhead during DML as well as direct loading operations.
D. It incurs extra CPU overhead during DML but not direct loading operations.
E. It requires uncompress operation during I/O.
Answer: AC
Q143. Note the following statements that use flashback technology:
1. FLASHBACK TABLE <table> TO SCN <scn>;
2. SELECT * FROM <table> AS OF SCN 123456;
3. FLASHBACK TABLE <table> TO BEFORE DROP;
4. FLASHBACK DATABASE TO TIMESTAMP <timestamp>;
5. SELECT * FROM <table> VERSIONS AS OF SCN 123456 AND 123999;
Which of these statements will be dependent on the availability of relevant undo data in the undo segment?
A. 1, 2, and 5
B. 1, 3, and 4
C. 2, 3, 4, and 5
D. 1, 2, 3, 4, and 5
Answer: A
Q144. View the Exhibit to examine the error obtained during the I/O calibration process.
There are no data files on raw devices. What is the reason for this error?
A. The DISK_ASYNCH_IO parameter is set to TRUE.
B. The FILESYSTEMIO_OPTIONS parameter is set to NONE.
C. Another session runs the I/O calibration process concurrently.
D. The pending area has not been created before running the I/O calibration process.
Answer: B
Q145. 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
Q146. Which two changes and their effect on the system can be tested by using the Database Replay feature? (Choose two.)
A. multiplexing of the control file
B. adding the redo log member to the database
C. database and operating system upgrades
D. changing the database storage to ASM-managed storage
Answer: CD
Q147. Why would you execute the report obsolete command?
A. To list all backups that were no longer available for restore operations
B. To list all backups that had aged beyond the RMAN retention criteria
C. To list all backup set pieces listed in control-file or recovery-catalog metadata that are not on the backup media
D. To list all datafiles that are no longer part of the database and thus do not need to be backed up
E. To list all archived redo logs that are no longer needed for any database recovery
Answer: B
Q148. You issue the following command:
RMAN>CONFIGURE BACKUP OPTIMIZATION ON;
What is the result of this command on your backups?
A. An incremental backup strategy will be used automatically.
B. Read-only datafiles will not be backed up as long as backups of those files already exist and those backups meet established retention criteria.
C. RMAN will configure itself for maximum performance at the cost of CPU.
D. RMAN will configure itself for minimal OS/CPU impact at the cost of time to back up the database.
E. RMAN will automatically compress backups.
Answer: B
Q149. Which of the following statements is true regarding the VERSIONS BETWEEN clause?
A. The VERSIONS BETWEEN clause may be used in DML statements.
B. The VERSIONS BETWEEN clause may be used in DDL statements.
C. The VERSIONS BETWEEN clause may not be used to query past DDL changes to tables.
D. The VERSIONS BETWEEN clause may not be used to query past DML statements to tables.
Answer: C
Q150. You have lost all your SYSTEM tablespace datafiles (system_01.dbf and system_02.dbf) nd the database has crashed. What would be the appropriate order of operations to correct the situation?
a. Mount the database with the startup mount command.
b. Take the SYSTEM datafile offline with the alter database command.
C. Restore the SYSTEM_01.dbf datafile from backup media with the required archived redo logs.
D. Restore all SYSTEM tablespace ~elated datafiles from backup media.
e. Issue the recover tablespace SYSTEM command.
f. Issue the recover datafile SYSTEM_01.dbf command.
g. Open the database with the alter database open command.
h. Open the database with the alter database open resetlogs command.
A. a, c, f, g
B. b, d, e, h
C. a, b, c, f, g
D. d, a, e, g
E. b, c, f, e, g
Answer: D