Proper study guides for Renewal Oracle Oracle Database 11g: New Features for Administrators certified begins with Oracle 1z0-050 preparation products which designed to deliver the Exact 1z0-050 questions by making you pass the 1z0-050 test at your first time. Try the free 1z0-050 demo right now.
2021 Jun 1z0-050 exam guide
Q21. Which statements are true regarding the Query Result Cache? (Choose all that apply.)
A. It can be set at the system, session, or table level.
B. It is used only across statements in the same session.
C. It can store the results from normal as well as flashback queries.
D. It can store the results of queries based on normal, temporary, and dictionary tables.
Q22. You need to perform an online table redefinition of an existing SALES table to partition it into two tablespaces TBS1 and TBS2.
The SALES table has a materialized view, materialized log, indexes, referential integrity constraint, and triggers with the PRECEDES clause existing on it.
What action is required for dependent objects when you perform online table redefinition?
A. The materialized log should be dropped before the online table redefinition process.
B. Triggers with the PRECEDES clause should be disabled before the online table redefinition process.
C. Referential integrity constraints must be manually enabled after the online table redefinition process.
D. The dependent materialized view should have a complete refresh performed after the online table redefinition process.
Q23. You are managing an Oracle Database 11g ASM instance with a disk group dg01 having three disks. One of the disks in the disk group becomes unavailable because of power failure. You issued the following command to change the DISK_REPAIR_TIME attribute from 3.6 hours to 5 hours:
ALTER DISKGROUP dg01 SET ATTRIBUTE 'disk_repair_time' = '5h'
To which disks in the disk group will the new value be applicable?
A. all disks in the disk group
B. all disks that are currently in OFFLINE mode
C. all disks that are not currently in OFFLINE mode
D. all disks in the disk group only if all of them are ONLINE
Q24. 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
Q25. Which statements are true regarding table compression? (Choose all that apply.)
A. It requires uncompress operation during I/O.
B. It saves disk space and reduces memory usage.
C. It saves disk space but has no effect on memory usage.
D. It incurs extra CPU overhead during DML but not direct loading operations.
E. It incurs extra CPU overhead during DML as well as direct loading operations.
Rebirth 1z0-050 dumps:
Q26. Which two database operations can be performed at the MOUNT stage of database startup? (Choose two.)
A. renaming of control files
B. multiplexing of control files
C. dropping the database user
D. configuring the database in ARCHIVELOG mode
E. renaming of data files
Q27. View the Exhibit to observe the error.
You receive this error regularly and have to shut down the database instance to overcome the error.
What can the solution be to reduce the chance of this error in future, when implemented?
A. locking the SGA in memory
B. automatic memory management
C. increasing the value of SGA_MAX_SIZE
D. setting the PRE_PAGE_SGA parameter to TRUE
Q28. In which two cases would you perform only consistent backup? (Choose two.)
A. You are working on a database where downtime is not tolerated.
B. You are working on a database where downtime can be tolerated.
C. You are working on a database that operates in ARCHIVELOG mode.
D. You are working on a database that operates in NOARCHIVELOG mode.
E. You are working on a database where all the tablespaces are locally managed.
F. You are working on a database where control files and redo log files are multiplexed.
G. You are working on a database where control files and redo log files are not multiplexed.
Q29. 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.
Q30. Which three are the valid statements in relation to SQL plan baselines? (Choose three.)
A. The plans can be manually loaded to the SQL plan baseline.
B. The plans in the SQL plan baseline are verified and accepted plans.
C. The plans generated for every SQL statement are stored in the SQL plan baseline by default.
D. The plan baselines are stored temporarily in the memory as long as the database instance is running.
E. For the SQL plan baselines to be accessible to the optimizer, the SYSAUX tablespace must be online.