-
编辑 删除
047-190
190. Which SQL statement would display the view names and definitions of allthe views owned by you?A. SELECT view_name, text FROM user_view;B. SELECT view_name, text FROM user_object ;C. SELECT view_n...
-
编辑 删除
047-175
175. View the Exhibit and examine the data in the PRODUCTS table.Which statement would add a column called PRICE, which cannot contain NULL?A. ALTER TABLE products ADD price NUMBER(8,2) NOT NULL;B. AL...
-
编辑 删除
047-174
174. View the Exhibit and examine the structure of ORDERS and CUSTOMERStables.Evaluate the following UPDATE statement:UPDATE(SELECT order_date, order_total, customer_idFROM orders)SET order_date = '22...
-
编辑 删除
047-172
172. View the Exhibit and examine the structure of the ORDERS table.NEW_ORDERS is a new table with the columns ORD_ID, ORD_DATE, CUST_ID, andORD_TOTAL that have the same data types and size as the cor...
-
编辑 删除
047-171
171. View the Exhibit and examine the structure of the EMPLOYEES table.Evaluate the following SQL statement:SELECT employee_id, last_name, job_id, manager_idFROM employees START WITH employee_id = 101...
-
编辑 删除
047-167
167. View the Exhibit and examine the description of the ORDERS table.You need to display CUSTOMER_ID for all customers who have placed orders morethan three times in the last six months. You issued t...
-
编辑 删除
047-166
166. Evaluate the following SQL statements that are issued in the given order:CREATE TABLE emp(emp_no NUMBER(2) CONSTRAINT emp_emp_no_pk PRIMARY KEY,ename VARCHAR2(15),salary NUMBER(8,2),mgr_no NUMBER...
-
编辑 删除
047-165
165. View the Exhibit and examine the structure of the ORDERS table.The ORDERS table belongs to the user OE. HR is another user in the database.Evaluate the commands issued by users OE and HR in the f...
-
编辑 删除
047-151
161. View the Exhibit and examine the data in EMPLOYEES and DEPARTMENTS tables.In the EMPLOYEES table EMPLOYEE_ID is the PRIMARY KEY and DEPARTMENT_ID isthe FOREIGN KEY. In the DEPARTMENTS table DEPAR...
-
编辑 删除
047-159
159. View the Exhibit and examine the structure of the ORDERS and ORDER_ITEMStables.Evaluate the following SQL statement:SELECT oi.order_id, product_id, order_dateFROM order_items oi JOIN orders o USI...
-
编辑 删除
047-153
153. Which statement correctly grants a system privilege?A. GRANT EXECUTE ON proc1 TO PUBLIC;B. GRANT CREATE VIEW ON table1 TO user1;C. GRANT CREATE TABLE TO user1,user2;D. GRANT CREATE SESSION TO ALL...
-
编辑 删除
047-152
152. Evaluate the following SQL statement:SELECT product_name || 'it's not available for order'FROM product_information WHERE product_status = 'obsolete';You received the following error while executi...
-
编辑 删除
047-151
151. View the Exhibit and examine the structure of ORDERS and CUSTOMERStables.Which INSERT statement should be used to add a row into the ORDERStable for the customer whose CUST_LAST_NAME is Roberts a...
-
编辑 删除
047-150
150. Which statements are true regarding the hierarchical query in OracleDatabase 10g? (Choose all thatapply.)A. It is possible to retrieve data only in topdown hierarchy.B. It is possible to retrieve...
-
编辑 删除
047-138
138. View the Exhibit and examine the structure of the ORDER_ITEMS table.Examine the following SQL statement:SELECT order_id, product_id, unit_priceFROM order_items WHERE unit_price = (SELECT MAX(unit...
-
编辑 删除
047-138
138. View the Exhibit and examine the structure of the ORDER_ITEMS table.Examine the following SQL statement:SELECT order_id, product_id, unit_priceFROM order_items WHERE unit_price = (SELECT MAX(unit...
-
编辑 删除
047-137
137. Which three possible values can be set for the TIME_ZONE sessionparameter by using the ALTER SESSION command? (Choose three.)A. 'os'B. localC. '-8:00'D. dbtimezoneE. 'Australia'Answer: BCDE选项不...
-
编辑 删除
047-135
135. View the Exhibit and examine the description of the PRODUCT_INFORMATIONtable.SELECT product_name, list_price, min_price, list_price-min_priceDifference FROM product_informationWhich options when ...
-
编辑 删除
047-134
134. Which two statements are true regarding subqueries? (Choose two.)A. Only two subqueries can be placed at one level.B. A subquery can be used to access data from one or more tables or views.C. If ...
-
编辑 删除
047-215
215. View the Exhibit and examine the structure of the PRODUCT_INFORMATIONand INVENTORIES tables.You have a requirement from the supplies departmentto give a list containing PRODUCT_ID,SUPPLIER_ID, an...
