Want to know Ucertify 1z0-050 Exam practice test features? Want to lear more about Oracle Oracle Database 11g: New Features for Administrators certification experience? Study High value Oracle 1z0-050 answers to Replace 1z0-050 questions at Ucertify. Gat a success with an absolute guarantee to pass Oracle 1z0-050 (Oracle Database 11g: New Features for Administrators) test on your first attempt.
2021 Sep 1z0-050 exam topics
Q71. You performed the RMAN database backup with the KEEP option.
Which two statements are true regarding this backup? (Choose two.)
A. The KEEP option overrides the configured retention policy.
B. The KEEP option is an attribute of an individual backup piece.
C. The backup contains only data files and archived redo log files.
D. The backup contains data files, the server parameter file, and the control file even if the control file autobackup is disabled.
Q72. You have applications that have frequently executed queries, and produce small and static result sets.
You configure the sqlnet.ora file in the client machine to set a nonzero value for the OCI_RESULT_CACHE_MAX_SIZE parameter.
What is the purpose of this configuration?
A. to avoid round trips to the server by enabling caching of query results in client memory
B. to improve performance by storing a copy of the data from the private SQL area of the PGA
C. to enhance the query performance by creating a cache in the client memory for sorting operations
D. to avoid the storing of query plans and results in the server by creating a cache in the client memory
Q73. You performed the RMAN database backup having a backupset key number 231 with the KEEP FOREVER option. After some days, you want to change the status of the database backup and you issued the following command:
RMAN>CHANGE BACKUPSET 231 NOKEEP;
What is the implication of this command?
A. The backup is deleted.
B. The backup is marked unavailable.
C. The backup overrides the backup retention policy.
D. the backup becomes eligible for deletion according to the existing retention policy
Q74. Which statement describes the effect of table redefinition on the triggers attached to the table?
A. All triggers on the table remain valid.
B. All triggers on the table are invalidated and are automatically revalidated with the next DML execution on the table.
C. All triggers on the table are invalidated and must be manually recompiled before the next DML execution on the table.
D. Only triggers that are affected by the changes to the structure of the table are invalidated and automatically revalidated with the next DML execution on the table.
Q75. In which cases is reference partitioning effective in enhancing performance?
A. It is effective only in partition pruning.
B. It is effective only in partitionwise joins provided that the query predicates are different from the partitioning key.
C. It is effective in both partition pruning as well as partitionwise joins provided that the query predicates are identical to the partitioning key.
D. It is effective in both partition pruning as well as partitionwise joins irrespective of whether the query predicates are different from or identical to the partitioning key.
Up to the immediate present 1z0-050 exam answers:
Q76. Which two statements are true regarding the functionality of the remap command in ASMCMD? (Choose two.)
A. It repairs blocks that have read disk I/O errors.
B. It checks whether the alias metadata directory and the file directory are linked correctly.
C. It repairs blocks by always reading them from the mirror copy and writing them to the original location.
D. It reads the blocks from a good copy of an ASM mirror and rewrites them to an alternate location on disk if the blocks on the original location cannot be read properly.
Q77. The following databases are registered in the base recovery catalog:
PROD1, PROD2, and PROD3. The database user CATOWNER owns the base recovery catalog. You want a new user VPC1 to have access to only the PROD1 database and create a virtual private catalog.
Given below are some of the commands required to achieve this:
1.SQL> GRANT recovery_catalog_owner TO vpc1;
2.RMAN> CONNECT CATALOG vpc1/password@catdb;
3.RMAN> GRANT CATALOG FOR DATABASE prod1 TO vpc1;
4.RMAN> CONNECT CATALOG catowner/password@catdb;
5.RMAN> CREATE VIRTUAL CATALOG;
What is the correct sequence in which the commands have to be executed?
A. 1, 4, 5, 2, 3
B. 1, 4, 3, 2, 5
C. 4, 5, 2, 3, 1
D. 2, 3, 4, 5, 1
E. 1, 4, 2, 3, 5
Q78. Which statement is true regarding virtual private catalogs?
A. The virtual private catalog owner cannot create and modify the stored scripts.
B. A virtual private catalog owner can create a local stored script, and have read/write access to a global stored script.
C. The set of views and synonyms that make up the virtual private catalog is stored in the schema of the RMAN recovery catalog owner.
D. To perform most of the RMAN operations, the virtual catalog owner must have the SYSDBA or SYSOPER privilege on the target database.
Q79. What is the advantage of setting the ASM-preferred mirror read for the Stretch cluster configuration?
A. It improves resync operations.
B. This feature enables much faster file opens.
C. It improves performance as fewer extent pointers are needed in the shared pool.
D. It improves performance by reading from a copy of an extent closest to the node.
Q80. View the Exhibit exhibit1 to observe the maintenance window property.
Which two statements describe the conclusions? (Choose two.)
A. The window duration should be increased.
B. RESOURCE_PERCENTAGE should be increased.
C. RESOURCE_PERCENTAGE should be decreased.
D. The repeat time for the window should be decreased.