多选题Which two statements are true regarding partitioning in Mysql?（）ATables with BLOB and TEXT columns cannot be partitionedBPartitioning allows easier management of smaller data sets for certain queriesCPartitioning allows different columns to be stored i

第1题：

Which statement is true regarding the INTERSECT operator?（）

• A、It ignores NULL values 
• B、Reversing the order of the intersected tables alters the result 
• C、The names of columns in all SELECT statements must be identical 
• D、The number of columns and data types must be identical for all SELECT statements in the query 

第2题：

Which two statements are true regarding views?（）

• A、A subquery that defines a view cannot include the GROUP BY clause 
• B、A view that is created with the subquery having the DISTINCT keyword can be updated 
• C、A view that is created with the subquery having the pseudo column ROWNUM keyword cannot be updated 
• D、A data manipulation language (DML) operation can be performed on a view that is created with the subquery having all the NOT NULL columns of a table

第3题：

What two statements are true regarding the recommendations received from the SQL Access Advisor?（）(Choose two.)

• A、It cannot generate recommendations that support multiple workload queries.
• B、It can recommend partitioning on tables provided that the workloads have some predicates and joins on the columns of the NUMBER or DATE type.
• C、It can recommend partitioning only on tables that have at least 10,000 rows.
• D、It can recommend only B-tree indexes and not bitmap or function-based indexes

第4题：

Which two are true regarding MySQL binary and text backups?（）

• A、Binary backups are usually faster than text backups
• B、Binary backups are usually slower than text backups
• C、Text backups are human-readable while binary backups are not
• D、Binary backups are not portable across different operating systems

第5题：

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 checked
• E、It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.

第6题：

Which two statements are true regarding the starting of the database instance using the following command？（） SQL>STARTUP UPGRADE  

• A、 It enables all system triggers.
• B、 It allows only SYSDBA connections.
• C、 It ensures that all job queues remain active during the upgrade process.
• D、 It sets system initialization parameters to specific values that are required to enable database upgrade scripts to be run.

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns. Which two conditions must be true?（）

• A、Each extra column in the copy with more columns must not have a default value
• B、Columns that are common to both versions of the table must be defined in the same order on the master and the slave
• C、The slave database cannot have more columns than the master. Only the master database can have more columns
• D、Columns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either server
• E、The master database cannot have more columns than the slave. Only the slave deatbase can have more columns

第14题：

Which two statements are true regarding partitioning in Mysql?（）

• A、Tables with BLOB and TEXT columns cannot be partitioned
• B、Partitioning allows easier management of smaller data sets for certain queries
• C、Partitioning allows different columns to be stored in separate files
• D、The partitioning expression is an integer or function that returns an integer value or NULL value
• E、Partitioning is only available for those storage engines that implements it natively

第15题：

Which two statements regarding a SQL profile are true？（）

• A、 It is built by Automatic Tuning Optimizer.
• B、 It cannot be stored persistently in the data dictionary.
• C、 It can be used by the query optimizer automatically.
• D、 It can be created manually by using the CREATE PROFILE command.

第16题：

Which two statements are true regarding the USING and ON clauses in table joins?（）

• A、Both USING and ON clauses can be used for equijoins and nonequijoins 
• B、Amaximum of one pair of columns can be joined between two tables using the ON clause 
• C、The ON clause can be used to join tables on columns that have different names but compatible data types 
• D、The WHERE clause can be used to apply additional conditions in SELECT statements containing the ON or the USING clause 

第17题：

What two statements are true regarding the recommendations received from the SQL Access Advisor？（）

• A、 It cannot generate recommendations that support multiple workload queries.
• B、 It can recommend partitioning on tables provided that the workloads have some predicates and joins on the columns of the NUMBER or DATE type.
• C、 It can recommend partitioning only on tables that have at least 10，000 rows.
• D、 It can recommend only B-tree indexes and not bitmap or function-based indexes.

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：