Oracle認證考試章節(jié)練習(2020.01.15)

單項選擇題
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?（）
A.SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA\_%' ESCAPE '\';
B.SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_';
C.SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_' ESCAPE "\";
D.SELECT employee_id, last_name, job_id FROM employees WHERE job_id = '%SA_';
多項選擇題
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?（）
A. Data is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR role set.
B. Data is redacted for EMP.SAL column only if the SCOTT session has the MGR role set.
C. Data is never redacted for the EMP_V.SAL column.
D. Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.
E. Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set.
單項選擇題
當SELECT INTO語句沒有返回行時，會觸發(fā)的異常是（）。
A.TOO_MANY_ROWS
B.VALUE_ERROR
C.NO_DATA_FOUND
D.不會觸發(fā)任何異常
單項選擇題
Which substitution variable would you use if you want to reuse the variable without prompting the user each time?（）
A.&
B.ACCEPT
C.PROMPT
D.&&
單項選擇題
Given：What is the result？（）
A.r， t， t，
B.r， e， o，
C.Compilation fails.
D.An exception is thrown at runtime.
單項選擇題
從本質(zhì)上來看，（）就是命名的PL/SQL程序塊，它可以被賦予參數(shù)，存儲在數(shù)據(jù)庫中，然后由另外一個應用或PL/SQL例程調(diào)用。
A.異常
B.過程
C.表
D.視圖
單項選擇題
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？（）
A.The table is moved to the SYSAUX tablespace.
B.The table is moved to the SYSTEM tablespace.
C.The table is removed from the database permanently.
D.The table is renamed and remains in the TBSFD tablespace.
多項選擇題
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.
單項選擇題
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?（）
A.The Query Only property is set to Yes.
B.The Conceal Data property is set to Yes.
C.The Insert Allowed property is set to Yes.
D.The Update Allowed property is set to Yes.
單項選擇題
Given：Which code， inserted at line 15， allows the class Sprite to compile？（）
A.Foo { public int bar（） { return 1； }
B.new Foo { public int bar（） { return 1； }
C.new Foo（） { public int bar（） { return 1； }
D.new class Foo { public int bar（） { return 1； }

首頁

題庫

網(wǎng)課

在線模考

桌面端

Oracle認證考試章節(jié)練習(2020.01.15)

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?（）

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?（）

當SELECT INTO語句沒有返回行時，會觸發(fā)的異常是（）。

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

Given：What is the result？（）

從本質(zhì)上來看，（）就是命名的PL/SQL程序塊，它可以被賦予參數(shù)，存儲在數(shù)據(jù)庫中，然后由另外一個應用或PL/SQL例程調(diào)用。

Which two statements about subqueries are true?（）

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?（）

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

Oracle認證考試章節(jié)練習(2020.01.15)

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?（）

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?（）

當SELECT INTO語句沒有返回行時，會觸發(fā)的異常是（）。

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

Given：What is the result？（）

從本質(zhì)上來看，（）就是命名的PL/SQL程序塊，它可以被賦予參數(shù)，存儲在數(shù)據(jù)庫中，然后由另外一個應用或PL/SQL例程調(diào)用。

Which two statements about subqueries are true?（）

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?（）

Given：Which code， inserted at line 15， allows the class Sprite to compile？（）

當SELECT INTO語句沒有返回行時，會觸發(fā)的異常是（）。

從本質(zhì)上來看，（）就是命名的PL/SQL程序塊，它可以被賦予參數(shù)，存儲在數(shù)據(jù)庫中，然后由另外一個應用或PL/SQL例程調(diào)用。

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