单选题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? （）

DBA_USERS

DBA_OBJECTS

DBA_TS_QUOTAS

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”相关问题

第1题

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

点击查看答案
第2题

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

点击查看答案
第3题

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.

点击查看答案
第4题

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

点击查看答案
第5题

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

点击查看答案
第6题

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

点击查看答案
第7题

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

点击查看答案

单选题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”相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容