出自:Oracle认证

Given: If some sort of exception is thrown at line 34, which output is possible?（）
A:a
B:b
C:c
D:ac
E:abc
You are attempting to clear an unarchived redo log file. In order to manually enact a log switch, which of the following statements is appropriate?（）
A:ALTER DATABASE 
B:ALTER SYSTEM 
C:ALTER USER 
D:ALTER REDO LOG
Consider the following command to create a tablespace in your production database （which is using an Automatic Storage Management [ASM] instance to manage the database files）：  CREATE TABLESPACE user_tbsp  DATAFILE ’+dgroup3（user_temp）/user_files/user_tbsp’ SIZE 200M;  What would be the result of this command？（）
A:It would result in an error because the template cannot be used along with the disk group.
B:It would result in an error because the path cannot be specified while creating a tablespace in a disk group.
C:It would create a tablespace with a data file that has an alias， and its attributes are set by the user­defined template.
D:It would create a tablespace with a data file that does not have an alias， and its attributes are set by the user­defined template.
DRAG DROP Click the Task button.
What command is used to reset a database to a previous incarnation？（）  
A: reset incarnation
B: incarnation reset
C: reset database to incarnation
D: reset database incarnation
E: reset databse incarnation number
The Automatic Database Diagnostic Monitor （ADDM） analysis runs every 60 minutes on your database. Your database is facing a series of interrelated problems over a period of two hours. You need to ensure that the ADDM analysis is run over a time span of two hours in future.  What would you do？（）
A: Create two custom ADDM tasks.
B: Modify the AWR snapshot time interval to two hours.
C: Create a new scheduler window for a time period of two hours.
D: Modify the Automatic Workload Repository （AWR） snapshot retention period to two hours.
This is the online redo log files and the control file configurations： Based on these configurations， which statement is true？（）
A: Both the control files and the online redo log files are configured properly.
B: The control files are configured properly， but the online redo log files are not configured properly.
C: The online redo log files are configured properly， but the control files are not configured properly.
D: Neither the control files nor the online redo log files are configured properly.
The PRODUCTS table has these columns: PRODUCT_ID NUMBER(4) PRODUCT_NAME VARCHAR2(45) PRICE NUMBER(8,2) Evaluate this SQL statement: SELECT * FROM PRODUCTS ORDER BY price, product _ name; What is true about the SQL statement? （）
A:The results are not sorted.
B:The results are sorted numerically.
C:The results are sorted alphabetically.
D:The results are sorted numerically and then alphabetically.
Which two requirements would lead towards a high availability solution?（）
A:When uptime is critical
B:When data must be refactored
C:When application concurrency is static
D:When data loss is unacceptable
E:When application is a single point of failure
When issuing the CROSSCHECK command in RMAN， if a backup file CANNOT be found， to what status is that file set？（）
A:DELETED
B:OBSOLETE
C:EXPIRED
D:UNKNOWN
You are maintaining the SALES database. You have added a new disk to a disk group. Automatic Storage Management performs the rebalancing activity. You want to speed up the rebalancing activity.  Which parameter should you specify to control the speed of the rebalancing activity？（）
A: ASM_POWER_LIMIT
B: ASM_DISKSTRING
C: ASM_DISKGROUPS
D: INSTANCE_TYPE
The database Is configured in ARCHIVELOG mode. The database needs to be up 24 X 7. You want to perform user managed backup for the data files of the HR_DATA tablespace.To accomplish the task, you issued the following command: SQL> ALTER TABLESPACE hi_data BEGIN BACKUP; Which two statements are true in this scenario? （）
A:No transaction on the tablespace is allowed but you can perform queries.
B:The tablespace will automatically come out of backup mode when the file copy is complete.
C:The checkpoint change number is frozen in headers of the data files until the file is removed from backup mode.
D:The database writes the before image of an entire block to the redo stream before modifying. block tor the first time.
Given: Which four code fragments, inserted independently at line 7, will compile? （）
A:public void m1() { }
B:protected void m1() { }
C:private void m1() { }
D:void m2() { }
E:public void m2() { }
F:protected void m2() { }
G:private void m2() { }
关于行级触发器的伪记录，下列说法正确的是（）。
A:INSERT事件触发器中，可以使用“:old”伪记录
B:DELETE事件触发器中，可以使用“:new”伪记录
C:UPDATE事件触发器中，只能使用“:new”伪记录
D:UPDATE事件触发器中，可以使用“:old”伪记
Given： What is the result？（）
A:Compilation fails.
B:An exception is thrown at runtime.
C:The code executes normally and prints "foo".
D:The code executes normally， but nothing is printed.
可以使用（）伪列来访问序列。
A:CURRVAL和NEXTVAL
B:NEXTVAL和PREVAL
C:CACHE和NOCACHE
D:MAXVALUE和MINVALUE
You are managing an Oracle Database 11g instance and an Oracle Database 10g instance on the same machine. Both instances use the ASM instance as storage. Which statement regarding the ASM disk group compatibility attributes are true in this scenario？（）
A: The database-compatibility version settings for each instance must be greater than or equal to the RDBMS compatibility of all ASM disk groups used by that database instances.
B: RDBMS compatibility and the database version determines whether a database instance can mount the ASM disk group.
C: The RDBMS compatibility settings for a disk group control the format of data structures for ASM metadata on the disk.
D: ASM compatibility controls which features for the ASM will be enabled.
Click the Exhibit button and examine the diagram， which illustrates the components performing tasks within an Oracle Shared Sever environment. Which task is being performed by component 4？（）
A:The PMON process registers the request in the response queue.
B:A shared sever places the process request in the response queue.
C:A request within the request queue is processed by an idle shared server process.
D:A dispatcher assigns a request from the request queue to and idle shared server process.
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
You are required to remove the default EXTPROC entry from the default listener configuration to create a listener that will listen specifically for EXTPROC calls. Which two methods can you use to remove the default EXTPROC entry from the default listener configuration？ （）
A: the RMAN utility
B: the import/export utility
C: the Oracle Enterprise Manager
D: the change tracking feature
E: the Net Manager utility
The three tasks shown have been completed in order to configure a naming method： Task 1： Installed on server and client： Oracle Net Services， TCP/IP， TCP/IP protocol adaptor Task 2： Started default listener on port 1521 Task 3： Added global database name to the listener.ora file.  Which naming method was configured？（）
A:host naming method
B:local naming method
C:directory naming method
D:external naming method
Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework？（）
A: SQL statements that are part of the AWR baseline only
B: SQL statements based on the AWR top SQL identification
C: SQL statements that are part of the available SQL Tuning Set （STS） only
D: SQL statements that are available in the cursor cache and executed by a user other than SYS
Which of the following are valid program types for a lightweight job?（）
A:PLSQL_BLOCK PLSQL
B:EXECUTABLE
C:JAVA_STORED_PROCEDURE
D:STORED_PROCEDURE
E:EXTERNAL
Which steps are mandatory to enable Direct NFS？（）   1. Mount all required file systems using the kernel NFS driver.  2. Create an oranfstab file containing the attributes for each NFS server to be accessed using Direct NFS.    3. Replace the ODM library libodm11.so_stub with libodm11.so.
A: 2 and 3
B: 1 and 3
C: 1 and 2
D: 1，2 and 3
In which scenario will you perform an incomplete recovery？（）
A: when a table is dropped and stored in the Recycle Bin
B: when all the control files are deleted
C: when a member of a multiplexed redo log group is dropped
D: when you are required to recover a table to its previous state
限制从EMP表中只选出前5条记录的查语句为（）。
A:SELECT TOP 5 * FROM EMP
B:SELECT DISTINCT 5 * FROM EMP
C:SELECT * FROM EMP WHERE ROWNUM<6
D:SELECT * FROM EMP WHERE ROWNUM=5
What can you determine about the following linguistic sorts based only on their names?（） 1. GERMAN 2. FRENCH_M multilingual
A:1 is a monolingual sort.
B:2 is a monolingual sort.
C:1 is case insensitive.
D:Both 1 and 2 are case insensitive.
E:Case sensitivity is unknown.
You are operating your database in NOARCHIVELOG mode. Your most recent backup includes a copy of all of the data files and the control files taken when the current log sequence number was 45. You experience disk failure on the drive on which your SYSTEM tablespace data files are stored. At the time of the failure， the current log sequence number is 98. Which files should you restore to recover from the loss of the SYSTEM tablespace data files？（）
A:Only the data files.
B:All of the data files and the control files.
C:Only the data files belonging to the SYSTEM tablespace.
D:Only the data files belonging to the SYSTEM tablespace and the control files.
A MySQL replication slave is set up as follows: User all InnoDB tables Receives ROW-based binary logs Has the read-only option The replication slave has been found in an error state. You check the MySQL error log file and find the following entries: 2013-08-27 13:55:44 9056 [ERROR] Slave SQL: Could not execute Write_rows event on table test.tl; Duplicate entry ‘3’ for key’PRIMARY’ , Error_code: 1062; handler error HA_ERR_FOUND_DUPP_KEY; the event’s master log 56_master-bin.000003, end_log_pas 653, Error_code: 1062 2013-08-27 13:55:44 9056 [Warning] Salve: Duplicate entry ‘3’ for key ‘PRIMARY’ Error_code: 1062 2013-08-27 13:55:44 9056 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with “SLAVE START”, We stopped at log ‘56_masterbin.000003’ position 496 What are two possible causes for this error to occur?（）
A:The slave was created with mysqldump –u root –p – skip-lock-table—all-databases > /data/data.sql
B:The slave user does have INSERT, UPDATE, or DELETE permission and cannot execute the write_rows function
C:For tables with UNIQUE keys, statement-based replication must be used maintain integrity
D:The root user on the slave has executed FLUSH LOGS, causing the relay-log to doublewrite
E:The applications have the SUPER privilege, which allows them to update rows
You define an alert to be raised when the USERS tablespace usage has reached 80%of the total space. Which area would you refer to， in order to confirm that the alert has been raised due the event？（）
A:the alert.log file
B:the DBA_ALERTS view
C:the Database Control Home page
D:the Database Control performance page
E:the Database Control Maintenance page
首页 <上一页 53 54 55 56 57 下一页> 尾页