网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
In order to find out how many database objects a user has created, which view would the DBA query in the Oracle data dictionary? （）
A
DBA_USERS
B
DBA_OBJECTS
C
DBA_TS_QUOTAS
D
DBA_TAB_PRIVS
参考答案
参考解析
解析：
暂无解析
更多 “单选题In order to find out how many database objects a user has created, which view would the DBA query in the Oracle data dictionary? （）A DBA_USERS B DBA_OBJECTS C DBA_TS_QUOTAS D DBA_TAB_PRIVS ” 相关考题
考题
Which data dictionary table should you query to view the object privileges granted to the user on specific columns? ()
A. USER_TAB_PRIVS_MADEB. USER_TAB_PRIVSC. USER_COL_PRIVS_MADED. USER_COL_PRIVS
考题
In order to find out how many database objects a user has created, which view would the DBA query in the Oracle data dictionary? （）A、DBA_USERS B、DBA_OBJECTS C、DBA_TS_QUOTAS D、DBA_TAB_PRIVS
考题
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?（）A、V$SESSION B、V$SYSSTAT C、DBA_SEGMENTS D、V$SORT_USAGE
考题
You have many users complaining about slow inserts into a large table. While investigating the reason， you find that the number of indexes on the table is high. You want to find out which indexes are not being used. Which method would you follow to achieve this？（）A、enable index monitoring and query the DBA_OBJECTS viewB、enable index monitoring and query the DBA_INDEXES viewC、enable index monitoring and query the V$OBJECT_USAGE viewD、enable index monitoring and view the DBA_INDEXTYPE_COMMENTS view
考题
A user wants to connect to the database instance from an application that is running on a remote machine. Which tools should the DBA use to establish the required configuration to ensure that the user is able to connect to the database instance？（）A、Data PumpB、Oracle Net ManagerC、Oracle Enterprise ManagerD、Oracle Universal Installer （OUI）E、Database Configuration Assistant （DBCA）
考题
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?（）A、Use the DESCRIBE command on the EMP_DEPT_VU view.B、Use the DEFINE VIEW command on the EMP_DEPT_VU view.C、Use the DESCRIBE VIEW command on the EMP_DEPT_VU view.D、Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.E、Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.F、Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.
考题
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 create.) How do you obtain the definition of the view?（）A、Use the DESCRIBE command in the EMP_DEPT VU view.B、Use the DEFINE VIEW command on the EMP_DEPT VU view.C、Use the DESCRIBE VIEW command on the EMP_DEPT VU view.D、Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.E、Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.F、Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.
考题
On Tuesday， a junior DBA dropped an important application user account， whose schema has important tables. You are asked to recover all the objects in the schema. On investigation， you find that the user account was dropped at 11：00 a.m. and Sunday’s backup is the most recent backup. Which flashback feature would you use？（）A、Flashback DropB、Flashback TableC、Flashback DatabaseD、Flashback Version QueryE、Flashback Transaction Query
考题
A database user SMITH tries to query the V$SESSION view and fails to access it as follows： SQL connect smith/smith Connected. SQL SELECT * FROM v$session； SELECT * FROM v$session * ERROR at line 1： ORA-00942： table or view does not exist Which are the two possible solutions to enable SMITH to query the data in V$SESSION（）A、granting SELECT privilege to SMITH on V$SESSIONB、granting SELECT privilege to SMITH on V_$SESSIONC、asking the user SMITH to run the catalog.sql scriptD、granting SELECT privilege to SMITH on V$FIXED_TABLESE、setting the O7_DICTIONARY_ACCESSIBILITY parameter to TRUEF、creating a view based on V$SESSION and granting SELECT privilege to SMITH on the view that was created
考题
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？（）A、 Query the V$FLASHBACK_DATABASE_LOG view.B、 Query the V$FLASHBACK_DATABASE_STAT view.C、 Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.D、 Query the V$RECOVERY_FILE_DEST view.
考题
You are identifying dictionary objects in the Oracle database. Which of the following is a view in the data dictionary?（） A、V$DATABASE B、DBA_TABLES C、SYSAUD$ D、EMP
考题
Which data dictionary table should you query to view the object privileges granted to the user on specific columns? （）A、USER_TAB_PRIVS_MADEB、USER_TAB_PRIVSC、USER_COL_PRIVS_MADED、USER_COL_PRIVS
考题
You find this query being used in your Oracle 12c database: Which method a used by the optimizer to limit the rows being returned?（）A、A filter is added to the table query dynamically using ROWNUM to limit the rows to 20 percent of the total rowsB、All the rows are returned to the client or middle tier but only the first 20 percent are returned to the screen or the application.C、A view is created during execution and a filter on the view limits the rows to 20 percent of the total rows.D、A TOP-N query is created to limit the rows to 20 percent of the total rows
考题
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?（）A、SYSTEM B、OUTLN C、INTERNAL D、SYS
考题
A customer has determined they want to install an IBM x445 system in their company. They will be running a large database on the system. In order to determine how many CPUs will be needed to attain the optimum cost-effective solution， which TWO of the following questions should be asked？（）A、How large is the database？B、What is the expected user workload？C、How is the database software licensed？D、What type of user interface will be used？E、How much data cache will the database be allocated？
考题
单选题On Tuesday， a junior DBA dropped an important application user account， whose schema has important tables. You are asked to recover all the objects in the schema. On investigation， you find that the user account was dropped at 11：00 a.m. and Sunday’s backup is the most recent backup.Which flashback feature would you use？（）A
Flashback DropB
Flashback TableC
Flashback DatabaseD
Flashback Version QueryE
Flashback Transaction Query
考题
单选题Which data dictionary table should you query to view the object privileges granted to the user on specific columns?（）A
USER_TAB_PRIVS_MADEB
USER_TAB_PRIVSC
USER_COL_PRIVS_MADED
USER_COL_PRIVS
考题
单选题You are identifying dictionary objects in the Oracle database. Which of the following is a view in the data dictionary?（）A
V$DATABASE B
DBA_TABLES C
SYSAUD$ D
EMP
考题
单选题You find this query being used in your Oracle 12c database: Which method a used by the optimizer to limit the rows being returned?（）A
A filter is added to the table query dynamically using ROWNUM to limit the rows to 20 percent of the total rowsB
All the rows are returned to the client or middle tier but only the first 20 percent are returned to the screen or the application.C
A view is created during execution and a filter on the view limits the rows to 20 percent of the total rows.D
A TOP-N query is created to limit the rows to 20 percent of the total rows
考题
单选题On Tuesday， a junior DBA dropped an important application user account， whose schema has important tables. You are asked to recover all the objects in the schema. On investigation， you find that the user account was dropped at 11：00 a.m. and Sunday’s backup is the most recent backup. Which flashback feature would you use？（）A
Flashback DropB
Flashback TableC
Flashback DatabaseD
Flashback Version QueryE
Flashback Transaction Query
考题
单选题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 create.) How do you obtain the definition of the view? （）A
Use the DESCRIBE command in the EMP_DEPT VU view.B
Use the DEFINE VIEW command on the EMP_DEPT VU view.C
Use the DESCRIBE VIEW command on the EMP_DEPT VU view.D
Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.E
Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.F
Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.
考题
单选题You have many users complaining about slow inserts into a large table. While investigating the reason， you find that the number of indexes on the table is high. You want to find out which indexes are not being used. Which method would you follow to achieve this？（）A
enable index monitoring and query the DBA_OBJECTS viewB
enable index monitoring and query the DBA_INDEXES viewC
enable index monitoring and query the V$OBJECT_USAGE viewD
enable index monitoring and view the DBA_INDEXTYPE_COMMENTS view
考题
单选题In order to find out how many database objects a user has created, which view would the DBA query in the Oracle data dictionary? （）A
DBA_USERS B
DBA_OBJECTS C
DBA_TS_QUOTAS D
DBA_TAB_PRIVS
考题
单选题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?（）A
Use the DESCRIBE command on the EMP_DEPT_VU view.B
Use the DEFINE VIEW command on the EMP_DEPT_VU view.C
Use the DESCRIBE VIEW command on the EMP_DEPT_VU view.D
Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.E
Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.F
Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.
考题
单选题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？（）A
Query the V$FLASHBACK_DATABASE_LOG view.B
Query the V$FLASHBACK_DATABASE_STAT view.C
Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.D
Query the V$RECOVERY_FILE_DEST view.
考题
单选题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?（）A
SYSTEM B
OUTLN C
INTERNAL D
SYS
考题
单选题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?（）A
V$SESSION B
V$SYSSTAT C
DBA_SEGMENTS D
V$SORT_USAGE
考题
多选题A customer has determined they want to install an IBM x445 system in their company. They will be running a large database on the system. In order to determine how many CPUs will be needed to attain the optimum cost-effective solution， which TWO of the following questions should be asked？（）AHow large is the database？BWhat is the expected user workload？CHow is the database software licensed？DWhat type of user interface will be used？EHow much data cache will the database be allocated？
热门标签
最新试卷