1Z0-032
单选题What criterion does Oracle9i use to determine whether a database file is an Oracle Managed File？（）A The filename format. B Information stored inside a data dictionary table. C Information stored in the ALERT.LOG file for the corresponding instance. D I
题目
The filename format.
Information stored inside a data dictionary table.
Information stored in the ALERT.LOG file for the corresponding instance.
Information stored inside the corresponding initialization parameter file for the instance.
相似问题和答案
第1题：
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.
第2题：
B. database management system
C.data storage
D.data entities
第3题：
A. You can use RMAN stored scripts
B. Recovery is faster if data is stored in catalog in addition to the control file
C. You can store backup information of all registered databases in one place
D. Database backups are automatically deleted when they are older than the specified time period
第4题：
The operating system filecratabin the Linux platform gets updated whenever you create a new database on the same host machine. What kind of information is stored is stored in this file？（）
- A、OracleSIDsonly
- B、Oracle homes only
- C、Oracle install timestamp
- D、Oracle inventory pointer files
- E、Oracle database creation timestamp
- F、OracleSIDsand Oracle homes only
- G、OracleSIDs， Oracle homes and flag for auto startup
正确答案:G
第5题：
Identity two advantages of using a recovery catalog in-load of the control File of the target database Recovery Manager （RMAN）.（）
- A、 You can use RMAN stored scripts.
- B、 Recovery is faster if data is stored in catalog in addition to the control file.
- C、 You can store backup Information of all registered databases in one place.
- D、 Database backups are automatically deleted when they are older than the specified time period.
正确答案:A,C
第6题：
B .data access objects
C. database connection
D. data access logic
第7题：
The operating system file cratab in the Linux platform gets updated whenever you create a new database on the same host machine. What kind of information is stored is stored in this file？（）
- A、OracleSIDsonly
- B、Oracle homes only
- C、Oracle install timestamp
- D、Oracle inventory pointer files
- E、Oracle database creation timestamp
- F、OracleSIDsand Oracle homes only
- G、OracleSIDs， Oracle homes and flag for auto startup
正确答案:G
第8题：
A. You can use RMAN stored scripts
B. Recovery is faster if data is stored in catalog in addition to the control file
C. You can store backup information of all registered databases in one place
D. Database backups are automatically deleted when they are older than the specified time period
第9题：
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
第10题：
You are working as a DBA on Oracle Database 9i. You plan to upgrade your 9i database to Oracle 10g. To be familiar with the new database technology， you decide to install Oracle Database 10g on your workstation at home. You create a general purpose database. After the installation， you make the following changes in your initialization parameter file：LOG_ARCHIVE_DEST_1=’LOCATION=USE_DB_RECOVERY_FILE_DEST’ DB_RECOVERY_FILE_DEST = ’LOCATION=d：/product/10.1.0/flash_recovery_area’ DB_RECOVERY_FILE_DEST_SIZE=10g Where are the archived redo logs stored for your database？（）
- A、 The archived redo logs are stored in an operating system-dependent location.
- B、 The archived redo logs are stored in the location specified by LOG_ARCHIVE_DEST_1.
- C、 The archived redo logs are stored in the location specified by DB_RECOVERY_FILE_DEST.
- D、 The archived redo logs are stored in the locations specified by both LOG_ARCHIVE_DEST_1 and DB_RECOVERY_FILE_DEST.
正确答案:C