1z0-883

单选题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

题目
单选题
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 tables

B

Aggregating details from various storage engine caches for the final output is time consuming

C

Collecting information requires various disk-level operations and is time consuming

D

Counting and summarizing all table pages in the InnoDB shared tablespace is time consuming

如果没有搜索结果，请直接 联系老师 获取答案。
如果没有搜索结果，请直接 联系老师 获取答案。
相似问题和答案

第1题：

Designing the data storage architecture is an important activity in system design. There are two main types of data storage formats： files and databases. Files are electronic of data that have been optimized to perform a particular transaction. There are several types of files that differ in the way they are used to support an application. （ ） store core information that is important to the business and , more specifically , to the application , such as order information or customer mailing information. （ ） contain static values , such as a list of valid codes or the names of cities . Typically, the list is used for validation. A database is a collection of groupings of information that are related to each other in some way. There are many different types of databases that exist on the market today. （ ） is given to those databases which are based on older , sometimes outdated technology that is seldom used to develop new applications . （ ） are collections of records that are related to each other through pointers In relational database , （请作答此空） can be used in ensuring that values linking the tables together through the primary and foreign keys are valid and correctly synchronized.

A. identifying relationships
B. normalization
C. referential integrity
D. store procedure

答案：C
解析：
翻译：在系统设计中，数据存储架构设计是非常重要的一项工作。有两种主要类型的数据存储格式，即文件和数据库，文件是经过优化以执行特定事务的电子数据。（ ）存储的核心信息对业务很重要，更具体地说，对应用程序而言，如订单信息或客户邮件信息。（ ）包含静态值，如有效代码列表或城市名称，通常该列表用于验证。数据库是以某种方式彼此相关的信息分组的集合，目前市场上存在许多不同类型的数据库。（ ）用于那些基于较旧且过时技术的数据库，这些技术很少用于开发新的应用程序。（ ）是通过指针彼此相关的记录集合在关系数据库中，（ 请作答此空）可用于确保通过主键和外键将表链接在一起的值是有效且正确同步的。A．识别关系 B．正常化 C．参照完整性 D．商店程序

第2题：

Designing the data storage architecture is an important activity in system design. There are two main types of data storage formats: files and databases. Files are electronic of data that have been optimized to perform a particular transaction. There are several types of files that differ in the way they are used to support an application. （　） store core information that is important to the business and , more specifically , to the application , such as order information or customer mailing information. （　） contain static values , such as a list of valid codes or the names of cities . Typically, the list is used for validation. A database is a collection of groupings of information that are related to each other in some way. There are many different types of databases that exist on the market today. （请作答此空） is given to those databases which are based on older , sometimes outdated technology that is seldom used to develop new applications . （　） are collections of records that are related to each other through pointers In relational database , （ 　） can be used in ensuring that values linking the tables together through the primary and foreign keys are valid and correctly synchronized.

A. Legacy database
B. Backup database
C. Multidimensional database
D. Workgroup database

答案：A
解析：
（　）存储的核心信息对业务很重要，更具体地说，对应用程序而言，例如订单信息或客户邮件信息。（　）包含静态值，例如有效代码列表或城市名称。通常，该列表用于验证。数据库是以某种方式彼此相关的信息分组的集合。目前市场上存在许多不同类型的数据库。（请作答此空）给予那些基于较旧的，有时过时的技术的数据库，这些技术很少用于开发新的应用程序。（　）是通过指针彼此相关的记录集合在关系数据库中，（　）可用于确保通过主键和外键将表链接在一起的值是有效且正确同步的。 A. 旧数据库 B. 备份数据库 C. 多维数据库 D. 工作组数据库

第3题：

Designing the data storage architecture is an important activity in system design. There are two main types of data storage formats： files and databases. Files are electronic of data that have been optimized to perform a particular transaction. There are several types of files that differ in the way they are used to support an application. （请作答此空） store core information that is important to the business and , more specifically , to the application , such as order information or customer mailing information. （ ） contain static values , such as a list of valid codes or the names of cities . Typically, the list is used for validation. A database is a collection of groupings of information that are related to each other in some way. There are many different types of databases that exist on the market today. （ ） is given to those databases which are based on older , sometimes outdated technology that is seldom used to develop new applications . （ ） are collections of records that are related to each other through pointers In relational database , （ ） can be used in ensuring that values linking the tables together through the primary and foreign keys are valid and correctly synchronized.

A. Master files
B. Look-up files
C. Transaction files
D. History files

答案：A
解析：
翻译：在系统设计中，数据存储架构设计是非常重要的一项工作。有两种主要类型的数据存储格式，即文件和数据库，文件是经过优化以执行特定事务的电子数据。（请作答此空）存储的核心信息对业务很重要，更具体地说，对应用程序而言，如订单信息或客户邮件信息。（ ）包含静态值，如有效代码列表或城市名称，通常该列表用于验证。数据库是以某种方式彼此相关的信息分组的集合，目前市场上存在许多不同类型的数据库。（ ）用于那些基于较旧且过时技术的数据库，这些技术很少用于开发新的应用程序。（ ）是通过指针彼此相关的记录集合在关系数据库中，（ ）可用于确保通过主键和外键将表链接在一起的值是有效且正确同步的。A．主文件 B．查找文件 C．交易文件 D．历史档案

第4题：

You work as a database administrator for Certkiller .com. In your transaction application， you have scheduled a job to update the optimizer statistics at05：00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected？（）

  • A、Average row size
  • B、Last analyzed date
  • C、Size of table in bytes
  • D、Size of table in database blocks
  • E、Number of free blocks in the free list
  • F、Number of extents present in the table.

正确答案:A,B,D

第5题：

You need to migrate the DeliveryVans， AirlinePreferences， and SeasonalContractors databases into the data center. What should you do？（）

  • A、Install a separate instance of SQL Server 2005 for each of the databases on a single server.
  • B、Create a SQL Server database for each of the databases in a single instance of SQL Server 2005.
  • C、Import the data from each of the databases into a single database in an instance of SQL Server 2005.
  • D、Install a default instance of SQL Server 2005 on three separate servers. Use one server for each of the databases.

正确答案:B

第6题：

Designing the data storage architecture is an important activity in system design. There are two main types of data storage formats： files and databases. Files are electronic of data that have been optimized to perform a particular transaction. There are several types of files that differ in the way they are used to support an application. （ ） store core information that is important to the business and , more specifically , to the application , such as order information or customer mailing information. （ ） contain static values , such as a list of valid codes or the names of cities . Typically, the list is used for validation. A database is a collection of groupings of information that are related to each other in some way. There are many different types of databases that exist on the market today. （请作答此空） is given to those databases which are based on older , sometimes outdated technology that is seldom used to develop new applications . （ ） are collections of records that are related to each other through pointers In relational database , （ ） can be used in ensuring that values linking the tables together through the primary and foreign keys are valid and correctly synchronized.

A. Legacy database
B. Backup database
C. Multidimensional database
D. Workgroup database

答案：A
解析：
翻译：在系统设计中，数据存储架构设计是非常重要的一项工作。有两种主要类型的数据存储格式，即文件和数据库，文件是经过优化以执行特定事务的电子数据。（ ）存储的核心信息对业务很重要，更具体地说，对应用程序而言，如订单信息或客户邮件信息。（ ）包含静态值，如有效代码列表或城市名称，通常该列表用于验证。数据库是以某种方式彼此相关的信息分组的集合，目前市场上存在许多不同类型的数据库。（请作答此空）用于那些基于较旧且过时技术的数据库，这些技术很少用于开发新的应用程序。（ ）是通过指针彼此相关的记录集合在关系数据库中，（ ）可用于确保通过主键和外键将表链接在一起的值是有效且正确同步的。A．旧数据库 B．备份数据库 C．多维数据库 D．工作组数据库

第7题：

You have been assigned to manage a set of databases. The previous DBA did not leave you notes regarding the structure of each of the databases. While analyzing an instance， you notice that the system identifier （SID） for the instance is set to ’+ASM’. What is the purpose of this instance？（）

  • A、 This instance is being used to manage the operating system files.
  • B、 This instance is being used to manage the files of other databases.
  • C、 This instance is being used to manage the instances of other databases.
  • D、 This instance is being used to manage the background processes of other instances.

正确答案:B

第8题：

Designing the data storage architecture is an important activity in system design. There are two main types of data storage formats： files and databases. Files are electronic of data that have been optimized to perform a particular transaction. There are several types of files that differ in the way they are used to support an application. （ ） store core information that is important to the business and , more specifically , to the application , such as order information or customer mailing information. （ ） contain static values , such as a list of valid codes or the names of cities . Typically, the list is used for validation. A database is a collection of groupings of information that are related to each other in some way. There are many different types of databases that exist on the market today. （ ） is given to those databases which are based on older , sometimes outdated technology that is seldom used to develop new applications . （请作答此空） are collections of records that are related to each other through pointers In relational database , （ ） can be used in ensuring that values linking the tables together through the primary and foreign keys are valid and correctly synchronized.

A. Hierarchical database
B. Workgroup database
C. Linked table database
D .Network database

答案：A
解析：
翻译：在系统设计中，数据存储架构设计是非常重要的一项工作。有两种主要类型的数据存储格式，即文件和数据库，文件是经过优化以执行特定事务的电子数据。（ ）存储的核心信息对业务很重要，更具体地说，对应用程序而言，如订单信息或客户邮件信息。（ ）包含静态值，如有效代码列表或城市名称，通常该列表用于验证。数据库是以某种方式彼此相关的信息分组的集合，目前市场上存在许多不同类型的数据库。（ ）用于那些基于较旧且过时技术的数据库，这些技术很少用于开发新的应用程序。（请作答此空）是通过指针彼此相关的记录集合在关系数据库中，（ ）可用于确保通过主键和外键将表链接在一起的值是有效且正确同步的。A．分层数据库 B．工作组数据库 C．链接表数据库 D．网络数据库

第9题：

You need to ensure that the stored procedure that inserts new loan requests can access data in tables that are stored in another database on the same SQL Server instance. Which two actions should you perform?（）

  • A、Ensure that the stored procedure and the tables are owned by users that are associated with the same SQL Server login.
  • B、Ensure that the stored procedure and the tables are owned by the same database user.
  • C、Ensure that the stored procedure and the tables use the same database schema.
  • D、Configure the multiuser database option on both databases.
  • E、Configure the cross-database ownership chaining option on both databases.

正确答案:A,E

第10题：

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 tables
  • B、Aggregating details from various storage engine caches for the final output is time consuming
  • C、Collecting information requires various disk-level operations and is time consuming
  • D、Counting and summarizing all table pages in the InnoDB shared tablespace is time consuming

正确答案:C

更多相关问题
相关内容