Which of the following is a characteristic of a schema?() A.Foreign key references cannot cross schema boundaries.B.A DB2 user must be created before a schema with the same name can be created.C.If no schema is specified when an object is created, the default schema PUBLIC is used.D.A schema enables the creation of multiple objects in a database without encountering namespace collisions.
Which of the following is a characteristic of a schema?()
A.Foreign key references cannot cross schema boundaries.
B.A DB2 user must be created before a schema with the same name can be created.
C.If no schema is specified when an object is created, the default schema PUBLIC is used.
D.A schema enables the creation of multiple objects in a database without encountering namespace collisions.
相关考题：
You’re going to have a quiz ( )by another two in the ( )month. A. followed,followedB. followed,followingC. following,followedD. following,following
Parents transmit some of their()to their children.A. characteristicsB. characterC. characteristic
You want to start monitoring statistics on the distribution of storage engines that are being used and the average sizes of tables in the various databases.Some details are as follows:The Mysql instance has 400 databases. Each database on an average consists of 25-50 tables. You use the query:SELECT TABLE_SCHEMA, ‘ENGINE‘, COUNT (*), SUM(data_length) total_size FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE= ‘BASE TABLE‘ GROUP BY TABLE_SCHEMA, ‘ENGINE‘ ;Why is this query slow to execute?（）A.Collecting information requires large numbers of locks on various INFORMATION_SCHEMA tablesB.Aggregating details from various storage engine caches for the final output is time consumingC.Collecting information requires various disk-level operations and is time consumingD.Counting and summarizing all table pages in the InnoDB shared tablespace is time consuming
Consider the events_% tables in performance Schema.Which two methods will clear or reset the collected events in the tables?() A.Using DELETE statements, for example, DELETE FROM performance_schema.events_watis_currentB.Using the statement RESET PERFORMANCE CACHEC.Using the statement FLUSH PERFORMANCE CACHED.Using TRUNCATE statements, for example, TRUNATE TABLE performance_schema.events_waits_currentE.Disabling and re-enabling all instrumentsF.Restarting Mysql
TheapplicationtablesownedbytheuserTESTinatestdatabaseneedtobeexportedtotheAPPSschemaintheproductiondatabasebyusingDataPump.WhichoptionofDataPumpImportwouldyouusetoaccomplishthis?() A.ownerB.touserC.attachD.remap_schema
Password is a secret series of(73) that enables a user to access a file, computer, or program. On multi-user systems, each user must enter his or her password before the computer will respond to(74). The password helps ensure that(75) users do not access the computer. In addition, data files and programs may require a password.A．symbolB．signC．charactersD．characteristic
用xmlns属性定义命名空间时前缀有什么作用？把命名空间用于元素和属性有什么区别？怎样定义和使用默认的命名空间？Xml模式（Schema）这个词汇有哪些意义？Schema和DTD有什么区别？Schema提供哪两种方式来实现数据类型的定义？具体是怎样实现？Schema和XML文档有什么关系？Schema主要检验哪些方面内容？
Password is a secret series of(69)that enables a user to access a file, computer, or program. On multi-user systems, each user must enter his or her password before the computer will respond to(70). The password helps ensure that(71)users do not access the computer. In addition, data files and programs may require a password.A．symbolB．signC．charactersD．characteristic
使用impdp时,希望将源库的对象放到目标库不同的用户和表空间下,要用什么参数?() A. REMAP_SCHEMAB. REMAP_SCHEMA, REMAP_TABLESPACEC. REMAP_SCHEMA, REMAP_TABLESPACE , REMAP_DATAFILED. REMAP_SCHEMA, REMAP_TABLESPACE , REMAP_DATAFILE ,REUSE_DATAFILES
安装MySQL数据库后，系统自动创建的数据库包括______。A．information_schema；B．Choose;C．Mysql；D．performance_schema；