出自:Oracle认证

View the Exhibit and examine the privileges granted to the MGR_ROLE role. The user SKD has been granted the CONNECT and RESOURCE roles only. The database administrator （DBA） grants MGR_ROLE to the user SKD by executing the command： SQL> GRANT MGR_ROLE TO SKDWITH ADMIN OPTION；  Which statement is true about the user SKD after he/she is granted this role（）
A:The user SKD can grant only the MGR_ROLE role to other users， but not the privileges in it. 
B:The user SKD can revoke the MGR_ROLE only from the users for whom he/she is the grantor.
C:The user SKD can grant the privileges in the MGR_ROLE role to other users， but not with ADMIN OPTION.
D:The user SKD can grant the privileges in the MGR_ROLE role to other users， but cannot revoke privileges from them.
Which two IDEs are supported development environments for WebLogic Server 12c in version 12.1.1?（）
A:Websphere Developer Studio
B:NetBeans
C:InteliJ IDIA
D:JDeveloper
E:Eclipse
F:WebLogic Workshop
What are three purposes of the RMAN “FROM” clause?（）
A:to support PUSH-based active database duplication
B:to support synchronization of a standby database with the primary database in a Data environment
C:To support PULL-based active database duplication
D:To support file restores over the network in a Data Guard environment
E:To support file recovery over the network in a Data Guard environment
The EMPLOYEE tables has these columns: LAST_NAME VARCHAR2(35) SALARY NUMBER(8,2) COMMISSION_PCT NUMBER(5,2) You want to display the name and annual salary multiplied by the commission_pct for all employees. For records that have a NULL commission_pct, a zero must be displayed against the calculated column. Which SQL statement displays the desired results?（）
A:SELECT last_name, (salary * 12) * commission_pct FROM EMPLOYEES;
B:SELECT last_name, (salary * 12) * IFNULL(commission_pct, 0) FROM EMPLOYEES;
C:SELECT last_name, (salary * 12) * NVL2(commission_pct, 0) FROM EMPLOYEES;
D:SELECT last_name, (salary * 12) * NVL(commission_pct, 0) FROM EMPLOYEES;
Which two statements about subqueries are true? （）
A:A single row subquery can retrieve data from only one table.
B:A SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's FROM clause.
C:A SQL query statement can display data from table B that is referred to in its subquery, without including table B in its own FROM clause.
D:A single row subquery can retrieve data from more than one table.
E:A single row subquery cannot be used in a condition where the LIKE operator is used for comparison.
F:A multiple-row subquery cannot be used in a condition where the LIKE operator is used for comparison.
Which built-in returns a BOOLEAN value that indicated whether an objects internal ID is available?（）
A:GET_ID 
B:ID_NULL 
C:ID_FIND 
D:FIND_ID
定义过程和定义函数的主要区别之一是，定义函数必须使用（）返回数据。
A:return子句
B:throw
C:RAISE
D:TRY
You created a view called EMP_DEPT_VU that contains three columns from the EMPLOYEES and DEPARTMENTS tables: EMPLOYEE_ID, EMPLOYEE_NAME AND DEPARTMENT_NAME. The DEPARTMENT_ID column of the EMPLOYEES table is the foreign key to the primary key DEPARTMENT_ID column of the DEPARTMENTS table. You want to modify the view by adding a fourth column, MANAGER_ID of NUMBER data type from the EMPLOYEES tables. How can you accomplish this task?（）
A:ALTER VIEW emp_dept_vu (ADD manager_id NUMBER);
B:MODIFY VIEW emp_dept_vu (ADD manager_id NUMBER);
C:ALTER VIEW emp_dept_vu AS   SELECT employee_id, employee_name,   department_name, manager_id   FROM employee e, departments d   WHERE e.department_id = d.department_id;
D:MODIFY VIEW emp_dept_vu AS   SELECT employee_id, employee_name,   department_name, manager_id   FROM employees e, departments d   WHERE e.department_id = d.department_id;
E:CREATE OR REPLACE VIEW emp_dept_vu AS   SELECT employee_id, employee_name,   department_name, manager_id   FROM employees e, departments d   WHERE e.department_id = d.department_id;
F:You must remove the existing view first, and then run the CREATE VIEW command   with a new column list to modify a view.
Given a class Repetition： Which code should be inserted at line 1 of Demo.java to compile and run Demo to print "pizzapizza"？（）
A:import utils.*；
B:static import utils.*；
C:import utils.Repetition.*；
D:static import utils.Repetition.*；
E:import utils.Repetition.twice（）；
F:import static utils.Repetition.twice；
使用（），可以将某个SQL语句的执行依赖于另一个查询语句的执行结果。
A:内连接查询
B:子查询
C:外连接查询
D:合并查询
Given： What is the result？（）
A:A,B,C
B:B,C,A
C:Compilation fails
D:The code runs with no output
E:An exception is thrown at runtime
Performance divergence indicated in the Workload Replay report is most likely due to what？（）  
A: DML and SQL statement results that do not match between the capture and replay systems
B: When errors that occur in the capture system dont occur in the replay system
C: Top SQL statements
D: Infrastructure or system-configuration differences
E: Time-of-day differences between capture and replay systems
You work as a database administrator for Supportcenter.cn. Your database is in the MOUNT state and you execute the following command to open it ALTER DATABASE OPEN； What two actions are performed as a result of this command？（）
A:All control files are opened
B:All redo files are opened
C:The password file is opened
D:The parameter file is opened
E:All online data files are opened
Which two statements are true about Block Media Recovery （BMR）？（）
A: BMR increases the Mean Time To Recover （MTTR）.
B: BMR can only be implemented using Recovery Manager （RMAN）.
C: The blocks that need to be recovered are accessible during BMR.
D: BMR cannot be performed using cumulative incremental backups.
E: The datafile must be restored if most of the blocks in the datafile are corrupt.
You disabled the Flashback Database feature by using the following command：  SQL> ALTER DATABASE FLASHBACK OFF；  What would be the effect of this command on the existing flashback logs？（）
A: Flashback logs are not deleted.
B: Flashback logs are deleted automatically.
C: Flashback logs are deleted only if you are using Recovery Manager （RMAN）
D: Flashback logs are deleted only if you are using Oracle Manager Files （OFM）
E: Flashback logs are deleted only if you are using Automatic Storage Management （ASM）
The INV_HISTORY table is created using the command：   SQL>CREATE TABLE INV_HISTORY （inv_no NUMBER（3）， inv_date DATE， inv_amt NUMBER（10，2）） partition by range （inv_date） interval （numtoyminterval（1，’month’）） （partition p0  values less than （to_date（’01-01-2005’，’dd-mm-yyyy’））， partition p1 values less than （to_date（’01-01-2006’，’dd-mm-yyyy’）））；   The following data has been inserted into the INV_HISTORY table ：   INV_NO INV_DATE INV_AMT 1 30-dec-2004 1000 2 30-dec-2005 2000 3 1-feb-2006 3000 4 1-mar-2006 4000 5 1-apr-2006 5000   You would like to store the data belonging to the year 2006 in a single partition and issue the command：   SQL> ALTER TABLE inv_history MERGE PARTITIONS  FOR（TO_DATE（’15-feb-2006’，’dd-mon-yyyy’））， FOR（TO_DATE（’15-apr-2006’）） INTO PARTITION sys_py；  What would be the outcome of this command？（）
A: It executes successfully，and the transition point is set to ’1-apr-2006’.
B: It executes successfully，and the transition point is set to ’15-apr-2006’.
C: It produces an error because the partitions specified for merging are not adjacent.
D: It produces an error because the date values specified in the merge do not match the date values stored in the table.
Which two statements are true regarding subqueries? （）
A:A subquery can retrieve zero or more rows 
B:Only two subqueries can be placed atone level 
C:A subquery can be used only in SQL query statements 
D:A subquery can appear on either side of a comparison operator 
E:There is no limit on the number of subquery levels in the WHERE clause of a SELECT statement 
You want the size of the tablespace to increase when it is full. Which option would you use？（）
A:use automatic extent allocation
B:disable threshold for the tablespace
C:use freelists to manage the free space
D:use automatic segment space management
E:create the tablespace as a bigfile tablespace
F:use the RESIZE clause while creating the tablespace
G:enable AUTOEXTEND for at least one of the data files in the tablespace
Examine the CREATE DISKGROUP command used to create a disk group: SQL> CREATE DISKGROUP misc EXTERNAL REDUNDANCY DISK 'ORCL: FRA3' NAME misc1, 'ORCL: FRA4' NAME misc2; In which situation would you use this method of disk group creation?（）
A:When two-way disk mirroring is required for the allocation units
B:When three-way disk mirroring is required for the allocation units
C:When using hardware mirroring or RAID
D:When disk mirroring is required for the Automatic Storage Management (ASM) disks
You are maintaining the SALES database on Oracle 10g. 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 will you specify to control the speed of the rebalancing activity？ （） 
A: ASM_POWER_LIMIT
B: ASM_DISKSTRING
C: ASM_DISKGROUPS
D: LARGE_POOL_SIZE
You work as a database administrator for Supportcenter.cn. One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it？（）
A:Uses undo data for roll forward
B:Uses Flashback Log for recovery
C:Uses online redo logs to roll back
D:Uses undo data to roll back the transaction
E:Uses Recovery Manager （RMAN） to roll back
F:Uses the System Monitor （SMON） background process to perform instance recovery
After performing a clean shut down of the database instance for maintenance， you mount thedatabase and then execute a command to open the database： SQL> ALTER DATABASE OPEN；  Which two statements are true（）
A:The online redo log files and online data files are opened.
B:All the online data file headers are checked for consistency.
C:Instance recovery is performed before opening the database.
D:The path and existence of all the log file members are checked
You have specified the warning and critical threshold values of an application tablespace to be 60% and 70%， respectively. From the tablespace space usage metrics， you find that the actual space usage has reached the specified warning threshold value， but no alerts have been generated.  What could be the reason for this？（） 
A:The EVENT parameter was not set.
B:The SQL_TRACE parameter is set to FALSE
C:The Enterprise Manager Grid Control is not used.
D:The STATISTICS_LEVEL parameter is set to BASIC
E:The TIMED_STATISTICS parameter is set to FALSE
The user Alice wants to grant all users query privileges on her DEPT table. Which SQL statement accomplishes this? （）
A:GRANT select ON dept TO ALL_ USER;
B:GRANT select ON dept TO ALL;
C:GRANT QUERY ON dept TO ALL_USERS
D:GRANT select ON dept TO PUBLIC;
Your database is functional with peak load for one hour. You want to preserve the performance statistics collected during this period so that they can be used for comparison while analyzing the performance of thedatabase in the future. What action would you take to achieve this task？（）
A:Set the STATISTICS_LEVEL initialization parameter to ALL.
B:Create a baseline on a pair of snapshots that have the statistics of the peak-load period in the database.
C:Decrease the snapshot interval in the AWR to collect more number of snapshots during the peak-load period.
D:Set the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid the automatic purging of the snapshots.
程序包通常（）组成。
A:规范
B:函数
C:主体
D:过程
Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command：   RESTORE CONTROLFILE FROM AUTOBACKUP；   Which of the following statements is true？（） 
A: The command restores only the missing control file.
B: The command restores all the control files.
C: The command fails because the database is running.
D: This is the correct way to address this problem.
E: This is not the correct way to address this problem.
How would you grant the RVPC user access to specific RMAN database records in the RMAN virtual private catalog？（）  
A: Issue the grant command from the SYS user （or equivalent） of the target database.
B: Issue the grant command from the SYS user （or equivalent） of the recovery-catalog database.
C: Issue the grant command from the recovery catalog-owning schema user account in the recovery catalog.
D: Issue the grant command from RMAN when connected to the recovery catalog-owning schema.
E: Issue the grant command from RMAN when connected to the target database.
Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_NAME VARCHAR2(30) NOT NULL FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2) Which statement produces the number of different departments that have employees with last name Smith? （）
A:SELECT COUNT (*) FROM employees WHERE last _name='smith';
B:SELECT COUNT (dept_id) FROM employees WHERE last _name='smith';
C:SELECT DISTINCT (COUNT (dept_id) FROM employees WHERE last _name='smith';
D:SELECT COUNT (DISTINCT dept_id) FROM employees WHERE last _name='smith';
E:SELECT UNIQE (dept_id) FROM employees WHERE last _name='smith';
In your multitenant container database (CDB) with two pluggable database (PDBs). You want to create a new PDB by using SQL Developer. Which statement is true?（）
A:The CDB must be open.
B:The CDB must be in the mount stage.
C:The CDB must be in the nomount stage.
D:Alt existing PDBs must be closed.
首页 <上一页 119 120 121 122 123 下一页> 尾页