Latest Oracle 1Z0-051 Actual Free Exam Questions & Community Discussion, Page 2

Question #11

You need to calculate the number of days from 1st January 2007 till date . Dates are stored in the default format of dd-mon-rr. Which two SQL statements would give the required output? (Choose two.)

A. SELECT SYSDATE - '01-JAN-2007' FROM DUAL:

B. SELECT TO_DATE(SYSDAT *DD/MONTH/YYYY') - '01/JANUARY/2007' FROM DUAL:

C. SELECT SYSDATE - TOJDATE('01-JANUARY-2007') FROM DUAL:

D. SELECT TO_CHAR(SYSDATE. 'DD-MON-YYYY') - '01-JAN-2007' FROM DUAL:

E. SELECT SYSDATE - TOJDATE(X)1/JANUARY/2007") FROM DUAL:

Discussion 0

Correct Answer: C,E Vote an answer

Question #12

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

A. cannot be nested

B. accept arguments which can be a column or an expression

C. act on each row returned

D. manipulate data items

E. return one result per row

F. accept only one argument and return only one value

Discussion 0

Correct Answer: B,C,D,E Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #13

Where can sub queries be used? (Choose all that apply)

A. the WHERE clause in only the SELECT statement

B. the WHERE clause in SELECT as well as all DML statements

C. the HAVING clause in the SELECT statement

D. the FROM clause in the SELECT statement

E. the GROUP BY clause in the SELECT statement

F. field names in the SELECT statement

Discussion 0

Correct Answer: B,C,D,F Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #14

See the Exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS and ITEMS 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 the CREATE TABLE command: Exhibit:

Which statement is true regarding the above command?

A. The NEW_SALES table would get created and all the FOREIGN KEY constraints defined on the specified columns would be passed to the new table

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

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

D. The NEW_SALES table would get created and all the NOT NULL constraints defined on the specified columns would be passed to the new table

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #15

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 the correct result.

B. Only the first query gives the correct result.

C. Both give wrong results.

D. Only the second query gives the correct result.

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Question #16

You are currently located in Singapore and have connected to a remote database in
Chicago.
You issue the following command:
Exhibit:

PROMOTIONS is the public synonym for the public database link for the PROMOTIONS table.
What is the outcome?

A. Number of days since the promo started based on the current Chicago data and time

B. An error because the WHERE condition specified is invalid

C. Number of days since the promo started based on the current Singapore data and time.

D. An error because the ROUND function specified is invalid

Discussion 0

Correct Answer: A Vote an answer

Question #17

View the Exhibit and examine the structure of the PRODUCTS table.

You want to display the category with the maximum number of items. You issue the following query:
SQL>SELECT COUNT(*),prod_category_id FROM products GROUP BY prod_category_id HAVING COUNT(*) = (SELECT MAX(COUNT(*)) FROM products);
What is the outcome?

A. It generates an error because = is not valid and should be replaced by the IN operator.

B. It generates an error because the subquery does not have a GROUP BY clause.

C. It executes successfully but does not give the correct output.

D. It executes successfully and gives the correct output.

Discussion 0

Correct Answer: B Vote an answer

Question #18

Which two are true about aggregate functions? (Choose two.)

A. You cannot group the rows of a table by more than one column while using aggregate functions.

B. You can use aggregate functions in any clause of a SELECT statement.

C. You can pass column names, expressions, constants, or functions as parameter to an aggregate function.

D. You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.

E. You can use aggregate functions only in the column list of the select clause and in the WHERE clause of a SELECT statement.

F. You can use aggregate functions on a table, only by grouping the whole table as one single group.

Discussion 0

Correct Answer: B,C Vote an answer

Question #19

View the Exhibit and examine the data in the PROMOTIONS table.

You need to display all promo categories that do not have 'discount' in their subcategory.
Which two SQL statements give the required result? (Choose two.)

A. SELECT promo_category FROM promotions MINUS SELECT promo_category FROM promotions WHERE promo_subcategory <> 'discount';

B. SELECT promo_category FROM promotions INTERSECT SELECT promo_category FROM promotions WHERE promo_subcategory = 'discount';

C. SELECT promo_category FROM promotions MINUS SELECT promo_category FROM promotions WHERE promo_subcategory = 'discount';

D. SELECT promo_category FROM promotions INTERSECT SELECT promo_category FROM promotions WHERE promo_subcategory <> 'discount';

Discussion 0

Correct Answer: C,D Vote an answer

Question #20

Evaluate the SQL statement:
TRUNCATE TABLE DEPT;
Which three are true about the SQL statement? (Choose three.)

A. You can roll back the deletion of rows after the statement executes.

B. An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.

C. It does not release the storage space used by the table.

D. It releases the storage space used by the table.

E. You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table

F. You can NOT roll back the deletion of rows after the statement executes.

Discussion 0

Correct Answer: D,E,F Vote an answer

Explanation: Only visible for EduDump members. You can sign-up / login (it's free).

Oracle 1Z0-051 Actual Free Exam Questions & Community Discussion

Download Free Oracle 1Z0-051 Demo