Modify the profile assigned to the user.
Modify the roles assigned to the users.
Modify the object privileges assigned to the user.
Modify the system privileges assigned to the users.
Modify the value for the RESOURCE_LIMIT parameter in the parameter file.
第1题:
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
第2题:
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?()
第3题:
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.
第4题:
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?()
第5题:
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()
第6题:
Which three of the following are components of a syslog message? ()(Choose three.)
第7题:
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?()
第8题:
A. Resumable set for session with sid 18
B. The user session has entered into a deadlock
C. The database instance is enabled to use asynchronous commit
D. The threshold warning limit is exceeded for the tablespace that is used by the user session
第9题:
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?()
第10题:
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?()