With New Update Passleader Real 1Z0-053 Test Questions To Pass Exam Easily (31-40)

QUESTION 31
Exhibit: View the Exhibit to examine the parameter values. You are planning to set the value for the MEMORY_TARGET parameter of your database instance. What value would you assign?
311

A.    1440 MB
B.    90 MB
C.    362 MB
D.    272 MB

Answer: C

QUESTION 32
You are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, a big file tablespace of size 100 TB on tape drive, but you have tapedrives of only 10 GB each. Which method would accomplish the task quickly and efficiently?

A.    parallel image copy backup
B.    backup with MAXPIECESIZE configured for the channel
C.    parallel backup with MAXPIECESIZE configured for the channe
D.    intrafile parallel backup

Answer: D

QUESTION 33
You issue the following command in your database:
CREATE RESTORE POINT rec_load
GUARANTEE FLASHBACK DATABASE;
Which two statements are true regarding the REC_LOAD guaranteed restore point? (Choose two.)

A.    It cannot be used in RECOVER DATABASE operations.
B.    It can work only if logging for Flashback Database is enabled.
C.    It creates logs in the flash recovery area that would not be deleted even if there is space pressure.
D.    It can be used to reverse the effects of NOLOGGING operations like in the case of direct load inserts.

Answer: CD

QUESTION 34
One of the tablespaces is read-only in your database. The loss of all control files forced you to re-create the control file.
Which operation do you need to perform after re-creating the control file and opening the database?

A.    drop and re-create the read-only tablespaces
B.    rename the read-only data files to their correct file names
C.    change the tablespace status from read/write to read-only
D.    re-create the read-only tablespace because it is automatically removed

Answer: B

QUESTION 35
The ADMIN_EMP table has columns EMPNO, ENAME, DEPTNO, and SAL. It has a materialized view EMP_MV with a materialized log and an ENAME_IDX index on the ENAME column. You need to perform an online table redefinition on the ADMIN_EMP table to move it from the TBS1 tablespace to the TBS2 tablespace in the same schema. What action is required for the dependent objects when you perform online redefinition on the table?

A.    The materialized view should have a complete refresh performed after the online table redefinition is completed.
B.    The materialized view should have a fast refresh performed after the online table redefinition is completed.
C.    The materialized view, materialized log, and the index should be dropped and re-created after the online table redefinition is complete.
D.    The materialized view and materialized log should be dropped and all constraints disabled and re-created after the online table redefinition is complete.

Answer: A

QUESTION 36
You issued the following command to mount the DATA disk group in restricted mode:
ALTER DISKGROUP data MOUNT RESTRICT;
What is the implication of this command?

A.    The client RDBMS instance can access the file as a read-only file.
B.    A new disk cannot be added to a disk group.
C.    A disk in a disk group can be taken offline.
D.    The client RDBMS instance cannot access the files in the disk group.

Answer: D

QUESTION 37
Your company wants to upgrade the current production database to the RAC environment. To perform testing before migrating to the RAC environment, you performed the workload capture on the production database to record the peak workload. You set up the test RAC database and want to replay the recorded workload on the testmachine. Note the following steps that you may require to replay the database workload:
1) Preprocess the captured workload.
2) Restart the database in RESTRICTED mode.
3) Set up the Replay Clients.
4) Restore the test database to the point when the capture started.
5) Remap connections.
Arrange the steps required in the correct sequence to accomplish this task on the test machine.

A.    1, 4, 5, 3 (2 is not required.)
B.    1, 4, 3, 5 (2 is not required.)
C.    1, 2, 4, 5 (3 is not required.)
D.    2, 1, 5, 3, 4
E.    1, 2, 4, 5, 3

Answer: A

QUESTION 38
You are working on the APPDB database as a DB A. The database has a default Flashback Data Archive DFLA1 created on it. You issued the following command to drop the Flashback Archive FLA1:
DROP FLASHBACK ARCHIVE fla1;
What is the effect of this command?

A.    The Flashback Archive FLA1 is dropped only if it is empty.
B.    The tablespace having Flashback Archive is dropped.
C.    The Flashback Archive FLA1 is dropped after moving the existing data in it to the default Flashback Archive.
D.    The Flashback Data Archive and historical data are dropped.

Answer: D

QUESTION 39
Which two prerequisites are needed for performing workload capture and replay? (Choose two.)

A.    Close all sessions performing queries using database links.
B.    running the database in shared server mode
C.    The database on which the workload is replayed has to be a restore of the original database to a specific SCN.
D.    setting up the directory to capture the workload

Answer: CD

QUESTION 40
Which two statements are true regarding Health Monitor checks in Oracle Database 11g? (Choose two.)

A.    Health Monitor checks can be used to scan the contents of the redo log and archive logs for accessibility and corruption.
B.    Health Monitor checks can be used to verify the integrity of database files and report failures if these files are inaccessible, corrupt or inconsistent.
C.    Health Monitor checks can be used to verify the contents of dictionary entries for each dictionary object and fix it automatically.
D.    Health Monitor checks are always initiated manually when there is some critical error.

Answer: AB

With New Update Passleader Real 1Z0-053 Test Questions To Pass Exam Easily