Online Access Free 1Z0-051 Exam Questions

Examine the structure of the TRANSACTIONS table:
Name Null Type
TRANS_ID NOT NULL NUMBER(3)
CUST_NAME VARCHAR2(30)
TRANS_DATE DATE
TRANS_AMT NUMBER(10,2)
You want to display the transaction date and specify whether it is a weekday or weekend.
Evaluate the following two queries:

Which statement is true regarding the above queries?

• A.Both give wrong results.
• B.Only the first query gives the correct result.
• C.Only the second query gives the correct result.
• D.Both give the correct result.

Examine the structure proposed for the TRANSACTIONS table:

Which two statements are true regarding the storage of data in the above table structure? (Choose two.)

• A.The TRANS_DATE column would allow storage of dates only in the dd-mon-yyyy format.
• B.The CUST_CREDIT_VALUE column would allow storage of positive and negative integers.
• C.The CUST_STATUS column would allow storage of data up to the maximum VARCHAR2 size of 4,000 characters.
• D.The TRANS_VALIDITY column would allow storage of a time interval in days, hours, minutes, and seconds.

See the Exhibit and examine the structure of the PROMOTIONS table: Exhibit:

Using the PROMOTIONS table, you need to find out the average cost for all promos in the
range $0-2000 and $2000-5000 in category A.
You issue the following SQL statements:
Exhibit:

What would be the outcome?

• A.It generates an error because multiple conditions cannot be specified for the WHEN clause
• B.It generates an error because CASE cannot be used with group functions
• C.It executes successfully and gives the required result
• D.It generates an error because NULL cannot be specified as a return value

Which SQL statements would display the value 1890.55 as $1,890.55? (Choose three.)

• A.SELECT TO_CHAR(1890.55,'$99G999D00') FROM DUAL;
• B.SELECT TO_CHAR(1890.55,'$99G999D99') FROM DUAL;
• C.SELECT TO_CHAR(1890.55,'$99,999D99') FROM DUAL;
• D.SELECT TO_CHAR(1890.55,'$9,999V99') FROM DUAL;
• E.SELECT TO_CHAR(1890.55,'$0G000D00') FROM DUAL;

What does the FORCE option for creating a view do?

• A.creates a view with constraints
• B.creates a view in another schema even if you don't have privileges
• C.creates a view even if the underlying parent table has constraints
• D.creates a view regardless of whether or not the base tables exist