Oracle认证 - 自考题库

出自:Oracle认证

View the Exhibit to examine the output for the V$DIAG_INFO view. Which statements are true regarding the location of diagnostic traces?（）

A:The path to the location of the background as well as the foreground process trace files is /u01/oracle/diag/rdbms/orclbi/orclbi/trace.
B:The location of the text alert log file is /u01/oracle/diag/rdbms/orclbi/orclbi/alert.
C:The location of the trace file for the current session is /u01/oracle/diag/rdbms/orclbi/orclbi/trace.
D:The location of the XML-formatted version of the alert log is /u01/oracle/diag/rdbms/orclbi/orclbi/alert.

Oracle Coherence is best classified as （）?
A:A Database Product
B:A Middleware Product
C:An Object Relational Mapping (ORM) Tool
D:A Soft Load Balancer
E:An Application Product

Which interface provides the ability to aggregate values across a cluster in parallel using Filters ？（）
A: ConcurrentMap
B: Java.Util.AbstractMap
C: ObservableMap
D: InvocableMap

Which five methods， inserted independently at line 5， will compile？（）
A: protected int blipvert（long x） { return 0； }
B: protected long blipvert（int x） { return 0； }
C: private int blipvert（long x） { return 0； }
D: private int blipvert（int x） { return 0； }
E: public int blipvert（int x） { return 0； }
F: protected long blipvert（long x） { return 0； }
G: protected long blipvert（int x， int y） { return 0； }

Which tasks can be accomplished using the DBMS_LOB. SETOPTIONS procedure?（）
A:only encryption and compression settings for all SecureFile LOBs
B:only encryption and deduplication settings for only SecureFile CLOBs
C:deduplication, encryption, and compression settings for all SecureFile LOBs
D:deduplication, encryption, and compression settings only for SecureFile CLOBs

You find that the database performance degrades while you backup the PROD database using Recovery Manager （RMAN）. The PROD database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason. Which action would you consider to overcome the performance degradation？（）
A:Configure Java Pool to cache the java objects.
B:Configure Streams Pool to enable parallel processing.
C:Increase Shared Pool size to cache more PL/SQL objects.
D:Increase Database Buffer Cache size to increase cache hits.
E:Configure Large Pool to be used by RMAN and shared server.
F:Increase the total System Global Area （SGA） size to increase memory hits.

Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following command in the root container: Which two statements are true?（）
A:Schema objects owned by the C# # A_ADMIN common user can be shared across all PDBs.
B:The C # # A_ADMIN user will be able to use the TEMP_TS temporary tablespace only in root.
C:The command will, create a common user whose description is contained in the root and each pdb.
D:The schema for the common user C # # A_ADMIN can be different in each container.
E:The command will create a user in the root container only because the container clause is not used

Evaluate this SQL statement: SELECT e.employee_id, (.15* e.salary) + (.5 * e.commission_pct) + (s.sales_amount * (.35 * e.bonus)) AS CALC_VALUE FROM employees e, sales s WHERE e.employee_id = s.emp_id; What will happen if you remove all the parentheses from the calculation?（）
A:The value displayed in the CALC_VALUE column will be lower.
B:The value displayed in the CALC_VALUE column will be higher.
C:There will be no difference in the value displayed in the CALC_VALUE column.
D:An error will be reported.

You explicitly specified the tablespace usage threshold values while creating a tablespace. You need to revert to the database-wide default tablespace usage threshold values for the tablespace. Which PL/SQL package would you use?（）
A:DBMS_STATS
B:DBMS_ALERT
C:DBMS_SPACE
D:DBMS_MONITOR
E:DBMS_SERVER_ALERT
F:DBMS_SPACE_ADMIN

You find that the execution time of reports in your datawarehouse application is significantly high. You suspect the lack of indexes to be the reason for the degradation in performance. Which advisory component would you refer to， in order to determine the appropriate indexes？（）
A:Memory Advisor
B:Segment Advisor
C:SQL Access Advisor
D:Automatic Workload Repository （AWR）
E:Automatic Database Diagnostic Monitor （ADDM）

Which of the following describes how a distributed resumable transaction behaves？（）
A: The resumable setting on the initiating session determines the resumable conditions for the entire distributed transaction.
B: The resumable setting for the initiating instance determines the resumable conditions for the entire distributed transaction.
C: The resumable setting on the initiating session controls only that part of the transaction that occurs within the local instance； remote resumable settings determine the behavior of the distributed parts of the transaction.
D: None of the above.

Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement？（）
A: The SGA Tuning Advisor
B: The SQL Access Advisor
C: The SQL Tuning Advisor
D: The Memory Advisor

Examine the data in the EMPLOYEES table. EMPLOYEES EMP_NAME DEPT_ID MGR_ID JOB_ID SALARY EMPLOYEE_ID 101 Smith 20 120 SA_REP 4000 102 Martin 10 105 CLERK 2500 103 Chris 20 120 IT_ADMIN 4200 104 John 30 108 HR_CLERK 2500 105 Diana 30 108 IT_ADMIN 5000 106 Smith 40 110 AD.ASST 3000 108 Jennifer 30 110 HR_DIR 6500 110 Bob 40 EK_DIR 8000 120 Revi 20 110 SA_DIR 6500 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.

What is the result?（）
A:null
B:finally
C:null finally
D:Compilation fails.
E:finally exception

View the Exhibit and examine the user information.

The user has been granted CONNECT and RESOURCE roles and no individual system privileges. TheSL_REP user executes this command to create a table： SQL> CREATE TABLE orders（oid number（6）， odate date， ccode number（4）， oamt number（10，2）） TABLESPACE purchase_space； The PURCHASE_SPACE tablespace already exists in the database. Which statement describes theeffect of the command（）
A:The command executes successfully and creates the table in the USERS tablespace.
B:The command executes successfully and creates the table in the PURCHASE_SPACE tablespace.
C:The command produces an error because the user does not have the privilege to create the table.
D:The command produces an error because the user does not have quota in the PURCHASE_SPACE tablespace.

View the Exhibit to observe the roles assigned to the SL_REP user. Which statement is true about theassignment of the SELECT_CATALOG_ROLE role to the SL_REP user（）
A:The user must enable the role explicitly.
B:The user can grant the role to other users.
C:The user cannot use the role until the DBA enables it explicitly.
D:The user can start using the role immediately without any changes

You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state？（）
A:renaming the control files
B:dropping a user in your database
C:enabling or disabling redo log archiving
D:dropping a tablespace in your database
E:re-creating the control files， after you lost all the control files in your database

Which code, inserted at line 15, creates an instance of the Point class defined in Line?（）
A:Point p = new Point();
B:Line.Point p = new Line.Point();
C:The Point class cannot be instatiated at line 15.
D:Line l = new Line() ; l.Point p = new l.Point();

What is the result?（）
A:The value "4" is printed at the command line.
B:Compilation fails because of an error in line 5.
C:Compilation fails because of an error in line 9.
D:A NullPointerException occurs at runtime.
E:A NumberFormatException occurs at runtime.
F:An IllegalStateException occurs at runtime.

You have a read-only tablespace on read-only media. You want to perform a media recovery on the existing data files， but using a backup control file. The backup control file indicates that the status of the read-only tablespace was read/write when the control file was backed up. What should you consider？（）
A: take data files from the read-only tablespace offline before performing a recovery
B: recovery using backup control file is not possible， so restore all the files from the last full database backup， and then open the database
C: drop the read-only tablespace and re-create the tablespace after recovery
D: perform a recovery； status of the tablespace in control file will be changed automatically

What is the result?（）
A:Compilation fails.
B:An exception is thrown at runtime.
C:doStuff x = 6 main x = 6
D:doStuff x = 5 main x = 5
E:doStuff x = 5 main x = 6
F:doStuff x = 6 main x = 5

在Oracle中，下面哪条语句当COMM字段为空时显示0，不为空时显示COMM的值（）。
A:select ename,nvl（comm.,0）from emp
B:select ename,null（comm.,0）from emp
C:SELECT ename,NULLIF（comm,0）FROM emp
D:SELECT ename,DECODE（comm.,NULL,0）FROM emp

You need to display a very large single-record data block. Since it will be so large, a convenient means of navigation is needed between items. Which type of canvas would you use to display the data block? （）
A:Tab canvas.
B:Pop up canvas.
C:Spread table canvas.
D:Vertical toolbar canvas.

Identify four valid requests in a RESTful service using JAX-RS.（）
A:GET
B:PUT
C:UPDATE
D:DELETE
E:POST
F:REMOVE

当需要查询Oracle的控制文件的名称、位置和状态时，可以使用（）语句。
A:SELECT name FROM V$CONTROLFILE
B:SELECT name FROM V$CTRLLFILE
C:SELECT name FROM V$USERFILES
D:SELECT name FROM V$DBAFILE

You work as a database administrator for Certkiller .com. While granting a role，SELECT_CATALOG_ROLE， to a user， Certkiller， using Oracle Enterprise Manager 10g Database Control， you have cleared the DEFAULT check box. What will be the result？（）
A:The user cannot use the role at all.
B:The role would not be granted to the user.
C:The user needs to enable the role explicitly.
D:The user can start using the role immediately.
E:The user would have the admin option for the role.

Which best describes an inline view? （）
A:a schema object
B:a subquery that can contain an ORDER BY clause
C:another name for a view that contains group functions
D:a subquery that is part of the FROM clause of another query

You created a department report and preview it in life preview. The font for the department name is too small and you want to enlarge it but do not want to change the font for any other fields. What is the easiest way to make this change?（）
A:Select the text to be enlarged in the life previewer and make the size change using the style bar.
B:Select the text to be enlarged in the layout mode and make the change.
C:Open the report wizard in the re-entrant mode and make the change.
D:Make the copy of the report, open the copy, make the changes and then delete the original report.

The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3) The register has requested a report listing the students' grade point averages (GPA), sorted from highest grade point average to lowest within each semester, starting from the earliest date. Which statement accomplishes this?（）
A:SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester_end DESC, gpa DESC;
B:SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester _end, ASC,gpa ASC;
C:SELECT student_id, semester_end, gpa FROM student_grades ORDER BY semester _end, gpa DESC;
D:SELECT student_id, semester_end, gpa FROM student_grades ORDER BY gpa DESC,semester_end DESC;
E:SELECT student_id, semester_end, gpa FROM student_grades

Integration between （）with "multi data sources" and（） is defined as Gridlink for RAC （Real Application Clusters）
A: Oracle Weblogic Server； Oracle Database
B: Oracle Weblogic Server clusters； Oracle Database
C: Oracle Weblogic Server clusters； Oracle Database RAC
D: Oracle OC4J； Oracle Database RAC

首页 <上一页 50 51 52 53 54 下一页> 尾页