QUESTION 91
The DB_BLOCK_CHECKING initialization parameter is set to TRUE. What would be the result of this setting on the data blocks being written to the datafiles, every time the DBWn writes?

A.    The Oracle database will check all data blocks by going through the data on each block, making sure the data is self-consistent.
B.    The DBWn and the direct loader will calculate a checksum and store it in the cache header of every data block when writing it to disk.
C.    The Oracle database will check data blocks belonging to the SYSTEM tablespace only, by going through the data on each block, making sure the data is self-consistent.
D.    The Oracle database will check data blocks belonging to the SYSAUX tablespace only, by going through the data on each block, making sure the data is self-consistent.
E.    The Oracle database will check data blocks in the SYSTEM and SYSAUX tablespaces only, by going through the data on each block, making sure the data is self-consistent.

Answer: A

QUESTION 92
In your production database you want to use an Automatic Storage Management (ASM) instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance?

A.    Oracle Migration Assistant
B.    Recovery Manager (RMAN)
C.    Oracle Data Pump Export and Import
D.    Conventional Oracle Export and Import
E.    Operating system utilities to copy the files to the ASM instance

Answer: B

QUESTION 93
In the parameter file of your production database, the CONTROL_FILE_RECORD_KEEP_TIME parameter is set to 31. What would be the impact of this setting on the backup that is being performed by using Recovery Manager (RMAN)?

A.    The backup would be retained on the media for 31 days.
B.    The backup would be maintained in the recovery catalog for 31 days.
C.    The backup metadata would be retained in the control file for 31 days.
D.    The backup metadata would be maintained in the recovery catalog for 31 days.
E.    Automatic backups of the control file will be retained in the flash recovery area for 31 days.

Answer: C

QUESTION 94
You decided to change the location of the flash recovery area. You executed the following command:
ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’+disk1′ SCOPE=BOTH SID’=*’;
Which statement is true?

A.    The location can be changed only if the flash recovery area is empty.
B.    After executing the command, all new flash recovery area files will be created in the new location.
C.    The command will generate an error because you cannot change the flash recovery area while the database is open.
D.    All the existing files in the flash recovery area will be moved to the new location and all new Flash Recovery Area files will be created in the new location.

Answer: B

QUESTION 95
View the Exhibit. A user has inserted wrong department data in the DEPT3 table in the USERS tablespace. You use the Flashback Table functionality to rectify the erroneous inserts. While performing the recovery, you choose 2004343 as the Flashback SCN. Which two statements are correct in this scenario? (Choose two.)
Exhibit:

A.    Only the row with DEPARTMENT_ID 290 would be flashed back.
B.    The rows with DEPARTMENT_ID 290 and 300 would be flashed back.
C.    The rows with DEPARTMENT_ID 290 and 280 would be flashed back.
D.    You would have taken the USERS tablespace offline before starting the Flashback Table operation.
E.    You would have enabled row movement for the DEPT3 table before starting the Flashback Table operation.

Answer: BE

QUESTION 96
Using Oracle Scheduler you have scheduled two jobs, JOB_A and JOB_B, to run at 9:00

A.    m.every Friday. You want both the jobs to use a single resource plan, WEEKEND_PLAN. Which task must have already been performed to enable you to achieve this objective?
B.    A window must have been created with the WEEKEND_PLAN resource plan.
C.    A program must have been created with the WEEKEND_PLAN resource plan.
D.    A job class must have been created with the WEEKEND_PLAN resource plan.
E.    A window group must have been created with the WEEKEND_PLAN resource plan.

Answer: C

QUESTION 97
Your database is running on the automatic Program Global Area (PGA) memory management and Shared Memory Management mode. You want to increase the memory available for the SQL work areas. What would you do?

A.    modify the HASH_AREA_SIZE initialization parameter
B.    modify the PGA_AGGREGATE_TARGET initialization parameter
C.    modify the WORK_AREASIZE_POLICY initialization parameter
D.    increase the value of the SGA_TARGET initialization parameter
E.    increase the value of the SGA_MAX_SIZE initialization parameter
F.    increase the value of the SORT_AREA_SIZE initialization parameter

Answer: B

QUESTION 98
On Tuesday, a junior DBA dropped an important application user account, whose schema has important tables. You are asked to recover all the objects in the schema. On investigation, you find that the user account was dropped at 11:00 a.m.and Sunday’s backup is the most recent backup. Which flashback feature would you use?

A.    Flashback Drop
B.    Flashback Table
C.    Flashback Database
D.    Flashback Version Query
E.    Flashback Transaction Query

Answer: C

QUESTION 99
View the Exhibit and examine the Flashback Database architecture. Identify the missing component shown with a "?"= in the Flashback Database architecture.
Exhibit:

A.    DBWn
B.    RVWR
C.    ARCH
D.    RECO
E.    TRWR

Answer: B

QUESTION 100
Case 1:
1.Shut down the database and perform a backup.
2.Restore all the data files.
3.Mount the database.
4.Recover the database.
5.Without applying all the redo log files, open the database using the RESETLOGS option.
6.Back up the database.
Case 2:
1.Shut down the database and perform a backup.
2.Restore only the data files of the tablespace where user error damaged the data.
3.Mount the database.
4.Recover the database.
5.Open the database with the RESETLOGS option.
6.Back up the database.
Case 3:
1.Shut down the database.
2.Restore the data files.
3.Open the database.
4.Perform recovery to the current point in time.
Which case has the correct steps for an incomplete recovery?

A.    Only case 1
B.    Only case 2
C.    Only case 3
D.    Case 1 and 2
E.    Case 2 and 3
F.    Case 1 and 3
G.    All cases, case 1, case 2, case 3

Answer: A

Get Passleader New Update Oracle 1Z0-043 Test Questions With Low Cost