Which two statements are true regarding partitioning in Mysql?（）A、Tables with BLOB and TEXT columns cannot be partitionedB、Partitioning allows easier management of smaller data sets for certain queriesC、Partitioning allows different columns to be stored in separate filesD、The partitioning expression is an integer or function that returns an integer value or NULL valueE、Partitioning is only available for those storage engines that implements it natively
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
相关考题：
An application architecture specifies the technologies to be used to implement one or more information systems． It serves as an outline for detailed design， construction， and implementation． Given the models and details， include（ ）， we can distribute data and processes to create a general design of application architecture． The design will normally be constrained by architecture standards， project objectives， and （ ）． The first physical DFD to be drawn is the（ ）． The next step is to distribute data stores to different processors． Data（ ） are two types of distributed data which most RDBMSs support． There are many distribution options used in data distribution． In the case of （ ）we should record each table as a data store on the physical DFD and connect each to the appropriate server．A.logical DFDs and ERDB.ideal object model and analysis class modelC.use case models and interface prototypesD.physical DFDs and database schemaA.the database management systemB.the feasibility of techniques usedC.the network topology and technologyD.the user interface and process methodsA.context DFDB.system DFDC.network architecture DFDD.event-response DFDA.vertical partitioning and horizontal replicationB.vertical replication and horizontal partitioningC.integration and distributionD.partitioning and replicationA.storing all data on a single serverB.storing specific tables on different serversC.storing subsets of specific tables on different serversD.duplicating specific tables or subsets on different servers
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.
Which two statements are true regarding partitioning in Mysql?() A.Tables with BLOB and TEXT columns cannot be partitionedB.Partitioning allows easier management of smaller data sets for certain queriesC.Partitioning allows different columns to be stored in separate filesD.The partitioning expression is an integer or function that returns an integer value or NULL valueE.Partitioning is only available for those storage engines that implements it natively
In which three cases would you use the USING clause?() A.You want to create a nonequijoin.B.The tables to be joined have multiple NULL columns.C.The tables to be joined have columns of the same name and different data types.D.The tables to be joined have columns with the same name and compatible data types.E.You want to use a NATURAL join, but you want to restrict the number of columns in the join condition.
Which statement correctly describes a situation in which VRFs are used in the data center?() A. Partitioning of network resources is enabled.B. VRFs cannot support path isolation from MAN/WAN designs.C. VRFs cannot be used to map a virtualized data center to a MPLS implementation.D. VRFs do not allow for the use of application services with multiple access topologies.E. An access design using a VRF allows for an aggregation layer service module solution.
Using the following information: Performance data from an existing system that a new system will replace; Performance estimates that anticipate future workloads; Micro-partitioning and logical partitioning implementations. Which of the following allows a technical sales representative to create a system design which can be imported into an HMC?（）A、IBMeConfigB、IBM Performance MonitorC、IBM Workload Estimator (WLE)D、IBM System Planning Tool (SPT)
Which two statements are true regarding the USING clause in table joins?（）A、It can be used to join a maximum of three tables B、It can be used to restrict the number of columns used in a NATURAL join C、It can be used to access data from tables through equijoins as well as nonequijoins D、It can be used to join tables that have columns with the same name and compatible data types
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
Which three statements are true regarding subqueries?（）A、Subqueries can contain GROUP BY and ORDER BY clauses B、Main query and subquery can get data from different tables C、Main query and subquery must get data from the same tables D、Subqueries can contain ORDER BY but not the GROUP BY clause E、Only one column or expression can be compared between the main query and subqueryF、 Multiple columns or expressions can be compared between the main query and subquery
Which of the following features sets IBM apart from competitors in the area of partitioning？（）A、Software supportB、Hardware isolationC、Static changes in partitionsD、Micro-Partitioning
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
In which cases is reference partitioning effective in enhancing performance?（）A、It is effective only in partition pruning.B、It is effective only in partitionwise joins provided that the query predicates are different from the partitioning key.C、It is effective in both partition pruning as well as partitionwise joins provided that the query predicates are identical to the partitioning key.D、It is effective in both partition pruning as well as partitionwise joins irrespective of whether the query predicates are different from or identical to the partitioning key.
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
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.
Which statements are true regarding system-partitioned tables？（） A、 Only a single partitioning key column can be specified.B、 All DML statements must use partition-extended syntax.C、 The same physical attributes must be specified for each partition.D、 Unique local indexes cannot be created on a system-partitioned table.E、 Traditional partition pruning and partitionwise joins are not supported on these tables.
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
What is true about the WITH GRANT OPTION clause?（）A、It allows a grantee DBA privileges.B、It is required syntax for object privileges.C、It allows privileges on specified columns of tables.D、It is used to grant an object privilege on a foreign key column.E、It allows the grantee to grant object privileges to other users and roles.
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.
单选题In which cases is reference partitioning effective in enhancing performance?（）AIt is effective only in partition pruning.BIt is effective only in partitionwise joins provided that the query predicates are different from the partitioning key.CIt is effective in both partition pruning as well as partitionwise joins provided that the query predicates are identical to the partitioning key.DIt is effective in both partition pruning as well as partitionwise joins irrespective of whether the query predicates are different from or identical to the partitioning key.
多选题What two statements are true regarding the recommendations received from the SQL Access Advisor?（）(Choose two.)AIt cannot generate recommendations that support multiple workload queries.BIt can recommend partitioning on tables provided that the workloads have some predicates and joins on the columns of the NUMBER or DATE type.CIt can recommend partitioning only on tables that have at least 10,000 rows.DIt can recommend only B-tree indexes and not bitmap or function-based indexes
多选题Which two statements are true regarding the USING clause in table joins?（）AIt can be used to join a maximum of three tablesBIt can be used to restrict the number of columns used in a NATURAL joinCIt can be used to access data from tables through equijoins as well as nonequijoinsDIt can be used to join tables that have columns with the same name and compatible data types
多选题What two statements are true regarding the recommendations received from the SQL Access Advisor？（）AIt cannot generate recommendations that support multiple workload queries.BIt can recommend partitioning on tables provided that the workloads have some predicates and joins on the columns of the NUMBER or DATE type.CIt can recommend partitioning only on tables that have at least 10，000 rows.DIt can recommend only B-tree indexes and not bitmap or function-based indexes.
多选题Which two statements are true regarding the USING and ON clauses in table joins?（）ABoth USING and ON clauses can be used for equijoins and nonequijoinsBAmaximum of one pair of columns can be joined between two tables using the ON clauseCThe ON clause can be used to join tables on columns that have different names but compatible data typesDThe WHERE clause can be used to apply additional conditions in SELECT statements containing the ON or the USING clause
多选题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 in separate filesDThe partitioning expression is an integer or function that returns an integer value or NULL valueEPartitioning is only available for those storage engines that implements it natively
多选题Which two statements regarding a SQL profile are true？（）AIt is built by Automatic Tuning Optimizer.BIt cannot be stored persistently in the data dictionary.CIt can be used by the query optimizer automatically.DIt can be created manually by using the CREATE PROFILE command.
单选题Which statement is true regarding the INTERSECT operator?（）AIt ignores NULL values BReversing the order of the intersected tables alters the result CThe names of columns in all SELECT statements must be identical DThe number of columns and data types must be identical for all SELECT statements in the query
多选题Which two statements are true regarding views?（）AA subquery that defines a view cannot include the GROUP BY clauseBA view that is created with the subquery having the DISTINCT keyword can be updatedCA view that is created with the subquery having the pseudo column ROWNUM keyword cannot be updatedDA 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