-
编辑 删除
047-074
74. View the Exhibit and examine the structure of the ORDER_ITEMS and ORDERStables.You are asked to retrieve the ORDER_ID, PRODUCT_ID, and total price(UNIT_PRICE multiplied by QUANTITY), where the tot...
-
编辑 删除
047-073
73. 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 corr...
-
编辑 删除
047-088
88. View the Exhibit1 and examine the descriptions of the EMPLOYEES andDEPARTMENTS tables.The following SQL statement was executed:SELECT e.department_id, e.job_id, d.location_id, sum(e.salary) total,...
-
编辑 删除
047-071
71. Given below is a list of datetime data types and examples of values storedin them in a random order:Datatype Example1)INTERVAL YEAR TO MONTH a) '20030415 8:00:00 8:00'2)TIMESTAMP WITH LOCAL TIME Z...
-
编辑 删除
047-070
70. Which two statements are true about the GROUPING function? (Choose two.)A. It is used to find the groups forming the subtotal in a row.B. It is used to identify the NULL value in the aggregate fun...
-
编辑 删除
047-068
68. The following are the steps for a correlated subquery, listed in randomorder:1) The WHERE clause of the outer query is evaluated.2) The candidate row is fetched from the table specified in the out...
-
编辑 删除
047-067
67. View the Exhibit and examine the structure of the ORDERS table. Thecolumns ORDER_MODE and ORDER_TOTAL have the default values 'direct' and 0respectively.Which two INSERT statements are valid? (Cho...
-
编辑 删除
047-066
66. Which two statements are true regarding multiple-row subqueries? (Choosetwo.)A. They can contain group functions.B. They always contain a subquery within a subquery.C. They use the < ALL operator ...
-
编辑 删除
042-065
65. Which statement is true regarding Flashback Version Query?A. It returns versions of rows only within a transaction.B. It can be used in subqueries contained only in a SELECT statement.C. It will r...
-
编辑 删除
047-064
64. Evaluate the following SELECT statement and view the Exhibit to examineits output:SELECT constraint_name, constraint_type, search_condition,r_constraint_name, delete_rule, statusFROM user_constrai...
-
编辑 删除
047-063
63. Which CREATE TABLE statement is valid?A. CREATE TABLE ord_details(ord_no NUMBER(2) PRIMARY KEY,item_no NUMBER(3) PRIMARY KEY,ord_date date NOT NULL);B.CREATE TABLE ord_details(ord_no NUMBER(2) UNI...
-
编辑 删除
047-061
61. 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-056
56. Which mandatory clause has to be added to the following statement tosuccessfully create an external table called EMPDET?CREATE TABLE empdet(empno CHAR(2), ename CHAR(5), deptno NUMBER(4))ORGANIZAT...
-
编辑 删除
047-054
54. Which two statements are true about sequences created in a single instancedatabase? (Choose two.)A. The numbers generated by a sequence can be used only for one table.B. DELETE <sequencename> woul...
-
编辑 删除
047-047
47. Given below are the SQL statements executed in a user session:CREATE TABLE product(pcode NUMBER(2),pname VARCHAR2(10));INSERT INTO product VALUES(1, 'pen');INSERT INTO product VALUES (2,'pencil');...
-
编辑 删除
047-046
46. Which two statements are true regarding operators used with subqueries?(Choose two.)A. The NOT IN operator is equivalent to IS NULL.B. The <ANY operator means less than the maximum.C. =ANY and =AL...
-
编辑 删除
047-044
44. View the Exhibit and examine the structure of ORD and ORD_ITEMS tables.In the ORD table, the PRIMARY KEY is ORD_NO and in the ORD_ITEMS tables thecompositePRIMARY KEY is (ORD_NO, ITEM_NO).Which tw...
-
编辑 删除
047-043
43. Which statement best describes the GROUPING function?A. It is used to set the order for the groups to be used for calculating thegrand totals and subtotals.B. It is used to form. various groups to...
-
编辑 删除
047-042
42. SCOTT is a user in the database.Evaluate the commands issued by the DBA:1 -CREATE ROLE mgr.2 -GRANT CREATE TABLE, SELECT ON oe.orders TO mgr.3 -GRANT mgr, create table TO SCOTT.Which statement is ...
-
编辑 删除
047-040
40. User OE, the owner of the ORDERS table, issues the following command:GRANT SELECT ,INSERT ON orders TO hr WITH GRANT OPTION.The user HR issues the following command:GRANT SELECT ON oe.orders TO sc...
