Oracle認(rèn)證考試章節(jié)練習(xí)(2020.01.15)

You administer an online transaction processing (OLTP) system whose database is stored in Automatic
Storage Management (ASM) and whose disk group use normal redundancy.
One of the ASM disks goes offline, and is then dropped because it was not brought online before DISK_REPAIR_TIME elapsed.
When the disk is replaced and added back to the disk group, the ensuing rebalance operation is too slow.
Which two recommendations should you make to speed up the rebalance operation if this type of failure
happens again?（）

You have a large amount of historical data in a flat file. Some analysts in your organization need toquery this data in the file. The file is too large to load the data in it into your current database. 
Which is the most effective method to access this data in your database（）

Examine the SQL statements that creates ORDERS table: CREATE TABLE orders
(SER_NO NUMBER UNIQUE,
ORDER_ID NUMBER,
ORDER_DATE DATE NOT NULL
STATUS VARCHARD2(10)
CHECK (status IN ('CREDIT','CASH')),
PROD_ID_NUMBER
REFERENCES PRODUCTS(PRODUCT_ID),
ORD_TOTAL NUMBER,
PRIMARY KEY (order id, order date));
For which columns would an index be automatically created when you execute the aboveSQL statement? （）

Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client 
while connecting to the database instance from a remote machine（）

You enabled Automatic Shared Memory Management. The initialization parameters are set as shown below： 
SGA_TARGET = 10GB SGA_MAX_SIZE = 14GB 
STREAMS_POOL_SIZE = 1GB 
SHARED_POOL_SIZE = 3GB 
Which two statements are correct in this scenario？ （）

You deploy two different applications to the WebLogic container. One application use Xerces parser version A and the other application uses Xerces parser version B. Both these versions are different from the parser version that the WebLogic server uses internally. You want to use the Filtering Classloader feature to solve this problem.
What action would you take to generate proper filtering Classloader entries?（）