100% Free Oracle PL/SQL Developer Certified Associate 1z0-071 Dumps PDF Demo Cert Guide Cover [Q54-Q68] : Exams Labs Braindumps : http://blog.examslabs.com

NEW QUESTION 54
Which two statements are true regarding constraints? (Choose two.)

A foreign key cannot contain NULL values.

A column with the UNIQUE constraint can contain NULL.

A constraint is enforced only for the INSERT operation on a table.

A constraint can be disabled even if the constraint column contains data.

All the constraints can be defined at the column level as well as the table level

NEW QUESTION 55
Which two are true?

CONCAT joins two or more character strings together.

FLOOR returns the largest integer less than or equal to a specified number.

CONCAT joins two character strings together.

INSTR finds the offset within a string of a single character only.

INSTR finds the offset within a character string, starting from position 0.

FLOOR returns the largest positive integer less than or equal to a specified number.

NEW QUESTION 56
The BOOKS_TRANSACTIONStable exists in your database.
Examine the SQL statement:
SQL>SELECT * FROM books_transactionsORDER BY 3;
What is the outcome on execution?

The execution tails unless the numeral 3 in the order by clause is replaced by a column name,

Rows are displayed in the order that they are stored in the table only for the three rows with the lowest values in the key column.

Rows are displayed in the order that they are stored in the table only for the first three rows.

Rows are displayed sorted in ascending order of the values in the third column in the table.

NEW QUESTION 57
On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command:
$> sqlldr hr/hr@pdb table=employees
Which two statements are true regarding the command?

It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database.

It fails because no SQL *Loader data file location is specified.

It fails if the HR user does not have the CREATE ANY DIRECTORY privilege.

It fails because no SQL *Loader control file location is specified.

NEW QUESTION 58
Which two are true about multiple table INSERT statements?

They always use subqueries.

They can transform a row from a source table into multiple rows in a target table.

The conditional INSERT FIRST statement always inserts a row into a single table.

The conditional INSERT ALL statement inserts rows into a single table by aggregating source rows.

The unconditional INSERT ALL statement must have the same number of columns in both the source and target tables.

NEW QUESTION 59
You issued this command:

Which three statements are true?

Views referencing HR.EMPLOYEES are dropped.

All constraints defined on HR.EMPLOYEES are dropped.

Sequences used to populate columns in the HR.EMPLOYEES table are dropped.

The HR.EMPLOYEES table may be moved to the recycle bin.

All indexes defined on HR.EMPLOYEES are dropped.

Synonyms for HR.EMPLOYEES are dropped.

NEW QUESTION 60
View the Exhibit and examine the structure of the ORDERS table.

Which UPDATE statement is valid?

UPDATE ordersSET order_date = ’12-mar-2007′,order_total IS NULLWHERE order_id = 2455;

UPDATE ordersSET order_date = ’12-mar-2007′,AND order_total = TO_NUMBER(NULL)WHERE order_id = 2455;

UPDATE ordersSET order_date = ’12-mar-2007′,order_total = NULLWHERE order_id = 2455;

UPDATE ordersSET order_date = TO_DATE(’12-mar-2007′,’dd-mon-yyyy’),SET order_total = TO_NUMBER (NULL)WHERE order_id = 2455;

NEW QUESTION 61
These are the steps for a correlated subquery, listed in random order:
The WHERE clause of the outer query is evaluated.
A candidate row is fetched from the table specified in the outer query.
This is repeated for the subsequent rows of the table, until all the rows are processed.
Rows are returned by the inner query, after being evaluated with the value from the candidate row in the outer query.
Which is the correct sequence in which the Oracle server evaluates a correlated subquery?

2, 1, 4, 3

4, 1, 2, 3

4, 2, 1, 3

2, 4, 1, 3

NEW QUESTION 62
Evaluate the following SQL statement:

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

It executes successfully and displays rows in the descending order of PROMO_CATEGORY.

It produces an error because positional notation cannot be used in the ORDER BYclause with SET operators.

It executes successfully but ignores the ORDER BYclause because it is not located at the end of the compound statement.

It produces an error because the ORDER BYclause should appear only at the end of a compound query-that is, with the last SELECTstatement.

NEW QUESTION 63
View the exhibit and examine the structure and data in the INVOICE table.

Which two SQL statements would execute successfully? (Choose two.)

SELECT MAX(AVG(SYSDATE -inv_date))FROM invoice;

SELECT AVG(inv_date)FROM invoice;

SELECT MAX(inv_date),MIN(cust_id)FROM invoice;

SELECT AVG( inv_date – SYSDATE), AVG(inv_amt)FROM invoice;

NEW QUESTION 64
which is true about the round,truncate and mod functions>?

ROUND(MOD(25,3),-1) IS INVALID

ROUND(MOD(25,3),-1) AND TRUNC(MOD(25,3),-1) ARE BOTH VALID AND GIVE THE SAME RESULT.

ROUND(MOD(25,3),-1) AND TRUNC(MOD(25,3),-1) ARE BOTH VALID AND GIVE THE DIFFERENT RESULTS.

TRUNC(MOD(25,3),-1) IS INVALID.

NEW QUESTION 65
View the Exhibit and examine the details of the ORDER_ITEMS table.

Evaluate the following SQL statements:
Statement 1:
SELECT MAX(unit_price*quantity) “Maximum Order”
FROM order_items;
Statement 2:
SELECT MAX(unit_price*quantity) “Maximum Order”
FROM order_items
GROUP BY order_id;
Which statements are true regarding the output of these SQL statements? (Choose all that apply.)

Statement 2 would return multiple rows of output.

Both statements would ignore NULL values for the UNIT_PRICE and QUANTITY columns.

Statement 1 would not return give the same output.

Both the statements would give the same output.

Statement 1 would return only one row of output.

NEW QUESTION 66
Examine the structure of the EMPLOYEEStable.

There is a parent/child relationship between EMPLOYEE_IDand MANAGER_ID.
You want to display the last names and manager IDs of employees who work for the same manager as the employee whose EMPLOYEE_IDis 123.
Which query provides the correct output?
SELECT e.last_name, m.manager_id

FROM employees e RIGHT OUTER JOIN employees m
on (e.manager_id = m.employee_id)
AND e.employee_id = 123;
SELECT e.last_name, m.manager_id

FROM employees e LEFT OUTER JOIN employees m
on (e.employee_id = m.manager_id)
WHERE e.employee_id = 123;
SELECT e.last_name, e.manager_id

FROM employees e RIGHT OUTER JOIN employees m
on (e.employee_id = m.employee_id)
WHERE e.employee_id = 123;
SELECT m.last_name, e.manager_id

FROM employees e LEFT OUTER JOIN employees m
on (e.manager_id = m.manager_id)
WHERE e.employee_id = 123;

NEW QUESTION 67
Examine the data in the PRODUCTStable:

Examine these queries:

Which queries generate the same output?

1 and 2

1 and 3

1, 2, and 3

2 and 3

NEW QUESTION 68
Which two are true about granting privilege on objects?

The owner of an object acquires all object privilege on that object by default.

The WITH GRANT OPTION clause can be used only by DBA users.

A table owner must grant the references privilege to allow other users to create FOREIGN KEY constraints using that table.

An object privilege can be granted to a role only by the owner of that object.

An object privilege can be granted to other users only by the owner of object.