单选题Which step do you need to perform to enable a user with the SYSDBA privilege to log in as SYSDBA in iSQL*Plus？（）A The user must be granted the database administrator （DBA） privilege.B The user must be listed in the password file for the authentication.

第1题：

A user is successfully authenticating to the network but is unable to access protected resources behind a ScreenOS enforcer. You log in to the ScreenOS enforcer and issue the command get auth table infranet and you do not see the user listed.Which two event log settings on the Junos Pulse Access Control Service must you enable to troubleshootthis issue?（）

• A、Connection Requests
• B、System Errors
• C、Enforcer Events
• D、Enforcer Command Trace

第2题：

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：$ SQLPLUS scott/tiger@DB01 AS SYSDBA   where DB01 is the net service name.   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

第3题：

You are working as a Database Administrator. Despite having a password in the data dictionary as change_on_install， you always log on to the database MYNEWDB using operating system authentication. Your organization is planning to recruit two junior-level DBAs. You decide to enable remote authentication in your database so that the new DBAs can log on to the database from their workstations to carry out administrative tasks.   To allow the new DBAs to perform the administrative tasks， you create a password file on the database server using the following command：   ORAPWD file=d：/oracle/ora9i/orapwU01 password=admin entries=4   After creating the password file， you remove the operating system authentication and change the value of the  REMOTE_LOGIN_PASSWORDFILE parameter to EXCLUSIVE. You also create a net service name as MYNEWDB that allows the new DBAs to connect to the database server from their workstations using this net service name. Which command must you use to connect to the database to start it？（）  

• A、 CONNECT / AS SYSDBA
• B、 CONNECT sys/admin AS SYSDBA
• C、 CONNECT sys/admin@mynewdb AS SYSDBA
• D、 CONNECT sys/change_on_install AS SYSDBA

第4题：

In order to enable remote administration of users and tablespaces on an Oracle database, which of the following types of files must exist in the database?（）

• A、Password file 
• B、Initialization file 
• C、Datafile 
• D、Control file 
• E、Nothing - SYSDBA privileges are not required for these actions

第5题：

Your network consists of a single Active Directory domain. All servers run Windows Server 2003 Service Pack 2 (SP2). You create a new domain user account named User1 and assign the account a password of P@ssw0rd. On the new account, you enable the User must change password at next logon option. A week later, you discover that User1 is still using the password P@ssw0rd to log on to the domain. You need to ensure that User1 is forced to use a different password the next time she changes her password. What should you do first? （）

• A、In the Default Domain Policy, select Enforce password history.
• B、In the Default Domain Policy, select Passwords must meet complexity requirements.
• C、From the User’s account properties, select Account is sensitive and cannot be delegated.
• D、From the User’s account properties, select Store password using reversible encryption.

第6题：

You need to configure the local security policy setting to request a user name and password when you make changes to the computer system.  What should you do？（）

• A、Enable the Password must meet complexity requirements setting.
• B、Enable the User Account Control： Detect application installations and prompt for elevation setting.
• C、Configure the Interactive logon： Prompt user to change password before expiration setting to a value between 1 and 999.
• D、Configure the User Account Control： Behavior of the elevation prompt for administrators in Admin Approval mode setting to the Prompt for credentials option.

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

Which are the prerequisites for performing flashback transactions on your database？（）

• A、 Undo retention guarantee for the database must be configured.
• B、 Supplemental log must be enabled for the primary key.
• C、 Supplemental log must be enabled.
• D、 Execute permission on the DBMS_FLASHBACK package must be granted to the user.

第14题：

Manually， you set the consumer group of all of the newly created users to MYDB_GRP. You want the users to be able to change their consumer groups as per the application requirement. What was the first step that was needed in the process to achieve this objective？（）

• A、 The user must have been granted the DBA role.
• B、 The user must have been granted the switch privilege as a part of a role.
• C、 The user must have been granted the Resource Manager administrator privilege.
• D、 The user must have been granted the switch privilege by using the DBMS_RESOURCE_MANAGER_PRIVS package.

第15题：

You are part of the DBA team working for a multinational bank. The team is responsible for performing administrative tasks on the database server located at the home office. The database server at the home office has a production database and a test database named TESTDB. The test database is primarily used for testing database commands and configuration settings befor implementing these settings on the production database. The test database is also used for the development of database applications. You have been asked by the senior DBA to grant the SYSDBA privilege to a new team member， John， so that he can perform some administrative tasks， such as shutdown and startup operations， on TESTDB. You use the password file to configure remote authentication on the TESTDB database. You execute the following statement to grant the SYSDBA privilege to John：   SQL>GRANT SYSDBA TO john；   However， you receive the following error：   ORA-01996： GRANT failed： password file   ’c：/oracle/ora9i/dbs/testdb.pwd’ is full   Which action should you take to add the user john to the password file without removing any of the existing users？（）

• A、 Create another password file and then re-execute the GRANT statement.
• B、 Re-create the password file， specifying a larger number of allowed entries， and then re-execute the GRANT statement.
• C、 Change the value of the REMOTE_LOGIN_PASSWORDFILE initialization parameter in theinitialization parameter file to NONE and then re-execute the GRANT statement.
• D、 Change the value of the REMOTE_LOGIN_PASSWORDFILE initialization parameter in the initialization parameter file to SHARED and then re-execute the GRANT statement.

第16题：

You want the user APP_DBA to administer the Oracle database from a remote machine. APP_DBA is granted the SYSDBA privilege to perform administrative tasks on the database. Which file is used by the Oracle database server to authenticate APP_DBA？（）

• A、control file
• B、password file
• C、listener controller file
• D、control file and password file

第17题：

You are the administrator of an Active Directory domain named A user reports that he forgot his password and cannot log on to the domain. You discover that yesterday morning the user reset his password and successfully logged on to the domain. You need to enable the user to log on to the domain. What should you do? （）(Choose two)

• A、Use Active Directory Users and Computers to move the account to the default organizational unit (OU) named Users. Instruct the user to restart his computer.
• B、Use Active Directory Users and Computers to open the account properties for the user's user account. Clear the Account is locked out check box, and select the User must change password at next logon check box.
• C、Use Active Directory Users and Computers to reset the user's password. Give the user the new password.
• D、Use Computer Management to reset the password for the local Administrator account.

第18题：

You are the network administrator for The network consists of a single Active Directory domain named The functional level of the domain is Windows Server 2003. Some user accounts have expiring passwords and some do not. You need to identify all user accounts that do not have expiring passwords. You need to modify the password property to allow the passwords on these accounts to expire. You must complete this task by using the minimum amount of administrative effort. First, you create a saved query to obtain a list of all user accounts that do not have expiring passwords. What should you do next?（）

• A、Export the query results to a comma-delimited file. Use a CSVDE script to modify the password property of each user account.
• B、From the Results pane of the query, select all user accounts and modify their password properties simultaneously.
• C、Export the query results to a comma-delimited file. Use an LDIFDE script to modify the password property of each user account.
• D、From the Results pane of the query, select each user account and modify the password property, one by one.

第19题：

第20题：

第21题：

第22题：

第23题：