出自:Oracle认证

You work as a database administrator for Certkiller .com. You are using three database， Certkiller DB01， Certkiller DB02， and Certkiller DB03， on different host machines in your development environment. The database serverconfiguration， such as IP address and listener port number， change frequently due to development requirements， and you havethe task of notifying the developers of the changes. Which connection method would you use to overcome this overhead？（）
A:Host naming
B:Local naming
C:Easy Connect
D:External naming
E:directory naming
Given: What is the result?（）
A:Hello
B:Hello World
C:Compilation fails.
D:Hello World 5
E:The code runs with no output.
F:An exception is thrown at runtime.
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提出的独特的数据库对象的概念。（两个即可）
You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database.Which two statements are true about this backup operation?（）
A:Backup compression should be enabled
B:Parallelism for the channel should be set to 2
C:All the files must be backed up as backup sets
D:The backup may be stored either on disk or on media with media manager
以下（）是Oracle相关的系统服务，在Windows操作系统中，可以使用控制面板的服务工具进行管理。
A:Oracle代理服务
B:Oracle的侦听程序
C:用于OEM管理结构
D:Oracle网络服务
You are creating a form that will access an Oracle8 database. On which three sources can you base a data block?（）
A:BFILE 
B:REF column 
C:Object table 
D:Column object 
E:INSTEAD-OF trigger
You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB) as a pluggable database (PDB). The characteristics of the non-CDB are as follows: -Version: Oracle Database 12c Releases 1 64-bit -Character set: WE8ISO8859P15 -National character set: AL16UTF16 -O/S: Oracle Linux 6 64-bit The characteristics of the CDB are as follows: -Version: Oracle Database 12c Release 1 64-bit -Character set: AL32UTF8 -O/S: Oracle Linux 6 64-bit Which technique should you use to minimize down time while plugging this non-CDB into the CDB?（）
A:Transportable database
B:Transportable tablespace
C:Data Pump full export / import
D:The DBMS_PDB package
E:RMAN
You lost a temporary file that belongs to the default temporary tablespace in your database. From the options provided， which approach would you take to solve the problem？（）
A: flash back the database
B: import the temporary tablespace from the last export
C: restore all the data files and temporary files from the last full database backup and perform a recovery
D: not perform a recovery， but create a new temporary tablespace， make it the default temporary tablespace and then drop the old tablespace
Examine the following command：   SQL> ALTER TABLE booking SHRINK SPACE COMPACT；   Which activity is performed when the preceding command is executed？（）
A: The shrink operation touches every block in the BOOKING table
B: The high-water mark （HWM） for the BOOKING table is shifted from its original position
C: The progress of the shrink operation is saved in the bitmap blocks of the BOOKING table
D: The data manipulation language （DML） triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operation
Which constraint can be defines only at the column level? （）
A:UNIQUE
B:NOT NULL
C:CHECK
D:PRIMARY KEY
E:FOREIGN KEY
Evaluate the SQL statement: What will be displayed?（）
A:0
B:1
C:0.00
D:An error statement
For an inventory report, you created a work_in_progress that contains two columns, ID_number and quantity. The parent group of the work_in_progress is in_inventory which contains one column, dept_no. You added a filter of fist fifteen to total_inventory and a filter of last 20 for work_in_progress. Which records will the report return?（）
A:First 15 dept_no values. 
B:Last 20 ID_no and quantity values with the first 15 dept_no values for each work_in_progress value. 
C:First 15 dept_no values with the last 20 ID_number and quantity values for each total_inventory value. 
D:First 15 dept_no values and the last 20 ID_no and quantity values. 
E:The last 20 ID_number and quantity values.
You plan to have a larger moving window size for the default system-defined moving window baseline because you want to use the adaptive threshold. Which statement factors in this consideration while increasing the size of the moving window?（）
A:The collection level for the AWR should be set to BASIC
B:The moving window size must be less than Undo Retention
C:The moving window size should be greater than the Automatic Workload Repository (AWR) retention period
D:The moving window size should be equal to or less than the Automatic Workload Repository (AWR) retention period
You backed up the control file to trace. Which statement is true about the trace file generated？（）
A:The trace file is in binary format.
B:The trace file has a SQL script to re-create the control file.
C:The trace file is a backup set created during the backup of the control file. 
D:The trace file contains the instructions to manually re-create the control file.
E:The trace file is an image copy of the control file created during the backup of the control file.
Which of the following is a valid way of putting a tablespace named DAVE_TBS into hot backup mode？（）  
A: alter tablespace DAVE_TBS backup mode
B: alter tablespace DAVE_TBS start backup
C: alter tablespace DAVE_TBS begin backup
D: alter tablespace DAVE_TBS backup begin
E: alter tablespace DAVE_TBS backup
Which two statements are true regarding the Oracle Data Pump export and import operations（）
A:You cannot export data from a remote database.
B:You can rename tables during an import operation.
C:You can overwrite existing dump files during an export operation.
D:You can compress the data during export but not the metadata because it is not supported.
Given： Which code， inserted at line 15， allows the class Sprite to compile？（）
A:Foo { public int bar（） { return 1； }
B:new Foo { public int bar（） { return 1； }
C:new Foo（） { public int bar（） { return 1； }
D:new class Foo { public int bar（） { return 1； }
Identify two situations in which the alert log file is updated.（）
A:Running a query on a table returns ORA-600: Internal Error.
B:Inserting a value into a table returns ORA-01722: invalid number.
C:Creating a table returns ORA-00955: name us already in used by an existing objects.
D:Inserting a value into a table returns ORA-00001: unique constraint (SYS.OK_TECHP) violated.
E:Rebuilding an index using ALTER INDEX . . . REBUILD fails with an ORA-01578: ORACLE data block corrupted (file # 14, block # 50) error.
You administer an online transaction processing (OLTP) system whose database is stored in Automatic Storage Management (ASM) and whose disk group use normal redundancy. One of the ASM disks goes offline, and is then dropped because it was not brought online before DISK_REPAIR_TIME elapsed. When the disk is replaced and added back to the disk group, the ensuing rebalance operation is too slow. Which two recommendations should you make to speed up the rebalance operation if this type of failure happens again?（）
A:Increase the value of the ASM_POWER_LIMIT parameter.
B:Set the DISK_REPAIR_TIME disk attribute to a lower value.
C:Specify the statement that adds the disk back to the disk group.
D:Increase the number of ASMB processes.
E:Increase the number of DBWR_IO_SLAVES in the ASM instance.
If you back up a database without connecting to the recovery catalog， which operations will cause the recovery catalog to be updated？（）
A: The next time you back up the database when you are also connected to the recovery catalog and the target database
B: The next time you are connected to the target database and the recovery catalog database and issue the resync command
C: The next time you connect RMAN to just the recovery catalog
D: The next time you connect to the recovery catalog and the target database with RMAN
E: Connecting to the recovery catalog and issuing the resync all databases command
在定义游标时使用的FOR UPDATE子句的作用是（）。
A:执行游标
B:执行SQL语句的UPDATE语句
C:对要更新表的列进行加锁
D:都不对
Given: Which code fragment, inserted at line 23, allows the code to compile?（）
A:df = new DateFormat();
B:df = Date.getFormat();
C:df = date.getFormat();
D:df = DateFormat.getFormat();
E:df = DateFormat.getInstance();
Consider typical High Availability (HA) solutions that do not use shared storage. Which three HA solutions do not use shared storage?（）
A:Mysql NDB Cluster
B:Mysql Replication
C:Distributed Replicated Block Device (DRBD) and Mysql
D:Windows Cluster and Mysql
E:Solaris Cluster and Mysql
You configured the large pool for Oracle backup and restore operations. As a result， which component would require less memory？（）
A: streams pool
B: shared pool
C: log buffer
D: keep buffer cache
E: recycle buffer cache
Which two events will cause a slave server to create a new relay log file?（）
A:Execution of the FLUSH LOGS statement
B:Starting of the SQL thread
C:Reaching the slave_pendign _jobs_size_max limit
D:Execution of FULSH TABLES WITH READ LOCK
E:Starting of the I/O thread
Which are the two options to which a menu can be assigned?（） (Choose two.)
A:menu
B:functions
C:data group
D:responsibility
E:functional group
Note the following parameters settings in your database: What would happen?（）
A:It will fail because DB_8K_CACHE_SIZE parameter cannot be changed dynamically
B:It will be successful only if the memory is available from the auto tuned components
C:It will fail because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET
D:It will fail because an increase in the DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE
You created a custom menu for the Order Entry application. The shipping administrator has requested an additional submenu containing four items to invoke various reports. Which command type must you use to identify the parent menu item as a submenu? （）
A:Menu 
B:Plus 
C:Macro
D:PL/SQL
To save time configuring some custom network facilities， a junior administrator in your company  attempts to copy some entries from the /etc/inetd.conf file on a Solaris 8 OS server into the /etc/inetd.conf on a Solaris 10 OS server. The junior administrator is unable to determine why services do not start.  Which two commands can you run on the Solaris 10 OS server to start the services？（）
A: inetconv -f
B: inetcfg -i /etc/inetd.conf
C: inetcfg -o /etc/inetd.conf
D: inetconv -f -i /etc/inetd.conf
E: inetconv -forceimport -o /etc/inetd.conf
首页 <上一页 44 45 46 47 48 下一页> 尾页