单选题A user complains that he gets the following error message repeatedly after executing some SQL statements. The error message forces the user to log off from and log on to the database to continue his work. ORA-02392： exceeded session limit on CPU usage，

第1题：

A new employee needs access to a SQL Server 2005 database that is located on a server named SQL1. You create a login named ajones by using the following Transact-SQL statement. CREATE LOGIN ajones WITH PASSWORD = ’SQLServer$1’ The new employee reports that when he logs in， he receives the following error message： "Login failed. The user is not associated with a trusted SQL Server connection." You need to resolve the error and allow the new employee to gain access to SQL1. What should you do？（）

• A、Change the SQL Server security mode from Windows Authentication mode to SQL Server and Windows authentication mode.
• B、Change the SQL Server security mode from SQL Server and Windows Authentication mode to Windows authentication mode.
• C、Ensure that the login name is created with square brackets （[]）.
• D、Give the login access to a specific database by using the CREATE USER Transact-SQL statement.

第2题：

The session of user SCOTT receives the following error after executing an UPDATE command onthe EMP table：  ERROR at line 1：  ORA-00060： deadlock detected while waiting for resource  On investigation， you find that a session opened by user JIM has a transaction that caused the deadlock.  two statements are true regarding the session of SCOTT in this scenario（）

• A、The session is terminated after receiving the error and JIM can continue with his transaction.
• B、SCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.
• C、The session is rolled back after receiving the error and JIM can continue with his transaction.
• D、SCOTT has to reexecute the last command in the transaction after he commits the transaction.

第3题：

You execute the following set of commands to create a database user and to grant the system privileges in your production environment.  SQL> CREATE USER user01  IDENTIFIED BY oracle DEFAULT TABLESPACE tbs1  TEMPORARY TABLESPACE temp PROFILE default  /  SQL> GRANT create session， create table TO user01； While executing the command to create a table， the user gets the following error message and the CREATE TABLE.. command fails.  ERROR at line 1： ORA-01950： no privileges on tablespace  What could be the possible reason for this error message？（）

• A、The tablespace TBS1 is full.
• B、The user is not the owner of the SYSTEM tablespace.
• C、The user does not have quota on the TBS1 tablespace.
• D、The user does not have sufficient system privileges to create table in the TBS1 tablespace.
• E、The user does not have sufficient privileges to create table on the default permanent tablespace.

第4题：

You receive the following error：   ORA-19804： cannot reclaim nnnnn bytes disk space from mmmmm limit   Identify the reason for receiving the above error message？（）

• A、 The sort area is very small.
• B、 There is no more space in the Undo tablespace.
• C、 The flash recovery area is full.
• D、 The online redo log file is full.

第5题：

A user has a computer that runs Windows XP Professional. The user attempts to connect to the computer by using a Remote Desktop Connection and receives the following error message: “The local policy of the system does not permit you to log on interactively.” You need to ensure that the user can log on to the computer by using a Remote Desktop Connection. What should you do?（） 

• A、From the System settings, disable Remote Assistance.
• B、Add the user's account to the Remote Desktop Users group. 
• C、From Windows Firewall, modify the scope of the Remote Desktop exception. 
• D、Set the Remote Desktop Help Session Manager service Startup type to Automatic, and then start the service.

第6题：

You are the network administrator for The network consists of a single Active Directory domain named . For security reasons,management decides that a particular user must not be able to log on to the domain after 5:00 P.M. If the user is logged on to the domain at 5:00 P.M., he must be logged off automatically. You configure the Logon Hours setting for the appropriate user account. Thatnight, you verify that the user cannot log on to the domain after 5:00 P.M. The nextday, you notice that the user is still accessing domain resources at 6:00 P.M. Youverify that the time on the user's computer and on the domain controller arecorrect. You need to ensure that the user is logged off automatically if he is still working onthe domain after 5:00 P.M. What should you do?（）

• A、In Active Directory Users and Computers, on the Sessions tab, configure the End Session setting for the user account. Instruct the user to log off from the domain and log on again.
• B、Modify the Default Domain Policy GPO to enforce logoff when logon hours expire. Ensure that the user's computer has the latest Group Policy settings applied.
• C、Remove the user's domain account from the local Administrators group on the user's client computer. Instruct the user to log off from the domain and log on again.
• D、Use Computer Management on the domain controller. Restart the Net Logon service.

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

A user selects their proper domain and is unable to log into their Windows computer.The error states：‘System cannot log you on to the domain because the system’s computer account in its primary domain is missing or the password on that account is incorrect’.Which of the following is the MOST likely cause for this error？（）

• A、The computer’s account was removed from Active Directory.
• B、The user’s account was removed from Active Directory.
• C、The computer was disjoined from the domain.
• D、The user typed in the wrong password.

第14题：

You execute the following command in your Certkiller .com production database to change the width of the CUST_NAME column of the CUSTOMERS table： ALTER TABLE customers  MODIFY （cust_nameVARCHAR2 （40）） /  When you execute the command， it displays the following error message：  ERROR at line 1：  ORA-00054： resource busy and acquire with NOWAIT specified  What could be the reason for the error message？（）

• A、The database instance is not available.
• B、The ALTER TABLE command does not have WAIT option
• C、The table or a row in the table is currently locked by another user session.
• D、The database instance is busy processing other user sessions commands.
• E、The CUSTOMERS table has no long running query active at the time when this request is made.
• F、The server process executing the ALTER TABLE command is busy with another command execution

第15题：

A user complains that he gets the following error message repeatedly after executing some SQL statements.The error message forces the user to log off from and log onto the database to continue his work.  ORA-02392：exceeded session limit on CPU usage，you are being logged off Which action would you take to increase the session limit on CPU usage？（）

• A、Modify the profile assigned to the user.
• B、Modify the roles assigned to the users.
• C、Modify the object privileges assigned to the user.
• D、Modify the system privileges assigned to the users.
• E、Modify the value for the RESOURCE_LIMIT parameter in the parameter file.

第16题：

You are working on a database， where you have three redo log groups. When the database is down for a backup， an operating system （OS） user deletes all the redo log files in a group. What will happen when you open your database？（）

• A、 The instance starts， the database is mounted， but efforts to open the database fail， and an error about the missing redo log group is displayed.
• B、 Before the instance starts， you receive an error about the missing redo log files of a group.
• C、 The instance starts and the database opens with an error message written to the alert log file.
• D、 The instance starts and the database opens because two redo log groups still exist.
• E、 The instance starts and the database opens， but every attempt to write to redo log files fails with an error.

第17题：

You are the network administrator for . Your network consists of asingle Active Directory domain. All network servers run Windows Server 2003. TestKing has offices in Chicago, New York and Los Angeles. Each office has one domain controller. Each office also has its own organization unit (OU), which contains all user accounts and computer accounts in that office. The Chicago OU is accidentally deleted from Active Directory. You perform an authoritative restoration of that OU. Some users in Chicago now report that they receive the following error message when they try to log on to the domain. "The session setup from the computer DOMAINMEMBER failed to authenticate. The name of the account referenced is the security database in DOMAINMEMBER$. The following error occurred: Access is denied". How should you solve this problem?（）

• A、Reset the computer accounts of the computers that receive the error message. Instruct the affected users to restart their computers.
• B、Perform a nonauthoritative restoration of Active Directory. Force directory replication on all domain controllers.
• C、Restart the Kerberos Key Distribution Center service on each domain controller.
• D、Run Nltest.exe on the computers that receive the error message. Restart the Net Logon service on the domain controller on Chicago.

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：