网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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.
参考答案
参考解析
解析：
暂无解析
更多 “单选题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.” 相关考题
考题
You have a stand-alone server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2).A user named User1 is a member of the Administrators group on Server1.User1 attempts to log on to Server1 and receives the following error message.Other members of the Administrators group can log on to Server1.You need to ensure that User1 can log on to Server1.What should you do? （）A. From the properties of the User1 account, modify the Session settings.B. From the properties of the User1 account, modify Environment settings.C. From the local security policy on Computer1, modify the Deny log on locally setting.D. From the local security policy on Server1, modify the Impersonate a client after authentication setting.
考题
You observed the following output for a user session:What do you infer from the preceding output?()
A. Resumable set for session with sid 18B. The user session has entered into a deadlockC. The database instance is enabled to use asynchronous commitD. The threshold warning limit is exceeded for the tablespace that is used by the user session
考题
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
考题
Which three of the following are components of a syslog message? （）(Choose three.)A、time stampB、error codesC、severity levelD、log message name
考题
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.
考题
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.
考题
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.
考题
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 optionC、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
考题
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.
考题
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.
考题
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.
考题
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.
考题
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.
考题
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.
考题
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.
考题
单选题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.
考题
单选题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.
考题
多选题The session of user SCOTT receives the following error after executing an UPDATE command on the EMPtable： ERROR at line 1： ORA-00060： deadlock detected while waiting for resource On investigation， you find that a session opened byuser JIM has a transaction that caused the deadlock. Which two statements are true regarding the session ofSCOTT in this scenario（）AThe session is terminated after receiving the error and JIM can continue with his transaction.BSCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.CThe session is rolled back after receiving the error and JIM can continue with his transaction.DSCOTT has to reexecute the last command in the transaction after he commits the transaction.
考题
单选题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， 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.
考题
单选题Your company has an Active Directory domain. A user attempts to log on to a computer that was turned off for twelve weeks. The administrator receives an error message that authentication has failed. You need to ensure that the user is able to log on to the computer. What should you do（）A
Run the netdom TRUST /reset command.B
Run the netsh command with the set and machine options.C
Run the Active Directory Users and Computers console to disable， and then enable the computer account.D
Reset the computer account. Disjoin the computer from the domain， and then rejoin the computer to the domain.
考题
单选题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.
考题
单选题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.
考题
单选题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 optionC
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
考题
单选题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.
考题
单选题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.
考题
单选题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
考题
单选题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.
考题
单选题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.
热门标签
最新试卷