单选题The database instance has the following parameter setting： OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE REMOTE_OS_AUTHENT = FALSE REMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0 You have a local operating system user SKD.You create a database user OPS$SKD

第1题：

Examine the following steps performed on a database instance： 1. The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION. 2. The SKD user creates a table. 3. The SKD user grants the CREATE TABLE system privilege to the HR user. 4. The HR user creates a table. 5. The DBA revokes the CREATE TABLE system privilege from SKD.  Which statement is true after step 5 isperformed（）

• A、The table created by SKD is not accessible and SKD cannot create new tables.
• B、The tables created by SKD and HR remain， but both cannot create new tables.
• C、The table created by HR remains and HR still has the CREATE TABLE system privilege.
• D、The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.

第2题：

The database instance has the following parameter setting： OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE REMOTE_OS_AUTHENT = FALSE REMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0 You have a local operating system user SKD.You create a database user OPS$SKD， and then assign external authentication. The user OPS$SKD has theCREATE SESSION privilege.  What would you achieve by the above process（）

• A、The database user OPS$SKD will be able to administer the database.
• B、The authentication detail for the database user OPS$SKD is recorded in the password file.
• C、The local operating system user SKD will be able to access the database instance without specifying theusername and password.
• D、The database user OPS$SKD has to login with the password of the local operating system user SKD toaccess the database instance.

第3题：

You are administering a database and you receive a requirement to apply the following restrictions: 1. A connection must be terminated after four unsuccessful login attempts by user. 2. A user should not be able to create more than four simultaneous sessions. 3. User session must be terminated after 15 minutes of inactivity. 4. Users must be prompted to change their passwords every 15 days. How would you accomplish these requirements?（）

• A、by granting a secure application role to the users
• B、by creating and assigning a profile to the users and setting the REMOTE_OS_AUTHENT parameter to false
• C、By creating and assigning a profile to the users and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameter to 4
• D、By Implementing Fine-Grained Auditing (FGA) and setting the REMOTE_LOGIN_PASSWORD_FILE parameter to none.
• E、By implementing the database resource Manager plan and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameters to 4.

第4题：

You are installing Oracle Database 11g on your server. During the installation Oracle Universal Installer （OUI） prompts you to enter the path of the inventory directory and also prompts you to specify an operating systemgroup name.  Which statement is true in this case（）

• A、The ORACLE_BASE parameter is not set.
• B、The installation is being performed by the root user.
• C、The operating system group that will be specified should have root user as its member.
• D、The installation is being performed without the "Create Starter Database" option selected.
• E、The operating system group that will be specified must have permission to write to the inventory directory

第5题：

In your test database， you find that a user’s session is executing a lot of SQL statements， resulting in the generation of a large number of trace files. While investigating the reason， you find that SQL trace has been enabled at the instance level. You want to disable SQL trace， remotely， only for that user session to reduce the volume of trace data being generated.How do you achieve this objective？（）

• A、 by setting the SQL_TRACE parameter to FALSE in the parameter file
• B、 by using DBMS_MONITOR.SESSION_TRACE_DISABLE to disable the tracing for the user session
• C、 by setting the SQL_TRACE parameter to FALSE by using the ALTER SYSTEM command in the user session
• D、 by setting the SQL_TRACE parameter to FALSE by using the ALTER SESSION command in the user session

第6题：

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA.  While observing the server settings， you find that the following parameter has been set in the parameter file of the database：  REMOTE_OS_AUTHENT = TRUE  What could have been the reason to set this parameter as TRUE？（）

• A、to enable operating system authentication for a remote client
• B、to restrict the scope of administration to identical operating systems
• C、to allow the start up and shut down of the database from a remote client
• D、to enable the administration of the operating system from a remote client
• E、to disable the administration of the operating system from a remote client

第14题：

Examine the following steps performed on a database instance：  1：The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION.  2：The SKD usercreates a table.  3：The SKD user grants theCREATETABLE system privilege to the HR user.  4：The HR user creates a table.  5：The DBA revokes the CREATE TABLE system privilege from SKD.  Which statement is true after step 5 is performed（）

• A、The table created by SKD isnot accessibleand SKD cannot create new tables.
• B、The tables created by SKD and HR remain， but both cannot create new tables.
• C、The table created by HR remains and HR still has the CREATE TABLE system privilege.
• D、The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.

第15题：

An administrator account is granted the CREATE SESSION and SET CONTAINER system privileges. A multitenant container database (CDB) instant has the following parameter set: THREADED_EXECUTION = FALSE Which four statements are true about this administrator establishing connections to root in a CDB that has been opened in read only mode?（）

• A、You can conned as a common user by using the connect statement.
• B、You can connect as a local user by using the connect statement.
• C、You can connect by using easy connect.
• D、You can connect by using OS authentication.
• E、You can connect by using a Net Service name.
• F、You can connect as a local user by using the SET CONTAINER statement.

第16题：

You issued the following command at the UNIX environment：   % setenv ORA_SDTZ ’OZ_TZ’   What will be the impact of issuing the above command？（）  

• A、 The operating system local time zone will be set for a user session using the operating system environment variable.
• B、 The database local time zone will be set for a user session using the operating system environment variable.
• C、 The operating system local time zone will be set for the database using the operating system environment
• D、 The database local time zone will be set for the database using the operating system environment variable.

第17题：

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：