You need to configure fine-grained acc...

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

A. It is a list of remote database links stored in the XML file that are available to the users of the database.
B.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.
C. 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.
D. 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.

点击查看答案

您可能感兴趣的试卷

你可能感兴趣的试题

1.单项选择题 You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the user RCO11. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10.
You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10, into the recovery catalog owned by RCO11. You also want to deregister them from the catalog after import.
You executed the following commands to achieve this:

What happens if the RCO11 catalog has scripts with the same name as that of the scripts in RCAT10 catalog?（）

A. The scripts in the RCO11 catalog are overwritten.
B. RMAN renames the local stored scripts in the RCO11 catalog.
C.The RMAN session in which the command is executed aborts.
D. RMAN renames the global scripts that are imported from the RCAT10 catalog.

点击查看答案

2.多项选择题 Examine the section of the Health Check report given below:

Which two statements are true regarding the Health Check report?（）

A. Health Check was performed manually.
B. Health Check was performed to check the disk image block corruptions.
C. Health Check was performed to check interblock and intersegment corruption.
D. Health Check was performed to verify the integrity of database files and report failures.
E. Health Check was performed by the Health Monitor automatically in response to a critical error.

点击查看答案

3.多项选择题Which three components does the Scheduler use for managing tasks within the Oracle environment?（）

A. a job
B. a program
C. a schedule
D. a PL/SQL procedure

点击查看答案

4.单项选择题 Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains one redo member. When you attempt to start the database, you receive the following errors:

Which statement should you use to resolve this issue?（）

A. ALTER DATABASE DROP LOGFILE GROUP 1;
B.ALTER DATABASE CLEAR LOGFILE GROUP 1;
C. ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;
D. ALTER DATABASE DROP LOGFILE MEMBER 'D:\REDO01.LOG';

点击查看答案

5.单项选择题You plan to have a larger moving window size for the default system-defined moving window baseline because you want to use the adaptive threshold. Which statement factors in this consideration while increasing the size of the moving window?（）

A. The collection level for the AWR should be set to BASIC
B. The moving window size must be less than Undo Retention
C. The moving window size should be greater than the Automatic Workload Repository (AWR) retention period
D. The moving window size should be equal to or less than the Automatic Workload Repository (AWR) retention period

点击查看答案

6.多项选择题While deploying a new application module, the software vendor ships the application software along with appropriate SQL plan baselines for the new SQLs being introduced. Which two statements describe the consequences?（）

A. The plan baselines can be evolved over time to produce better performance.
B. The newly generated plans are directly placed into the SQL plan baseline without being verified.
C. The new SQL statements initially run with the plans that are known to produce good performance under standard test configuration.
D. The optimizer does not generate new plans for the SQL statements for which the SQL plan baseline has been imported.

点击查看答案

7.单项选择题 The following databases are registered in the base recovery catalog: PROD1, PROD2, and PROD3. The database user CATOWNER owns the base recovery catalog. You want a new user VPC1 to have access to only the PROD1 database and create a virtual private catalog.
Given below are some of the commands required to achieve this:
1.SQL> GRANT recovery_catalog_owner TO vpc1;
2.RMAN> CONNECT CATALOG vpc1/password@catdb;
3.RMAN> GRANT CATALOG FOR DATABASE prod1 TO vpc1;
4.RMAN> CONNECT CATALOG catowner/password@catdb;
5.RMAN> CREATE VIRTUAL CATALOG;
What is the correct sequence in which the commands have to be executed?（）

A. 1, 4, 5, 2, 3
B. 1, 4, 3, 2, 5
C. 4, 5, 2, 3, 1
D. 2, 3, 4, 5, 1
E. 1, 4, 2, 3, 5

点击查看答案

8.单项选择题 In your database, the LDAP_DIRECTORY_SYSAUTH initialization parameter has been set to YES and the users who need to access the database as DBAs have been granted SYSDBA enterprise role in Oracle Internet Directory (OID). SSL and the password file have been configured. A user SCOTT with the SYSDBA privilege tries to connect to the database instance from a remote machine using the command:

Which authentication method would be used first?（）

A. authentication by password file
B. authentication by using certificates over SSL
C. authentication by using the Oracle Internet Directory
D. authentication by using the local OS of the database server

点击查看答案

9.单项选择题While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available. What would the optimizer do in this situation?（）

A. It updates the existing SQL profiles with current statistics
B. It makes the statistics information available to GATHER_STATS_JOB
C. It initiates the statistics collection process by running GATHER_STATS_JOB
D. It logs a warning message in the alert log so that the DBA can perform statistics collection manually

点击查看答案

10.单项选择题 View the Exhibit for some of the parameter settings. You start a session and issue the following command:
SQL>CREATE INDEX emp_ename ON emp(ename) TABLESPACE users INVISIBLE;
What is the outcome of the above command?（）

A. The index is not used by the optimizer but is maintained during DML operations.
B. The index is not used by the optimizer and is not maintained during DML operations.
C. The index is used by the optimizer only if a hint is specified in the query statement and is maintained during DML operations.
D. The index is used by the optimizer only if a hint is specified in the query statement but is not maintained during DML operations.

点击查看答案