网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
When importing a table into a database，the import process performs these tasks： 1. Triggers are imported. 2. Data is imported. 3. New tables are created. 4. Indexes are built. 5. Any bitmap， functional， and/or domain indexes are built. 6. Integrity constraints are enabled on the new tables. Which option shows the tasks in the order in which they are performed？（）
A
2，3，4，1，6，5
B
3，2，4，1，6，5
C
3，2，6，4，1，5
D
4，2，3，1，5，6
参考答案
参考解析
解析：
暂无解析
更多 “单选题When importing a table into a database，the import process performs these tasks： 1. Triggers are imported. 2. Data is imported. 3. New tables are created. 4. Indexes are built. 5. Any bitmap， functional， and/or domain indexes are built. 6. Integrity constraints are enabled on the new tables. Which option shows the tasks in the order in which they are performed？（）A 2，3，4，1，6，5B 3，2，4，1，6，5C 3，2，6，4，1，5D 4，2，3，1，5，6” 相关考题
考题
Examine this command:SQL exec DBMS_STATS.SET_TABLE_PREFS (‘SH’, ‘CUSTOMERS’, ‘PUBLISH’, ‘false’);Which three statements are true about the effect of this command?()
A. Statistics collection is not done for the CUSTOMERS table when schema stats are gathered.B. Statistics collection is not done for the CUSTOMERS table when database stats are gathered.C. Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.D. Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.E. Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.
考题
You are the administrator of a SQL Server 2000 computer. You are creating a data transformation services package. As the first step in this process, you need to load data from text files into a database table. These text files contain data on new stores that join your franchise. The text files list the data columns in the following format StoreID, StoreName, Address, City, State, PostalCode, ManagerID, StoreTypeID, FacilityID.The destination table is configured as shown in the exhibit.You want to load the data into the table as quickly as possible. What should you do?A．Use a Bulk Insert Task to read the data into a temporary table. Use an Execute SQL task to import the appropriate data into the destination table.B．Create and edit a format file to select the columns you want to import. Use a Bulk Insert Task, and then specify the format file to import the appropriate data into the destination table.C．Use a transform. data task to import the data. Use Microsoft ActiveX transformation scripts to write the appropriate data to the appropriate columns in the destination table.D．Create and edit a format file to select the columns you want to import. Use a transform. data task, and then specify the format file to import the appropriate data into the destination table.
考题
When importing or exporting routing information using routing policy, the import or export is always done from which point of view?()
A. routing tableB. forwarding tableC. routing protocolD. neighbor or peer
考题
What does the OSPF command capability vrf-lite achieve？（）A、It enables provider edge （PE） specific checks on a router when the OSPF process is associated with the VRFB、It disables provider edge （PE） specific checks on a router when the OSPF process is associated with the VRFC、It enables the exchange of the "VRF-Lite" capability when the OSPF adjacency is formed.D、It disables the MPLS processing on the OSPF learned routes inside the VRF
考题
When BGP is used as the PE-CE routing protocol, which of these statements is correct?（）A、On the CE router, PE neighbors must be configured in the VRF context on the CE routerB、On PE routers, the CE IBGP neighbors are configured in the global BGP configurationC、On PE routers, the CE EBGP neighbors are configured in the VRF contextD、A separate BGP process must be used on the PE routers for CE routers so that they do not use the same BGP routing process as that used for the PE router's other provider neighbors
考题
You are planning to import customer data from the Customer table and the Country table in your SQL Server 2000 database into a SQL Server 2005 database. You want to ensure that during the import process，each value in the CountryCode column of the Customer table has a corresponding record in the CountryCode column in the Country table of the SQL Server 2005 database. You define a foreign key between these two tables. Thus，referential integrity will guarantee that the import routine fails if there are any records where a CountryCode value does not exist in the Country table but does exist in the Customer table. You need to ensure that the import process does not fail if records are encountered that do not exist in the Country table. What should you do？（）A、Drop the foreign key. Import the data by using the script. Re-create the foreign key.B、Create a CHECK constraint.C、Create a DML INSTEAD OF trigger that writes the failed records to a file or table.D、Create a DML AFTER trigger that writes the failed records to a file or table.
考题
What Oracle process runs when the database is in ARCHIVELOG mode but not when it is in NOARCHIVELOG mode？（）A、 MMONB、 LGWRC、 ARCHD、 ARWRE、 COPY
考题
In which scenario do you use the Flashback Database feature？（）A、 when a table is dropped and you restore it from the Recycle BinB、 when a user’s schema is dropped and you recover the user’s schemaC、 when some incorrect data is inserted in the table and you retrieve the table to a state that was at a certain timestampD、 when a row of a table is updated frequently and committed， and you view all the versions of the row within a specific duration
考题
You need to perform an online table redefinition of an existing SALES table to partition it into two tablespaces TBS1 and TBS2. The SALES table has a materialized view， materialized log， indexes， referential integrity constraint， and triggers with the PRECEDES clause existing on it. What action is required for dependent objects when you perform online table redefinition？（） A、 The dependent materialized view should have a complete refresh performed after the online table redefinition process.B、 Triggers with the PRECEDES clause should be disabled before the online table redefinition process.C、 Referential integrity constraints must be manually enabled after the online table redefinition process.D、 The materialized log should be dropped before the online table redefinition process.
考题
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.
考题
You need to cleanse and standardize the data on potential survey participants prior to inserting it into the staging database. What should you do?（）A、Import the data into a staging table by using the OPENROWSET BULK statement. Execute a Transact-SQL stored procedure to cleanse the data and to insert the data into the database.B、Import the data into a staging table by using the BULK INSERT statement. Execute a Transact-SQL stored procedure to cleanse the data and to insert the data into the database.C、Create a SQL Server Integration Services （SSIS） package to import， standardize， and cleanse the data.D、Create a CLR stored procedure to import the data into a staging table， to cleanse and standardize the data， and to insert the data into the database.
考题
单选题In which scenario do you use the Flashback Database feature？（）A
when a table is dropped and you restore it from the Recycle BinB
when a user’s schema is dropped and you recover the user’s schemaC
when some incorrect data is inserted in the table and you retrieve the table to a state that was at a certain timestampD
when a row of a table is updated frequently and committed， and you view all the versions of the row within a specific duration
考题
单选题When importing or exporting routing information using routing policy, the import or export is always done from which point of view?（）A
routing tableB
forwarding tableC
routing protocolD
neighbor or peer
考题
单选题You need to perform an online table redefinition of an existing SALES table to partition it into two tablespaces TBS1 and TBS2. The SALES table has a materialized view， materialized log， indexes， referential integrity constraint， and triggers with the PRECEDES clause existing on it. What action is required for dependent objects when you perform online table redefinition？（）A
The dependent materialized view should have a complete refresh performed after the online table redefinition process.B
Triggers with the PRECEDES clause should be disabled before the online table redefinition process.C
Referential integrity constraints must be manually enabled after the online table redefinition process.D
The materialized log should be dropped before the online table redefinition process.
考题
单选题Examine the following query output: You issue the following command to import tables into the hr schema: $ impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hr TRANSFORM=DISABLE_ARCHIVE_LOGGING: Y Which statement is true?（）A
All database operations performed by the impdp command are logged.B
Only CREATE INDEX and CREATE TABLE statements generated by the import are logged.C
Only CREATE TABLE and ALTER TABLE statements generated by the import are logged.D
None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged.
考题
单选题When importing a table into a database，the import process performs these tasks： 1. Triggers are imported. 2. Data is imported. 3. New tables are created. 4. Indexes are built. 5. Any bitmap， functional， and/or domain indexes are built. 6. Integrity constraints are enabled on the new tables. Which option shows the tasks in the order in which they are performed？（）A
2，3，4，1，6，5B
3，2，4，1，6，5C
3，2，6，4，1，5D
4，2，3，1，5，6
考题
多选题TestKing.com uses a SQL Server 2005 database. This database contains a trigger named trg InsertOrders， which fires when order data is inserted into the Orders table. The trigger is responsible for ensuring that a customer exists in the Customers table before data is inserted into the Orders table. You need to configure the trigger to prevent it from firing during the data import process. You must accomplish this goal while using the least amount of administrative effort. Which two Transact-SQL statements can you use to achieve this goal？（）AALTER TABLE OrdersDISABLE TRIGGER trg InsertOrdersBDROP TRIGGER trg InsertOrdersCDISABLE TRIGGER trg InsertOrders ON OrdersDALTER TRIGGER trg InsertOrders ON Orders NOT FOR REPLICATION
考题
多选题Examine this command: SQL exec DBMS_STATS.SET_TABLE_PREFS (‘SH’, ‘CUSTOMERS’, ‘PUBLISH’, ‘false’); Which three statements are true about the effect of this command?（）AStatistics collection is not done for the CUSTOMERS table when schema stats are gathered.BStatistics collection is not done for the CUSTOMERS table when database stats are gathered.CAny existing statistics for the CUSTOMERS table are still available to the optimizer at parse time.DStatistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics.EStatistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.
考题
单选题In your test database， you have created the ORDERS table as an index-organized table （IOT）. To facilitate faster querying， you have created a mapping table and a bitmap index on the ORDER_FILLED column. You observe that the query performance degrees when users perform a large volume of transactions. While investigating the reason， you find that the mapping table segment is fragmented， leading to poor performance. Which option would you use to defragment the mapping table without affecting the original table data？（）A
Export and import the mapping table.B
Drop and re-create the mapping table.C
Truncate the mapping table and reinsert the values.D
Use the ALTER TABLE .. REBUILD command to defragment the mapping table.
考题
多选题You work as a database administrator for Certkiller .com. One of the database users accidentally deleted all the rows of a critical table and committed the delete at 1：30 p.m. You senior database administrator， Certkiller， asks you to retrieve the lost data. Which two actions would you use to ensure that there is no impact on other connected users while retrieving the deleted rows？（）AUse a flashback query to retrieve the rows that were deletedBUseconventialincremental export and then import the affected objectCShutdown the database inNORMALmode and restart the database instanceDUse DBMS_META package to reconstruct the object using undo segmentsEUseTablespacePoint in Time Recovery （TSPITR） method to recover the table and the dataFUse Oracle DataPumptwithflashback_timeoption toentableflashback export and then import the affected object.
考题
单选题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.
考题
单选题You execute the following command in your Certkiller .com production database to change the width of the CUST_NAME column of the CUSTOMERS table： ALTER TABLE customers MODIFY （cust_nameVARCHAR2 （40）） / When you execute the command， it displays the following error message： ERROR at line 1： ORA-00054： resource busy and acquire with NOWAIT specified What could be the reason for the error message？（）A
The database instance is not available.B
The ALTER TABLE command does not have WAIT optionC
The table or a row in the table is currently locked by another user session.D
The database instance is busy processing other user sessions commands.E
The CUSTOMERS table has no long running query active at the time when this request is made.F
The server process executing the ALTER TABLE command is busy with another command execution
考题
单选题In your test database， you have created the ORDERS table as an index-organized table （IOT）. To facilitate faster querying， you have created a mapping table and a bitmap index on the ORDER_FILLED column. You observe that the query performance degrades when users perform a large volume of transactions. While investigating the reason， you find that the mapping table segment is fragmented， leading to poor performance. Which option would you use to defragment the mapping table without affecting the original table data？（）A
export and import the mapping tableB
drop and re-create the mapping tableC
truncate the mapping table and reinsert the valuesD
use the ALTER TABLE···REBUILD command to defragment the mapping table
考题
单选题What does the OSPF command capability vrf-lite achieve？（）A
It enables provider edge （PE） specific checks on a router when the OSPF process is associated with the VRFB
It disables provider edge （PE） specific checks on a router when the OSPF process is associated with the VRFC
It enables the exchange of the VRF-Lite capability when the OSPF adjacency is formed.D
It disables the MPLS processing on the OSPF learned routes inside the VRF
考题
单选题What Oracle process runs when the database is in ARCHIVELOG mode but not when it is in NOARCHIVELOG mode？（）A
MMONB
LGWRC
ARCHD
ARWRE
COPY
考题
单选题You need to cleanse and standardize the data on potential survey participants prior to inserting it into the staging database. What should you do?（）A
Import the data into a staging table by using the OPENROWSET BULK statement. Execute a Transact-SQL stored procedure to cleanse the data and to insert the data into the database.B
Import the data into a staging table by using the BULK INSERT statement. Execute a Transact-SQL stored procedure to cleanse the data and to insert the data into the database.C
Create a SQL Server Integration Services （SSIS） package to import， standardize， and cleanse the data.D
Create a CLR stored procedure to import the data into a staging table， to cleanse and standardize the data， and to insert the data into the database.
考题
多选题Your company uses a SQL Server 2005 database. This database contains a trigger named trg_InsertOrders, which fires when order data is inserted into the Orders table. The trigger is responsible for ensuring that a customer exists in the Customers table before data is inserted into the Orders table. You need to configure the trigger to prevent it from firing during the data import process. You must accomplish this goal while using the least amount of administrative effort. Which two Transact-SQL statements can you use to achieve this goal?（）AALTER TABLE OrdersDISABLE TRIGGER trg_InsertOrdersBDROP TRIGGER trg_InsertOrdersCDISABLE TRIGGER trg_InsertOrders ON OrdersDALTER TRIGGER trg_InsertOrders ON Orders NOT FOR REPLICATIONEsp_settriggerorder@triggername= 'trg_InsertOrders', @order='None'
考题
单选题In the instance of the PROD database， the checkpoint （CKPT） process runs after every minute. A database user updates the rows of the ORDERS table. Because of the configuration， the CKPT process gets initiated before the user commits the transaction. What would happen to the modified blocks when the CKPT process is started？（）A
The modified blocks would be written to the data files.B
The modified blocks would be written to the temp files.C
The modified blocks would be written to the control file.D
The modified blocks would be written to the redo log files.E
The modified blocks would be written to the archived redo log files.F
The modified blocks would be retained in the database buffer cache.
热门标签
最新试卷