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- 1z1-051





Question ID 4850

View the Exhibit and examine the structure of ORDERS and CUSTOMERS tables. There is only one customer with the cus_last_name column having value Roberts. Which INSERT statement should be used to add a row into the ORDERS table for the customer whose CUST_LAST_NAME is Roberts and CREDIT_LIMIT is 600?
 

Option A

 
A.    INSERT INTO orders VALUES (l.'10-mar-2007\ 'direct'. (SELECT customerid FROM customers
WHERE cust_last_iiame='Roberts' AND
credit_limit=600). 1000);
 

Option B

B.    INSERT INTO orders (order_id.order_date.order_mode. (SELECT customer id
FROM customers
WHERE cust_last_iiame='Roberts' AND
redit_limit=600).order_total)
VALUES(L'10-mar-2007'. 'direct', &&customer_id, 1000):
 

Option C

C.    INSERT INTO(SELECT o.order_id. o.order_date.o.order_modex.customer_id. o.ordertotal
FROM orders o. customers c
WHERE o.customer_id = c.customerid
AND c.cust_la$t_name-RoberTs' ANDc.credit_liinit=600)
VALUES (L'10-mar-2007\ 'direct'.( SELECT customer_id
FROM customers
WHERE cust_last_iiame='Roberts' AND
credit_limit=600). 1000);
 

Option D

D.    INSERT INTO orders (order_id.order_date.order_mode. (SELECT customer_id
FROM customers
WHERE cust_last_iiame='Roberts' AND
credit_limit=600).order_total)
VALUES(l.'10-mar-2007\ 'direct'. &customer_id. 1000):
 

Correct Answer A
Explanation


Question ID 4851

View the Exhibit and examine the structure of the SALES, CUSTOMERS,
PRODUCTS, and TIMES tables. The PROD_ID column is the foreign key in the SALES table, which references the PRODUCTS table. Similarly, the CUST ID and
TIME ID columns are also foreign keys in the SALES table referencing the CUSTOMERS and TIMES tables. respectively.
Evaluate the following CREATE
TABLE command:
CREATE TABLE new_sales(prod_id. cust_id. order_date DEFAULT SYSDATE) AS SELECT prod_id. custid. time_id
FROM sales;
Which statement is true regarding the above command?
 

Option A

A. The NEW_SALES table would not get created because the DEFAULT value cannot be specified in the column definition.
 
 

Option B

B.    The NEW SALES table would set created and all the NOT NULL constraints defined on the specified columns would be passed to the new table.
 

Option C

C.    The NEW_SALES table would not set created because the column names in the CREATE TABLE command and the SELECT clause do not match.
 

Option D

D.    The NEW SALES table would set created and all the FOREIGN KEY constraints defined on the specified columns would be passed to the new table.
 

Correct Answer B
Explanation

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