单选题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. Master files B. Look-up files C. Transaction files D. History files

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. identifying relationships B. normalization C. referential integrity D. store procedure

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. Legacy database B. Backup database C. Multidimensional database D. Workgroup database

4.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 databaseD .Network database

更多“单选题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 ”相关问题

  • 第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. Legacy database
    B. Backup database
    C. Multidimensional database
    D. Workgroup database

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

  • 第2题：

    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

  • 第3题：

    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

  • 第4题：

    In your Oracle 10g database ， you have scheduled a job to update the optimizer statistics at 05：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 design the consolidation strategy for the Promotions and Partners databases. You want to choose a strategy that results in the best database performance while maintaining the permissions of end users in each database.What consolidation strategy should you choose？（）

    • A、Place each database in a separate instance running on SQL2.
    • B、Place each database in a separate instance running on SQL3.
    • C、Place both databases in a single instance running on SQL2.
    • D、Place both databases in a single instance running on SQL3.

    正确答案:C

  • 第6题：

    You want to consolidate some of the databases onto existing SQL Server computers until additional hardware can be purchased.You need to identify which of the servers， in its current configuration， can support additional databases. You need to ensure that your solution fulfills the company’s securiy requirements while allowing for future database growth requirements. Which server and database combination can be used？（）

    • A、SQL3 with the OnlineReadOnly and HR databases
    • B、SQL4 with the TravelOnline and Storefront databases
    • C、SQL2 with the Storefront and TravelOnline databases
    • D、SQL2 with the Storefront and HR databases

    正确答案:D

  • 第7题：

    单选题
    You have forgotten the root user account password. You decide to reset the password and execute the following: Shell＞ /etc/init.d/mysql stop Shell＞ /etc/init.d/mysql start – skip-grant tables Which additional argument makes this operation safer?（）
    A

    –skip-networking, to prohibit access from remote locations

    B

    –reset-grant-tables, to start the server with only the mysql database accessible

    C

    –read-only,to set all data to read-only except for super users

    D

    –old-passwords, to start Mysql to use the old password format while running without the grant tables


    正确答案： D
    解析： 暂无解析

  • 第8题：

    单选题
    You have a listener process， L1， currently listening for the connections to the PROD and ADMIN databases. You create a new database， PAY， using CREATE  DATABASE.. command. You have not enabled dynamic instance registration. You modified the LISTENER.ORA file manually to include PAY database for L1 listener process.  Which command of Listener control utility （LSNRCTL） would you use to enable L1 process to start listening for the connections to the PAY database without disrupting any existing database communications？（）
    A

    START

    B

    RELOAD

    C

    RESTART

    D

    REFRESH

    E

    START L1

    F

    RELOAD L1

    G

    RESTART L1

    H

    REFRESH L1


    正确答案： E
    解析： 暂无解析

  • 第9题：

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


    正确答案： A
    解析： 暂无解析

  • 第10题：

    单选题
    In your production database you want to use an Automatic Storage Management （ASM） instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance？（）
    A

    Oracle Migration Assistant

    B

    Recovery Manager （RMAN）

    C

    Oracle Data Pump Export and Import

    D

    conventional Oracle Export and Import

    E

    operating system utilities to copy the files to the ASM instance


    正确答案： A
    解析： 暂无解析

  • 第11题：

    单选题
    You need to design the consolidation strategy for the Promotions and Partners databases. You want to choose a strategy that results in the best database performance while maintaining the permissions of end users in each database.What consolidation strategy should you choose？（）
    A

    Place each database in a separate instance running on SQL2.

    B

    Place each database in a separate instance running on SQL3.

    C

    Place both databases in a single instance running on SQL2.

    D

    Place both databases in a single instance running on SQL3.


    正确答案： B
    解析： 暂无解析

  • 第12题：

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


    正确答案： A
    解析： 暂无解析

  • 第13题：

    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

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

    TestKing.com has a server named SQL1 that runs SQL Server 2005 Enterprise Edition.SQL1 has 2 GB of RAM， 1.6 GB of which are used by the default SQL Server database engine instance. The average data growth of all databases combined is 100 MB a month. Users state that report execution times are increasing. You want to assess whether more RAM is needed. You need to use System Monitor to create a counter log that will help you decide whether to add RAM. Which performance object should you add to the counter log？（）

    • A、MSAS 2005：Cache
    • B、MSAS 2005：Memory
    • C、MSAS 2005：Proactive Caching
    • D、SQLServer：Buffer Manager

    正确答案:D

  • 第17题：

    You have an Exchange Server 2010 organization that contains 20 Mailbox servers.You plan to create 10 mailbox databases on each Mailbox server. You need to create a naming convention for all mailbox databases.  What should you include in your naming convention（）？ 

    • A、For each mailbox database， provide a database name that is unique within the organization.
    • B、For each mailbox database， provide a database name that is unique within the Mailbox server.
    • C、For each mailbox database file， provide a file name that is unique within the organization.
    • D、For each mailbox database file， provide a file name that is unique within the Mailbox server.

    正确答案:A

  • 第18题：

    You have a listener process， L1， currently listening for the connections to the PROD and ADMIN databases. You create a new database， PAY， using CREATE  DATABASE.. command. You have not enabled dynamic instance registration. You modified the LISTENER.ORA file manually to include PAY database for L1 listener process.  Which command of Listener control utility （LSNRCTL） would you use to enable L1 process to start listening for the connections to the PAY database without disrupting any existing database communications？（）

    • A、START
    • B、RELOAD
    • C、RESTART
    • D、REFRESH
    • E、START L1
    • F、RELOAD L1
    • G、RESTART L1
    • H、REFRESH L1

    正确答案:F

  • 第19题：

    单选题
    You want to consolidate some of the databases onto existing SQL Server computers until additional hardware can be purchased.You need to identify which of the servers， in its current configuration， can support additional databases. You need to ensure that your solution fulfills the company’s securiy requirements while allowing for future database growth requirements. Which server and database combination can be used？（）
    A

    SQL3 with the OnlineReadOnly and HR databases

    B

    SQL4 with the TravelOnline and Storefront databases

    C

    SQL2 with the Storefront and TravelOnline databases

    D

    SQL2 with the Storefront and HR databases


    正确答案： D
    解析： 暂无解析

  • 第20题：

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


    正确答案： B
    解析： 暂无解析

  • 第21题：

    单选题
    You are upgrading the database servers that are used by all of the companys applications. As the first step in the upgrade, you upgrade the development database servers. You need to verify that the upgrade of the database servers did not introduce any errors into the databases. What should you do?（）
    A

    Execute unit test scripts for each stored procedure in each database.

    B

    Execute the stored procedures in the SQL Server Management Studio debugger, and verify the results.

    C

    Set the database compatibility level on the database servers to 80.

    D

    Execute the application user interface test scripts to verify proper operation.


    正确答案： A
    解析： 暂无解析

  • 第22题：

    单选题
    TestKing.com has a server named SQL1 that runs SQL Server 2005 Enterprise Edition.SQL1 has 2 GB of RAM， 1.6 GB of which are used by the default SQL Server database engine instance. The average data growth of all databases combined is 100 MB a month. Users state that report execution times are increasing. You want to assess whether more RAM is needed. You need to use System Monitor to create a counter log that will help you decide whether to add RAM. Which performance object should you add to the counter log？（）
    A

    MSAS 2005：Cache

    B

    MSAS 2005：Memory

    C

    MSAS 2005：Proactive Caching

    D

    SQLServer：Buffer Manager


    正确答案： D
    解析： 暂无解析

  • 第23题：

    单选题
    You have an Exchange Server 2010 organization that contains 20 Mailbox servers.You plan to create 10 mailbox databases on each Mailbox server. You need to create a naming convention for all mailbox databases.  What should you include in your naming convention（）？
    A

    For each mailbox database， provide a database name that is unique within the organization.

    B

    For each mailbox database， provide a database name that is unique within the Mailbox server.

    C

    For each mailbox database file， provide a file name that is unique within the organization.

    D

    For each mailbox database file， provide a file name that is unique within the Mailbox server.


    正确答案： C
    解析： 暂无解析

  • 第24题：

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


    正确答案： D
    解析： 暂无解析

相关内容