搜题

【单选题】

The EMP_DEPT block in your EMPLOYEE form is based on a view in an Oracle8 database. The items in this block have the Update Allowed property set to Yes. Which database feature makes it possible to permanently modify the underlying view?（）

A、REF cursor.

B、Instead Of trigger.

C、Stored procedure that returns object values.

D、The underlying view cannot be modified because DML on a view is not supported.

查看正确答案

更多“The EMP_DEPT block in your EMPLOYEE form is based on a view in an Oracle8 database. The items in this block have the Update Allowed property set to Yes. Which database feature makes it possible to permanently modify the underlying view?（）”相关的问题

第1题

[单选题] You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created.You want to look at the definition of the view (the SELECT statement on which the view was create.) How do you obtain the definition of the view?（）

A、Use the DESCRIBE command in the EMP_DEPT VU view. B、Use the DEFINE VIEW command on the EMP_DEPT VU view. C、Use the DESCRIBE VIEW command on the EMP_DEPT VU view. D、Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view. E、Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view. F、Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.

点击查看答案

第2题

[单选题] You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created. You want to look at the definition of the view (the SELECT statement on which the view was create.) How do you obtain the definition of the view?（）

点击查看答案

第3题

[单选题] You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created. You want to look at the definition of the view (the SELECT statement on which the view was create.) How do you obtain the definition of the view? （）

点击查看答案

第4题

[] You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created. You want to look at the definition of the view (the SELECT statement on which the view was created.) How do you obtain the definition of the view?（）

A、A.Use the DESCRIBE command on the EMP_DEPT_VU view. B、B.Use the DEFINE VIEW command on the EMP_DEPT_VU view. C、C.Use the DESCRIBE VIEW command on the EMP_DEPT_VU view. D、D.Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view. E、E.Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view. F、F.Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.

点击查看答案

第5题

[] Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. She granted SELECT privilege to Scott on this view. Which option enables Scott to eliminate the need to qualify the view with the name MARY.EMP_DEPT_LOC_VU each time the view is referenced?（）

A、A.Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command CREATE PRIVATE SYNONYM EDL_VU FOR mary.EMP_DEPT_LOC_VU; then he can prefix the columns with this synonym. B、B.Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command CREATE SYNONYM EDL_VU FOR mary.EMP_DEPT_LOC_VU; then he can prefix the columns with this synonym. C、C.Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command CREATE LOCAL SYNONYM EDL_VU FOR mary.EMP_DEPT_LOC_VU; then he can prefix the columns with this synonym. D、D.Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command CREATE SYNONYM EDL_VU ON mary(EMP_DEPT_LOC_VU); then he can prefix the columns with this synonym. E、E.Scott cannot create a synonym because synonyms can be created only for tables. F、F.Scott cannot create any synonym for Mary's view. Mary should create a private synonym for the view and grant SELECT privilege on that synonym to Scott.

点击查看答案

第6题

[单选题] Which SQL statement would you use to remove a view called EMP_DEPT_VU from your schema?（）

A、DROP emp_dept_uv; B、DELETE emp_dept_uv; C、REMOVE emp_dept_uv; D、DROP VIEW emp_dept_uv; E、DELETE VIEW emp_dept_uv; F、REMOVE VIEW emp_dept_uv;

点击查看答案

第7题

[单选题] Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. She granted SELECT privilege to Scott on this view. Which option enables Scott to eliminate the need to qualify the view with the name MARY .EMP_DEP_LOC_VU each time the view is referenced?（）

A、Scott can create a synonym for the EMP_DEPT_LOC_VU bus using the command: CREATE PRIVATE SYNONYM EDL_VU FOR mary.EMP DEPT_LOC_VU; then he can prefix the columns with this synonymn. B、Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command: CREATE SYNONYM EDL_VU FOR mary.EMP_DEPT_LOC_VU; then he can prefix the columns with this synonym. C、Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command: CREATE LOCAL SYNONYM EDL_VU FOR mary.EMP DEPT_LOC_VU; then he can prefix the columns with this synonym. D、Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command: CREATE SYNONYM EDL_VU ON mary(EMP_DEPT_LOC_VU); then he can prefix the columns with this synonym. E、Scott cannot create a synonym because synonyms can be created only for tables. F、Scott cannot create any synonym for Mary's view. Mary should create a private synonym for the view and grant SELECT privilege on that synonym to Scott.

点击查看答案

第8题

A、Scott can create a synonym for the EMP_DEPT_LOC_VU bus using the command: CREATE PRIVATE SYNONYM EDL_VU FOR mary.EMP DEPT_LOC_VU; then he can prefix the columns with this synonymn. B、Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command: CREATE SYNONYM EDL_VU FOR mary.EMP_DEPT_LOC_VU; then he can prefix the columns with this synonym. C、Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command: CREATE LOCAL SYNONYM EDL_VU FOR mary.EMP DEPT_LOC_VU; then he can prefix the columns with this synonym. D、Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command: CREATE SYNONYM EDL_VU ON mary(EMP_DEPT_LOC_VU); then he can prefix the columns with this synonym. E、Scott cannot create a synonym because synonyms can be created only for tables. F、Scott cannot create any synonym for Mary’s view. Mary should create a private ynonym for the view and grant SELECT privilege on that synonym to Scott.

点击查看答案

第9题

[] Which SQL statement would you use to remove a view called EMP_DEPT_VU from your schema?（）

A、A. DROP emp_dept_uv; B、B. DELETE emp_dept_uv; C、C. REMOVE emp_dept_uv; D、D. DROP VIEW emp_dept_uv; E、E. DELETE VIEW emp_dept_uv; F、F. REMOVE VIEW emp_dept_uv;

点击查看答案

第10题

[单选题] Which SQL statement defines the FOREIGN KEY constraint on the DEPTNO column of the EMP table?（）

A、CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) NOT NULL CONSTRAINT emp_deptno_fk FOREIGN KEY deptno REFERENCES dept deptno); B、CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) CONSTRAINT emp_deptno_fk REFERENCES dept (deptno)); C、CREATE TABLE EMP (empno NUMBER(4) ename VARCHAR2(35), deptno NUMBER(7,2) NOT NULL, CONSTRAINT emp_deptno_fk REFERENCES dept (deptno) FOREIGN KEY (deptno)); D、CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) FOREIGN KEY CONSTRAINT emp deptno fk REFERENCES dept (deptno));

点击查看答案

账号：登录

答题记录

我的收藏

我的题库

客服

TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服