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 filesB. Look-up filesC. Transaction filesD. History files
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
B. Look-up files
C. Transaction files
D. History files
参考解析
解析：（请作答此空）存储的核心信息对业务很重要，更具体地说，对应用程序而言，例如订单信息或客户邮件信息。（ ）包含静态值，例如有效代码列表或城市名称。通常，该列表用于验证。数据库是以某种方式彼此相关的信息分组的集合。目前市场上存在许多不同类型的数据库。（ ）给予那些基于较旧的，有时过时的技术的数据库，这些技术很少用于开发新的应用程序。（ ）是通过指针彼此相关的记录集合在关系数据库中，（ ）可用于确保通过主键和外键将表链接在一起的值是有效且正确同步的。 A. 主文件 B. 查找文件 C. 交易文件 D. 历史档案
相关考题：
Files can be lost or destroyed accidentally. Keep(74) copies of all data on removable storage media.A．moveB．pasteC．backdownD．backup
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
Files can be lost or destroyed accidentally．Keep ______ copies of all data on removable storage media.A．backupB．backC．blackD．backdown
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 filesB. Look-up filesC. Transaction filesD. History files
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 databaseB. Workgroup databaseC. Linked table database D .Network database
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
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 relationshipsB. normalizationC. referential integrityD. store procedure
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.
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 channelsB、The data files is in the read-write mode after being backed up in the read only modeC、The backup was taken after the data files was taken offline-normal or is in the read only modeD、The data file backup complies with the back retention policy and the backup duplexing feature
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 channelsB、The data files is in the read-write mode after being backed up in the read only modeC、The backup was taken after the data files was taken offline-normal or is in the read only modeD、The data file backup complies with the back retention policy and the backup duplexing feature
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 wayB、IBM System Storage DCS9900C、IBM System Storage DS8700 4 wayD、IBM XIV Storage System
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.
The loss of which two types of files may require a recovery with the RESETLOGS option？（）A、 control filesB、 password fileC、 archived log filesD、 system-critical data files for which all the redo entries are presentE、 non-system-critical data files for which all the redo entries are present
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
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.
单选题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
单选题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（）AIBM DS Storage ManagerBTivoli Storage Resource ManagerCTivoli Storage Productivity Center for DiskDTivoli Storage Productivity Center for Data
单选题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?（）AActivating the MySQL Enterprise thread pool pluginBRelocating your data and log files to separate storage devicesCDisconnecting idle localhost client sessionsDImplementing storage engine data compression options
单选题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.
单选题When performing an incomplete recover of the whole database， which data files must you restore？ （）AOnly the damaged or lost data files.BAll of the data files of the database.COnly the data files belonging to the SYSTEM tablespace.DThe data files belonging to the SYSTEM tablespace and the damaged or lost data files.
单选题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？（）ANetwork utilizationBTotal amount of storage installedCAmount of open files in the backupDAmount of critical data in the backup or restore
单选题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？（）AShut down the database, restore the two data files and then start up the database. BTake the system and users tablespace offline, restore the two data files, recover the two datafiles, and then bring the SYSTEM and USERS tablespaces online. CShut 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. DTake the SYSTEM and USERS tablespaces offline, recover the two datafiles and then bring the SYSTEM and USERS tablespaces online.
多选题Which two statements correctly describe the relation between a data file and the logical databasestructures（）AAn extent cannot spread across data files.BA segment cannot spread across data files.CA data file can belong to only one tablespace.DA data file can have only one segment created in it.EA data block can spread across multiple data files as it can consist of multiple operating system （OS） blocks.
多选题The loss of which two types of files may require a recovery with the RESETLOGS option？（）Acontrol filesBpassword fileCarchived log filesDsystem-critical data files for which all the redo entries are presentEnon-system-critical data files for which all the redo entries are present
单选题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？（）AOnly the data files.BAll of the data files and the control files.COnly the data files belonging to the SYSTEM tablespace.DOnly the data files belonging to the SYSTEM tablespace and the control files.
多选题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？（）AStore VHDs in Windows Azure page blob storage.BStore VHDs in Windows Azure block blob storage.CStore video files in Windows Azure page blob storage.DStore video files in Windows Azure block blob storage
单选题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（）Asector size and the amount of production dataBexisting RAID levels and the disk drive speedCsector size and existing RAID levelsDamount of production data and the disk drive speed
多选题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.)AThe data file backup is done with multiple channelsBThe data files is in the read-write mode after being backed up in the read only modeCThe backup was taken after the data files was taken offline-normal or is in the read only modeDThe data file backup complies with the back retention policy and the backup duplexing feature