Oracle认证考试章节练习(2020.01.15)

来源：考试资料网

1 The EMPLOYEES table contains these columns:
EMPLOYEE_ID NUMBER(4)
LAST_NAME VARCHAR2 (25)
JOB_ID VARCHAR2(10)
You want to search for strings that contain 'SA_' in the JOB_ID column. Which SQL statement do you use?（）

点击查看答案

2 You execute the following piece of code with appropriate privileges: User SCOTT has been granted theCREATE SESSION privilege and the MGR role.Which two statements are true when a session logged in as SCOTT queries the SAL column in the viewand the table?（）

点击查看答案

3 当SELECT INTO语句没有返回行时，会触发的异常是（）。

点击查看答案

4 Which substitution variable would you use if you want to reuse the variable without prompting the user each time?（）

点击查看答案

5 Given：

What is the result？（）

点击查看答案

6 从本质上来看，（）就是命名的PL/SQL程序块，它可以被赋予参数，存储在数据库中，然后由另外一个应用或PL/SQL例程调用。

点击查看答案

7 Examine the following commands executed in your database： SQL> ALTER SESSION RECYCLEBIN=ON； Session altered
SQL> CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees；
Table created.
Further， you executed the following command to drop the table：
SQL> DROP TABLE emp； Table dropped.
What happens in this scenario？（）

点击查看答案

8 Which two statements about subqueries are true?（）

点击查看答案

9 You create a data block based on a relational table containing a REF column. You select the REF column for your form module. What is true about the items based on the REF column attributes?（）

点击查看答案

10 Given：

Which code， inserted at line 15， allows the class Sprite to compile？（）

点击查看答案