Oracle 1z0-061 Exam Questions

Question 6 of 339

View the Exhibit and examine the structure of the products table.
Exam 1z0-061: Question 6 - Image 1

Using the products table, you issue the following query to generate the names, current list price, and discounted list price for all those products whose list price falls below $10 after a discount of 25% is applied on it.
Exam 1z0-061: Question 6 - Image 2

The query generates an error. What is the reason for the error?

The parenthesis should be added to enclose the entire expression.

The double quotation marks should be removed from the column alias.

The column alias should be replaced with the expression in the where clause.

The column alias should be put in uppercase and enclosed within double quotation marks in the where clause.

Correct Answer: C

Question 7 of 339

Examine the structure proposed for the transactions table:
Exam 1z0-061: Question 7 - Image 1

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

The CUST_STATUS column would give an error.

The TRANS_VALIDITY column would give an error.

The CUST_STATUS column would store exactly one character.

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

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

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

Correct Answer: B, C

Question 8 of 339

You need to create a table for a banking application. One of the columns in the table has the following requirements:
1) You want a column in the table to store the duration of the credit period.
2) The data in the column should be stored in a format such that it can be easily added and subtracted with date data type without using conversion functions.
3) The maximum period of the credit provision in the application is 30 days.
4) The interest has to be calculated for the number of days an individual has taken a credit for.
Which data type would you use for such a column in the table?

DATE

NUMBER

TIMESTAMP

INTERVAL DAY TO SECOND

INTERVAL YEAR TO MONTH

Correct Answer: D

Question 9 of 339

Which three tasks can be performed using SQL functions built into Oracle Database?

Displaying a date in a nondefault format

Finding the number of characters in an expression

Substituting a character string in a text expression with a specified string

Combining more than two columns or expressions into a single column in the output

Correct Answer: A, B, C

SQL functions built into Oracle Database can indeed perform tasks such as displaying a date in a nondefault format, finding the number of characters in an expression, and substituting a character string in a text expression with a specified string. These tasks are handled using various built-in functions like TO_CHAR for date formatting, LENGTH for finding the number of characters, and REPLACE for substituting strings. Combining more than two columns or expressions into a single column in the output is not typically done using a single function, as the CONCAT function in Oracle is limited to two parameters, though it can be achieved using the concatenation operator ||.

Question 10 of 339

View the Exhibit and examine the description of SALES and PROMOTIONS tables.
Exam 1z0-061: Question 10 - Image 1

You want to delete rows from the sales table, where the PROMO_NAME column in the promotions table has either blowout sale of everyday low prices as values.
Which three delete statements are valid?
Exam 1z0-061: Question 10 - Image 2

Option A

Option B

Option C

Option D

Correct Answer: B, C, D