This page was exported from Easily Pass By Training Lead2pass Latest Dumps [ https://www.freebraindump.com ]
Export date: Thu Mar 28 10:56:56 2024 / +0000 GMT

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


QUESTION 151
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

QUESTION 152
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

QUESTION 153
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
B.    NUMBER
C.    TIMESTAMP
D.    INTERVAL DAY TO SECOND
E.    INTERVAL YEAR TO MONTH

Answer: D

QUESTION 154
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

QUESTION 155
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

QUESTION 156
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

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

clip_image001
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

QUESTION 158
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

QUESTION 159
Examine the structure of the customers table:

clip_image001[4]
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

QUESTION 160
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
s
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.
QUESTION 161
Which three SQL statements would display the value 1890.55 as $1, 890.55?

clip_image001[6]

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.

http://www.lead2pass.com/1z0-060.html
Post date: 2014-03-07 01:57:21
Post date GMT: 2014-03-07 01:57:21
Post modified date: 2014-05-27 08:38:31
Post modified date GMT: 2014-05-27 08:38:31
Powered by [ Universal Post Manager ] plugin. HTML saving format developed by gVectors Team www.gVectors.com