1Z0-032
单选题What is the purpose of importing from an export，and specifying that no rows be imported and that the output goes to a log file？（）A To verify space requirements in the target database before importing.B To generate the SQL for the DDL operations that wo
题目
To verify space requirements in the target database before importing.
To generate the SQL for the DDL operations that would occur during import.
To check character set compatibility between the export file and the target database.
To check for integrity constraint violations that would occur in the target database.
相似问题和答案
第1题：
A. The import operation must be performed by a user on the target database with the DATAPUMP_IMP_FULL_DATABASE role, and the database link must connect to a user on the source database with the DATAPUMP_EXD_FULL_DATABASE role.
B. All the user-defined tablespaces must be in read-only mode on the source database.
C. The export dump file must be created before starting the import on the target database.
D. The source and target database must be running on the same platform with the same endianness.
E. The path of data files on the target database must be the same as that on the source database.
F. The impdp operation must be performed by the same user that performed the expdp operation.
第2题：
You issue this statement：ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What does the statement generate？（）
- A、A text copy of the control file.
- B、A binary copy of the control file.
- C、A file containing a SQL statement which will re-create the database.
- D、A file containing a SQL statement which will re-create the control file.
正确答案:D
第3题：
A. Creating the control file for the duplicate database
B. Restoring the target data files to the duplicate database
C. Performing complete recovery using all available backups
D. Generating a new, unique DBID for the duplicate database
E. Copying the online redo log files from the target database to the duplicate database
第4题：
Your archive-log destination directory runs out of space. What is the impact of this on the database?（）
- A、None. The database will switch over to the stand-by archive-log destination directory.
- B、A warning message will be written to the alert log of the database, but no adverse impacts to the database will be experienced.
- C、The database will shut down, and will not restart until you correct the out-of-space situation.
- D、The database will continue to try to write to the archive-log destination directory for one hour. After one hour, the database will shut down normally.
- E、Once Oracle has cycled through all online redo logs, it will stop processing any DML or DDL until the out-of-space condition is corrected.
正确答案:E
第5题：
After performing a clean shut down of the database instance for maintenance， you mount the database andthen execute a command to open the database：SQL> ALTER DATABASE OPEN； Which two statements are true（）
- A、The online redo log files and online data files are opened.
- B、All the online data file headers are checked for consistency.
- C、Instance recovery is performed before opening the database.
- D、The path and existence of all the log file members are checked
正确答案:A,B
第6题：
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.
第7题：
Examine the following command:ALTER SYSTEM SET enable_ddl_logging=FALSE;Which statement is true?（）
- A、None of the data definition language (DDL) statements are logged in the trace file.
- B、Only DDL commands that resulted in errors are logged in the alert log file.
- C、A new log.xml file that contains the DDL statements is created, and the DDL command details are removed from the alert log file.
- D、Only DDL commands that resulted in the creation of new database files are logged.
正确答案:A
第8题：
Examine the following scenario:The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the same host, using the Recovery Manager (RMAN) duplicate command as follows:Which statement is true about the duplicate database in this scenario?（）
A. It contains data till the last backup
B. It contains all data from target database until the current time
C. It contains all data from only the committed transactions in the target database
D. It contains all data except that which is used by the transactions in the current online redo file of target database
第9题：
Because of hardware failure， you decided to drop a redo log member from the database. Which condition should be met to drop a redo log file？（）
- A、 The redo log file should belong to an active group.
- B、 The redo log file should belong to an inactive group.
- C、 The redo log file should belong to the current group.
- D、 The redo log file can be dropped only if all the transactions are stopped.
- E、 Before a redo log file is dropped， it should be deleted from the operating system （OS）.
正确答案:B
第10题：
A redo log file is corrupted while the database is open； as a consequence， database operations are stopped because archiving cannot continue. What would you do to solve the problem？（）
- A、 clear the redo log group
- B、 perform redo log file import
- C、 perform an incomplete recovery
- D、 perform a redo log recovery using Recovery Manager （RMAN）
- E、 shut down the database and open the database in the NOARCHIVELOG mode
正确答案:A