[Free] 2019(Nov) EnsurePass Oracle 1z0-061 Dumps with VCE and PDF 61-70

Get Full Version of the Exam
http://www.EnsurePass.com/1z0-061.html

Question No.61

Which two statements are true regarding constraints? (Choose two.)

  1. A table can have only one primary key and one foreign key.

  2. A table can have only one primary key but multiple foreign keys.

  3. Only the primary key can be defined at the column and table levels.

  4. The foreign key and parent table primary key must have the same name.

  5. Both primary key and foreign key constraints can be defined at both column and table levels.

Correct Answer: BE

Question No.62

Examine the data in the ORD_ITEMS table:

image

Evaluate the following query:

image

Which statement is true regarding the outcome of the above query?

  1. It gives an error because the having clause should be specified after the group by clause.

  2. It gives an error because all the aggregate functions used in the having clause must be specified in the select list.

  3. It displays the item nos with their average quantity where the average quantity is more than double the minimum quantity of that item in the table.

  4. It displays the item nos with their average quantity where the average quantity is more than double the overall minimum quantity of all the items in the table.

Correct Answer: C

Question No.63

View the Exhibits and examine products and sales tables.

image

You issue the following query to display product name and the number of times the product has been sold:

image

What happens when the above statement is executed?

  1. The statement executes successfully and produces the required output.

  2. The statement produces an error because item_cnt cannot be displayed in the outer query.

  3. The statement produces an error because a subquery in the from clause and outer-joins cannot be used together.

  4. The statement produces an error because the group by clause cannot be used in a subquery in the from clause.

Correct Answer: A

Question No.64

Examine the structure proposed for the transactions table:

image

Which two statements are true regarding the creation and storage of data in the above table structure?

  1. The CUST_STATUS column would give an error.

  2. The TRANS_VALIDITY column would give an error.

  3. The CUST_STATUS column would store exactly one character.

  4. The CUST_CREDIT_LIMIT column would not be able to store decimal values.

  5. The TRANS_VALIDITY column would have a maximum size of one character.

  6. The TRANS_DATE column would be able to store day, month, century, year, hour, minutes, seconds, and fractions of seconds

Correct Answer: BC

Explanation:

VARCHAR2(size)Variable-length character data (A maximum size must be specified: minimum size is 1; maximum size is 4, 000.)

CHAR [(size)] Fixed-length character data of length size bytes (Default and minimum size is 1; maximum size is 2, 000.)

NUMBER [(p, s)] Number having precision p and scale s (Precision is the total number of decimal digits and scale is the number of digits to the right of the decimal point; precision can range from 1 to 38, and scale can range from ?4 to 127.) DATE Date and time values to the nearest second between January 1, 4712 B.C., and December 31, 9999 A.D.

Question No.65

Which two statements are true regarding the count function?

  1. The count function can be used only for CHAR, VARCHAR2, and NUMBER data types.

  2. Count (*) returns the number of rows including duplicate rows and rows containing null value in any of the columns.

  3. Count (cust_id) returns the number of rows including rows with duplicate customer IDs and NULL value in the CUST_ID column.

  4. Count (distinct inv_amt) returns the number of rows excluding rows containing duplicates and NULL values in the INV_AMT column.

  5. A select statement using the COUNT function with a DISTINCT keyword cannot have a where clause.

Correct Answer: BD

Explanation:

Using the COUNT Function

The COUNT function has three formats: COUNT(*)

COUNT(expr) COUNT(DISTINCT expr)

COUNT(*) returns the number of rows in a table that satisfy the criteria of the SELECT statement, including duplicate rows and rows containing null values in any of the columns. If a WHERE clause is included in the SELECT statement, COUNT(*) returns the number of rows that satisfy the condition in the WHERE clause.

In contrast,

COUNT(expr) returns the number of non-null values that are in the column identified by expr. COUNT(DISTINCT expr) returns the number of unique, non-null values that are in the column identified by expr.

Question No.66

Study the following exhibit:

image

Assuming that the sequence SEQ1 was created with the option ORDER and INCREMENT BY

set to 1, what value will be returned by the final SELECT statement?

  1. 2

  2. 3

  3. 4

  4. It will depend on whether any other sessions are selecting from the sequence while the statements in the exhibit are being run.

Correct Answer: D

Question No.67

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

  1. SELECT TO_CHAR(1890.55, #39;$0G000D00#39;)FROM DUAL;

  2. SELECT TO_CHAR(1890.55, #39;$9, 999V99#39;)FROM DUAL;

  3. SELECT TO_CHAR(1890.55, #39;$99, 999D99#39;)FROM DUAL;

  4. SELECT TO_CHAR(1890.55, #39;$99G999D00#39;)FROM DUAL;

  5. SELECT TO_CHAR(1890.55, #39;$99G999D99#39;)FROM DUAL;

Correct Answer: ADE

Question No.68

Examine the data in the PROMO_BEGIN_DATE column of the promotions table:

image

You want to display the number of promotions started in 1999 and 2000. Which query gives the correct output?

image

  1. Option A

  2. Option B

  3. Option C

  4. Option D

Correct Answer: A

Question No.69

The customers table has the following structure:

image

You need to write a query that does the following tasks:

  1. Display the first name and tax amount of the customers. Tax is 5% of their credit limit.

  2. Only those customers whose income level has a value should be considered.

  3. Customers whose tax amount is null should not be considered. Which statement accomplishes all the required tasks?

image

  1. Option A

  2. Option B

  3. Option C

  4. Option D

Correct Answer: B

Question No.70

You want to create a sales table with the following column specifications and data types: SALESID: Number

STOREID: Number ITEMID: Number

QTY: Number, should be set to 1 when no value is specified

SLSDATE: Date, should be set to current date when no value is specified

PAYMENT: Characters up to 30 characters, should be set to CASH when no value is specified Which statement would create the table?

image

  1. Option A

  2. Option B

  3. Option C

  4. Option D

Correct Answer: B

Explanation:

To specify the default value of payment field you must use DEFAULT #39;CASH#39;.

Get Full Version of the Exam
1z0-061 Dumps
1z0-061 VCE and PDF

Leave a Reply

Your email address will not be published. Required fields are marked *

Proudly powered by WordPress