[单选题]Designing the data storage architecture is an important activity

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

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 Master files B Look-up files C Audit files D History files

3.An application architecture specifies the technologies to be used to implement one or more information systems. It serves as an outline for detailed design, construction, and implementation. Given the models and details, include （请作答此空）, we can distribute data and processes to create a general design of application architecture. The design will normally be constrained by architecture standards, project objectives, and （）. The first physical DFD to be drawn is the （）. The next step is to distribute data stores to different processors. Data（）are two types of distributed data which most RDBMSs support. There are many distribution options used in data distribution. In the case of （）, we should record each table as a data store on the physical DFD and connect each to the appropriate server. 选项： A:logical DFDs and ERD B:ideal object model and analysis class model C:use case models and interface prototypes D:physical DFDs and database schema

4.Data ﬁles are for storing data of the database,however theData dictionary can be used to store the schemas for the database

5.Identify two situations in which you can use Data Recovery Advisor for recovery. （）(Choose two.) 选项： A、AThe user has dropped an important table that needs to be recovered. B、BThe database files are corrupted when the database is open. C、CYou are not able to start up the database instance because the required database files are missing. D、DThe archived log files are missing for which backup is not available.

6.Identify two situations in which you can use Data Recovery Advisor for recovery.（）选项： A、A The user has dropped an important table that needs to be recovered. B、B The database files are corrupted when the database is open. C、C You are not able to start up the database instance because the required database files are missing. D、D The archived log files are missing for which backup is not available.

7. Filein a database ________. 选项： A、 is a collection of related records B、 is called a table in PC database C、 likes a record D、 can be used to build a database

8.Which part of a relational database contains the logical structure for the information? 选项： A、Data dictionary B、Relation C、Query D、SQLIn the relational database model, a data dictionary contains the logical structure for the information in a database. When you create a database, you first create its data dictionary.

9. A _____ is a collection of information that you organize and access according to the logical structure of that information. 选项： A: database B: data dictionary C: data mart D: data mineAny database is a collection of information that you organize and access according to the logical structure of that information.

10.In the database system, the core software that realizes the data management function is called（）. 选项： A、database B、database system C、database management system D、database application system

11.For your database, an incremental level 1 backup is taken every week day. On Tuesday, before the backup is performed, you add a new tablespace.You execute the command:RMAN> BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG ‘WEEKLY’DATABASE;Which statement is true about the execution of the command? 选项： A: It returns an error because there is no level 0 backup available for new data files. B: It performs an image copy backup of new data files, and a level 1 incremental backup of all other data files. C: It performs a level-0 backup of all data files including those that belong to the new tablespace. D: It performs an image copy backup of all data files including those that belong to the newTablespace. E: It performs a backup as a backup set of all data files including those that belong to the new tablespace.

12.；A collection of related information，organized for easy retrieval．选项： A、Data B、Database C、Buffer D、Stack

13.For your database, an incremental level 1 backup is taken every week day. On Tuesday, before the backupIs performed, you add a new tablespace.You execute the command:RMAN> BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG WEEKLY DATABASE;Which statement is true about the execution of the command? 选项： A: It returns an error because there is no level 0 backup available for new data files. B: It performs an image copy backup of new data files, and a level 1 incremental backup of all other dataFiles. C: It performs a level-0 backup of all data files including those that belong to the new tablespace. D: It performs an image copy backup of all data files including those that belong to the new tablespace. E: It performs a backup as a backup set of all data files including those that belong to the new tablespace.

14.A“database” refers to a set of related data and the way it is ________. Access to this data is usually provided by a DBMS consisting of an integrated set of computer software that allows users to interact with one or more databases and provides access to all of the data contained in the database. 选项：A、organized B、modeled C、managed contained

15.93:In the context of computer security, "scavenging" refers to searching 选项： A:A user list to find a name. B:Through storage to acquire information. C:Through data for information content. D:Through log files for trusted path information.

16.634A persistent collection of interrelated data items can be defined as which of the following? 选项： A: database B: database management system C: database security D: database shadowing

17.For your database, an incremental level 1 backup is taken every week day. On Tuesday, before the backup is performed, you add a new tablespace. You execute the command:

RMAN> BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG WEEKLY DATABASE;

Which statement is true about the execution of the command?

选项： A:

It returns an error because there is no level 0 backup available for new data files.

B:

It performs an image copy backup of new data files, and a level 1 incremental backup of all other data files.

C:

It performs a level-0 backup of all data files including those that belong to the new tablespace.

D:

It performs an image copy backup of all data files including those that belong to the new tablespace

E:

It performs a backup as a backup set of all data files including those that belong to the new tablespace.