[Free] 2018(Jan) EnsurePass Testinsides Oracle 1z0-061 Dumps with VCE and PDF 21-30

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan Oracle Official New Released 1z0-061
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/1z0-061.html

Oracle Database 12c: SQL Fundamentals

Question No: 21

View the Exhibits and examine the structures of the products and sales tables.

Ensurepass 2018 PDF and VCE

Ensurepass 2018 PDF and VCE

Which two SQL statements would give the same output?

Ensurepass 2018 PDF and VCE

  1. Option A

  2. Option B

  3. Option C

  4. Option D

Answer: A,C

Question No: 22

View the Exhibit and examine the data in the employees table:

Ensurepass 2018 PDF and VCE

You want to display all the employee names and their corresponding manager names. Evaluate the following query:

Ensurepass 2018 PDF and VCE

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

  1. INNER JOIN

  2. FULL OUTER JOIN

  3. LEFT OUTER JOIN

  4. RIGHT OUTER JOIN

Answer: C

Question No: 23

Which create table statement is valid?

Ensurepass 2018 PDF and VCE

  1. Option A

  2. Option B

  3. Option C

  4. Option D

Answer: D Explanation:

PRIMARY KEY Constraint

A PRIMARY KEY constraint creates a primary key for the table. Only one primary key can be created for each table. The PRIMARY KEY constraint is a column or a set of columns that uniquely identifies each row in a table. This constraint enforces the uniqueness of the column or column combination and ensures that no column that is part of the primary key can contain a null value.

Note: Because uniqueness is part of the primary key constraint definition, the Oracle server enforces the uniqueness by implicitly creating a unique index on the primary key column or columns.

Question No: 24

Examine the structure of the employees table.

Ensurepass 2018 PDF and VCE

You want to display the maximum and minimum salaries of employees hired 1 year ago. Which two statements would get the correct output?

Ensurepass 2018 PDF and VCE

  1. Option A

  2. Option B

  3. Option C

  4. Option D

Answer: B,D Explanation:

http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db2z1 0.doc.sqlref/src/tpc/db2z_sql_subselectexamples.htm

Question No: 25

Which two statements are true regarding constraints?

  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.

Answer: B,E

Question No: 26

View the Exhibit and evaluate the structure and data in the CUST_STATUS table.

Ensurepass 2018 PDF and VCE

You issue the following SQL statement:

Ensurepass 2018 PDF and VCE

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

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

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

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

  4. 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.

Answer: C Explanation:

The NULLIF Function

The NULLIF function tests two terms for equality. If they are equal the function returns a null, else it returns the first of the two terms tested.

The NULLIF function takes two mandatory parameters of any data type. The syntax is NULLIF(ifunequal, comparison_term), where the parameters ifunequal and comparison_term are compared. If they are identical, then NULL is returned. If they differ, the ifunequal parameter is returned.

Question No: 27

Examine the structure proposed for the transactions table:

Ensurepass 2018 PDF and VCE

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

Answer: B,C 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 -84 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: 28

Examine the structure of the sales table:

Ensurepass 2018 PDF and VCE

Evaluate the following create table statement:

Ensurepass 2018 PDF and VCE

Which two statements are true about the creation of the SALES1 table?

  1. The SALES1 table is created with no rows but only a structure.

  2. The SALES1 table would have primary key and unique constraints on the specified columns.

  3. The SALES1 table would not be created because of the invalid where clause.

  4. The SALES1 table would have not null and unique constraints on the specified columns.

  5. The SALES1 table would not be created because column-specified names in the select

and create table clauses do not match,

Answer: A,D

Question No: 29

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

Ensurepass 2018 PDF and VCE

Evaluate the following query:

Ensurepass 2018 PDF and VCE

What would be the outcome of executing the above SQL statement?

  1. It produces an error.

  2. It shows the names of all products in the table.

  3. It shows the names of products whose list price is the second highest in the table.

  4. It shows the names of all products whose list price is less than the maximum list price.

Answer: C

Question No: 30

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?

  1. DATE

  2. NUMBER

  3. TIMESTAMP

  4. INTERVAL DAY TO SECOND

  5. INTERVAL YEAR TO MONTH

Answer: D

100% Ensurepass Free Download!
Download Free Demo:1z0-061 Demo PDF
100% Ensurepass Free Guaranteed!
1z0-061 Dumps

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.