Proper study guides for Renovate Oracle Oracle Database 11g: New Features for Administrators certified begins with Oracle 1z0-050 preparation products which designed to deliver the Real 1z0-050 questions by making you pass the 1z0-050 test at your first time. Try the free 1z0-050 demo right now.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for Oracle 1z0-050 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Q21. Which client requests to the database can be captured as a part of the workload capture? (Choose all that apply.)
A. flashback query
B. distributed transactions
C. logging in and logging out of sessions
D. all DDL statements having bind variables
E. direct path load of data from external files
Q22. Which tasks can be accomplished using the DBMS_LOB.SETOPTIONS procedure?
A. only encryption and compression settings for all SecureFile LOBs
B. only encryption and deduplication settings for only SecureFile CLOBs
C. deduplication, encryption, and compression settings for all SecureFile LOBs
D. deduplication, encryption, and compression settings only for SecureFile CLOBs
Q23. An index called ORD_CUSTNAME_IX has been created on the CUSTNAME column in the ORDERS table using the following command:
SQL>CREATE INDEX ord_custname_ix ON orders(custname); The ORDERS table is frequently queried using the CUSTNAME column in the WHERE clause. You want to check the impact on the performance of the queries if the index is not available. You do not want the index to be dropped or rebuilt to perform this test.
Which is the most efficient method of performing this task?
A. disabling the index
B. making the index invisible
C. making the index unusable
D. using the MONITORING USAGE clause for the index
Q24. Which three statements are true regarding persistent lightweight jobs? (Choose three.)
A. The user cannot set privileges on persistent lightweight jobs.
B. The use of a template is mandatory to create persistent lightweight jobs.
C. Persistent lightweight jobs modify several tables in the data dictionary to generate a lot of redo.
D. Persistent lightweight jobs are useful when users need to create a large number of jobs in a short time.
E. Persistent lightweight jobs are useful when users need to create a small number of jobs that run infrequently.
Q25. 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.
Q26. View the Exhibit to examine the output for the V$DIAG_INFO view.
Which statements are true regarding the location of diagnostic traces? (Choose all that apply.)
A. The path to the location of the background as well as the foreground process trace files is /u01/oracle/diag/rdbms/orclbi/orclbi/trace.
B. The location of the text alert log file is /u01/oracle/diag/rdbms/orclbi/orclbi/alert.
C. The location of the trace file for the current session is /u01/oracle/diag/rdbms/orclbi/orclbi/trace.
D. The location of the XML-formatted version of the alert log is /u01/oracle/diag/rdbms/orclbi/orclbi/alert.
Q27. You plan to have a larger moving window size for the default system-defined moving window baseline because you want to use the adaptive threshold.
Which statement factors in this consideration while increasing the size of the moving window?
A. The collection level for the AWR should be set to BASIC.
B. The moving window size must be less than Undo Retention.
C. The moving window size should be greater than the Automatic Workload Repository (AWR) retention period.
D. The moving window size should be equal to or less than the Automatic Workload Repository (AWR) retention period.
Q28. 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.
Q29. The Database Resource Manager is automatically enabled in the maintenance window that runs the Automated Maintenance Task.
What is the reason for this?
A. to prevent the creation of an excessive number of scheduler job classes
B. to allow the Automated Maintenance Tasks to use system resources without any restriction
C. to allow resource sharing only among the Automated Maintenance Tasks in the maintenance window
D. to prevent the Automated Maintenance Tasks from consuming excessive amounts of system resources
Q30. You want to take the backup of the USERS tablespace. It has a single data file of 900 MB.. You have tape drives of 300 MB each. The SBT channel is configured for the RMAN. To accomplish the backup, you issued the following RMAN command:
RMAN> BACKUP SECTION SIZE 300M TABLESPACE users;
Which two statements are true regarding the execution of the above command? (Choose two.)
A. The backup piece size will be limited to 300 MB.
B. The operation is accomplished using the default channel available.
C. The RMAN parallelizes the backup although the parallelism is not set for a channel.
D. Three channels for the tape drive must be configured by setting the parallelism to three.