1Z1-052 試験問題を無料オンラインアクセス

Which two are true about Optimizer Statistics? (Choose two.)

• A.They can be used to determine the events on which a database instance waited
• B.They provide information to the Optimizer so that it can determine optimal execution plans for SQL statements
• C.They are automatically updated when DDL statements execute
• D.They can be gathered by executing the PL/SQL procedures in the DBMS_STATS package
• E.They are gathered by the Manageability Monitor (MMON) background process
• F.They do not persist across instance restarts

You have issued a SHUTDOWN ABORT command to bring down your database instance.
Consider the steps that will be performed later when you open the database:
1 . SGA is allocated.
2 . Control file is read.
3 . Redo log files are opened.
4 . Instance recovery is started.
5 . Background processes are started.
6 . Data file headers are checked for consistency.
7. Server parameter file or the initialization parameter file is read.
Which option has the correct order in which these steps occur?

• A.7, 1, 4, 5, 2, 3, 6
• B.1, 7, 5, 4, 2, 3, 6
• C.7, 1, 5, 2, 3, 6, 4
• D.1, 2, 3, 7, 5, 6, 4

Which statement is true about loading data using the conventional path of SQL*Loader?

• A.Only PRIMARY KEY, UNIQUE KEY and NOT NULL constraints are checked
• B.No exclusive locks are acquired when the conventional path loads are performed
• C.Instead of performing transactions, SQL*Loader directly writes data blocks to the data files
• D.Redo is not generated while performing conventional path loads
• E.INSERT triggers are disabled before the conventional path load and reenabled at the end of the load

View the Exhibit.

You want to create a tablespace to contain objects with block size 16 KB. But while configuring the storage you find that the block size that you can provide is only 8 KB.
Which configuration could have enabled the block selection of 16 KB?

• A.Choosing the Segment Space Management option to manual
• B.Setting autoextension on for the data file mentioned for the tablespace
• C.Choosing the extent allocation type to uniform
• D.Setting the DB_16K_CACHE_SIZE parameter for the database instance to a nonzero value

You receive complaints from users regarding the high waiting time for their transactions.
On investigation, you find that some users are not committing their transactions though they are not performing any activity for a long time. As a result, SQL statements need to wait for rowlevel locks. Which two actions could you take to prevent this locking problem in the future? (Choose two.)

• A.Decrease the IDLE_TIME resource limit in the profile assigned to the blocking users.
• B.Decrease the maximum number of interested transaction list (ITL) slots for the segments on which the blocking user performs the transaction.
• C.Set the limit in the profile of blocking users to control the number of blocks to be accessed in a session.
• D.Use Database Resource Manager to automatically log out sessions that block others and are idle