出自:Oracle认证

View the Exhibit and examine the attributes of an undo tablespace. In an OLTP system, the user SCOTT hasstarted a query on a large table in the peak transactional hour that performs bulk inserts. The query runs formore than 15 minutes and then SCOTT receives the following error:ORA-01555: snapshot too old What could be the reason for this error（）
A:The query is unable to get a read-consistent image.
B:There is not enough space in Flash Recovery Area.
C:There is not enough free space in the flashback archive.
D:The query is unable to place data blocks in undo tablespace

Which Man clsss properly represents the relationship "Man has a best friend who is a Dog"？（）
A:class Man extends Dog { }
B:class Man implements Dog { }
C:class Man { private BestFriend dog； }
D:class Man { private Dog bestFriend； }
E:class Man { private Dog； }
F:class Man { private BestFriend； }

假设需要查询Oracle数据文件的文件名和存储位置，可以使用如下（）方式。
A:SELECT name，status FROM V$datafile
B:SELECT name，status FROM V$userfile
C:SELECT name，status FROM V$DBA
D:SELECT name，status FROM V$ctrlfile

Given: What is the result?（）
A:peep
B:bark
C:meow
D:Compilation fails.
E:An exception is thrown at runtime.

Examine the structure if the EMPLOYEES table: Column name Data Type Remarks EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2(30) JOB_ID VARCHAR2(20) NOT NULL SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table You need to create a view called EMP_VU that allows the user to insert rows through the view. Which SQL statement, when used to create the EMP_VU view, allows the user to insert rows? （）
A:CREATE VIEW emp_Vu AS SELECT employee_id, emp_name, department_id FROM employees WHERE mgr_id IN (102, 120);
B:CREATE VIEW emp_Vu AS SELECT employee_id, emp_name, job_id department_id FROM employees WHERE mgr_id IN (102, 120);
C:CREATE VIEW emp_Vu AS SELECT department_id, SUM(sal) TOTALSAL FROM employees WHERE mgr_id IN (102, 120) GROUP BY department_ id;
D:CREATE VIEW emp_Vu AS SELECT employee_id, emp_name, job_id, DISTINCT department_id FROM employees;

You are designing an application for Certkiller .com and you have been asked to design a database table to facilitate monthly bill generation. The bill would include details of customer calls， listed in chronological order.Which method would you follow to achieve this objective without increasing the overhead of sorting the rows？（）
A: create a hash cluster to store the data
B: create an index cluster to store the data
C: create a partitioned table to store the data
D: create a sorted hash cluster to store the data
E: create a heap table with rowid to store the data

首页 <上一页 152 153 154 155 156 下一页> 尾页