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？（）
Your network contains an Active Directory domain. All servers run Windows Server 2008 R2.
You need to audit the deletion of registry keys on each server.
What should you do（）
An administrator performs a Live Partition Mobility operation. After the operation completes， the administrator runs errpt -a.
What is the machine ID reported by errpt command？（）
You are the desktop administrator for ExamSheet.
Your Windows 2000 Professional computer is configured to support two monitors. You install a DOS-based application on your computer. The application uses the Windows 2000 Professional default settings Autoexec.nt and Config.nt.
Your primary video adapter is set to 24 bit color, 800 x 600 resolution, and default refresh rates. Your secondary video adapter is set to 32 bit color, 1024 x 768 resolution, and a refresh refresh of 72 hertz. You create a shortcut for the DOS-based application on the secondary monitor's desktop and use the
default PIF settings. You attempt to run the DOS-based application on the secondary monitor. The application opens, but the display area is scrambled. You then attempt to run the DOS-based application on the primary monitor.
The application does not open. Both monitors function correctly when you run Windows based applications.
You want to be able to run the DOS-based application on either monitor.
What should you do?（）
You are the desktop administrator for ExamSheet. Your Windows 2000 Professional computer is configured to support two monitors. You install a DOS-based application on your computer. The application uses the Windows 2000 Professional default settings Autoexec.nt and Config.nt.
Your primary and secondary video adapters are both set to 32 bit color, 800 x 600 resolution, and default refresh rates. You create a shortcut for the DOS-based application on the primary monitor's desktop and use the default PIF settings. You attempt to run the DOS-based application on the primary monitor. The application opens, but the display area is scrambled. You then attempt to run the DOS-based application on the secondary monitor. The application does not open. Both monitors function correctly when you run Windows based applications.
You want to be able to run the DOS-based application on either monitor. What should you do?（）
Your Windows 2000 Professional computer is configured to support two monitors. You install a DOS-based application on your computer. The application uses the Windows 2000 Professional default settings Autoexec.nt and Config.nt.
Your primary and secondary video adapter are both set to 16-bit color,1024x 768 resolution, and default refresh rates. You create a shortcut for the DOS-based application on the primary monitor’s desktop and use the default PIF settings.
Your attempt to run the DOS-based application on the primary monitor. The application opens, but the display area is scrambled. You then attempt to run the DOS-based application on the secondary monitor. The application does not open. Both monitors function correctly when you run Windows-based applications. 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 have a computer that runs Windows 7. The computer is in a workgroup. You need to ensure that youcan decrypt Encrypting File System (EFS) files on the computer if you forget your password.
What are two possible ways to achieve this goal?（）
Given：
12.Date date = new Date（）；
13.df.setLocale（Locale.ITALY）；
14.String s = df.format（date）；
The variable df is an object of type DateFormat that has been initialized in line 11.
What is the result if this code is run on December 14， 2000？（）
12. Date date = new Date（）；
13. df.setLocale（Locale.ITALY）；
14. String s = df.format（date）；
The variable df is an object of type DateFormat that has been initialized in line 11. What is the result if this code is run on December 14， 2000？（）
You are responsible for implementing maintenance jobs on a SQL Server 2005 database server. Certain jobs run every Sunday and other jobs run at the beginning of every month. You need to schedule the jobs in the way that uses the least amount of administrative effort.
What should you do？（）
Given the following RMAN commands，choose the option that reflects the order required to restore your currently operational ARCHIVELOG-mode database.（）
a. restore database
b. recover database
c. shutdown immediate
d. startup
e. restore archivelog all
f. alter database open
You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. There is a database named Inventory on a SQL Server 2005 computer， and the computer is named SQL01. SQL01 is utilized to aggregate manufacturing part numbers from your company’s trading partners. And the company stores the manufacturing part numbers in the Product table in the Inventory database. The company requests the users to deliver data as text files from each trading partner to SQL1 every night. The data should be imported， and no duplicate manufacturing part numbers should exist in the data which is imported from the text files， and the text files are stored in the Inventory database on SQL01. You should cut the effect on your company’s trading partners and your IT department to the least.
Which action should you perform？（）
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？（）
Which of the following commands will perform an active database duplication of the ORCL database to the ORCL2 database？（）
You have a server named Server1 that runs Windows Server 2003 Service Pack 2 （SP2）.
Server1 runs an application named App1. All client computers run Windows XP Professional Service Pack 3 （SP3）. Users from a remote network segment report poor performance when they run App1. You need to identify whether the cause of the poor network performance is packet loss.
Which tool should you use？（）
You have a computer that runs Windows 7. Your computer s disk configuration is shown in the exhibit.(Click the Exhibit button.) You need to ensure that you can create a striped volume on the computer.
What should you do?（）
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?（）
You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. In the database, a small percentage of data is modified everyday. Ever day in the morning, you have to create a read-only copy of the database for reporting purposes and make sure that you use as little disk space as possible.
In the options below, which strategy should you use?（）
You just completed a manual open database backup. However there seems to be a problem with the database performance. You discover that the database is generating many log switches and the LGWR is consuming lots of CPU time. You have an idea of what the problem is and you begin looking at the information in V$BACKUP and in V$DATAFILE_HEADER.
What do you suspect is the problem？（）
In your database instance， the STATISTICS_LEVEL initialization parameter is set to BASIC.
What isthe impact of this setting（）
What is the impact of the following backup if it exceeds the duration allowance？（）
Backup as compressed backupset duration 2：00 partial minimize load database ；
Company.com has a resource group that contains a database that is accessed by a web client based on another system. The communication to the database is TCP/IP. Occasionally after a failure， the end users get unusual error messages that indicate the database server is not available. It has been determined that the web server is trying to access the database server’s information before it has completed file system recovery after a failure.
How can HACMP affect this problem？（）
You are the administrator of a Microsoft Windows Server 2003 computer named Server1. SQL Server 2005 is installed on Server1 to host a database named MedDB. The MedDB database serves as the backend database for a new client/server application named MedDATA. Installation of the MedDATA application creates the database schema， application roles， and administrative accounts. It also sets all of the default permissions. You need to establish a permissions baseline for all objects in the MedDB database.
What should you do？（）
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？（）
You are working as a DBA on the decision support system. There is a business requirement to track and store all transactions for at least three years for a few tables in the database. Automatic undo management is enabled in the database.
Which configuration should you use to accomplish this task？（）
Your boss， Miss ，is interested in CEF.
What should you tell her？ （）
You work as a network technician at. Your boss， Mrs. ， is interested in the Spanning Tree Protocol timers.
What can you tell her regarding the default STP timers？ （）
You work as a network technician at Company. Your boss， Mrs.， is interested in LWAPP （Lightweight Access Point Protocol）.
What should you tell her regarding this technology？ （）
You work as a network technician at Company. Your boss， Mrs.， is interested in the Cisco Compatible Extensions program.
What are three features of this program？ （）
What is the end result of these commands if they are successful？（）
RMAN> show retention policy；
RMAN configuration parameters for database with db_unique_name
ORCL are： CONFIGURE RETENTION POLICY TO REDUNDANCY 1； # default
Backup database tag=gold_copy plus archivelog tag=gold_copy delete input； Backup
database tag=silver_copy plus archivelog tag=silver_copy delete input；
You are working as a Database Administrator. Despite having a password in the data dictionary as change_on_install， you always log on to the database MYNEWDB using operating system authentication. Your organization is planning to recruit two junior-level DBAs. You decide to enable remote authentication in your database so that the new DBAs can log on to the database from their workstations to carry out administrative tasks.
To allow the new DBAs to perform the administrative tasks， you create a password file on the database server using the following command：
ORAPWD file=d：\oracle\ora9i\orapwU01 password=admin entries=4
After creating the password file， you remove the operating system authentication and change the value of the REMOTE_LOGIN_PASSWORDFILE parameter to EXCLUSIVE. You also create a net service name as MYNEWDB that allows the new DBAs to connect to the database server from their workstations using this net service name. Which command must you use to connect to the database to start it？（）
A healthcare provider has two applications that they need to redundantly protect in a SAN environment. Their patient record application runs on Oracle 11i and consists of many small， randomly accessed files. The database is kept on three clustered Sun servers and currently uses 30 TB of data space. Their imaging application that retains and manages x-rays， consists of Filenet， CommonStore， and TSM running on an IBM Power750 server， and is currently using 65
TB of data space.
Which of the following disk solutions meets the customer’s requirement（）
免费的网站请分享给朋友吧