IBM(000-237)
单选题When the clverify utility is run，verification checks use ODM data provided by the common communication infrastructure. This provides efficient access to configuration ODMs from the other nodes. The utility manages these files by storing the copies in v
题目
A successful completion of clverify
A problem with the clverify utility
All nodes agree on active configuration
Configuration differences between current and last successful clverify
相似问题和答案
第1题：
You are the network administrator for The network consists of asingle Active Directory domain named All domain controllers runWindows Server 2003, and all client computers run Windows XP Professional. Eachdomain server has a locally attached tape device.You need to back up each domain controller. Your backup process must fulfil thefollowing requirements:a. System recovery must be possible in the event of server failure.b. The system configuration and all current dynamic disk configurations must bebacked up.c. Other data partitions do not need to be backed up.What should you do?（）
A. Use the Backup utility to back up the system files and to create an Automated System Recovery (ASR) disk.
B. Use the Backup utility to back up the contents of all mounted drives.
C. Use the Backup utility to back up only the System State data.
D. Use the Copy command to copy C:\windows and its subfolders to a shared folder on the network.
E. Use the Xcopy command to copy C:\windows and its subfolders to a shared folder on the network.
第2题：
You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance， you plan to move the data from the flat files to clustered tables in an Oracle database.While migrating the data， you want to have minimal impact on the database performance and optimize the dataload operation. Which method would you use to load data into the Oracle database（）
- A、Use the external table population.
- B、Use the Oracle Data Pump export and import utility.
- C、Use the conventional path data load of the SQL*Loader utility.
- D、Use the INSERT INTO...SELECT command to load the data
正确答案:C
第3题：
The kernel is the(66)of an operating system such as Windows98, Windows NT, Mac OS or Unix. The kernel provides basic services for the other parts of the operating system,(67)it possible for it to run several programs at once(multitasking), read and write files and connect to networks and peripherals. Applications and utility programs use the services provided by the kernel to provide practical business functionality.
In operating systems such as Windows or most versions of Unix, the kernel(68)everything except application and utility programs.
In microkernel operating systems such as Digital Unix and Apples forthcoming Mac OS Server, the kernel(69)supports only multitasking and memory management. Other services such as applications, utilities and the user interface support device drivers, API and graphics which all(70)outside the microkernel.
A．nucleus
B．center
C．core
D．heart
第4题：
Which two statements are true regarding Oracle Data Pump（）
- A、EXPDP and IMPDP are the client components of Oracle Data Pump.
- B、DBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients.
- C、Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.
- D、Oracle Data Pump imports can be done from the export files generated in the export utility of previous versions.
- E、EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands.
正确答案:A,B
第5题：
You have a large amount of historical data in a flat file. Some analysts in your organization need toquery this data in the file. The file is too large to load the data in it into your current database. Which is the most effective method to access this data in your database（）
- A、Use the database link.
- B、Use the SQL*Loader utility.
- C、Use the Oracle Data Pump utility.
- D、Create an external table and leave the data in the flat file
正确答案:D
第6题：
You are the network administrator for The network consists of a single Active Directory domain named All network servers run Windows Server 2003. All user files are stored in home folders on a member server named Testking3. Full backups are performed on Testking3 every day. A user named Mark leaves the company. A technical support specialist deletes Mark's user account and his files. You need to restore certain files from Mark's folder and enable another user named Anne to access them. What should you do?（）
- A、Clear the Restore security check box. Use the Backup utility to restore Mark's files to the original location.
- B、Select the Restore security check box. Use the Backup utility to restore Mark's files to the original location.
- C、Clear the Restore security check box. Use the Backup utility to restore Mark's files to Anne's home folder.
- D、Select the Restore security check box. Use the Backup utility to restore Mark's files to Anne's home folder.
正确答案:C
第7题：
When the clverify utility is run，verification checks use ODM data provided by the common communication infrastructure. This provides efficient access to configuration ODMs from the other nodes. The utility manages these files by storing the copies in various directories depending on the success or failure of the verification pass. By default，this directory is "/var/hacmp/clverify/current/nodename/ if the ’current’ directory still exists when clverify stops running，this indicates which of the following？（）
- A、 A successful completion of clverify
- B、 A problem with the clverify utility
- C、 All nodes agree on active configuration
- D、 Configuration differences between current and last successful clverify
正确答案:B
第8题：
You are the administrator of a SQL Server 2000 computer in your company's personnel department. Employee data is stored in a SQL Server 2000 database. A portion of the database schema is shown in the exhibit.
You want to create a text file that lists these data columns in the following format title, FirstName, LastName, WorkPhone, PositionName, DepartmentName.
You want to create the text file as quickly as possible. You do not expect to re-create this file, and you want to avoid creating new database objects if possible.
What should you do?
A．Use the bcp utility to export data from each table to a separate text file. Use format files to select the appropriate columns. Merge the data from each text file into a single text file.
B．Create a view that joins data from all three tables include only the columns you want to appear in the text file. Use the bcp utility to export data from the view.
C．Create a SELECT query that joins the data from the appropriate columns in the three tables. Add an INTO clause to the query to create a local temporary table. Use the bcp utility to export data from the local temporary table to a text file.
D．Create a SELECT query that joins the data from the appropriate columns in the three tables. Add an INTO clause to the query to create a global temporary table. Use the bcp utility to export data from the global temporary table to a text file.
解析：Explanation:Asthecolumnsthatwewantinthetextfileareondifferenttablesinthedatabase,wewouldhavetocombinethecolumnintoatableorview.Becausewewillnotneedtoreproducethefile,wecanwecancombinethecolumnfromthevarioustablesintoaglobaltemporarytablebyusingtheSELECTINTOstatement.Thenweusethebcputilitytoexportthedatafromtheglobaltemporaryfiletoatextfile.Note:Temporarytablesarenotstoredinthecurrentdatabase;theyarestoredinthetempdbsystem.Therearetwotypesoftemporarytables:localtemporarytables,whicharevisibleonlytotheconnectionthatcreatedthem,andglobaltemporarytables,thatarevisibletoallconnections.Ifglobaltemporarytablesarenotdroppedexplicitlybeforetheconnectionthatcreatedthemdisconnects,theyaredroppedassoonasallothertasksstopreferencingthem.Nonewtaskscanreferenceaglobaltemporarytableaftertheconnectionthatcreateditdisconnects.ThebcputilitycopiesdatabetweenaninstanceofSQLServer2000andadatafileinauser-specifiedformat.ItcanbeusedtotransferdatafromaSQLServertabletoadatafileforuseinotherprograms.Furthermore,datacanalsobetransferredoutbyspecifyingaSELECTstatement.Thebcputilitycanuseglobaltemporarytables,butnotlocaltemporarytables.IncorrectAnswers:A:CreatingaglobaltemporarytablebyusingtheSELECTstatementandusingthebcputilitytoexportdatafromthattablewouldrequirelessadministrativeeffortthanusingbcptoexporttherequiredcolumnsfromeachtableintoaseparatetextfileandthenmergingthosetextfilesintoasingletextfile.B:Becausewewouldnotneedtore-createthedatafileagain,itwouldbeeasiertousetheSELECTstatementtocreateaglobaltemporarytableasthesetablesaredroppedautomaticallywhennothingreferencethem.C:Thebcputilitycannotuselocaltemporarytables.Note:Temporarytablesarenotstoredinthecurrentdatabase;theyarestoredinthetempdbsystem.Therearetwotypesoftemporarytables:localtemporarytables,whicharevisibleonlytotheconnectionthatcreatedthem,andglobaltemporarytables,thatarevisibletoallconnections.
第9题：
For which two tasks would it be best NOT to use the utility SQL*Loader？（）
- A、When loading selected rows into each table.
- B、When loading data from an export dump file.
- C、When loading data from disk， tape， or named pipes.
- D、When your data is NOT being inserted from a flat file.
- E、When using a record management system to access data files.
正确答案:B,D
第10题：
You are using flat files as the data source for one of your data warehousing applications. To optimizethe application performance， you plan to move the data from the flat files toclustered tablesin an Oracle database. While migrating the data， you want to have minimal impact on the database performance and optimize thedata load operation. Which method would you use to load data into the Oracle database（）
- A、Use the external table population.
- B、Use the Oracle Data Pump export and import utility.
- C、Use the conventional path data load of the SQL*Loader utility.
- D、Use the INSERT INTO...SELECT command to load the data.
正确答案:C