User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK，or any data definition language （DDL） command：
SQL> SELECT job FROM emp
2 WHERE job=’CLERK’ FOR UPDATE OF empno;
SCOTT has opened another session to work with the database. Which three operations would wait when issued in SCOTT’s second session？（）
You issued the following command to analyze the SCOTT.EMP table for block corruption：
ANALYZE TABLE SCOTT.EMP VALIDATE STRUCTURE； You received the following error：
ORA-01578： ORACLE data block corrupted （file # %s， block # %s）
How will you resolve the block corruption problem？（）
User SCOTT wants to perform a bulk insert operation in the EMP_DEP table. SCOTT receives the followingerror after the INSERT statement is issued and few rows are inserted：INSERT INTO EMP_DEP （emp_id，name，salary，dep_name，mgr_id） *ERROR at line 1：
ORA-01653： unable to extend table SCOTT.EMP_DEP by 128 in tablespace USERS Identify two actions eitherof which will help you resolve this problem. （）
You have a computer that runs Windows XP Professional. Two users named User1 and User2 share the computer. User1 and User2 encrypt files on the computer. User1 encrypts a file named file1. doc. You need ensure that both User1 and User2 can view the contents of file1. doc.
What should you instruct User1 to do?（）
You want to check the details of few errors that users have reported. You search for the alert log fileand execute few commands to find the location of the alert log file. View the Exhibit and check the commands executed.
What is the location of the alert_orcl.log file（）
Given that Triangle implements Runnable， and：
Which two statements， inserted independently at both lines 35 and 41， tend to allow both threads to temporarily pause and allow the other thread to execute？（）
Given that Triangle implements Runnable， and：
Which two statements， inserted independently at both lines 35 and 41， tend to allow both threads totemporarily pause and allow the other thread to execute？（）
You are designing a top-level OU structure to meet the business and technical requirements.
Which top-evel OU or OUs should you use？ （）
You are the administrator of a Windows 2000 network. You use a user account named Hans1 to log on to a Windows 2000 Professional computer named Company1 that is used by different students in a classroom. Hans1 is a user with administrative rights. Another administrator has created a command file named AddUsers.cmd that automatically adds student user accounts. You have scheduled a task on Company1 to run AddUsers.cmd later in the evening. The next day you find that the job did not run. There are no errors reported in the Event Log. You want to schedule a task to successfully run AddUsers.cmd.
What should you do? （）
You are a network administrator for ExamSheet.net's Windows 2000 network.
You use a user account named User1 to log on tot a Windows 2000 Professional computer. The computer is used by different students in a classroom. User1 does not have administrative rights. However, you prefer to use this account for your daily activities. Using the Task Scheduler you schedule a task to run a command file named AddUsers.cmd that automatically adds six more student user accounts. You configure the task to run as the administrator account.
After the task was scheduled to have run you open the Task Scheduler and discover a status of "Could not start" for the task. You also discover account logon failure audit events in the computer's Security log.You want the scheduled task to successfully run AddUsers.cmd. You want to accomplish this with the least amount of administrative effort.
What should you do?（）
You are employed as the Exchange administrator at Company.com.You are in the process of
installing a new Exchange Server 2010 Organization.After the installation you send a text message to an external client and receive the subsequent non-delivery report （NDR）： "Delivery has failed to these recipients or groups： [email protected] （[email protected]）.The recipient’s e-mail system isn’t accepting messages now.Please try resending this message later or contact the recipient directly." You attempt to e-mail the user from an external e-mail system with great success.To ensure productivity you need to make sure e-mails can be sent to external clients from within the organization.
What should you do？（）
You are the administrator of Etechsol.com Enterprises. Your company consists of a small 20-user network. Management has decided to upgrade all computers to Windows 2000.
After having a closer examination of your company’s network, you realize that only half of the network interface cards are Net PC compliant. You decide to create Windows 2000 remote boot floppies.
What executable is used for creating RIS boot disks for non-PXE compliant clients?（）
You have two computers named Computer1 and Computer2 that run Windows 7. Computer1 has two localuser accounts named User1 and User2. On Computer1, you run Scanstate.exe /all \\server1\data \computer1. On Computer2, you run Loadstate.exe /lac:Pa$$w0rd \\server1\data\computer1. You need toensure that User1 and User2 can log on to Computer2.
What should you do on Computer2?（）
A user is unable to determine the default system text editor.
How can the local administrator assist the user by identifying the default text editor for the system？（）
All client computers in your network run Windows 7 Enterprise.
You need to prevent all standard user accounts from running programs that are signed by a specific publisher.
What should you do？（）
You have a server named Server1. Server1 runs Windows Server 2012 R2. A user named Admin1
is a member of the local Administrators group. You need to ensure that Admin1 receives a User Account Control （UAC） prompt when attempting to open Windows PowerShell as an administrator.
Which setting should you modify from the Local Group Policy Editor？ To answer， select the appropriate setting in the answer area.
At the request of a user， you issue the following command to restore a dropped table： flashback table "BIN$F2JFfMq8Q5unbC0ceE9eJg==$0" to before drop； Later， the user notifies you that the data in the table seems to be very old and out of date.
What might be the problem？（）
A customer would like to share the processor resources automatically between logical partitions.
Which of the following would accomplish this requirement without user interaction？ （）
You are planning a Windows 7 deployment infrastructure for a new company.
You have the following requirements：
Three domains
10，000 client computers No user interaction
You need to recommend a deployment infrastructure.
What should you recommend？（）
Your company has a single Active Directory Domain Services （AD DS） domain and 1，000 Windows 7 computers.
You are planning to deploy a custom application.
You need to schedule the deployment to occur outside of business hours and without user interaction.
Which deployment method should you choose？（）
In Recovery Manager （RMAN）， you set the retention policy to NONE by executing the following command：
CONFIGURE RETENTION POLICY TO NONE;
What would be the impact of this setting？（）
In your production database， data manipulation language （DML） operations are executed on theSALES table. You have noticed some dubious values in the SALES table during the last few days. Youare able to track users， actions taken， and the time of the action for this particular period but the changesin data are not tracked. You decide to keep track of both the old data and new data in the table along withthe user information.
What action would you take to achieve this task（）
In your production database， data manipulation language （DML） operations are executed on the SALES table.You have noticed some dubious values in the SALES table during the last few days. You are able to track
users， actions taken， and the time of the action for this particular period but the changes in data are not tracked.You decide to keep track of both the old data and new data in the table along with the user information.
Whataction would you take to achieve this task（）
User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK，or any data definition language （DDL） command：
SQL> SELECT job FROM emp
2 WHERE job=’CLERK’ FOR UPDATE OF empno;
SCOTT has opened another session to work with the database. Which three operations would wait when issued in SCOTT’s second session？（）
User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK， or any data definition language （DDL） command： SQL> SELECT ename FROM emp
2 WHERE job=’CLERK’ FOR UPDATE OF empno；
SCOTT has opened another session to work with the database instance.
Which three operations wouldwait when issued in SCOTT’s second session（）
You want to enable the user， Scott， to change to the GRP1 consumer group by issuing the following code：
SQL> EXEC DBMS_SESSION.SWITCH_CURRENT_CONSUMER_GROUP
（’SCOTT’， ’GRP1’， FALSE）；
How will you grant the switch privilege to the user， Scott？（）
User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK， orany data definition language （DDL） command：
SQL> SELECT ename FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno；
SCOTT has opened another session to work with the database instance.
Which three operations would waitwhen issued in SCOTT’s second session（）
Which statement is true regarding the effect of this command on the transaction in Scott’s session（）
In which two scenarios should you issue the following command？（）
FLASHBACK TABLE SCOTT.EMP TO TIMESTAMP SYSTIMESTAP- INTERVAL ’15’ MINUTE；
You executed the following command to drop a user：
DROP USER scott CASCADE；
Which two statements regarding the above command are correct？（）
Your database is running in ARCHIVELOG mode. The SCOTT.EMP table belongs to the DATA1 tablespace. The junior DBA erroneously runs a script that executes the following statement：
SQL> DROP TABLE SCOTT.EMP PURGE；
After one hour， you are performing the user managed incomplete recovery. Which datafiles will you restore from the last full backup？（）
View the Exhibit and examine the privileges granted to the SL_REP user.
The EMP table is owned by the SCOTT user. The SL_REP user executes the following command: SQL> GRANT SELECT ON scott.emp TO hr;
Which statement describes the outcome of the command（）
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（）
免费的网站请分享给朋友吧