单选题What criterion does Oracle9i use to determine whether a database file is an Oracle Managed File？（）A The filename format. B Information stored inside a data dictionary table. C Information stored in the ALERT.LOG file for the corresponding instance. D I

题目
单选题
What criterion does Oracle9i use to determine whether a database file is an Oracle Managed File？（）
A

The filename format. 

B

Information stored inside a data dictionary table. 

C

Information stored in the ALERT.LOG file for the corresponding instance. 

D

Information stored inside the corresponding initialization parameter file for the instance.

相似考题

1.Indentify two advantages of using recovery catalog instead of the control file of the database in Recovery Manager (RMAN)?()A. You can use RMAN stored scriptsB. Recovery is faster if data is stored in catalog in addition to the control fileC. You can store backup information of all registered databases in one placeD. Database backups are automatically deleted when they are older than the specified time period

2.You are the administrator of a SQL Server 2000 computer in your company's personnel department. Employee data is stored in a SQL Server 2000 database. A portion of the database schema is shown in the exhibit.You want to create a text file that lists these data columns in the following format title, FirstName, LastName, WorkPhone, PositionName, DepartmentName.You want to create the text file as quickly as possible. You do not expect to re-create this file, and you want to avoid creating new database objects if possible.What should you do?A．Use the bcp utility to export data from each table to a separate text file. Use format files to select the appropriate columns. Merge the data from each text file into a single text file.B．Create a view that joins data from all three tables include only the columns you want to appear in the text file. Use the bcp utility to export data from the view.C．Create a SELECT query that joins the data from the appropriate columns in the three tables. Add an INTO clause to the query to create a local temporary table. Use the bcp utility to export data from the local temporary table to a text file.D．Create a SELECT query that joins the data from the appropriate columns in the three tables. Add an INTO clause to the query to create a global temporary table. Use the bcp utility to export data from the global temporary table to a text file.

3.The objective of (71) is to determine what parts of the application software will be assigned to what hardware. The major software components of the system being developed have to be identified and then allocated to the various hardware components on which the system will operate. All software systems can be divided into four basic functions. The first is (72). Most information systems require data to be stored and retrieved, whether a small file, such as a memo produced by a word processor, or a large database, such as one that stores an organization's accounting records. The second function is the (请作答此空), the processing required to access data, which often means database queries in Structured Query Language. The third function is the (74), which is the logic documented in the DFDs, use cases, and functional requirements. The fourth function is the presentation logic, the display of information to the user and the acceptance of the user's commands. The three primary hardware components of a system are (75).A. data persistence B .data access objects C. database connection D. data access logic

4.Indentify two advantages of using recovery catalog instead of the control file of the database in RecoveryManager (RMAN).()(Choose two.)A. You can use RMAN stored scriptsB. Recovery is faster if data is stored in catalog in addition to the control fileC. You can store backup information of all registered databases in one placeD. Database backups are automatically deleted when they are older than the specified time period

更多“单选题What criterion does Oracle9i use to determine whether a database file is an Oracle Managed File？（）A The filename format. B Information stored inside a data dictionary table. C Information stored in the ALERT.LOG file for the corresponding instance. D I”相关问题

  • 第1题：

    The objective of（）is to determine what parts of the application software will be assigned to what hardware. The major software components of the system being developed have to be identified and then allocated to the various hardware components on which the system will operate. All software systems can be divided into four basic functions. The first is（请作答此空 ）.Most information systems require data to be stored and retrieved, whether a small file,such as a memo produced by a word processor, or a large database, such as one that stores an organization's accounting records.The second function is the（）,the processing required to access data, which often means database queries in Structured Query Language. The third function is the（）,which is the logic documented in the DFDs, use cases,and functional requirements.The fourth function is the presentation logic,the display of information to the user and the acceptance of the user's commands.The three primary hardware components of a system are （）.


    A. data access components
    B. database management system
    C.data storage
    D.data entities

    答案：C
    解析：
    （）的目标是确定应用软件的哪些部分将分配到何种硬件。识别出正在开发系统的主要软件构件并分配到系统将要运行的硬件构件。所有软件系统可分为四项基本功能。第一项是（请作答此空 ）。大多数信息系统需要数据进行存储并检索，不论是一个小文件，比如一个字处理器产生的一个备忘录，还是一个大型数据库，比如存储一个企业会计记录的数据库。第二项功能是（），处理过程需要访问数据，这通常是指用SQL进行数据库查询。第三项功能是（），这些逻辑通过数据流图，用例和功能需求来记录。第四项功能是表示逻辑，给用户显示信息并接收用户命令。一个系统的三类主要硬件构件是（）。A.数据访问组件 B.数据库管理系统 C.数据存储 D.数据实体

  • 第2题：

    Identity two advantages of using a recovery catalog in-load of the control File of the target database Recovery Manager （RMAN）.（）

    • A、 You can use RMAN stored scripts.
    • B、 Recovery is faster if data is stored in catalog in addition to the control file.
    • C、 You can store backup Information of all registered databases in one place.
    • D、 Database backups are automatically deleted when they are older than the specified time period.

    正确答案:A,C

  • 第3题：

    The operating system filecratabin the Linux platform gets updated whenever you create a new database on the same host machine.  What kind of information is stored is stored in this file？（）

    • A、OracleSIDsonly
    • B、Oracle homes only
    • C、Oracle install timestamp
    • D、Oracle inventory pointer files
    • E、Oracle database creation timestamp
    • F、OracleSIDsand Oracle homes only
    • G、OracleSIDs， Oracle homes and flag for auto startup

    正确答案:G

  • 第4题：

    Indentify two advantages of using recovery catalog instead of the control file of the database in RecoveryManager (RMAN).（）(Choose two.)

    • A、You can use RMAN stored scripts
    • B、Recovery is faster if data is stored in catalog in addition to the control file
    • C、You can store backup information of all registered databases in one place
    • D、Database backups are automatically deleted when they are older than the specified time period

    正确答案:A,C

  • 第5题：

    Indentify two advantages of using recovery catalog instead of the control file of the database in Recovery Manager （RMAN）.（）

    • A、 You can use RMAN stored scripts
    • B、 Recovery is faster if data is stored in catalog in addition to the control file
    • C、 You can store backup information of all registered databases in one place
    • D、 Database backups are automatically deleted when they are older than the specified time period

    正确答案:A,C

  • 第6题：

    What criterion does Oracle9i use to determine whether a database file is an Oracle Managed File？（） 

    • A、The filename format. 
    • B、Information stored inside a data dictionary table. 
    • C、Information stored in the ALERT.LOG file for the corresponding instance. 
    • D、Information stored inside the corresponding initialization parameter file for the instance.

    正确答案:A

  • 第7题：

    单选题
    You need to design a method to encrypt confidential data. Your solution must address the concerns of the chief information officer. What should you do？（）
    A

    Encrypt customer information when it is stored and when it is being transmitted

    B

    Require encrypted connections to the public Web site， which is hosted on the Web server on the perimeter network

    C

    Encrypt all marketing information on file servers and client computers

    D

    Require encrypted connections to all file servers


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

  • 第8题：

    单选题
    The operating system file cratab in the Linux platform gets updated whenever you create a new database on the same host machine. What kind of information is stored is stored in this file？（）
    A

    OracleSIDsonly

    B

    Oracle homes only

    C

    Oracle install timestamp

    D

    Oracle inventory pointer files

    E

    Oracle database creation timestamp

    F

    OracleSIDsand Oracle homes only

    G

    OracleSIDs， Oracle homes and flag for auto startup


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

  • 第9题：

    单选题
    You are managing an Oracle Database 10g database that uses Oracle Managed Files （OMF）. You enabled the block change tracking feature for the database. Which statement regarding the change tracking file is true？（）
    A

     One block change tracking file is created for each data file. By default， the file is created in DB_CREATE_FILE_DEST.

    B

     One block change tracking file is created for each data file. By default， the file is created in BACKGROUND_DUMP_DEST.

    C

     One block change tracking file is created for the database. By default， the file is created in DB_CREATE_FILE_DEST.

    D

     One block change tracking file is created for the database. By default， the file is created in BACKGROUND_DUMP_DEST.


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

  • 第10题：

    单选题
    Users complain SQL statements using a particular index fail. Using DBVERIFY， you find that two separate blocks in the index have become corrupt. The database data files for user data and index are very large.  What is the least disruptive recover strategy available in Oracle9i？（）
    A

    Rebuild the index using the online option. 

    B

    Take the individual data file offline (not the whole tablespace), restore and recover the data file from backup with RMAN, then set the data file online again. 

    C

    Without setting the individual data file offline, use RMAN with Block Media Recovery to restore and recover only those blocks. 

    D

    Take the individual data file (not the whole tablespace) offline, use RMAN with Block Media Recovery to restore and recover only those blocks, then set the data file online again.


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

  • 第11题：

    单选题
    You are working as a DBA on Oracle Database 9i. You plan to upgrade your 9i database to Oracle 10g. To be familiar with the new database technology， you decide to install Oracle Database 10g on your workstation at home. You create a general purpose database.   After the installation， you make the following changes in your initialization parameter file：LOG_ARCHIVE_DEST_1=’LOCATION=USE_DB_RECOVERY_FILE_DEST’   DB_RECOVERY_FILE_DEST =    ’LOCATION=d：/product/10.1.0/flash_recovery_area’  DB_RECOVERY_FILE_DEST_SIZE=10g   Where are the archived redo logs stored for your database？（）
    A

     The archived redo logs are stored in an operating system-dependent location.

    B

     The archived redo logs are stored in the location specified by LOG_ARCHIVE_DEST_1.

    C

     The archived redo logs are stored in the location specified by DB_RECOVERY_FILE_DEST.

    D

     The archived redo logs are stored in the locations specified by both LOG_ARCHIVE_DEST_1 and  DB_RECOVERY_FILE_DEST.


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

  • 第12题：

    单选题
    You are administering a database stored in Automatic Storage management (ASM). The files are storedin the DATA disk group. You execute the following command:SQL > ALTER DISKGROUP data ADD ALIAS ‘+data/prod/myfile.dbf’ FOR ‘+data.231.45678’;What is the result?（）
    A

    The file ‘+data.231.54769’ is physically relocated to ‘+data/prod’ and renamed as ‘myfile.dbf’.

    B

    The file ‘+data.231.54769’ is renamed as ‘myfile.dbf’, and copied to ‘+data/prod’.

    C

    The file ‘+data.231.54769’ remains in the same location and a synonym 'myfile.dbf' is created.

    D

    The file ‘myfile.dbf’ is created in ‘+data/prod’ and the reference to ‘+data.231.54769’ in the data dictionary removed.


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

  • 第13题：

    The operating system file cratab in the Linux platform gets updated whenever you create a new database on the same host machine. What kind of information is stored is stored in this file？（）

    • A、OracleSIDsonly
    • B、Oracle homes only
    • C、Oracle install timestamp
    • D、Oracle inventory pointer files
    • E、Oracle database creation timestamp
    • F、OracleSIDsand Oracle homes only
    • G、OracleSIDs， Oracle homes and flag for auto startup

    正确答案:G

  • 第14题：

    You have a large amount of historical data in a flat file. Some analysts in your organization need toquery this data in the file. The file is too large to load the data in it into your current database.  Which is the most effective method to access this data in your database（）

    • A、Use the database link.
    • B、Use the SQL*Loader utility.
    • C、Use the Oracle Data Pump utility.
    • D、Create an external table and leave the data in the flat file

    正确答案:D

  • 第15题：

    You are working as a DBA on Oracle Database 9i. You plan to upgrade your 9i database to Oracle 10g. To be familiar with the new database technology， you decide to install Oracle Database 10g on your workstation at home. You create a general purpose database.   After the installation， you make the following changes in your initialization parameter file：LOG_ARCHIVE_DEST_1=’LOCATION=USE_DB_RECOVERY_FILE_DEST’   DB_RECOVERY_FILE_DEST =    ’LOCATION=d：/product/10.1.0/flash_recovery_area’  DB_RECOVERY_FILE_DEST_SIZE=10g   Where are the archived redo logs stored for your database？（）

    • A、 The archived redo logs are stored in an operating system-dependent location.
    • B、 The archived redo logs are stored in the location specified by LOG_ARCHIVE_DEST_1.
    • C、 The archived redo logs are stored in the location specified by DB_RECOVERY_FILE_DEST.
    • D、 The archived redo logs are stored in the locations specified by both LOG_ARCHIVE_DEST_1 and  DB_RECOVERY_FILE_DEST.

    正确答案:C

  • 第16题：

    Users complain SQL statements using a particular index fail. Using DBVERIFY， you find that two separate blocks in the index have become corrupt. The database data files for user data and index are very large.  What is the least disruptive recover strategy available in Oracle9i？（）

    • A、Rebuild the index using the online option. 
    • B、Take the individual data file offline (not the whole tablespace), restore and recover the data file from backup with RMAN, then set the data file online again. 
    • C、Without setting the individual data file offline, use RMAN with Block Media Recovery to restore and recover only those blocks. 
    • D、Take the individual data file (not the whole tablespace) offline, use RMAN with Block Media Recovery to restore and recover only those blocks, then set the data file online again.

    正确答案:C

  • 第17题：

    ou have a large amount of historical data in a flat file. Some analysts in your organization need to query thisdata in the file. The file is too large to load the data in it into your current database.  Which is the most effectivemethod to access this data in your database（）

    • A、Use the database link.
    • B、Use the SQL*Loader utility.
    • C、Use the Oracle Data Pump utility.
    • D、Create an external table and leave the data in the flat file

    正确答案:D

  • 第18题：

    You need to design a method to encrypt confidential data. Your solution must address the concerns of the chief information officer. What should you do？（）

    • A、Encrypt customer information when it is stored and when it is being transmitted
    • B、Require encrypted connections to the public Web site， which is hosted on the Web server on the perimeter network
    • C、Encrypt all marketing information on file servers and client computers
    • D、Require encrypted connections to all file servers

    正确答案:A

  • 第19题：

    单选题
    The operating system filecratabin the Linux platform gets updated whenever you create a new database on the same host machine.  What kind of information is stored is stored in this file？（）
    A

    OracleSIDsonly

    B

    Oracle homes only

    C

    Oracle install timestamp

    D

    Oracle inventory pointer files

    E

    Oracle database creation timestamp

    F

    OracleSIDsand Oracle homes only

    G

    OracleSIDs， Oracle homes and flag for auto startup


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

  • 第20题：

    单选题
    What criterion does Oracle9i use to determine whether a database file is an Oracle Managed File？（）
    A

    The filename format. 

    B

    Information stored inside a data dictionary table. 

    C

    Information stored in the ALERT.LOG file for the corresponding instance. 

    D

    Information stored inside the corresponding initialization parameter file for the instance.


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

  • 第21题：

    单选题
    Which data dictionary views displays the error information related to a data file， when an internal read fails on that file？（）
    A

    V$DATAFILE

    B

    V$DATAFILE_HEADER

    C

    DBA_DATA_FILES

    D

    V$DBFILE

    E

    V$DATAFILE_ERRORS


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

  • 第22题：

    多选题
    Identity two advantages of using a recovery catalog in-load of the control File of the target database Recovery Manager （RMAN）.（）
    A

    You can use RMAN stored scripts.

    B

    Recovery is faster if data is stored in catalog in addition to the control file.

    C

    You can store backup Information of all registered databases in one place.

    D

    Database backups are automatically deleted when they are older than the specified time period.


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

  • 第23题：

    多选题
    Indentify two advantages of using recovery catalog instead of the control file of the database in Recovery Manager （RMAN）.（）
    A

    You can use RMAN stored scripts

    B

    Recovery is faster if data is stored in catalog in addition to the control file

    C

    You can store backup information of all registered databases in one place

    D

    Database backups are automatically deleted when they are older than the specified time period


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

  • 第24题：

    多选题
    Indentify two advantages of using recovery catalog instead of the control file of the database in RecoveryManager (RMAN).（）(Choose two.)
    A

    You can use RMAN stored scripts

    B

    Recovery is faster if data is stored in catalog in addition to the control file

    C

    You can store backup information of all registered databases in one place

    D

    Database backups are automatically deleted when they are older than the specified time period


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

相关内容