Oracle Database 12c: SQL Fundamentals - Version: 4.1 (Course: 1z0-061 Exam)

JavaScript isn't enabled in your browser, so this file can't be opened. Enable and reload.

Email *

QUESTION NO:7 You execute the following commands: *

1 point

For which substitution variables are you prompted for the input?

A. None, because no input required

B. Both the substitution variables 'hiredate' and 'mgr_id\

C. Only 'hiredate'

D. Only 'mgr_id'

QUESTION NO:1 Which three SQL statements would display the value 1890.55 as $1, 890.55? *

1 point

A. Option A

B. Option B

C. Option C

D. Option D

E. Option E

Required

QUESTION NO:2 You want to display 5 percent of the employees with the highest salaries in the EMPLOYEES table. Which query will generate the required result? *

1 point

A. Option A

B. Option B

C. Option C

D. Option D

QUESTION NO:6 Examine the types and examples of relationships that follow: *

1 point

A. 1-a, 2-b, 3-c, and 4-d

B. 1-c, 2-d, 3-a, and 4-b

C. 1-c, 2-a, 3-b, and 4-d

D. 1-d, 2-b, 3-a, and 4-c

QUESTION NO:4 View the Exhibit and evaluate the structure and data in the CUST_STATUS table. *

1 point

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

A. It produces an error because the AMT_SPENT column contains a null value.

B. It displays a bonus of 1000 for all customers whose AMT_SPENT is less than CREDIT_LIMIT.

C. It displays a bonus of 1000 for all customers whose AMT_SPENT equals CREDIT_LIMIT, or AMT_SPENT is null.

D. It produces an error because the TO_NUMBER function must be used to convert the result of the NULLIF function before it can be used by the NVL2 function.

QUESTION NO:9 View the Exhibit and examine the data in the employees table: *

1 point

Which join option can be used in the blank in the above query to get the required output?

A. INNER JOIN

B. FULL OUTER JOIN

C. LEFT OUTER JOIN

D. RIGHT OUTER JOIN

QUESTION NO: 10 Evaluate the following query: *

1 point

What would be the outcome of the above query?

A. It produces an error because flower braces have been used.

B. It produces an error because the data types are not matching.

C. It executes successfully and introduces an 's at the end of each PROMO_NAME in the output.

D. It executes successfully and displays the literal "{'s start date was \} * for each row in the output.

QUESTION NO:3 In the customers table, the CUST_CITY column contains the value 'Paris' for the CUST_FIRST_NAME 'Abigail'. Evaluate the following query: *

1 point

What would be the outcome?

A. Abigail PA

B. Abigail Pa

C. Abigail IS

D. An error message

QUESTION NO:8 View the Exhibit and examine the structure of the customers table. *

1 point

A. Option A

B. Option B

C. Option C

D. Option D

Write down the your Mobile Number? *

QUESTION NO:5 Which normal form is a table in if it has no multi-valued attributes and no partial dependencies? *

1 point

A. First normal form

B. Second normal form

C. Third normal form

D. Fourth normal form

Write down the your Full Name? *

Clear form

Never submit passwords through Google Forms.

This content is neither created nor endorsed by Google. Report Abuse - Terms of Service - Privacy Policy

Forms