你可能感興趣的試題

Users complain about the slow response time of queries. While investigating the cause you find that the Oracle Instance is not configured to cache all of the data blocks to satisfy the users’queries. Which component of the Oracle Instance would you change to improve performance？（）

A.Java pool
B.Large pool
C.Shared pool
D.Streams pool
E.Library cache
F.Redo log buffer
G.Data dictionary cache
H.Database buffer cache

單項(xiàng)選擇題

A user complains that he gets the following error message repeatedly after executing some SQL statements.The error message forces the user to log off from and log onto the database to continue his work.
ORA-02392：exceeded session limit on CPU usage，you are being logged off Which action would you take to increase the session limit on CPU usage？（）

A.Modify the profile assigned to the user.
B.Modify the roles assigned to the users.
C.Modify the object privileges assigned to the user.
D.Modify the system privileges assigned to the users.
E.Modify the value for the RESOURCE_LIMIT parameter in the parameter file.

User SCOTT wants to export his objects using Oracle Data Pump and executes the following command： $ expdp scott/tiger directory = EXPORT_DIR dumpfile = scott.dmp include = table include = view："like ’%DEPARTMENTS%’" content = DATA_ONLY Which task would the command accomplish？（）

你可能感興趣的試題

Users complain about the slow response time of queries. While investigating the cause you find that the Oracle Instance is not configured to cache all of the data blocks to satisfy the users’queries. Which component of the Oracle Instance would you change to improve performance？（）

User SCOTT wants to export his objects using Oracle Data Pump and executes the following command： $ expdp scott/tiger
directory = EXPORT_DIR
dumpfile = scott.dmp include = table
include = view："like ’%DEPARTMENTS%’"
content = DATA_ONLY
Which task would the command accomplish？（）