出自:Oracle认证

Given: What is the result？（）
A:peep
B:bark
C:meow
D:Compilation fails.
E:An exception is thrown at runtime.
Given that t1 is a reference to a live thread, which is true?（）
A:The Thread.sleep() method can take t1 as an argument.
B:The Object.notify() method can take t1 as an argument.
C:The Thread.yield() method can take t1 as an argument.
D:The Thread.setPriority() method can take t1 as an argument.
E:The Object.notify() method arbitrarily chooses which thread to notify.
Given: If class Donkey is invoked twice, the first time without assertions enabled, and the second time with assertions enabled, what are the results?（）
A:no output
B:no output  assert is on
C:assert is on
D:no output An AssertionError is thrown.
E:assert is on An AssertionError is thrown.
要审计用户执行的create，drop，和alter等ddl语句，应创建（）触发器。
A:行级
B:语句级
C:Instead of
D:模式
E:数据库
Which of the following commands will perform an active database duplication of the ORCL database to the ORCL2 database？（）
A:A
B:B
C:C
D:D
E:E
Which two statements about the SQL Management Base (SMB) are true?（）
A:It contains only SQL profiles generated by SQL Tuning Advisor.
B:It stores plans generated by the optimizer using a stored outline.
C:It is part of the data dictionary and stored in the SYSAUX tablespace.
D:It is part of the data dictionary and stored in the SYSTEM tablespace.
E:It contains the statement log, the plan history, plan baselines, and SQL profiles.
You deployed a Java EE Shared Library and want to use it from an application that is also deployed on the same cluster.    Which two manifest attributes must be specified at a minimum with corresponding values in the deployment descriptor of the application that requires?（）
A:Implementation-Version
B:Specification-Version
C:Extension-Name  
D:Specification-Vendor
E:Implementation-Vendor
Given a class whose instances， when found in a collection of objects， are sorted by using the compare To method， which two statements are true？（）
A:The class implements java.lang.Comparable.
B:The class implements java.util.Comparator.
C:The interface used to implement sorting allows this class to define only one sort sequence.
D:The interface used to implement sorting allows this class to define many different sort sequences.
At 10：30 A.M.， you ran a batch job by mistake， which executed a transaction in the database. The transaction identifier of the transaction that made to the changes in the database is 0500A00627B000. At 11：10 A.M.， you stopped the batch job. Now， you want to identify the changes made to the database tables by the batch job. Which view will you query？（）
A: DBA_PENDING_TRANSACTIONS
B: DBA_AUDIT_STATEMENT
C: V$FLASHBACK_DATABASE_STATS
D: FLASHBACK_TRANSACTION_QUERY
Click the Exhibit button and examine the data from the ORDERS and CUSTOMERS tables. Evaluate this SQL statement: SELECT cust_id, ord_total FROM orders WHERE ord_total > ANY(SELECT ord_total FROM orders WHERE cust_id IN (SELECT cust_id FROM customers WHERE city LIKE'New York')); What is the result when the above query is executed?（）
A:A
B:B
C:C
D:D
E:E
Immediately after adding a new disk to or removing an existing disk from an Automatic Storage Management （ASM） instance， you find that the performance of the database decreases initially， until the addition or removal process is completed. Performance then gradually returns to normal levels. Which two activities could you perform to maintain a consistent performance of the database while adding or removing disks？（）
A: increase the number of checkpoint processes
B: define the POWER option while adding or removing the disks
C: increase the number of DBWR processes by setting up a higher value for DB_WRITER_PROCESSES
D: increase the number of slave database writer processes by setting up a higher value for DBWR_IO_SLAVES
E: increase the number of ASM Rebalance processes by setting up a higher value for ASM_POWER_LIMIT during the disk addition or removal
Within a resource-plan definition， what differentiates a top-level plan from a subplan？（）  
A: A subplan has the PLAN_SUB parameter value set to SUB
B: A top-level plan has the GROUP_OR_PLAN parameter set to the name of the subplan in the resource-plan definition
C: There is no difference in the resource-plan definition
D: A subplan always has the CPU_MTH parameter value set to RATIO
E: The string TOP_LEVEL is appended to the name of top-level resource plans
The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3) The registrar has asked for a report on the average grade point average (GPA) for students enrolled during semesters that end in the year 2000. Which statement accomplish this? （）
A:SELECT AVERAGE(gpa) FROM student_grades WHERE semester _ end > '01-JAN-2000' and semester end <31-DEC-2000';
B:SELECT COUNT(gpa) FROM student grades WHERE semester _ end > '01-JAN-2000' and semester end <31-DEC-2000';
C:SELECT MIN(gpa) FROM student grades WHERE semester _ end > '01-JAN-2000' and semester end <31-DEC-2000';
D:SELECT AVG(gpa) FROM student_grades WHERE semester _ end BETWEEN '01-JAN-2000' and '31-DEC-2000';
E:SELECT SUM(gpa) FROM student grades WHERE semester _ end > '01-JAN-2000' and semester end <31-DEC-2000';
F:SELECT MEDIAN(gpa) FROM student_grades WHERE semester _ end > '01-JAN-2000' and semester end <31-DEC-2000';
Examine the description of the MARKS table: STD_ID NUMBER(4) STUDENT_NAME VARCHAR2(30) SUBJ1 NUMBER(3) SUBJ2 NUMBER(3) SUBJ3 NUMBER(3) SUBJ1, SUBJ2, and SUBJ3 indicate the marks (grades) obtained by a student in the three subjects. Which two statements are valid? （）
A:SELECT SUM(subj1, subj2, subj3) FROM marks;
B:SELECT SUM(subj1 + subj2 + subj3) FROM marks;
C:SELECT SUM(subj1), SUM(subj2), SUM(subj3) FROM marks;
D:SELECT MAX(subj1, subj2, subj3) FROM marks;
E:SELECT MINIMUM(subj1) FROM marks;
F:SELECT COUNT(std_id) FROM marks WHERE subj1 >= AVG(subj1);
You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DB  A. While observing the server settings， you find that the  following parameter has been set in the parameter file of the database： REMOTE_OS_AUTHENT = TRUE  What could have been the reason to set this parameter as TRUE？（）
A:to enable operating system authentication for a remote client
B:to restrict the scope of administration to identical operating systems
C:to allow the start up and shut down of the database from a remote client
D:to enable the administration of the operating system from a remote client
E:to disable the administration of the operating system from a remote client
The DB_BLOCK_CHECKING initialization parameter is set to OFF.Which block checking would be performed?（）
A:The Oracle database will perform block checking for the index blocks only
B:The Oracle database will not perform block checking for any of the data blocks
C:The Oracle database will perform block checking for the default permanent tablespace only
D:The Oracle database will perform block checking for the data blocks in all user tablespaces
E:The Oracle database will perform block checking for the data blocks in the SYSTEM tablespace only
An online tablespace, TEST_TBS, is full and you realize that no server-managed tablespace threshold alerts were generated for the TEST_TBS tablespace. What could be the reason, if the TEST_TBS tablespace does not include autoextensible data files?（）
A:TEST_TBS is a small file tablespace 
B:TEST_TBS is a bigfile tablespace (BFT)
C:TEST_TBS is the default temporary tablespace
D:TEST_TBS is a dictionary-managed tablespace
E:Threshold values for the TEST_TBS tablespace are not explicitly specified
You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty. Which statement accomplishes this task?（）
A:ALTER TABLE students ADD PRIMARY KEY _ id;
B:ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student_id);
C:ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY student_id;
D:ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY (student_id);
E:ALTER TABLE students MODIFY CONSTRAINT stud_id_pk PRIMARY KEY (student_id);
You plan to use Flashback Drop feature to recover a dropped table SALES_EMP. No other table with the same name exists in the schema.You query RECYCLEBIN and find multiple entries for the SALES_EMP table as follows, You then issue the following statement to recover the table: SQL> FLASHBACK TABLE sales_emp TO BEFORE DROP; What would be the outcome of the precedent statement?（）
A:It retrieves the latest version of the table from the recycle bin
B:It retrieves the oldest version of the table from the recycle bin
C:It retrieves the version of the table for which undo information is available
D:It returns an error because the table name is not specified as per the names in the OBJECT_NAME column
A warehouse fact table in your Oracle 12c Database is range-partitioned by month and accessed frequently with queries that span multiple partitions The table has a local prefixed, range partitioned index. Some of these queries access very few rows in some partitions and all the rows in other partitions, but these queries still perform a full scan for all accessed partitions. This commonly occurs when the range of dates begins at the end of a month or ends close to the start of a month. You want an execution plan to be generated that uses indexed access when only a few rows are accessed from a segment, while still allowing full scans for segments where many rows are returned. Which three methods could transparently help to achieve this result?（）
A:Using a partial local Index on the warehouse fact table month column with indexing disabled to the table partitions that return most of their rows to the queries.
B:Using a partial local Index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.
C:Using a partitioned view that does a UNION ALL query on the partitions of the warehouse fact table, which retains the existing local partitioned column.
D:Converting the partitioned table to a partitioned view that does a UNION ALL query on the monthly tables, which retains the existing local partitioned column
E:Using a partial global index on the warehouse fact table month column with indexing disabling for the table partitions that return most of their rows to the queries.
F:Using a partial global index on the warehouse fact table month column with indexing disabled for the table partitions that return a few rows to the queries.
A class games.cards.Poker is correctly defined in the jar file Poker.jar. A user wants to execute the main method of Poker on a UNIX system using the command：java games.cards. Poker What allows the user to do this？（）
A:put Poker.jar in directory /stuff/java， and set the CLASSPATH to include /stuff/java
B:put Poker.jar in directory /stuff/java， and set the CLASSPATH to include /stuff/java/*.jar
C:put Poker.jar in directory /stuff/java， and set the CLASSPATH to include /stuff/java/Poker.jar
D:put Poker.jar in directory /stuff/java/games/cards， and set the CLASSPATH to include /stuff/java
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;
For the V$SESSION_LONGOPS view， you find that some of the database users have long-running queries that consume a lot of CPU time. This causes performance problems for other users in the database， who have much shorter queries. You would like to make sure that the users with large queries do not use all the CPU time， but you still do not want to terminate them with an error message. Which method would you follow to achieve this？（）
A: Set the CPU time per call in the users profile.
B: Set the CPU time per session in the users profile.
C: Set the CPU levels for the user’s group using Resource Manager.
D: Set the TIMED_STATISTICS parameter to TRUE in the parameter file.
Given： What is the result？（）
A:B
B:The code runs with no output.
C:Compilation fails because of an error in line 12.
D:Compilation fails because of an error in line 15.
E:Compilation fails because of an error in line 18.
Given： Which line of code marks the earliest point that an object referenced by intObj becomes a candidate for garbage collection？（）
A:Line 16
B:Line 17
C:Line 18
D:Line 19
Which two statements regarding the FLASHBACK_TRANSACTION_QUERY view are correct?（）
A:You can find information about only active transactions from the view
B:You can find information about read only transactions from the view
C:You require the SELECT ANY TRANSACTION system privilege to access the view 
D:You can find information about both active and committed transactions from the view 
E:You require the SELECT ON FLASHBACK_TRANSACTION_QUERY object privilege to access the view
使用数据库初始化参数文件中的（）参数可以指定控制文件名。
A:CONTROL_FILES
B:CONTROL_FILES_NAME
C:CONTROL_NAME
D:CONTROL_FILE
You work as a database administrator for Certkiller .com. In your development environmentenvironment， the developers are responsible for modifying the table structure according to the application requirements. However， you want to keep track of the ALTER TABLE commands being executed by developers， so you enable auditing to achieve this objective.  Which two views would you refer to find out the audit information？（）
A:DBA_AUDIT_TRAIL
B:DBA_AUDIT_SESSION
C:DBA_FGA_AUDIT_TRAIL
D:DBA_COMMON_AUDIT_TRAIL
The DB_BLOCK_CHECKING initialization parameter is set to TRUE. What would be the result of this setting on the data blocks being written to the datafiles， every time the DBWn writes？（）
A:The Oracle database will check all data blocks by going through the data on each block， making sure the data is self-consistent.
B:DBWn and the direct loader will calculate a checksum and store it in the cache header of every data block when writing it to disk.
C:The Oracle database will check data blocks belonging to the SYSTEM tablespace only， by going through the data on each block， making sure the data is self-consistent.
D:The Oracle database will check data blocks belonging to the SYSAUX tablespace only， by going through the data on each block， making sure the data is self-consistent.
E:The Oracle database will check data blocks in the SYSTEM and SYSAUX tablespaces only， by going through the data on each block， making sure the data is self-consistent
Which two statements regarding the Flashback Table feature are correct?（）
A:Flashback Table can be performed on system tables.
B:Flashback Table operation does not shrink the segments.
C:Flashback Table uses log mining to extract SQL_REDO and SQL_UNDO statements.
D:Flashback Table operation acquires exclusive data manipulation language (DML) locks.
首页 <上一页 27 28 29 30 31 下一页> 尾页