违法和不良信息举报 联系客服
免费注册 登录

单选题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 O

题目
单选题
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

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

You work as a database administrator for Supportcenter.cn. You are working on Oracle Database 10g. To forward client connections to an instance， the listener must know information such as the name of the instance and where the instance’s ORACLE_HOME is located. How does the listener get this information？（）

  • A、It gets it from the parameter file.
  • B、The listener prompts for details on startup.
  • C、The listener gathers information from the control file.
  • D、The instance automatically registers with the default listener.
  • E、The listener gets this information through thelistener.orafile.

正确答案:D,E

第2题：

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

第3题：

You are managing the APPPROD database as a DBA which is not using the Oracle-managed files. You plan to duplicate this database in the same system with the name DUPDB.You want to create the same directory structure for duplicate database files as of the target database.You executed the following RMAN commands:What are the implications of this command?（）

A. It creates database files for the duplicate database under the Oracle base with a different directory for the duplicate database.

B. It overwrites data files of the target database because a different location for data files is not mentioned for the duplicate database.

C. It creates database files for the duplicate database under the same Oracle home as that of the target database with the same directory structure.

D. It creates database files for the duplicate database under the same Oracle home as that of the target but with a different directory for the duplicate database.


参考答案：B

第4题：

You are adding redo logs to the Oracle database. Creating a new redo log adds information to which of the following Oracle resources? （）

  • A、Shared pool 
  • B、Control file 
  • C、SGA 
  • D、PGA

正确答案:B

第5题：

You want to create a new optimized database for your transactional production environment to be used by a financial application. While creating the database， you want the Oracle software to take care of all basic settings to optimize the database performance. Which method would you use to achieve this objective？（）

  • A、Use the CREATE DATABASE .. command to create the database with Oracle-managed files. 
  • B、Use the Database Configuration Assistant (DBCA) to create the database with Oracle-managed files. 
  • C、Use Enterprise Manager to create a new database with the Online Transaction Processing (OLTP) option. 
  • D、Use Database Configuration Assistant (DBCA) to create the database with Transaction Processing template. 
  • E、Use the CREATE DATABASE .. command to create the database with Automatic Storage Management (ASM) file system.

正确答案:D

第6题：

You are a Database Administrator with WonderWeb. You use a password file to establish connections to the Sales database located on the server. You created the password file using the following command：        ORAPWD file=d：/oracle/ora9i/orapwU01 password=admin entries=4   You erroneously deleted the password file while the database was running. You re-create the password file using the following command：   ORAPWD file=d：/oracle/ora9i/orapwU01 password=change_on_install entries=4   However， when you try to connect as the SYS user， you receive the following error：        ORA-01031： insufficient privileges   What should you do to resolve this error？（）

  • A、 Delete the newly created password file and re-create another password file with the password admin， without shutting down the database.
  • B、 Enable the operating system authentication， shut down the database， disable the operating system authentication， and restart the database using the password file.
  • C、 Enable the operating system authentication， shut down the database， re-create the password file using the same ORAPWD command， and restart the database using the password file.
  • D、 Delete the newly created password file， enable operating system authentication and shut down the database. Then， re-create another password file using the same ORAPWD command and restart the database using this password file.

正确答案:D

第7题：

In your Certkiller .com production database， you find that the database users are able to create and read files with unstructured data， available in any location on the host machine from an application.  You want to restrict the database users to access files in a specific location on the host machine.  What could do to achieve this？（）

  • A、Modify the value for the UTL_FILE_DIR parameter in the parameter file
  • B、Grant read and write privilege on the operating system path to the database users
  • C、Modify the value for the LDAP_DIRECTORY_ACCESS parameter in the parameter file
  • D、Modify the value for the PLSQL_NATIVE_LIBRARY_DIR parameter in the parameter file
  • E、Create a directory object referring to the operating system path， and grant read and write privilege on the directory object to the database users

正确答案:A

第8题：

You are the administrator of a SQL Server 2000 computer. Your company uses the server to store service contract information for its customers.

You are also the administrator of Oracle relational database management system (RDBMS) server.

This server is used to store your company’s financial information. The financial information is updated frequently throughout the day.

You need to create a series of reports that combine the service contract information and the financial information. These reports will be updated several times a day.

You want to create reports on the SQL Server computer by using the minimum amount of disk space.

What should you do?

A．Set up SQL server replication to replicate the data from the oracle server to the SQL server computer.

B．Set up the oracle server as a linked server. Create a view that joins the service contract information and the financial information.

C．Set up data transformation services (DTS) package that imports and transforms the database from the oracle server to the SQL server computer. Use SQL server agent to execute the DTS package throughout the day as needed.

D．Set up Microsoft ActiveX script. that connects to the oracle server and imports the financial information into SQL server temporary table. Create a view that joins the service contract information and the temporary table.


正确答案：B
解析：Explanation: SQL Server 2000 permits the creation of links to OLE DB data sources called linked servers. After linking to an OLE DB data source, it is possible to reference rowsets from the OLE DB data sources as tables in Transact-SQL statements and to pass commands to the OLE DB data sources and include the resulting rowsets as tables in Transact-SQL statements.

Each distributed query can reference multiple linked servers and can perform. either update or read operations against each individual linked server. A single distributed query can perform. read operations against some linked servers and update operations against other linked servers. The Microsoft OLE DB Provider for Oracle allows distributed queries to query data in Oracle databases.

Incorrect Answers:
A: Replication allows for the coping, distribution, and modification of data across an enterprise. This involves the copying of database data from one server to another. This is not the best solution in this scenario as this will require frequent replication because the reports must be updated several times a day.

C: Data Transformation Services is a set of graphical tools and programmable objects that allows for the extraction, transformation, and consolidation of data from disparate sources into single or multiple destinations. In this scenario, however, the Oracle database needs to be included in a query. Hence, Data Transformation Services are inappropriate.

D: Microsoft ActiveX scripts can be used to add functionality to Data Transformation Services packages, which is a set of graphical tools and programmable objects that allows for the extraction, transformation, and consolidation of data from disparate sources into single or multiple destinations. In this scenario, however, the Oracle database needs to be included in a query. Hence, Data Transformation Services are inappropriate.

第9题：

You installed Oracle Database 11g afresh. Which statements are true regarding the default audit settings in this database？（） 

  • A、 The audit trail is stored in an operating system file.
  • B、 Auditing is disabled for all privileges.
  • C、 The audit trail is stored in the database.
  • D、 Auditing is enabled for all privileges.
  • E、 Auditing is enabled for certain privileges related to database security.

正确答案:C,E

第10题：

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

更多相关问题
相关内容