niusouti.com

单选题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

题目
单选题
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 would occur during import.

C

To check character set compatibility between the export file and the target database.

D

To check for integrity constraint violations that would occur in the target database.

相似考题

1.Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN)while duplicating a running database?()A. Creating the control file for the duplicate databaseB. Restoring the target data files to the duplicate databaseC. Performing complete recovery using all available backupsD. Generating a new, unique DBID for the duplicate databaseE. Copying the online redo log files from the target database to the duplicate database

2.Examine the following impdp command to import a database over the network from a pre－12c Oracledatabase (source): Which three are prerequisites for successful execution of the command?()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.

3.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.

4.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 backupB. It contains all data from target database until the current timeC. It contains all data from only the committed transactions in the target databaseD. It contains all data except that which is used by the transactions in the current online redo file of target database

更多“单选题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”相关问题

  • 第1题：

    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

  • 第2题：

    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

  • 第3题：

    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

  • 第4题：

    You executed the following query in your database：  FROM V$FLASHBACK_DATABASE_LOG;  What would you determine from the output？（）

    • A、the time when the last flashback operation in your database was performed
    • B、the time when the first flashback operation in your database was performed
    • C、a list of flashback operations performed in your database using SCN and time
    • D、the approximate time and the lowest system change number （SCN） to which you can flash back your database

    正确答案:D

  • 第5题：

    Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN) whileduplicating a running database? （）(Choose Two)

    • 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

    正确答案:C,E

  • 第6题：

    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 Dworks in the instance. The Dworks database has a table named Orderthings. According to the company requirement, you have to export all data from the Orderthings table to a file. During the export, you must make sure that the data export process is saved for reuse and a Microsoft Office Open XML document format is used. What should you do?（）  

    • A、You should run the bulk copy program utility along with an output file and no format file
    • B、You should run the SQLCmd utility and save the output to a file
    • C、You should run the SQL Import and Export Data Wizard and save the output to a file.
    • D、You should run the bulk copy program utility along with a format file and an output file.

    正确答案:C

  • 第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.


    正确答案： D
    解析： 暂无解析

  • 第8题：

    单选题
    You are responsible for importing data into SQL Server 2005 databases.Your department is starting to receive text files that contain sales transactions from stores across the country. Columns in the data are separated by semicolons.You need to import the files into the sales database. What should you do？（）
    A

    Create a custom format file， specifying a semicolon as the row terminator.

    B

    Use the bcp command， specifying a semicolon as the field terminator.

    C

    Use the bcp command with the default arguments.

    D

    Use the BULK INSERT statement with the default arguments.


    正确答案： A
    解析： 暂无解析

  • 第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）.


    正确答案： A
    解析： 暂无解析

  • 第10题：

    单选题
    You work at the regional sales office. You are responsible for importing and exporting data in SQL Server 2005 databases. The main office asks you to send them a text file that contains updated contact information for the customers in your region. The database administrator in the main office asks that the data be sorted by the StateProvince，Surname， and FirstName columns.You need to satisfy these requirements by using the least amount of effort. What should you do？（）
    A

    Specify StateProvince， Surname， and FirstName in the ORDER hint in the bcp out command.

    B

    Create a format file for the export operation.

    C

    Specify StateProvince， Surname， and FirstName in the ORDER BY clause in the bcp queryout command.

    D

    Copy the data into a new table that has a clustered index on StateProvince，Surname，and FirstName. Export the data.


    正确答案： B
    解析： 暂无解析

  • 第11题：

    单选题
    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 would occur during import.

    C

    To check character set compatibility between the export file and the target database.

    D

    To check for integrity constraint violations that would occur in the target database.


    正确答案： D
    解析： 暂无解析

  • 第12题：

    单选题
    What is a feature of the Integration Framework?（）
    A

    Allow bulk importing of XML or flat files. 

    B

    Allow bulk importing from Excel spreadsheets.

    C

    Allow bulk importing from external/legacy system.

    D

    Allow bulk importing from one database platform to another.


    正确答案： A
    解析： 暂无解析

  • 第13题：

    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

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

    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 would occur during import.
    • C、To check character set compatibility between the export file and the target database.
    • D、To check for integrity constraint violations that would occur in the target database.

    正确答案:C

  • 第17题：

    Which two operations are NOT performed by the DUPLICATE command in Recovery Manager （RMAN） while duplicating a running database？（）

    • 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

    正确答案:C,E

  • 第18题：

    You are responsible for importing data into SQL Server 2005 databases.Your department is starting to receive text files that contain sales transactions from stores across the country. Columns in the data are separated by semicolons.You need to import the files into the sales database. What should you do？（）

    • A、Create a custom format file， specifying a semicolon as the row terminator.
    • B、Use the bcp command， specifying a semicolon as the field terminator.
    • C、Use the bcp command with the default arguments.
    • D、Use the BULK INSERT statement with the default arguments.

    正确答案:B

  • 第19题：

    单选题
    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.


    正确答案： A
    解析： 暂无解析

  • 第20题：

    单选题
    You administer a SQL Server 2008 instance. You plan to deploy a new database to the instance. The database will be subject to frequent inserts and updates. The database will have multiple schemas. One of the schemas will contain a large amount of read-only reference data. You need to design the physical database structure for optimal backup performance. What should you do?（）
    A

    Create the database by using a single data file and a single log file.

    B

    Create the database by using a single data file and multiple log files.

    C

    Create the database by using a single log file and multiple filegroups.

    D

    Create the database by using a single log file and a filegroup that has multiple data files.


    正确答案： B
    解析： 暂无解析

  • 第21题：

    单选题
    You executed the following query in your database：  FROM V$FLASHBACK_DATABASE_LOG;  What would you determine from the output？（）
    A

    the time when the last flashback operation in your database was performed

    B

    the time when the first flashback operation in your database was performed

    C

    a list of flashback operations performed in your database using SCN and time

    D

    the approximate time and the lowest system change number （SCN） to which you can flash back your database


    正确答案： D
    解析： 暂无解析

  • 第22题：

    单选题
    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
    解析： 暂无解析

  • 第23题：

    单选题
    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 Dworks in the instance. The Dworks database has a table named Orderthings. According to the company requirement, you have to export all data from the Orderthings table to a file. During the export, you must make sure that the data export process is saved for reuse and a Microsoft Office Open XML document format is used. What should you do?（）
    A

    You should run the bulk copy program utility along with an output file and no format file

    B

    You should run the SQLCmd utility and save the output to a file

    C

    You should run the SQL Import and Export Data Wizard and save the output to a file.

    D

    You should run the bulk copy program utility along with a format file and an output file.


    正确答案： B
    解析： 暂无解析

  • 第24题：

    单选题
    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.


    正确答案： C
    解析： 暂无解析

相关内容