1Z0-051 試験問題を無料オンラインアクセス

Exhibit contains the structure of PRODUCTS table:

Evaluate the following query:

What would be the outcome of executing the above SQL statement?

• A.It shown the names of all products whose list price is less than the maximum list price
• B.It shows the names of products whose list price is the second highest in the table.
• C.It produces an error
• D.It shows the names of all products in the table

You need to perform these tasks:
- Create and assign a MANAGER role to Blake and Clark - Grant CREATE TABLE and CREATE VIEW privileges to Blake and Clark
Which set of SQL statements achieves the desired results?

• A.GRANT manager ROLE TO BLAKE,CLARK;
  GRANT create table, create voew
  TO BLAKE CLARK;
  ***MISSING***
• B.CREATE ROLE manager;
  GRANT create table, create view
  TO manager;
  GRANT manager TO BLAKE,CLARK;
• C.CREATE ROLE manager;
  GRANT create table, create voew
  TO manager;
  GRANT manager ROLE TO BLAKE,CLARK;

Examine the structure and data in the PRIC E_LIST table: Name Null? Type
PROD_D NOT NULL NUMBER(3) PROD_PRICE VARCHAR2(10) PROD_ID PROD PRICE
100 $234.55 101 $6,509.75 102 $1,234 in the same format as the PROD_PRICE. Which SQL statement would give the required
result?

• A.SELECT TO_NUMBER(TO_NUMBER(prod_price.,$99.999.99')* .25/$99.999.00') FROM PRICE_LIST:
• B.SELECT TO_CHAR(prod_price* .25.'$99.999.99') FROM PRICEJLIST:
• C.SELECT TO_CRAR(TO_NUMBER(prod_price.'S99.999.99')* .25.'$99.999.00') FROM PRICE_LIST:
• D.SELECT TO_CHAR(TO_NUMBER(prod_price)* .25.'$99.999.00') FROM PRICE_LIST;

View the Exhibit and examine the data in the PRODUCTS table. You need to display product names from the PRODUCTS table that belong to the 'Software/Other1 category with minimum prices as either $2000 or $4000 and no unit of measure. You issue thej following query:

Which statement is true regarding the above query?

• A.It generates an error because the condition specified for the PROD_CATEGORY column is not valid.
• B.It executes successfully and returns the required result.
• C.It generates an error because the condition specified for PROD_UNIT_OF_MEASURE is not valid.
• D.It executes successfully but returns no result.

View the Exhibit and examine the structure of ORDERS and CUSTOMERS tables.

There is only one customer with the CUST_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?

• A.INSERT INTO orders VALUES (1,'10-mar-2007', 'direct', (SELECT customer_id FROM customers WHERE cust_last_name='Roberts' AND credit_limit=600), 1000);
• B.INSERT INTO orders (order_id,order_date,order_mode,
  (SELECT customer_id
  FROM customers
  WHERE cust_last_name='Roberts' AND
  credit_limit=600),order_total)
  VALUES(1,'10-mar-2007', 'direct', &customer_id, 1000);
• C.INSERT INTO orders (order_id,order_date,order_mode, (SELECT customer_id FROM customers WHERE cust_last_name='Roberts' AND credit_limit=600),order_total) VALUES(1,'10-mar-2007', 'direct', &&customer_id, 1000);
• D.INSERT INTO(SELECT o.order_id, o.order_date,o.order_mode,c.customer_id, o.order_total FROM orders o, customers c WHERE o.customer_id = c.customer_id AND c.cust_last_name='Roberts' ANDc.credit_limit=600 ) VALUES (1,'10-mar-2007', 'direct',(SELECT customer_id FROM customers WHERE cust_last_name='Roberts' AND credit_limit=600), 1000);