单选题What criterion does Oracle9i use to determine whether a database file is an Oracle Managed File？（）AThe filename format. BInformation stored inside a data dictionary table. CInformation stored in the ALERT.LOG file for the corresponding instance. DInformation stored inside the corresponding initialization parameter file for the instance.
单选题
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.
参考解析
解析：
暂无解析
相关考题：
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
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
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.
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 objectsC. database connection D. data access logic
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 componentsB. database management systemC.data storageD.data entities
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、OracleSIDsonlyB、Oracle homes onlyC、Oracle install timestampD、Oracle inventory pointer filesE、Oracle database creation timestampF、OracleSIDsand Oracle homes onlyG、OracleSIDs， Oracle homes and flag for auto startup
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.
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
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、OracleSIDsonlyB、Oracle homes onlyC、Oracle install timestampD、Oracle inventory pointer filesE、Oracle database creation timestampF、OracleSIDsand Oracle homes onlyG、OracleSIDs， Oracle homes and flag for auto startup
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.
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
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.
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
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
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.
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 transmittedB、Require encrypted connections to the public Web site， which is hosted on the Web server on the perimeter networkC、Encrypt all marketing information on file servers and client computersD、Require encrypted connections to all file servers
单选题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？（）AEncrypt customer information when it is stored and when it is being transmittedBRequire encrypted connections to the public Web site， which is hosted on the Web server on the perimeter networkCEncrypt all marketing information on file servers and client computersDRequire encrypted connections to all file servers
单选题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？（）AOracleSIDsonlyBOracle homes onlyCOracle install timestampDOracle inventory pointer filesEOracle database creation timestampFOracleSIDsand Oracle homes onlyGOracleSIDs， Oracle homes and flag for auto startup
单选题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？（）AOracleSIDsonlyBOracle homes onlyCOracle install timestampDOracle inventory pointer filesEOracle database creation timestampFOracleSIDsand Oracle homes onlyGOracleSIDs， Oracle homes and flag for auto startup
单选题What criterion does Oracle9i use to determine whether a database file is an Oracle Managed File？（）AThe filename format. BInformation stored inside a data dictionary table. CInformation stored in the ALERT.LOG file for the corresponding instance. DInformation stored inside the corresponding initialization parameter file for the instance.
单选题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.
单选题Which data dictionary views displays the error information related to a data file， when an internal read fails on that file？（）AV$DATAFILEBV$DATAFILE_HEADERCDBA_DATA_FILESDV$DBFILEEV$DATAFILE_ERRORS
单选题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？（）ARebuild the index using the online option. BTake 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. CWithout setting the individual data file offline, use RMAN with Block Media Recovery to restore and recover only those blocks. DTake 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.
多选题Identity two advantages of using a recovery catalog in-load of the control File of the target database Recovery Manager （RMAN）.（）AYou can use RMAN stored scripts.BRecovery is faster if data is stored in catalog in addition to the control file.CYou can store backup Information of all registered databases in one place.DDatabase backups are automatically deleted when they are older than the specified time period.
单选题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.
多选题Indentify two advantages of using recovery catalog instead of the control file of the database in Recovery Manager （RMAN）.（）AYou can use RMAN stored scriptsBRecovery is faster if data is stored in catalog in addition to the control fileCYou can store backup information of all registered databases in one placeDDatabase backups are automatically deleted when they are older than the specified time period
单选题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?（）AThe file ‘+data.231.54769’ is physically relocated to ‘+data/prod’ and renamed as ‘myfile.dbf’.BThe file ‘+data.231.54769’ is renamed as ‘myfile.dbf’, and copied to ‘+data/prod’.CThe file ‘+data.231.54769’ remains in the same location and a synonym 'myfile.dbf' is created.DThe file ‘myfile.dbf’ is created in ‘+data/prod’ and the reference to ‘+data.231.54769’ in the data dictionary removed.
多选题Indentify two advantages of using recovery catalog instead of the control file of the database in RecoveryManager (RMAN).（）(Choose two.)AYou can use RMAN stored scriptsBRecovery is faster if data is stored in catalog in addition to the control fileCYou can store backup information of all registered databases in one placeDDatabase backups are automatically deleted when they are older than the specified time period