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

题目
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
相似考题

1.Files can be lost or destroyed accidentally. Keep(74) copies of all data on removable storage media.A．moveB．pasteC．backdownD．backup

2.Files can be lost or destroyed accidentally．Keep ______ copies of all data on removable storage media.A．backupB．backC．blackD．backdown

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

4.While reviewing the MySQL error log, you see occasions where MySQL has exceeded the number of file handles allowed to it by the operating system.Which method will reduce the number of file handles in use?（）A.Activating the MySQL Enterprise thread pool pluginB.Relocating your data and log files to separate storage devicesC.Disconnecting idle localhost client sessionsD.Implementing storage engine data compression options

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

  • 第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. Hierarchical database
    B. Workgroup database
    C. Linked table database
    D .Network database

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

  • 第2题：

    Which two statements correctly describe the relation between a data file and the logical databasestructures（）

    • A、An extent cannot spread across data files.
    • B、A segment cannot spread across data files.
    • C、A data file can belong to only one tablespace.
    • D、A data file can have only one segment created in it.
    • E、A data block can spread across multiple data files as it can consist of multiple operating system （OS） blocks.

    正确答案:A,C

  • 第3题：

    You have enabled backup optimization for the RMAN environment.Identify two criteria on which RMAN will skip the file, if it has already been backed up.（）

    • A、The data file backup is done with multiple channels
    • B、The data files is in the read-write mode after being backed up in the read only mode
    • C、The backup was taken after the data files was taken offline-normal or is in the read only mode
    • D、The data file backup complies with the back retention policy and the backup duplexing feature

    正确答案:C,D

  • 第4题：

    When performing an incomplete recover of the whole database， which data files must you restore？ （）

    • A、Only the damaged or lost data files.
    • B、All of the data files of the database.
    • C、Only the data files belonging to the SYSTEM tablespace.
    • D、The data files belonging to the SYSTEM tablespace and the damaged or lost data files.

    正确答案:B

  • 第5题：

    You are designing a Windows Azure application that will store data. You have the following requirements：   - The data storage system must support the storage of more than 500 GB of data.   - Data retrieval must be possible from a large number of parallel threads without threads blocking each other.   You need to recommend an approach for storing data.  What should you recommend？（）

    • A、 Use Windows Azure Queues.
    • B、 Use Windows Live Mesh 2011.
    • C、 Use a single SQL Azure database.
    • D、 Use Windows Azure Table storage

    正确答案:D

  • 第6题：

    单选题
    You are designing a Windows Azure application that will store data. You have the following requirements：   - The data storage system must support the storage of more than 500 GB of data.   - Data retrieval must be possible from a large number of parallel threads without threads blocking each other.   You need to recommend an approach for storing data.  What should you recommend？（）
    A

     Use Windows Azure Queues.

    B

     Use Windows Live Mesh 2011.

    C

     Use a single SQL Azure database.

    D

     Use Windows Azure Table storage


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

  • 第7题：

    单选题
    While reviewing the MySQL error log, you see occasions where MySQL has exceeded the number of file handles allowed to it by the operating system. Which method will reduce the number of file handles in use?（）
    A

    Activating the MySQL Enterprise thread pool plugin

    B

    Relocating your data and log files to separate storage devices

    C

    Disconnecting idle localhost client sessions

    D

    Implementing storage engine data compression options


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

  • 第8题：

    单选题
    When performing an incomplete recover of the whole database， which data files must you restore？ （）
    A

    Only the damaged or lost data files.

    B

    All of the data files of the database.

    C

    Only the data files belonging to the SYSTEM tablespace.

    D

    The data files belonging to the SYSTEM tablespace and the damaged or lost data files.


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

  • 第9题：

    单选题
    Two data files have been deleted at the operating system level by accident. Your database is running in ARCHIVELOG mode and online backups are taken nightly. One of the data files that has been deleted belongs to the USERS tablespace on the other belongs to the SYSTEM tablespace. How can you recover from this situation？（）
    A

    Shut down the database, restore the two data files and then start up the database. 

    B

    Take the system and users tablespace offline, restore the two data files, recover the two datafiles, and then bring the SYSTEM and USERS tablespaces online. 

    C

    Shut down the database, restore the two data files, start up the database in MOUNT mode, recover the two data files, and then alter the database open. 

    D

    Take the SYSTEM and USERS tablespaces offline, recover the two datafiles and then bring the SYSTEM and USERS tablespaces online.


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

  • 第10题：

    多选题
    The loss of which two types of files may require a recovery with the RESETLOGS option？（）
    A

    control files

    B

    password file

    C

    archived log files

    D

    system-critical data files for which all the redo entries are present

    E

    non-system-critical data files for which all the redo entries are present


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

  • 第11题：

    多选题
    You are designing a plan for migrating Virtual Hard Disks （VHDs） and video files to Windows Azure Storage.  The VHDs must be optimized for random read/write operation. The video files must be optimized for sequential access.  You need to recommend storage types for storing the VHDs and video files.   Which two storage types should you recommend？（）
    A

    Store VHDs in Windows Azure page blob storage.

    B

    Store VHDs in Windows Azure block blob storage.

    C

    Store video files in Windows Azure page blob storage.

    D

    Store video files in Windows Azure block blob storage


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

  • 第12题：

    多选题
    You have enabled backup optimization for the RMAN environment. Identify two criteria on which RMAN will skip the file, if it has already been backed up.（） (Choose two.)
    A

    The data file backup is done with multiple channels

    B

    The data files is in the read-write mode after being backed up in the read only mode

    C

    The backup was taken after the data files was taken offline-normal or is in the read only mode

    D

    The data file backup complies with the back retention policy and the backup duplexing feature


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

  • 第13题：

    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 .Audit files
    D .History files

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

  • 第14题：

    You have enabled backup optimization for the RMAN environment. Identify two criteria on which RMAN will skip the file, if it has already been backed up.（） (Choose two.)

    • A、The data file backup is done with multiple channels
    • B、The data files is in the read-write mode after being backed up in the read only mode
    • C、The backup was taken after the data files was taken offline-normal or is in the read only mode
    • D、The data file backup complies with the back retention policy and the backup duplexing feature

    正确答案:C,D

  • 第15题：

    A healthcare provider has two applications that they need to redundantly protect in a SAN environment. Their patient record application runs on Oracle 11i and consists of many small， randomly accessed files. The database is kept on three clustered Sun servers and currently uses 30 TB of data space. Their imaging application that retains and manages x-rays， consists of Filenet， CommonStore， and TSM running on an IBM Power750 server， and is currently using 65 TB of data space.  Which of the following disk solutions meets the customer’s requirement（）

    • A、IBM System Storage DS8700 2 way
    • B、IBM System Storage DCS9900
    • C、IBM System Storage DS8700 4 way
    • D、IBM XIV Storage System

    正确答案:C

  • 第16题：

    The loss of which two types of files may require a recovery with the RESETLOGS option？（）

    • A、 control files
    • B、 password file
    • C、 archived log files
    • D、 system-critical data files for which all the redo entries are present
    • E、 non-system-critical data files for which all the redo entries are present

    正确答案:A,C

  • 第17题：

    You are designing a Windows Azure application that will provide online backup storage for very large media files.  The application must be capable of storing an average of 1 GB of data for each user. The application must provide random read/write access. You need to recommend a durable data storage solution.  What should you recommend？（）

    • A、 Use a Windows Azure Drive.
    • B、 Use Windows Azure page blob storage.
    • C、 Use Windows Azure block blob storage.
    • D、 Use local storage on a Windows Azure instance.

    正确答案:B

  • 第18题：

    单选题
    A customer wants to collect performance data from a newly installed IBM System Storage DS8700 to determine if the system meets expected benchmarks using their application test data.  Which tool best gathers the performance data（）
    A

    IBM DS Storage Manager

    B

    Tivoli Storage Resource Manager

    C

    Tivoli Storage Productivity Center for Disk

    D

    Tivoli Storage Productivity Center for Data


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

  • 第19题：

    单选题
    You are designing a Windows Azure application that will provide online backup storage for very large media files.  The application must be capable of storing an average of 1 GB of data for each user. The application must provide random read/write access. You need to recommend a durable data storage solution.  What should you recommend？（）
    A

     Use a Windows Azure Drive.

    B

     Use Windows Azure page blob storage.

    C

     Use Windows Azure block blob storage.

    D

     Use local storage on a Windows Azure instance.


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

  • 第20题：

    单选题
    A customer needs the ability to recover their data if a total system failure occurs.  Which two of the following are the most important considerations in determining the solution？（）
    A

    Network utilization

    B

    Total amount of storage installed

    C

    Amount of open files in the backup

    D

    Amount of critical data in the backup or restore


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

  • 第21题：

    多选题
    Which two statements correctly describe the relation between a data file and the logical databasestructures（）
    A

    An extent cannot spread across data files.

    B

    A segment cannot spread across data files.

    C

    A data file can belong to only one tablespace.

    D

    A data file can have only one segment created in it.

    E

    A data block can spread across multiple data files as it can consist of multiple operating system （OS） blocks.


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

  • 第22题：

    单选题
    You are operating your database in NOARCHIVELOG mode. Your most recent backup includes a copy of all of the data files and the control files taken when the current log sequence number was 45. You experience disk failure on the drive on which your SYSTEM tablespace data files are stored. At the time of the failure， the current log sequence number is 98. Which files should you restore to recover from the loss of the SYSTEM tablespace data files？（）
    A

    Only the data files.

    B

    All of the data files and the control files.

    C

    Only the data files belonging to the SYSTEM tablespace.

    D

    Only the data files belonging to the SYSTEM tablespace and the control files.


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

  • 第23题：

    单选题
    A customer has an IBM System Storage Enterprise Storage Server and several EMC CX3 systems installed in a data center， attached to IBM System p servers. As a step toward data consolidation， they intend to put all data on a new DS8700.  What would be the most important data migration factors to consider（）
    A

    sector size and the amount of production data

    B

    existing RAID levels and the disk drive speed

    C

    sector size and existing RAID levels

    D

    amount of production data and the disk drive speed


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

相关内容