单选题Which statement is true about loading data using the conventional path of SQL*Loader（）ARedo is not generated while performing conventional path loads.BOnly PRIMARY KEY， UNIQUE KEY， and NOT NULL constraints are checked.CNo exclusive locks are acquired when the conventional path loads are performed.DInstead of performing transactions， SQL*Loader directly writes data blocks to the data files.EINSERT triggers are disabled before the conventional path load and reenabled at the end of the load.
单选题
Which statement is true about loading data using the conventional path of SQL*Loader（）
A
Redo is not generated while performing conventional path loads.
B
Only PRIMARY KEY， UNIQUE KEY， and NOT NULL constraints are checked.
C
No exclusive locks are acquired when the conventional path loads are performed.
D
Instead of performing transactions， SQL*Loader directly writes data blocks to the data files.
E
INSERT triggers are disabled before the conventional path load and reenabled at the end of the load.
参考解析
解析：
暂无解析
相关考题：
Which two statements about the SQL Management Base (SMB) are true?() A. It contains only SQL profiles generated by SQL Tuning Advisor.B. It stores plans generated by the optimizer using a stored outline.C. It is part of the data dictionary and stored in the SYSAUX tablespace.D. It is part of the data dictionary and stored in the SYSTEM tablespace.E. It contains the statement log, the plan history, plan baselines, and SQL profiles.
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
Which statement about the Lightweight Access Point Protocol （LWAPP） is true？（）A、 LWAPP encrypts control traffic between the AP and the controller.B、 LWAPP encrypts user traffic with a x.509 certificate using AES-CCMPC、 LWAPP encrypts both control traffic and user data.D、 When set to Layer 3， LWAPP uses a proprietary protocol to communicate with the Cisco Aironet APs.
Which statement about using McAfee and Webroot together is true？（） A、it is not recommended： the system will not detect more malwareB、it is notpossible ： the WSA will accept only one anti-malware licenseC、the system will stop all web-based threatsD、it is recommended： the system will detect more malware
Which statement is true about IBGP routers? （）A、They must be fully meshedB、They can be in a different ASC、They must be directly connected
Which statement about the Lightweight Access Point Protocol （LWAPP） is true？ （）A、 LWAPP encrypts both control traffic and user data.B、 LWAPP encrypts user traffic with an x.509 certificate using AES-CCMP.C、 When set to Layer 3， LWAPP uses a proprietary protocol to communicate with the Cisco Aironet APs.D、 LWAPP encrypts control traffic between the AP and the controller.E、 None of the other alternatives apply.
Which statement is true about using Microsoft Windows Cluster as a platform for Mysql?（）A、It implements High Availability by using the .NET Connector's' load balancing capabilitiesB、It is shared-nothing architectureC、It is provided by means of IP- level disk replicationD、It relies on the shared disk architecture being visible to both servers
Which three are true?（）A、A MERGE statement is used to merge the data of one table with data from another.B、A MERGE statement replaces the data of one table with that of another.C、A MERGE statement can be used to insert new rows into a table.D、A MERGE statement can be used to update existing rows in a table.
Which statement is true about the loss of system/x7fcritical data files in ARCHIVELOG mode？（）A、The data files can be recovered till the last committed transaction.B、The data files can be recovered without shutting down the database.C、The data file is taken offline automatically; the database remains open.D、The data files can be recovered to the time of the most recent backup.
Which statement is TRUE about the CacheFactory class ？（）A、 it is a topology agnostic way to access NamedCachesB、 it provides mechanisms to manage underlying remote data sourcesC、 both A and B are TRUED、Neither A nor B are TRUE
Which statement is true about the UNDO_RETENTION parameter when retention guarantee is notenabled（）A、It is the time period after which the undo data becomes obsolete.B、It is the time period after which the committed undo data would be transferred to a temporarytablespace.C、It is the minimum time period up to which the committed undo data would be retained if free undo spaceis available.D、It is the time period after which the undo data is transferred to the Flash Recovery Area to provide readconsistency.
Which statement is true about loading data using the conventional path of SQL*Loader（）A、Redo is not generated while performing conventional path loads.B、Only PRIMARY KEY， UNIQUE KEY， and NOT NULL constraints are checked.C、No exclusive locks are acquired when the conventional path loads are performed.D、Instead of performing transactions， SQL*Loader directly writes data blocks to the data files.E、INSERT triggers are disabled before the conventional path load and reenabled at the end of the load
Which statement is true about the loss of system-critical data files in ARCHIVELOG mode？（）A、The data files can be recovered till the last committed transaction.B、The data files can be recovered without shutting down the database.C、The data file is taken offline automatically； the database remains open.D、The data files can be recovered to the time of the most recent backup.
Examine the following statement that is used to modify the constraint on the SALES table： SQL ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements are true regarding the above command（）A、The constraint remains valid.B、The index on the constraint is dropped.C、It allows the loading of data into the table using SQL*Loader.D、New data conforms to the constraint， but existing data is not checkedE、It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.
Examine the following statement that is used to modify the primary key constraint on the SALES table： SQL ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements aretrue regarding the above command（）A、The constraint remains valid.B、The index on the constraint is dropped.C、It allows the loading of data into the table using SQL *Loader.D、New data conforms to the constraint， but existing data is not checked.E、It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.
多选题Which two statements about the SQL Management Base (SMB) are true?（）AIt contains only SQL profiles generated by SQL Tuning Advisor.BIt stores plans generated by the optimizer using a stored outline.CIt is part of the data dictionary and stored in the SYSAUX tablespace.DIt is part of the data dictionary and stored in the SYSTEM tablespace.EIt contains the statement log, the plan history, plan baselines, and SQL profiles.
单选题Which statement is true about using Microsoft Windows Cluster as a platform for Mysql?（）AIt implements High Availability by using the .NET Connector's' load balancing capabilitiesBIt is shared-nothing architectureCIt is provided by means of IP- level disk replicationDIt relies on the shared disk architecture being visible to both servers
多选题Examine the following statement that is used to modify the primary key constraint on the SALES table： SQL ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements aretrue regarding the above command（）AThe constraint remains valid.BThe index on the constraint is dropped.CIt allows the loading of data into the table using SQL *Loader.DNew data conforms to the constraint， but existing data is not checked.EIt allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.
多选题Which two statements about the SQL Management Base (SMB) are true? （）(Choose two.)AIt contains only SQL profiles generated by SQL Tuning Advisor.BIt stores plans generated by the optimizer using a stored outline.CIt is part of the data dictionary and stored in the SYSAUX tablespace.DIt is part of the data dictionary and stored in the SYSTEM tablespace.EIt contains the statement log, the plan history, plan baselines, and SQL profiles.
单选题Which statement is TRUE about the CacheFactory class ？（）A it is a topology agnostic way to access NamedCachesB it provides mechanisms to manage underlying remote data sourcesC both A and B are TRUEDNeither A nor B are TRUE
多选题Examine the following statement that is used to modify the constraint on the SALES table： SQL ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE VALIDATE； Which three statements are true regarding the above command（）AThe constraint remains valid.BThe index on the constraint is dropped.CIt allows the loading of data into the table using SQL*Loader.DNew data conforms to the constraint， but existing data is not checkedEIt allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.
单选题Which statement about the Lightweight Access Point Protocol （LWAPP） is true？（）A LWAPP encrypts control traffic between the AP and the controller.B LWAPP encrypts user traffic with a x.509 certificate using AES-CCMPC LWAPP encrypts both control traffic and user data.D When set to Layer 3， LWAPP uses a proprietary protocol to communicate with the Cisco Aironet APs.
单选题Which statement is true about the UNDO_RETENTION parameter when retention guarantee is notenabled（）AIt is the time period after which the undo data becomes obsolete.BIt is the time period after which the committed undo data would be transferred to a temporarytablespace.CIt is the minimum time period up to which the committed undo data would be retained if free undo spaceis available.DIt is the time period after which the undo data is transferred to the Flash Recovery Area to provide readconsistency.
单选题Which statement is true about the UNDO_RETENTION parameter when retention guarantee is not enabled（）AIt is the time period after which the undo data becomes obsolete.BIt is the time period after which the committed undo data would be transferred to a temporary tablespace.CIt is the minimum time period up to which the committed undo data would be retained if free undo space isavailable.DIt is the time period after which the undo data is transferred to the Flash Recovery Area to provide readconsistency.
单选题Refer to the exhibit. Which statement is true about a voice VLAN？（）A Physically the voice network and the data network are separateB The voice traffic will normally be on a different IP subnet than will the data trafficC End user intervention is necessary to place the phone into the proper VLAND The same security policy should be implemented for both voice and data trafficE The data VLAN must be configured as the native VLAN
多选题Examine the statement： SQL CREATE TABLESPACE user_data 2 EXTENT MANAGEMENT LOCAL 3 SEGMENT SPACE MANAGEMENT AUTO； Which twp assumptions must be true for this statement to execute successfully？（）AOracle Managed Files are used for this instance.BThe USER_DATA tablespace is managed using FET$/UET$ tables.CThe COMPATIBLE initialization parameter must be 9.0.0 or higher.DSpace within segments in the USER_DATA tablespace is managed with freelists.