Automatic Shared Memory Management is disabled for your database instance. You realize that there are cases of SQL statements performing poorly because of repeated parsing activity, resulting in degradation of performance. What would be your next step to improve performance?
A. Run the SQL Access Advisor.
B. Run the memory Advisor for the SGA.
C. Run the memory Advisor for the PGA.
D. Run the memory advisor for the shared pool.
E. Run the memory advisor for the buffer cache.
View the Exhibit and examine the parameters. User A executes the following command to update the TRANS table:
SQL> UPDATE B.trans SET tr_amt=tr_amt+500 WHERE c_code=’C005′;
Before user A issues a COMMIT or ROLLBACK command, user B executes the following command on the TRANS table:
SQL> ALTER TABLE trans MODIFY (tr_type VARCHAR2(3));
What would happen in this scenario?
A. The ALTER TABLE command modifies the column successfully.
B. The DDL operation gets higher priority and transaction for user A is rolled back.
C. The ALETER TABLE command waits indefinitely until user A ends the transaction.
D. The ALTER TABLE command fails after waiting for 60 seconds due to the resource being busy.
Which two files in the database can be configured for automatic backups by using the autobackup feature in Recovery Manager (RMAN)? (Choose two.)
A. Data Files
B. Control Files
C. Parameter Files
D. Online Redo Log Files
E. Server Parameter File
Which two statements are true regarding the usage of the SQL*LOADER utility? (Choose two.)
A. You can load data into multiple tables during the same load session.
B. You can load data from multiple files to a table during the same load session.
C. You cannot perform selective data loading based on the values available in the records.
D. You can use an export file generated by the EXPDP utility as an input data file to load the data.
E. You can load data only if the input file is available on the disk and tape but not a named pipes.
In which situation may the UNDO_RETENTION parameter be ignored, even if it is set to a value?
A. When the data file of the undo tablespace is autoextensible.
B. When there are more than one undo tablespace available in the database.
C. When the undo tablespace is of a fixed size and retention guarantee is not enabled.
D. When the undo tablespace is autoextensible and retention guarantee is not enabled.
Note the following structures in your database server:
2. OS Blocks
5. Oracle Data Block
Which option has the correct arrangement of these structures from the smallest to the largest?
A. 2, 5, 1, 4, 3
B. 1, 2, 3, 4, 5
C. 5, 2, 1, 3, 4
D. 2, 1, 5, 4, 3
You want to access employee details contained in flat files as part of the EMPLOYEE table. You plan to add a new column to the EMPLOYEE table to achieve this. Which data types would you use for the new column?
D. LONG RAW
You are managing an Oracle Database 11g database with the following backup strategy:
1. On Sunday, an incremental level 0 tape backup is performed.
2. Monday through Saturday, a cumulative incremental level 1 tape backup is performed.
Which two statements are true regarding the backups performed? (Choose two.)
A. The backup performed in step 1 backs up all blocks that have ever been in use in the database.
B. The backup performed in step 2 copies all the blocks changed since the most recent level 0 backup.
C. The backup performed in step 1 backs up all the blocks changed since the most recent level 1 backup.
D. The backup performed in step 2 backs up all blocks that have changed since the most recent incremental backup at level 1.
View the Exhibit and examine the attributes of an undo tablespace. In an OLTP system, the user SCOTT has started a query on a large table in the peak transactional hour that performs bulk inserts. The query runs for more than 15 minutes and then SCOTT receives the following error:
ORA-01555: snapshot too old
What could be the reason for this error?
A. The query is unable to get a read-consistent image.
B. There is not enough space in Flash Recovery Area.
C. There is not enough free space in the flashback archive.
D. The query is unable to place data blocks in undo tablespace.
Which two operations can be performed on an external table? (Choose two.)
A. Create a view on the table
B. Create an index on the table
C. Create a synonym on the table
D. Add a virtual column to the table
E. Update the table using the UPDATE statement
F. Delete rows in the table using the DELETE command
Download Latest Oracle 1Z0-052 Real Free Tests , help you to pass exam 100%.