出自:Oracle认证

以下哪个命令是DDL命令（）
A:CREATE
B:INSERT
C:COMMIT
D:SELECT
E:以上所述都不正确
Given: Which three are valid?（）
A:p0 = p1;
B:p1 = p2;
C:p2 = p4;
D:p2 = (ClassC)p1;
E:p1 = (ClassB)p3;
F:p2 = (ClassC)p4;
A database instance is using an Automatic Storage Management (ASM) instance, which has a disk group, DGROUP1, created as follows: SQL> CREATE DISKGROUP dgroup1 NORMAL REDUNDANCY FAILGROUP controller1 DISK '/devices/diska1', '/devices/diska2' FAILGROUP controller2 DISK '/devices/diskb1', '/devices/diskb2' ; What happens when the whole CONTROLLER1 Failure group is damaged?（）
A:The transactions that use the disk group will halt.
B:The mirroring of allocation units occurs within the CONTROLLER2 failure group.
C:The data in the CONTROLLER1 failure group is shifted to the CONTROLLER2 failure group and implicit rebalancing is triggered.
D:The ASM does not mirror any data and newly allocated primary allocation units (AU) are stored in the CONTROLLER2 failure group.
第一步用DELETE命令删除了表A中的数据（但并没有提交），第二步试图创建了一个表B，但由于权限不足，表B并没有创建成功。第三步执行了一个ROLLBACK回滚操作。请问以下叙述正确的是（）。
A:表A中的数据被恢复回来
B:表A中的数据被彻底从数据库中删除
C:表A中的数据被移至一个临时的表中
D:表A中的数据将处于一个不确定的状态
E:以上所述都不正确
Which dynamic performance view displays the information about the files associated with the locally managed temporary tablespaces in Oracle9i？（）
A:V$DATAFILE
B:V$TEMPFILE
C:V$DBFILE
D:V$DATAFILE_HEADER
You are working as a Database Administrator. You erroneously dropped an important table named WAREHOUSE_DETAILS. The table resides in a non-SYSTEM tablespace.  The following dependent objects have been defined on the dropped table：       Due to limited space， some of the indexes and triggers have been removed from the Recycle Bin. You decide to recover the table by using Flashback Drop. You execute the following statement： SQL>FLASHBACK TABLE warehouse_details TO BEFORE DROP；   What will be the implication of executing this statement？（）
A: Only the WAREHOUSE_DETAILS table is recovered， and none of the dependent objects are recovered.
B: The WAREHOUSE_DETAILS table is recovered along with the NOT NULL constraints， primary key constraint， and the referential integrity constraints.
C: The WAREHOUSE_DETAILS table is recovered along with all the dependent objects except the indexes and triggers previously removed from the Recycle Bin.
D: The WAREHOUSE_DETAILS table is recovered along with all the dependent objects except the referential integrity constraints and the indexes and triggers previously removed from the Recycle Bin.
What does the DB_FLASHBACK_RETENTION_TARGET parameter configure？（）  
A: An upper limit on how far you can flash back the database，depending on the information in the redo logs
B: An upper limit on how far you can flash back the database，depending on the information in the undo tablespace
C: The amount of time for which the flashback data is to be kept in the flash recovery area， provided that there is enough space
D: The amount of time for which the flashback data is guaranteed to be kept in the undo tablespace，provided that there is enough space
Evaluate the following SQL statement used to create the PRODUCTS table: Which statement is true regarding this command?（）
A:It executes successfully but partition pruning cannot happen for this partition key.
B:It produces an error because the TOTAL_VALUE column cannot be used as a partition key.
C:It produces an error because compression cannot be used for the TOTAL_VALUE partition key.
D:It executes successfully but the values in the TOTAL_VALUE column would not be physically stored in the partitions.
You have only two redo log groups and these groups get overwritten several times in a day. Your database operates in NOARCHIVELOG mode and user-managed consistent backups are performed every Sunday night. On Thursday morning， you find that an important table has been dropped and purged. With reference to this scenario， up to what point in time can the data be recovered？（）
A: until Thursday morning
B: until that point in time when the database is opened
C: until that point in time when the recovery is performed
D: until last Sunday’s backup
E: until that point in time when the table is dropped and purged
F: until Wednesday evening
To set the history retention period for either window logging or job logging individually， which parameters of the SET_SCHEDULER_ATTRIBUTE procedure need to be used？（）
A: LOG_HISTORY
B: JOB_LOG_RETENTION
C: WINDOW_LOG_RETENTION
D: WHICH_LOG
E: LOG_NAME
User A executes the following command to drop a large table in your database：SQL> DROP TABLE trans； While the drop table operation is in progress， user B executes the following command on the same table：SQL> DELETE FROM trans WHERE tr_type=’SL’； Which statement is true regarding the DELETE command（）
A:It fails to delete the records because the records are locked in SHARE mode.
B:It deletes the rows successfully because the table is locked in SHARE mode
C:It fails to delete the records because the table is locked in EXCLUSIVE mode.
D:It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.
What is true about a background engine? （）(Choose two.)
A:It is a server-side PL/SQL procedure.
B:When executing a PL/SQL function activity, it will automatically ping (cache) the PL/SQL code.
C:It executes deferred activities in decreasing order of their Cost property value (activities with higher cost value are processed first).
D:It would fail if another background engine process is started to handle the same type of activities within the same item type.
E:During its single invocation, it processes activities that were stuck, deferred or timed out when the background engine was started.
To perform management activities， each domain requires its own（）
A: Administration Server
B: Configuration Wizard
C: Ant Task
D: Node Server
During regular database operation, which background process will take smaller blocks of free space in a dictionary-managed tablespace and move things around to make bigger pieces of free space?（）
A:DBW0 
B:LGWR 
C:ARCH 
D:SMON 
E:PMON
Given：   11. String test = "This is a test"；   12. String[] tokens = test.split（"/s"）；   13. System.out.println（tokens.length）；   What is the result？（）
A: An exception is thrown at runtime.
B: 1
C: 4
D: Compilation fails.
E: 0
Which of the following are not disabled by default？（）
A: Jobs
B: Chains
C: Windows
D: Window groups
E: Schedule
You have just run this syntax to start the listener from the Listener Control utility：   LSNRCTL>START   Starting /mstgelai/oracle/bin/tnslsnr： please wait…  System parameter file is /u01/oracle/network/admin/listener.ora Log messages written to /u01/oracle/network/log/listener.log  Listening on： （DESCRIPTION=（ADDRESS=（PROTOCOL=tcp）（HOST=stc-sun01-server）（PORT=1521））） Connecting to…  The command completed successfully   What is the name of the Listener you started？（）
A:TNSLSNR
B:LISTENER
C:LOCAL_LISTENER
D:DEFAULT_LSRN
Which two statements are true regarding working with dates?（）
A:The default internal storage of dates is in the numeric format 
B:The default internal storage of dates is in the character format 
C:The RR date format automatically calculates the century from the SYSDATE function and does not allow the user to enter the century 
D:The RR date format automatically calculates the century from the SYSDATE function but allows the user to enter the century if required
DRAG DROP Click the Task button.
Note the following points describing various utilities in Oracle Database 1g：1. It enables the high-speed transfer of data from one database to another. 2. It provides a complete solution for the backup， restoration， and recovery needs of the entire database.3. It enables the loading of data from an external file into an Oracle database.4. It provides a tape backup management for the Oracle ecosystem. Which point describes Oracle Secure Backup（）
A:1
B:2
C:3
D:4
E:1， 2， and 4
F:1， 2， 3， and 4
You install a non-RAC Oracle Database. During Installation, the Oracle Universal Installer (OUI) prompts you to enter the path of the Inventory directory and also to specify an operating system group name. Which statement is true?（）
A:The ORACLE_BASE base parameter is not set.
B:The installation is being performed by the root user.
C:The operating system group that is specified should have the root user as its member.
D:The operating system group that is specified must have permission to write to the inventory directory
Which three statements are true regarding subqueries?（）
A:Subqueries can contain GROUP BY and ORDER BY clauses 
B:Main query and subquery can get data from different tables 
C:Main query and subquery must get data from the same tables 
D:Subqueries can contain ORDER BY but not the GROUP BY clause 
E:Only one column or expression can be compared between the main query and subquery
F: Multiple columns or expressions can be compared between the main query and subquery
Your database is open and the LISTENER listener running. You stopped the wrong listener LISTENER byissuing the following command:lsnrctl > STOPWhat happens to the sessions that are presently connected to the database Instance?（）
A:They are able to perform only queries.
B:They are not affected and continue to function normally.
C:They are terminated and the active transactions are rolled back.
D:They are not allowed to perform any operations until the listener LISTENER is started
Examine the commands executed in a DBA session：SQL> CREATE BIGFILE TABLESPACE MRKT 2 DATAFILE ’/u01/app/oracle/oradata/orcl/mrkt.dbf’ size 10M LOGGING 3 EXTENT MANAGEMENT LOCALSEGMENT SPACE MANAGEMENT AUTO； Tablespace created. SQL> ALTER DATABASE DEFAULT TABLESPACE MRKT； Database altered.  Which two statements are trueregarding the MRKT tablespace（）
A:No more data files can be added to the tablespace.
B:Segment space is managed by free lists in the tablespace.
C:A user created without being assigned a default tablespace uses this tablespace.
D:The tablespace can be dropped with the current setting with segments present in it
Given: Which two are true? （）
A:The output is mm.
B:The output is mc.
C:Component is-a Meter.
D:Component has-a Meter.
E:DeluxeThingy is-a Component.
F:DeluxeThingy has-a Component.
Which one of the following statements about the TNSPING utility is correct？（）
A:It helps you to determine whether or not the Oracle database is running.
B:It requires the username and password to check the connectivity of the service.
C:It does not require the username and password to check the connectivity of the service.
D:It establishes a session with the database and checks the connectivity of the service.
The ST_INFO master table has millions of rows that are updated very rarely. It has a STATE_CODE column that contains the value for 25 states. The table is frequently queried on the STATE_CODE column. Which type of index would you suggest to improve the query performance？（）
A:B-tree
B:bitmap
C:reverse key
D:function based
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE You issue these statements: CREATE table new_emp ( employe_id NUMBER, name VARCGAR2(30)); INSERT INTO new_emp SELECT employee_id, last_name from employees; Savepoint s1; UPDATE new_emp set name = UPPER(name); Savepoint s2; Delete from new_emp; Rollback to s2; Delete from new_emp where employee_id=180; UPDATE new_emp set name = 'James'; Rollback to s2; UPDATE new_emp sey name = 'James' Where employee_id=180; Rollback; At the end of this transaction, what is true?（）
A:You have no rows in the table.
B:You have an employee with the name of James.
C:You cannot roll back to the same savepoint more than once.
D:Your last update fails to update any rows because employee ID 180 was already deleted.
A web application is bound to the context named "/webapp" and the client uses the browser and  makes a request to the resource http://server:port/webapp/ctxl/resource.    Where do you place this resource inside the web application structure?（）
A:in the subdirectory /WEB-INF/ctxl
B:in the subdirectory /META-INF/ctxl
C:in the subdirectory /ctxl in the root of the archive
D:in the subdirectory /ctxl/resource in the root of the archive
E:in the root of the archive
Which command will result in a trace file being created with the create controlfile command contained in it?（）
A:alter database backup controlfile
B:alter database backup controlfile to trace
C:alter database controlfile backup
D:alter database controlfile backup to ’/ora01/oracle/ctrl_backup.ctl’
E:alter database begin controlfile backup
首页 <上一页 133 134 135 136 137 下一页> 尾页