出自:Oracle认证

在Oracle中引入的（）语句通常被称作“更新插入”，因为使用该语句可以在同一个步骤中更新（update）并插入（insert）数据行，对于抽取、转换和载入类型的应用软件可以节省大量宝贵的时间。
A:子查询
B:合并查询
C:外连接查询
D:内连接查询
When an UNDO segment is created manually by you, its availability status is set to which of the following automatically by Oracle?（）
A:Online 
B:Pending online 
C:Offline 
D:Stale
第一步用DELETE命令删除了表A中的数据（但并没有提交），第二步成功创建了一个表B，第三步执行了一个ROLLBACK回滚操作。请问以下叙述正确的是（）。
A:表A中的数据被恢复回来，创建的表B被从数据库中被删除，恢复为未建表之前的状态
B:表A中的数据被恢复回来，表B被创建在数据库中.
C:表A中的数据被彻底从数据库中删除，但表B被从数据库中被删除，恢复为未建表之前的状态
D:表A中的数据被彻底从数据库中删除，表B被创建在数据库中.
E:以上所述都不正确
Examine the following RMAN script：   RMAN> run { debug on；  allocate channel c1 type disk； backup datafile 5； }   Which statement describes the purpose of the script？（）  
A: The data file is checked for physical corruption and backed up if found clean.
B: The backup of data file 5 is performed and the interactive messages during the backup are suppressed.
C: The existing backup for the data file is checked and the backup is performed if there are changes in the data file after the last backup.
D: The backup of data file 5 is performed and all SQL statements that are executed during RMAN compilation and their results are displayed
What are two reasons to create synonyms? （）
A:You have too many tables.
B:Your tables are too long.
C:Your tables have difficult names.
D:You want to work on your own tables.
E:You want to use another schema's tables.
F:You have too many columns in your tables.
You are maintaining your database in Oracle10g. You find that the INDEXES index tablespace should be recovered. How will you recover the index tablespace？（）
A: by using the Flashback Database feature
B: by using RMAN incomplete recovery
C: by performing a user-managed incomplete recovery
D: by dropping and re-creating the index tablespace
Your company decided to start using RMAN in its backup strategy. Previously your company used operating system file copies. Which command is used to make RMAN aware of existing backups made by copying files at the operating system？（）
A:CHANGE
B:RESYNC
C:CATALOG
D:CROSSCHECK
What recommendations does the SQL Access Advisor provide for optimizing SQL queries?（）
A:selection of SQL plan baselines
B:partitioning of tables and indexes
C:creation of index-organized tables
D:creation of bitmap, function-based, and B-tree indexes
E:optimization of materialized views for maximum query usage and fast refresh
Which of the following initialization parameters have been deprecated in Oracle 11g because of the introduction of the Automatic Workload Repository？（） 
A: BACKGROUND_DUMP_DEST
B: FOREGROUND_DUMP_DEST
C: CORE_DUMP_DEST
D: USER_DUMP_DEST
E: DIAGNOSTIC_DEST
F: All of the above
Examine the structure of the STUDENTS table: You need to create a report of the 10 students who achieved the highest ranking in the course INT SQL and who completed the course in the year 1999.Which SQL statement accomplishes this task?（）
A:
B:
C:
D:
Given： Which statement is true？（）
A:Compilation fails.
B:An exception is thrown at runtime.
C:Synchronizing the run（） method would make the class thread-safe.
D:The data in variable "x" are protected from concurrent access problems.
E:Declaring the doThings（） method as static would make the class thread-safe.
说明触发器的种类和对应的作用对象、触发事件。
（）是Oracle最基本的物理存储单元。
A:数据文件
B:控制文件
C:日志文件
D:物理块
Given： and two separate command line invocations： java Yippee java Yippee 1 2 3 4 What is the result？（）
A:No output is produced.1 2 3
B:No output is produced.2 3 4
C:No output is produced.1 2 3 4
D:An exception is thrown at runtime.1 2 3
Which of the following would be affected by setting NLS_LENGTH_SEMANTICS=CHAR?（）
A:All objects in the database
B:Tables owned by SYS and SYSTEM
C:Data dictionary tables
D:NCHAR columns
E:CHAR columns
（）进程是一个和前台用户进程通信的进程，当数据库修改时，系统会产生一个日志并记录在重做日志缓冲区内。
A:DBWR
B:SMON
C:LGWR
D:PMON
You have a listener process， L1， currently listening for the connections to the PROD and ADMIN databases. You create a new database， PAY， using CREATE  DATABASE.. command. You have not enabled dynamic instance registration. You modified the LISTENER.ORA file manually to include PAY database for L1 listener process.  Which command of Listener control utility （LSNRCTL） would you use to enable L1 process to start listening for the connections to the PAY database without disrupting any existing database communications？（）
A:START
B:RELOAD
C:RESTART
D:REFRESH
E:START L1
F:RELOAD L1
G:RESTART L1
H:REFRESH L1
下列（）是Oracle superaggregate函数？
A:ROLLUP
B:VARIANCE
C:REGR_R2
D:RANK
The EMP table has these columns: ENAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATE Management wants a list of names of employees who have been with the company for more than five years. Which SQL statement displays the required results?（）
A:SELECT ENAME FROM EMP WHERE SYSDATE-HIRE_DATE >5;
B:SELECT ENAME FROM EMP WHERE HIRE_DATE-SYSDATE >5;
C:SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)/365 >5;
D:SELECT ENAME FROM EMP WHERE (SYSDATE_HIRE_DATE)*/365 >5;
Click the Exhibit button and examine the data in the EMPLOYEES table. On the EMPLOYEES table, EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID. The JOB_ID column is a NOT NULL column. Evaluate this DELETE statement: DELETE employee_id, salary, job_id FROM employees WHERE dept_id = 90; Why does the DELETE statement fail when you execute it?（）
A:There is no row with dept_id 90 in the EMPLOYEES table.
B:You cannot delete the JOB_ID column because it is a NOT NULL column.
C:You cannot specify column names in the DELETE clause of the DELETE statement.
D:You cannot delete the EMPLOYEE_ID column because it is the primary key of the table.
Which two statements are true regarding a tablespace（）
A:It can span multiple databases.
B:It can consist of multiple data files.
C:It can contain blocks of different sizes.
D:It can contain segments of different sizes.
E:It can contain a part of a nonpartitioned segment.
Given： What is the result?（）
A:0.0
B:Compilation fails.
C:A ParseException is thrown by the parse method at runtime.
D:A NumberFormatException is thrown by the parse method at runtime.
The EMPLOYEES table has these columns:LAST_NAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATEManagement wants to add a default value to the SALARY column. You plan to alter the table by using this SQL statement:ALTER TABLE EMPLOYEES MODIFY (SALARY DEFAULT 5000);Which is true about your ALTER statement?（）
A:Column definitions cannot be altered to add DEFAULT values.
B:A change to the DEFAULT value affects only subsequent insertions to the table.
C:Column definitions cannot be altered to add DEFAULT values for columns with a NUMBER data type.
D:All the rows that have a NULL value for the SALARY column will be updated with the value 5000.
You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance. At the end of the day, while all three production database instances are running, you execute the following command on the ASM instance : SQL> shutdown immediate; What is the result of executing this command?（）
A:The ASM instance is shut down, but the other instances are still running.
B:It results in an error because other database instances are connected to it.
C:All the instances, including the ASM instance, are shut down in the IMMEDIATE mode.
D:HRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode.
Which are the two prerequisites before setting up Flashback Data Archive? （）(Choose two.)
A:Flash recovery area must be defined
B:Undo retention guarantee must be enabled.
C:Database must be running in archivelog mode.
D:Automatic undo management must be enabled.
E:The tablespace in which the Flashback Data Archive is created must have automatic segment space Management (ASSM).
You are managing an Oracle Database 11g database. You want to take a backup on tape drives of the USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB each. To accomplish the backup, you issued the following RMAN command: RMAN> BACKUP SECTION SIZE 300M TABLESPACE users; Identify the appropriate configuration to accomplish faster and optimized backups using the above command.（）
A:The SBT channel must be configured, with the MAXPIECESIZE set to 300 mb.
B:The SBT channel must be configured, with the parallelism setting for the SBT devices set to 3.
C:The COMPATIBLE initialization parameter for the database instance must be set to at least 10.0.
D:The SBT channel must be configured, with the default parallelism setting for the SBT devices set to 1
If two windows overlap, which window attribute will determine whether one should be chosen over the other?（）
A:WINDOW_PRIORITY
B:PRIORITY
C:PRIORITY_LEVEL
D:WINDOW_PRIORITY_LEVEL
E:OVERLAP_RULE
Given： Which three methods， inserted individually at line 14， will correctly complete class Two？（）
A:int foo（） {  }
B:void foo（） {  }
C:public void foo（） {  }
D:private void foo（） {  }
E:protected void foo（） {  }
Which two tasks can your perform by using the TO_CHAR function?（）
A:Convert 10 to ‘TEN’
B:Convert ‘10’ to 10
C:Convert ‘10’ to ‘10’
D:Convert ‘TEN’ to 10
E:Convert a date to a character expression
F:Convert a character expression to a date
You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs). Examine the query and its output: Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKM privilege to the password file?（）
A:Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.
B:Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.
C:Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to No.
D:Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.
E:Re-create the password file in the Oracle Database 12c format.
首页 <上一页 42 43 44 45 46 下一页> 尾页