出自:Oracle认证

Click the Exhibit button. What is the result？（）
A:Value is： 8
B:Compilation fails.
C:Value is： 12
D:Value is： -12
You work as a database administrator at Certkiller .com. In your production database there is a job， CALC_STAT， which has been scheduled to run every Friday at 5.00 p.m. CALC_STATupdates the optimizer statistics for the objects owned by the APPSschema. You want the task to be generic， thereby allowing users to modify the attributes of the task at run time without affecting the original task.Which component of Oracle Scheduler must you define to achieve this？（）
A: Window
B: Program
C: Job class
D: Window group
Compare a typical Distributed Replicated Block Device (DRBD) with MySQL Standard Replication using master-slave replication. Which two statements are correct?（）
A:Both technologies guarantee an identical copy of data on the secondary node
B:Only MySQL can maintain a time-delayed copy of data on the secondary node
C:Both technologies use the TCP/IP stack as their primary transmission medium
D:DRBD uses shared-disk technology
在ORACLE客户端网络配置文件中"PORT"参数值为（）
A:服务器的侦听端口，默认为1521
B:服务器的侦听端口，默认为7778
C:中间层的接入端口，默认为1521
D:中间层的接入端口，默认为7778
E:以上所述都不正确
DRAG DROP Click the Task button.
You want to create the Recovery Manager (RMAN) Virtual Private Catalog (VPC) to maintain a separation of responsibilities along with a consolidation of RMAN repository. Which condition must be met before you create the VPC?（）
A:A base catalog exists
B:The recovery catalog is empty
C:The base recovery catalog must be dropped
D:A target database is registered in the recovery catalog
Your database is not configured for session failover. Your tnsnames.ora file contains the following details：  test.us.oracle.com= （DESCRIPTION=  （ADDRESS_LIST= （LOAD_BALANCE=off）   （FAILOVER=ON）   （ADDRESS= （PROTOCOL=tcp）（HOST=test1-server）（PORT=1521））   （ADDRESS= （PROTOCOL=tcp）（HOST=test2-server）（PORT=1521）））   （CONNECT_DATA= （SERVICE_NAME=test.us.oracle.com）））   Which feature is enabled in this case？（）
A:Load balancing
B:Instance failover
C:Database failover
D:Connect-time failover
E:Transparent Application Failover （TAF）
You are creating a database by using Database Configuration Assistant (DBCA). You have chosen the File System option as the storage mechanism. What would be the result of choosing this option?（）
A:Disk mirroring and striping would be done automatically
B:The database files would be managed by the operating system's file system
C:DBCA would not save the database files by using Optimal File Architecture (OFA)
D:The data files are automatically spread across all available storage devices to optimize performance and resource utilization
Which two statements are true regarding B-tree index（）
A:The leaf blocks in the index are doubly linked.
B:The leaf node stores a bitmap for each key value.
C:The rows with NULL value in key columns also have entries in the index.
D:The deletion of a row from the table causes a logical deletion in index leaf block and the space becomes available for the new leaf entry.
写出一个数据字典的应用（所有用户：all_users）。
使用显式游标的过程主要包括（）操作。
A:定义显式游标
B:打开显式游标
C:从显式游标中读取数据
D:关闭显式游标
Given: When line 15 is reached, how many objects are eligible for the garbage collector?（）
A:0
B:1
C:2
D:3
E:4
F:5
Evaluate the following block of code: What is the outcome of the above code?（）
A:It produces an error because a fully qualified host name needs to be specified.
B:It produces an error because the range of ports associated with the hosts has not been specified.
C:It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT and RESOLVE privileges.
D:It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT privilege but not the RESOLVE privilege.
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 SQL statement accepts user input for the columns to be displayed, the table name, and WHERE condition? （）
A:SELECT &1, "&2" FROM &3 WHERE last_name = '&8';
B:SELECT &1, '&2' FROM &3 WHERE '& last_name = '&8';
C:SELECT &1, &2 FROM &3 WHERE last_name = '&8';
D:SELECT &1, '&2' FROM EMP WHERE last_name = '&8';
Which command is used to begin a tablespace point-in-time recovery？（）  
A: Restore tablespace
B: Recover tablespace
C: Tablespace recover
D: Recover to time
E: recover datafile
Click the Exhibit button.   Given this code from Class B：   25. A a1 = new A（）；   26. A a2 = new A（）；   27. A a3 = new A（）；   28. System.out.println（A.getInstanceCount（））；   What is the result？（）
A: Compilation of class A fails.
B: Line 28 prints the value 3 to System.out.
C: Line 28 prints the value 1 to System.out.
D: Compilation fails because of an error on line 28.
E: A runtime error occurs when line 25 executes.
The Oracle Shared Server architecture reduces memory usage by reducing the number of server processes required. To process a request for a server process， the following tasks are performed：   1.A shared server picks up the request from the request queue and processes the  request.  2.The dispatcher retrieves the response from the response queue.  3.A user sends a request to its dispatcher.  4.The dispatcher returns the response to the user.  5.The shared sever places the response on the calling dispatcher’s response queue.  6.The dispatcher places the request into the request queue in the SGA.   Put the above task in the order in which they are performed.（）
A:3，1，6，2，5，4
B:3，6，1，5，2，4
C:3，1，2，3，4，5
D:6，1，3，5，2，4
E:6，3，1，2，4，5
F:6，3，1，2，5，4
当用SQL*PLUS已经登录到某一数据库，此时想登录到另一数据库，应该用命令（）
A:CONN
B:DISC
C:GOTO
D:LOGIN
E:LOGON
You are ready to implement RMAN in the backup and recover strategy for your company. Which system privilege must the RMAN user have to be able to connect and execute RMAN commands on a target database？（）
A:SYSDBA
B:SYSOPER
C:No system privileges are required for the RMAN user.
D:Only SYS user can connect and execute RMAN commands on a target database.
Your company security policy does not allow you to connect your servers directly to the internet. You would like to utilize some of theYour company？ security policy does not allow you to connect your servers directly to the internet. You would like to utilize some of the functionality in Solaris 10 to analyze your systems for available OS updates， and also download and install those updates from Sun Microsystems.  Which answer describes how to utilize this functionality to analyze your systems for available OS updates， and also download and install those updates without connecting your server directly to the internet？ （）
A:A
B:B
C:C
D:D
（）是比块更高一级的存储结构，由一系列的块组成，它是Oracle在进行存储空间分配、回收和管理的基本单元。
A:表空间
B:盘区
C:数据文件
D:段
Given： What is the result？（）
A:Compilation fails.
B:An exception is thrown at runtime.
C:The code executes normally and prints "sleep".
D:The code executes normally， but nothing is printed.
Your database is configured in shared server mode. However， your senior DBA asks you to modifythe value of the PRIVATE_SGA limit in the profile of the users.  What could be the reason for this（）
A:to limit the User Global Area （UGA） memory allocated to a session from the SGA
B:to limit the amount of memory to be used for the dispatcher queue of a session in SGA
C:to limit the amount of memory to be used for the request pool in System Global Area （SGA）
D:to control the amount of memory allocated in SGA for the local variables for each shared server process
In the parameter file of the production database， the BACKGROUND_DUMP_DEST parameter is set to $ORACLE_HOME/users. Which two types of files would you find in this location？（）
A:the alert log file
B:the core dump files
C:the change tracking file
D:the user session trace files
E:the database audit trail files
F:the background process trace files
Which of the following views must you query to identify any corrupt data file blocks that have been detected during backup set creation？（）
A:V$COPY_CORRUPT
B:V$COPY_CORRUPTION
C:V$BACKUP_CORRUPT
D:V$BACKUP_CORRUPTION
Which files are required for a full recovery of the database in ARCHIVELOG mode？（）
A: Database datafiles
B: Online redo logs
C: Archived redo logs
D: Backup control file
E: Control file from a backup
In your database， online redo log files are multiplexed and one of the members in a group is lost due to media failure.  How would you recover the lost redo log member？（）
A:import the database from the last export
B:restore all the members in the group from the last backup
C:drop the lost member from the database， and then add a new member to the group
D:restore all the database files from the backup， and then perform a complete recovery 
E:restore all the database files from the backup， and then perform an incomplete recovery
Which three statements are true about persistent configuration?（）
A:A user cannot set privileges on the persistent lightweight jobs
B:Persistent lightweight jobs generate a large amount of metadata
C:It is possible to create fully self-contained persistent lightweight jobs
D:The use of a template is mandatory to create persistent lightweight jobs
E:Persistent lightweight jobs are useful when users need to create a large number of jobs in a short time
首页 <上一页 61 62 63 64 65 下一页> 尾页