AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Oracle- 1z0-007





Question ID 7983

Which four are attributes of single row functions? (Choose four.)

Option A

cannot be nested

Option B

manipulate data items

Option C

act on each row returned

Option D

return one result per row

Option E

accept only one argument and return only one value

Option F

accept arguments which can be a column or an expression

Correct Answer BCDF
Explanation Explanation/Reference: Explanation : manipulate data items, act on each row returned, return one result per row, and accept arguments that can be a column or expression. Incorrect answer : A is not single row attributes E functions can accept more than one argument, e.g NVL2 Refer : Introduction to Oracle9i : SQL, Oracle University Study Guide, 3-5


Question ID 7984

You need to create a table named ORDERS that contain four columns: 1. an ORDER_ID column of number data type 2. aCUSTOMER_ID column of number data type 3. an ORDER_STATUS column that contains a character data type 4. aDATE_ORDERED column to contain the date the order was placed. When a row is inserted into the table, if no value is provided when the order was placed, today's date should be used instead. Which statement accomplishes this?

Option A

CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE = SYSDATE);

Option B

CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);

Option C

CREATE OR REPLACE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE DEFAULT SYSDATE);

Option D

CREATE OR REPLACE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status VARCHAR2 (10), date_ordered DATE = SYSDATE);

Option E

CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE = SYSDATE);

Option F

CREATE TABLE orders ( order_id NUMBER (10), customer_id NUMBER (8), order_status NUMBER (10), date_ordered DATE DEFAULT SYSDATE);

Correct Answer B
Explanation Explanation/Reference: Explanation: Requirement that OrderStatus should be a character data type Not E: Orderstatus must be a character data type. There is also a syntax error.

Send email to admin@getfreedumps for new dumps request!!!