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 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. （）
A banking user with the userid of ’joe’ is unable to rsh from SYSTEMA to SYSTEMB without having to retype their password， but they can rsh from SYSTEMB to SYSTEMA. No other users are experiencing the same issue.
Both systems have a /home/joe/.rhosts file that contain the proper references to the other host. The /home/joe/.rhosts files on both SYSTEMA and SYSTEMB are owned by userid ’joe’.
Which of the following is the most likely cause of 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?（）
A customer with a well-known brand wants to make sure they have a Green decision in their next IT infrastructure investment.
How can IBM Cool Blue help this customer？ （）
You are the administrator of your company’s network. You attempt to install a printer driver on a Windows 2000 computer for a user named Linda.
You receive the following error message： "Error 11-Cannot install printer driver."
The driver was originally downloaded from the printer manufacturer’s Web site. You have successfully used the driver in the past on their Windows 2000 Professional computers.
You want to configure Linda’s computer to check for driver integrity and to allow you to install this printer driver.
What should you do？ （）
You want to back up your 100-GB database on a remote tape device. You are required to ensure that minimum network bandwidth is consumed while transferring the backups to the tape device.
The current consumption of your CPU is approximately 40 percent.
Which type of backup should you perform？（）
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 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?（）
You administer a Windows 2000 Professional computer that is shared by multiple users. You receive a phone call from one of the users of the shared computer that tells you that the computer is reporting a kernel stop error. You notice that a user has tried to install video drivers that have caused the computer to become unstable. You want to ensure that users can install only the drivers that are approved by the manufacturer.
What should you do? （）
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.
Companycom wants to buy a new p5 570 running AIX 5.3. The applications require 4 processors and 8GB of memory. There is a requirement to have a Virtual IO Server.
What is the smallest p5 570 that should be sold to this customer?（）
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？ （）
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？（）
You are the network administrator for Company. to do an unattended installation so you create an Answer.txt file by using Setup Manager. The Answer.txt is copied to a floppy disk and you start the installation on a test computer by booting the computer with the Windows 2000 Professional CD-ROM. You insert the floppy disk after the computer starts. Although you had set the user interaction level to full unattended mode, you are prompted for all the required parameters. You want to ensure that the unattended installation upgrades the Windows 98 computers.
What should you do?（）
You are the administrator of Red Lington Enterprises. You want to upgrade 125 computers from Windows NT Workstation 4.0 to Windows 2000 Professional. You create an unattend.txt file by using the setup manager.
You copy the file to a floppy disk. You then start the installation on a computer in the test lab using the Windows 2000 Professional CD-ROM. After the computer starts you insert the floppy disk. Even though you set the user interaction level to full-unattended mode you are prompted for all the configuration parameters. You want to ensure that the unattended installation does not prompt you for input.
What should you do？ （）
A customer wants to purchase an IBM System Storage DS8700 to support a high-performance database environment.
Which technical solution gives the customer the best relationship between I/O performance at the machine’s backend vs. capacity installed in the machine（）
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（）
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（）
免费的网站请分享给朋友吧