V$DATABASE
DBA_TABLES
SYSAUD$
EMP
第1题:
You are trying to determine how many disk sorts are happening on the database right now. Which of the following dictionary tables would you use to find that information?()
第2题:
You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created. You want to look at the definition of the view (the SELECT statement on which the view was created.) How do you obtain the definition of the view?()
第3题:
You need to configure fine-grained access control to external network resources from within your database. You create an access control list (ACL) using the DBMS_NETWORK_ACL_ADMIN package. Which statement is true regarding the ACL created?()
第4题:
Records from the data dictionary information are stored in which of the following database memory areas?()
第5题:
You are identifying dictionary objects in the Oracle database. Which of the following is a view in the data dictionary?()
第6题:
You are about to create your Oracle data dictionary for use with the database. Which of the following users would you connect to the database as for this purpose in Oracle9i and later releases?()
第7题:
Repair damaged data dictionary entries.
Delete data dictionary information about database objects you no longer need.
Extract data definition commands from the data dictionary in a variety of formats.
Prepare pseudocode modules for conversion to Java or PL/SQL programs with a Metadata code generator
第8题:
All objects in the database
Tables owned by SYS and SYSTEM
Data dictionary tables
NCHAR columns
CHAR columns
第9题:
It is a list of remote database links stored in the XML file that are available to the users of the database.
It is a list of users and network privileges stored in the XML file according to which a group of users can connect to one or more hosts.
It is a list of users and network privileges stored in the data dictionary according to which a group of users can connect to one or more hosts.
It is the list of the host names or the IP addresses stored in the data dictionary that can connect to your database through PL/SQL network utility packages such as UTL_TCP.
第10题:
The trace file
The fixed views
The data dictionary views
The operating system log fields
The dynamic performance views.
第11题:
V$DATABASE
V$UNDOSTAT
V$FLASHBACK_DATABASE_LOG
V$FLASHBACK_DATABASE_STAT
第12题:
SYSTEM
OUTLN
INTERNAL
SYS
第13题:
You work as a database administrator for Supportcenter.cn. In a production environment, users complain about the slow response time when accessing the database. You have not optimized the memory usage of the Oracle instance and you suspect the problem to be with the memory. To which type of object would you refer to determine the cause of the slow response?()
第14题:
What does the Metadata Application Programming Interface (API) allow you to do?()
第15题:
You are analyzing how Oracle processes user statements. SQL and PL/SQL parse information is stored in which of the following database memory areas? ()
第16题:
You are required to flashback your database. You want to find the amount of flashback data generated since the database was opened. Which task will you perform to obtain the required information?()
第17题:
Flashback Database is enabled in your Oracle 10g database. One of your database users erroneously purged an important table residing in his schema. The table was purged sometime between 10:00 P.M. and 10:30 P.M. The next day, you decide to flash back the database. Before you flash back the database, you want to ensure that you have all the necessary flashback data. Which dynamic performance view must you use to determine whether you have the required flashback data to recover the purged table?()
第18题:
When the instance is started
When the database is mounted
When the database is opened
When the database is closed
第19题:
USER_TAB_PRIVS_MADE
USER_TAB_PRIVS
USER_COL_PRIVS_MADE
USER_COL_PRIVS
第20题:
Library cache
Row cache
Session UGA
Buffer cache
第21题:
Use the DESCRIBE command in the EMP_DEPT VU view.
Use the DEFINE VIEW command on the EMP_DEPT VU view.
Use the DESCRIBE VIEW command on the EMP_DEPT VU view.
Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.
Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.
Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.
第22题:
DBA_USERS
DBA_OBJECTS
DBA_TS_QUOTAS
DBA_TAB_PRIVS
第23题:
Query the V$FLASHBACK_DATABASE_LOG view.
Query the V$FLASHBACK_DATABASE_STAT view.
Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.
Query the V$RECOVERY_FILE_DEST view.