<span id="j2pzz"></span>

1Z0-052單項選擇題每日一練(2020.04.03)

單項選擇題
Note the following structures in your database server：1.Extents2.OS Blocks3.Tablespace4.Segments5.Oracle Data BlockWhich 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
單項選擇題
Which statement describes the effect on an index， when the indexed column for the rows is updatedin the base table（）
A.An update in a leaf row takes place.
B.The index becomes invalid after the update.
C.The leaf block containing the row to be updated is marked as invalid.
D.A row in the leaf block of the index for the key value is logically deleted and a new leaf row is inserted
單項選擇題
You suspect unauthorized data manipulation language （DML） operations on a particular table. Youwant to track users who are performing the transactions and the values used in the transactions. You alsoplan to transfer these values to another table for analysis. How would you achieve this（）
A.by using triggers
B.by using Data Pump
C.by using external tables
D.by using anonymous PL/SQL blocks
單項選擇題
In which situation is 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 tablespaces 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
單項選擇題
Your database instance is currently configured to support 1，500 connections. The Web applicationthat uses the database allows a large number of users to work with the database simultaneously. Someusers of the Web application do not interact with the server all the time. You want to increase the scalability by configuring the database instance to handle more connections. Asa DBA， which configuration would you set to support more than 1，500 connections at a time（）
A.You would configure more listeners for the database.
B.You would configure the database in shared server mode to use the connection pooling feature.
C.You would increase the value of the PGA_AGGREGATE_TARGET initialization parameter that assigns more session memory to users.
D.You would decrease the value of the PRIVATE_SGA resource limit in the profiles used by the users to accommodate more session information.

<rt id="vpkjv"></rt>

<span id="vpkjv"><noframes id="vpkjv"><rt id="vpkjv"></rt>

<rt id="vpkjv"></rt>