Lead2Pass: Latest Free Oracle 1Z0-060 Dumps (151-160) Download!

Which normal form is a table in if it has no multi-valued attributes and no partial dependencies?

A.    First normal form
B.    Second normal form
C.    Third normal form
D.    Fourth normal form

Answer: B

Examine the types and examples of relationships that follow:
1. One-to-one
a) Teacher to students
2. One-to-many
b) Employees to Manager
3. Many-to-one
c) Person to SSN
4. Many-to-many
d) Customers to products
Which option indicates the correctly matched relationships?

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

Answer: C

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?

A.    DATE

Answer: D

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

A.    Displaying a date in a nondefault format
B.    Finding the number of characters in an expression
C.    Substituting a character string in a text expression with a specified string
D.    Combining more than two columns or expressions into a single column in the output

Answer: ABC

Which two statements are true regarding the count function?

A.    The count function can be used only for CHAR, VARCHAR2, and NUMBER data types.
B.    Count (*) returns the number of rows including duplicate rows and rows containing null value in any of
the columns.
C.    Count (cust_id) returns the number of rows including rows with duplicate customer IDs and NULL value
in the CUST_ID column.
D.    Count (distinct inv_amt) returns the number of rows excluding rows containing duplicates and NULL values
in the INV_AMT column.
E.    A select statement using the COUNT function with a DISTINCT keyword cannot have a where clause.

Answer: BD

Which two statements are true regarding single row functions?

A.    MOD: returns the quotient of a division
B.    TRUNC: can be used with number and date values
C.    CONCAT: can be used to combine any number of values
D.    SYSDATE: returns the database server current date and time
E.    INSTR: can be used to find only the first occurrence of a character in a string
F.    TRIM: can be used to remove all the occurrences of a character from a string

Answer: BD

You issue the following command to alter the country column in the departments table:

Which statement is true?

A.    It produces an error because column definitions cannot be altered to add default values.
B.    It executes successfully and all the rows that have a null value for the country column will be updated
with the value ‘USA’.
C.    It executes successfully. The modification to add the default value takes effect only from subsequent
insertions to the table.
D.    It produces an error because the data type for the column is not specified.

Answer: B

Which two statements are true regarding constraints?

A.    A foreign key cannot contain null values.
B.    A column with the unique constraint can contain null values.
C.    A constraint is enforced only for the insert operation on a table.
D.    A constraint can be disabled even if the constraint column contains data.
E.    All constraints can be defined at the column level as well as the table level.

Answer: BD

Examine the structure of the customers table:

CUSTNO is the primary key in the table. You want to find out if any customers’ details have been entered more than once using different CUSTNO, by listing all the duplicate names.
Which two methods can you use to get the required result?

A.    Self-join
B.    Subquery
C.    Full outer-join with self-join
D.    Left outer-join with self-join
E.    Right outer-join with self-join

Answer: AB

Which statement is true regarding the default behavior of the order by clause?

A.    In a character sort, the values are case-sensitive.
B.    NULL values are not considered at all by the sort operation.
C.    Only those columns that are specified in the select list can be used in the order by clause.
D.    Numeric values are displayed from the maximum to the minimum value if they have decimal positions.

Answer: A
Character Strings and Date
Character strings and date values are enclosed with single quotation marks. Character values are case-sensitive and date values are format-sensitive.
The default date display format is DD-MON-RR.
Which three SQL statements would display the value 1890.55 as $1, 890.55?


A.    Option A
B.    Option B
C.    Option C
D.    Option D
E.    Option E

Answer: ADE

If you want to pass the Oracle 12c 1Z0-060 exam sucessfully, recommend to read latest Oracle 12c 1Z0-060 Dumps full version.



Why Choose Lead2pass?

If you want to pass the exam successfully in first attempt you have to choose the best IT study material provider, in my opinion, Lead2pass is one of the best way to prepare for the exam.

Lead2pass Testking Pass4sure Actualtests Others
$99.99 $124.99 $125.99 $189 $29.99-$49.99
Real Questions
Error Correction
Printable PDF
Premium VCE
VCE Simulator
One Time Purchase
Instant Download
Unlimited Install
100% Pass Guarantee
100% Money Back