Oracle RDBMS is a distributed DBMS. Which of the following techniques adapted ensure atomicity of distributed transaction？ ()

相似题目

• Which statement is true about Oracle Net Listener?（）

  A . It acts as the listening endpoint for the Oracle database instance for all local and non-local user connections. B . A single listener can service only one database instance and multiple remote client connections. C . Service registration with the listener is performed by the process monitor (PMON) process of each database instance. D . The listener.ora configuration file must be configured with one or more listening protocol addresses to allow remote users to connect to a database instance.

  查看最佳答案

• Which of the following Oracle features is enabled by setting a nonzero value for the MEMORY_TARGET initialization parameter？（）  

  A .  Automatic PGA Memory Management B .  Automatic SGA Memory Management C .  Automatic Shared Memory Management D .  Automatic Memory Management E .  Manual SGA Memory Management F .  None of the above

  查看最佳答案

• You are connecting to an Oracle database server from a client by using the following connect string：  SQL> CONNECT hr/hr@pdserver.us.oracle.com：1521/proddb  Which naming method is being used in this case？（）

  A . Local Naming B . Easy Connect C . External Naming D . Directory Naming

  查看最佳答案

• What is the new Oracle Shared Server?（）

  A . An improved version of multithreaded server configuration.  B . A connection pooling configuration where several clients are connected to the same server process.  C . Two more database servers, which share data by means of database links; the client software is unaware to which server it is connected.  D . A configuration of Real Application Cluster where the client connection is routed to the least busy instance.&e

  查看最佳答案

• Oracle Coherence is best classified as （）? 

  A . A Database Product B . A Middleware Product C . An Object Relational Mapping (ORM) Tool D . A Soft Load Balancer E . An Application Product

  查看最佳答案

• Which statement is true regarding Oracle Shared Server architecture？（）

  A . A dispatcher can support multiple client connects concurrently while a shared server process can be dedicated to only one dispatcher.  B . Under the Oracle Shared Server architecture, client-user processes connect to shared user processes. C . Each dispatcher has its own request queue, which is monitored every three seconds by the dispatcher.  D . Oracle Shared Server required Oracle Net Service even if the client and shared server processes reside on the same machine.

  查看最佳答案

• You want the user APP_DBA to administer the Oracle database from a remote machine. APP_DBA is granted the SYSDBA privilege to perform administrative tasks on the database. Which file is used by the Oracle database server to authenticate APP_DBA？（）

  A . control file B . password file C . listener controller file D . control file and password file

  查看最佳答案

• You are working on Oracle Database 10g， which is in ARCHIVELOG mode. All the archived log files are intact.  In which scenario would performing a recovery require the opening of the database with the RESETLOGS option？（）

  A . loss of a tempfile B . loss of a system data file C . loss of one of the control files D . loss of one of the tablespaces E . loss of a member from each redo log group F . loss of the only member of an unarchived redo log grou

  查看最佳答案

• 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 installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process，you execute the following script：   SQL>@utlu111i.sql   Which statement about the execution of this script is true？（）

  A .  It must be executed from the Oracle Database 11g environment. B .  It must be executed only after the SYSAUX tablespace has been created. C .  It must be executed from the environment of the database that is being upgraded. D .  It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces. E .  It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.

  查看最佳答案

• You are working on Oracle Database 10g， which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option？（）

  A .  loss of one of the tablespaces B .  loss of a system data file C .  loss of one of the control files D .  loss of a tempfile E .  loss of the only member of an unarchived redo log group F .  loss of a member from each redo log grou

  查看最佳答案

• A customer requires SSD drives for their Oracle log files. Cost is a major consideration. Which ofthe following IBM storage products would fulfill this customer’s requirement？（）

  A . N6040 B . DS5020 C . DS5100 D . DS5300

  查看最佳答案

• ORACLE RDBMS本身要利用（）来管理和控制整个数据库。

  A . 数据仓库 B . 数据字典 C . 数据挖掘 D . 控制文件

  查看最佳答案

• You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script: SQL>@utlu111i.sql Which statement about the execution of this script is true?（）

  A . It must be executed from the Oracle Database 11g environment. B . It must be executed only after the SYSAUX tablespace has been created. C . It must be executed from the environment of the database that is being upgraded. D . It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces. E . It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.

  查看最佳答案

• You are connecting to an Oracle database server from a client by using the following connect string：   SQL> CONNECT hr/hr@pdserver.us.oracle.com：1521/proddb   Which naming method is being used in this case？（）

  A . Local Naming B . Easy Connect C . External Naming D . Directory Naming

  查看最佳答案

• 检查oracle告警日志，是否存在错误信息。告警文件一般位于安装路径下的相应目录，比如：/home/oracle/product/10.2.0/rdbms/log下以（）开头的log文件。

  查看最佳答案

• You want to estimate the size of a table by using the Oracle Enterprise Manager.  On which data is the size of the table NOT based？（）

  A .  column sizes B .  column data types C .  PCTFREE D .  projected number of row E .  PCTUSED

  查看最佳答案

• You installed WebLogic, SOA Suite, and Oracle Service Bus on a machine and want to use the  WebLogic Node Manger to start servers for each product. Which statement is true?（）

  A . You need to install a separate node manager for each Middleware Home that has a unique  major and minor WebLogic Version Number. B . You need to install and configure only one instance of Node Manager for all products,  regardless of the WebLogic version number. C . You need to install and configure a separate Node Manager for each domain of each product  you want to run on the machine. D . You need to install one Node Manager but use separate SSL certificates for each product when  searching the network communication to the machine

  查看最佳答案

• What is true regarding the role Oracle Net provides in a client server connection with no middle tier？（）https://assets.asklib.com/images/image2/201808011106157721.jpg

  A . A B . B C . C D . D

  查看最佳答案

• Oracle Net Configuration Assistant is a post-installation tool that configures basic network components after installation. Which four components are included in the configuration？（）

  A . Directory server B . Hostname adaptor C . TCP/IP host file D . Connection Manager E . connecting pooling F . external procedures G . listener names and protocol addresses H . Net Service names in a tnsnames.ora file I . naming methods the client uses to resolve connect identifier

  查看最佳答案

• You have created a password file using the following command：   ORAPWD file=d：\oracle\ora9i\orapwU01 password=change_on_install entries=3   Which of the following is true about this password file？（）

  A .  If the REMOTE_LOGIN_PASSWORDFILE parameter is set to SHARED in the initialization parameter file， then a maximum of three users can be granted the SYSDBA or SYSOPER privileges. B .  If the REMOTE_LOGIN_PASSWORDFILE parameter is set to EXCLUSIVE in the initialization parameter file， then a maximum of three users can be granted the SYSDBA or SYSOPER privileges. C .  If the REMOTE_LOGIN_PASSWORDFILE parameter is set to SHARED in the initialization parameter file， then the SYSDBA and SYSOPER privileges can be granted to other users as long as space in the password file is D .  If the REMOTE_LOGIN_PASSWORDFILE parameter is set to EXCLUSIVE in the initialization parameter file， then the SYSDBAand SYSOPER privileges can be granted to other users as long as space in the password file is available.

  查看最佳答案

• You plan to collect the Automatic Workload Repository （AWR） data every Monday morning for a month. You want Oracle Database to automatically create a baseline every Monday and remove the old baseline.  What is the correct action to achieve this？（）  

  A .  Create and populate a SQL Tuning Set from the AWR on every Monday. B .  Change the RETENTION setting for the AWR snapshots to 7 days on Monday. C .  Create a repeating baseline template. D .  Insert a finding directive for future ADDM tasks.

  查看最佳答案

• You scheduled a backup by using the Schedule Backup option in Oracle Enterprise Manager. Which statement about the script created by Oracle Enterprise Manager is true？ （）

  A . It is a SQL script. B . It is a PL/SQL file. C . It is an operating system （OS） file. D . It is a Recovery Manager （RMAN） script

  查看最佳答案

• You are identifying dictionary objects in the Oracle database. Which of the following is a view in the data dictionary?（） 

  A . V$DATABASE  B . DBA_TABLES  C . SYSAUD$  D . EMP

  查看最佳答案