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
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
相关考题：
You are the administrator of a SQL Server 2000 computer. The server is configured as shown in the Database Server Configuration exhibit.You need to create a new database named Inventory. Employees in your company will use the Inventory database to track inventory data. Users will require immediate responses to queries that help them locate where parts are stored. The tables in the database will be configured as shown in the Database Schema exhibit.The database will consume 14 GB of disk space. You must configure the data files and transaction log to accelerate query response time.Which two courses of action should you take? (Each correct answer represents part of the solution. Choose two.)A. On drive C, create a transaction log.On drive D, create a data file in the PRIMARY filegroup.On drive E, create a data file in the SECONDARY filegroup.B. On each drive, create a transaction log.On each drive, create a data file in the PRIMARY filegroup.C. On drive D, create a transaction log.On drive E, create a data file in the PRIMARY filegroup.D. On the PRIMARY filegroup, create all tables and all indexes.E. On the PRIMARY filegroup, create all tables. On the SECONDARY filegroup, create all indexes.F. On the PRIMARY filegroup, create the Parts table and its indexes.On the SECONDARY filegroup, create all other tables and their indexes.
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.
How does DB2 protect the integrity of indexes when data is updated?（）A、Locks are acquired on the data.B、Locks are acquired on index keys.C、Locks are acquired on index pages.D、Locks are acquired on index pointers.
Given classes defined in two different files： 1. package util； 2. public class BitUtils { 3. private static void process（byte[] b） { } 4. } 1. package app； 2. public class SomeApp { 3. public static void main（String[] args） { 4. byte[] bytes = new byte[256]； 5. // insert code here 6. } 7. } What is required at line 5 in class SomeApp to use the process method of BitUtils？（） A、 process（bytes）；B、 BitUtils.process（bytes）；C、 app.BitUtils.process（bytes）；D、 util.BitUtils.process（bytes）；E、 import util.BitUtils. *； process（bytes）；F、 SomeApp cannot use the process method in BitUtils.
Given classes defined in two different files： 1. package util； 2. public class BitUtils { 3. public static void process（byte[]） { /* more code here */ } 4. } 1. package app； 2. public class SomeApp { 3. public static void main（String[] args） { 4. byte[] bytes = new byte[256]； 5. // insert code here 6. } 7. } What is required at line 5 in class SomeApp to use the process method of BitUtils？（） A、 process（bytes）；B、 BitUtils.process（bytes）；C、 util.BitUtils.process（bytes）；D、 SomeApp cannot use methods in BitUtils.E、 import util.BitUtils.*； process（bytes）；
Your are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table’s indexes, to another tablespace. The table does not have a primary key and is used by an OLTP application. Which technique will move the table and indexes while maintaining the highest level of availability to the application?（）A、Oracle Data Pump.B、An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.C、An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes.D、Online Table Redefinition.E、Edition-Based Table Redefinition.
Online index rebuild functionality has been extended to include which four index structures？（）A、Bitmap indexes.B、Reverse key indexes.C、Function-based indexes.D、Key-compressed indexes on regular tables.E、Key-compressed indexes on IOT （including secondary indexes）
Which statements are correct about temporary tables（）A、Indexes and views can be created on temporary tables.B、Both the data and the structure of temporary tables can be exported.C、Temporary tables are always created in a user’s temporary tablespace.D、The data inserted into a temporary table in a session is available to other sessions.E、Data manipulation language （DML） locks are never acquired on the data of temporary tables
You have table 'apps','userdata' on server that uses MyISAM storage engine. You want to transfer this data to server but use InnoDB engine instead. You execute the following commands: ServerB commands: Shell＞ mysqldump –u root –h server –no-data apps userdata | mysql –u root –p apps Shell＞ mysql –u root –p –h server –e 'ALTER TABLE 'apps','userdata' ENGINE=InnoDB;' Shell＞ mysqldump –u root –p –h server –no-create-info –order-by-primary apps userdata | mysql –u root –p apps What effect does the – order-by-primary argument have on the mysqldump command?（）A、It exports tables with the most indexes first to assist with import speedsB、It ensures that unique indexes have no conflicts when the data is dumpedC、It orders by primary key to assist in speeding up importing to InnoDB tablesD、It must be specified so index data is dumped correctly when –on-create-info is used
Case 1： 1. Shut down the database and perform a backup. 2. Restore all the data files. 3. Mount the database. 4. Recover the database. 5. Without applying all the redo log files， open the database using the RESETLOGS option. 6. Back up the database. Case 2： 1. Shut down the database and perform a backup. 2. Restore only the data files of the tablespace where user error damaged the data. 3. Mount the database. 4. Recover the database. 5. Open the database with the RESETLOGS option. 6. Back up the database. Case 3： 1. Shut down the database. 2. Restore the data files. 3. Open the database. 4. Perform recovery to the current point in time. Which case has the correct steps for an incomplete recovery？（）A、 Only case 1B、 Only case 2C、 Only case 3D、 Case 1 and 2E、 Case 2 and 3F、 Case 1 and 3G、 All cases， case 1， case 2， case 3
You lost the index tablespace in your database. You are not able to use tablespace point/x7fin/x7ftime recovery on the index tablespace. What could be the reason for this？（）A、The index tablespace contains bitmap indexes.B、The index tablespace contains more than one data file.C、The index tablespace supports only complete recovery.D、The index tablespace is not a dictionarymanaged tablespace.E、There is a dependency relationship between a table and its indexes.
You lost the index tablespace in your database. You are not able to use tablespace point-in-time recovery on the index tablespace. What could be the reason for this？（）A、 The index tablespace contains bitmap indexes.B、 The index tablespace contains more than one data file.C、 The index tablespace supports only complete recovery.D、 The index tablespace is not a dictionary-managed tablespace.E、 There is a dependency relationship between a table and its indexes.
Which three descriptions are correct about the effects of the TRUNCATE command on a table（）A、The corresponding indexes for the table are also truncated.B、Delete triggers on the table are fired during the execution of the TRUNCATE command.C、The child table is truncated when the TRUNCATE command is applied on the parent table.D、The high-water mark （HWM） is set to point to the first usable data block in the table segment.E、No undo or very little undo data is generated during the execution of the TRUNCATE command
On your Oracle Database, you issue the following commands to create indexes: SQL CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id) INVISIBLE; SQL CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id); Which two statements are true?（）A、Only the ORD_CUSTOMER_IX1 index created.B、Both the indexes are updated when a row is inserted, updated, or deleted in the ORDERS table.C、Both the indexes are created: however, only ORD_CUSTOMERS_IX1 is used by the optimizer for queries on the ORDERS table.D、The ORD_CUSTOMER_IX1 index is not used by the optimizer even when the OPTIMIZER_USE_INVISIBLE_INDEXES parameters is set to true.E、Both the indexes are created and used by the optimizer for queries on the ORDERS table.F、Both the indexes are created: however, only ORD_CUSTOMERS_IX2 is used by the optimizer for queries on the ORDERS table.
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.
Which three statements are correct about temporary tables？（）A、Indexes and views can be created on temporary tables.B、Both the data and the structure of temporary tables can be exported.C、Temporary tables are always created in a user’s temporary tablespace.D、The data inserted into a temporary table in a session is available to other sessions.E、Data manipulation language （DML） locks are never acquired on the data of temporary tables.
Which parameter allows SQL*Loader to load data into a table with the indexes in the unusable state， prior to the load operation？（）A、INDEXESB、SKIP_INDEXES_MAINTENANCEC、SKIP_UNUSABLE_INDEXESD、RESUMABLEE、INDEXES_UNUSABLE
A bitmap join index is defined as（）.A、An index used to join two bitmap indexes on a table.B、A bitmap index created for the join of two or more tables.C、A bitmap index created on the join of two or more indexes.D、A bitmap index created on the join of two or more indexed-organized tables.
A Windows Azure application retrieves data from SQL Azure. You need to recommend an approach for improving application query performance. What should you recommend？（）A、 Create a database view to retrieve the data.B、 Use a clustered index on the SQL Azure database tables.C、 Open a new database connection when an operation times out.D、 Create SQL Azure database table indexes basedon application queries
What are three benefits of performing data definition language （DDL） statements against a partitioned table with the UPDATE GLOBAL INDEXES clause？（）A、Global indexes are rebuilt automatically at the end of the DDL operation thereby avoiding problems with the UNUSABLE status. B、You do not have to search for invalid global indexes after the DDL command completes and rebuild them individually. C、Global indexes are maintained during the operation of the DDL command and therefore can be used by any concurrent query. D、Global indexes remain intact and available for use by data manipulation language （DML） statements even for sessions that have not enabled the skipping of unusable indexes.
单选题Given classes defined in two different files： 1. package util； 2. public class BitUtils { 3. private static void process（byte[] b） { } 4. } 1. package app； 2. public class SomeApp { 3. public static void main（String[] args） { 4. byte[] bytes = new byte[256]； 5. // insert code here 6. } 7. } What is required at line 5 in class SomeApp to use the process method of BitUtils？（）A process（bytes）；B BitUtils.process（bytes）；C app.BitUtils.process（bytes）；D util.BitUtils.process（bytes）；E import util.BitUtils. *； process（bytes）；F SomeApp cannot use the process method in BitUtils.
单选题A Windows Azure application retrieves data from SQL Azure. You need to recommend an approach for improving application query performance. What should you recommend？（）A Create a database view to retrieve the data.B Use a clustered index on the SQL Azure database tables.C Open a new database connection when an operation times out.D Create SQL Azure database table indexes basedon application queries
单选题Note the following functionalities of various background processes： 1. Record the checkpoint information in data file headers. 2. Perform recovery at instance startup. 3. Cleanup unused temporary segments. 4. Free the resources used by a user process when it fails. 5. Dynamically register database services with listeners. 6. Monitor sessions for idle session timeout. Which option has the correct functionalities listed for a background process（）AArchiver Process （ARCn）： 1， 2， 5BSystem Monitor Process （SMON）： 1， 4， 5CProcess Monitor Process （PMON）： 4， 5， 6DDatabase Writer Process （DBWn）： 1， 3， 4
单选题A bitmap join index is defined as（）.AAn index used to join two bitmap indexes on a table.BA bitmap index created for the join of two or more tables.CA bitmap index created on the join of two or more indexes.DA bitmap index created on the join of two or more indexed-organized tables.
多选题Which three descriptions are correct about the effects of the TRUNCATE command on a table（）AThe corresponding indexes for the table are also truncated.BDelete triggers on the table are fired during the execution of the TRUNCATE command.CThe child table is truncated when the TRUNCATE command is applied on the parent table.DThe high-water mark （HWM） is set to point to the first usable data block in the table segment.ENo undo or very little undo data is generated during the execution of the TRUNCATE command
单选题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.