在Mary的方案中已经存在“客户”表。应使用哪条语句来为所有数据库用户创建一个“客户”表的同义词()
第1题:
要以自身的模式创建私有同义词,用户必须拥有()系统权限。
第2题:
You need to generate a list of all customer last names with their credit limits from the CUSTOMERS table. Those customers who do not have a credit limit should appear last in the list. Which two queries would achieve the required result?()
第3题:
用户 SUSAN 创建了一个“雇员”表,然后又创建了一个“雇员_视图”视图,仅显示“雇员”表的“名字”列和“姓氏”列。用户 RUDI 需要能访问雇员的姓名,但不能访问“雇员”表中的其他数据。SUSAN 应使用哪条语句来实现这一点?()
第4题:
在Oracle中,你以SYSDBA登录,CUSTOMER表位于Mary用户方案中,下面哪条语句为数据库中的所有用户创建CUSTOMER表的同义词()。
第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?()
第6题:
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.
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.
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.
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.
Scott cannot create a synonym because synonyms can be created only for tables.
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.
第7题:
SELECT ord_id, cust_id, ord_total FROM orders, customers WHERE cust_name='Martin' AND ord_date IN ('18-JUL-2000','21-JUL-2000');
SELECT ord_id, cust_id, ord_total FROM orders WHERE ord_date IN (SELECT ord_date FROM orders WHERE cust_id = (SELECT cust_id FROM customers WHERE cust_name = 'Martin'));
SELECT ord_id, cust_id, ord_total FROM orders WHERE ord_date IN (SELECT ord_date FROM orders, customers WHERE cust_name = 'Martin');
SELECT ord_id, cust_id, ord_total FROM orders WHERE cust_id IN (SELECT cust_id FROM customers WHERE cust_name = 'Martin');
第8题:
&p_where_clause
:p_where_clause
WHERE CUST_ID=P_CUST_ID or cust_name=:p_cust_name or cust_phone=:p_cust_phone
Where cust_ID=&p_custid cust_name=&p_cust_name or cust_phone=&p_cust_phone
第9题:
SELECT* FROM customers;
SELECT name, address FROM customers;
SELECT id, name, address, phone FROM customers;
SELECT cust_name, cust_address FROM customers;
SELECT cust_id, cust_name, cust_address, cust_phone FROM customers;
第10题:
CREATE PUBLIC SYNONYM cust ON mary.customer
CREATE PUBLIC SYNONYM cust FOR mary.customer
CREATE SYNONYM cust ON mary.customer FOR PUBLIC
不能创建CUSTOMER的公用同义词
第11题:
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.
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.
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.
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.
Scott cannot create a synonym because synonyms can be created only for tables.
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.
第12题:
SELECT* FROM customers;
SELECT name, address FROM customers;
SELECT id, name, address, phone FROM customers;
SELECT cust_name, cust_address FROM customers;
SELECT cust_id, cust_name, cust_address, cust_phone FROM customers;
第13题:
The accounts receivable department requested an accounts status to allow users to enter either a customer name, customer number, customer phone number and then display the customer out standing balance. You want to restrict the data retrieved based on values entered by the users. Which where clause would you write in the query to select statement to accomplish this task?()
第14题:
用户SUSAN创建了“雇员”表,然后创建了视图“雇员视图”,此视图只显示雇员的“名字”和“姓氏”列。用户RUDI需要能访问“雇员”表中的“雇员”姓名但不能访问其它数据。SUSAN应执行以下哪条语句才允许此操作()
第15题:
User Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. She has the privilege to create a public synonym, and would like to create a synonym for this view that can be used by all users of the database.Which SQL statement can Mary use to accomplish that task?()
第16题:
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?()
第17题:
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?()
第18题:
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.
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.
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.
Scott cannot create a synonym because synonyms can be created only for tables.
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.
第19题:
CREATE PUBLIC SYNONYM cust ON mary.客户
CREATE PUBLIC SYNONYM cust FOR mary.客户
CREATE SYNONYM cust ON mary.客户FORPUBLIC
CREATE SYNONYM cust ON mary.客户;GRANT SELECT ON cust TO PUBLIC
第20题:
对用户所有的“雇员”表创建一个公用同义词
对您所有的“雇员”表创建一个私有同义词
对用户Sam所有的“雇员”表创建一个公用同义词
对用户Sam所有的“雇员”表创建一个私有同义词
第21题:
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.
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.
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.
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.
Scott cannot create a synonym because synonyms can be created only for tables.
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.
第22题:
CREATE SYNONYM ord FOR orders; This command is issued by OE
CREATE PUBLIC SYNONYM ord FOR orders; This command is issued by OE
CREATE SYNONYM ord FOR oe.orders; This command is issued by the database administrator
CREATE PUBLIC SYNONYM ord FOR oe.orders; This command is issued by the database administrator
第23题:
CREATE PUBLIC SYNONYM EDL_VU ON emp_dept_loc_vu
CREATE PUBLIC SYNONYM EDL:VU FOR mary (emp_dept_loc_vu);
CREATE PUBLIC SYNONYM EDL_VU FOR emp _dept_loc_vu;
CREATE SYNONYM EDL_VU ON emp_dept_loc_vu FOR EACH USER;
CREATE SYNONYM EDL_VU FOR EACH USER ON emp_dept_loc_vu
CREATE PUBLIC SYNONYM EDL_VU ON emp_dept_loc_vu FOR ALL USERS;