[Free] 2019(Nov) EnsurePass Oracle 1z0-061 Dumps with VCE and PDF 41-50

Get Full Version of the Exam
http://www.EnsurePass.com/1z0-061.html

Question No.41

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:

$gt; sqlldr hr/hr@pdb table=employees

Which two statements are true regarding the command?

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

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

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

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

Correct Answer: AC

Explanation:

*SQL*Loader is invoked when you specify the sqlldr command and, optionally, parameters that establish session characteristics.

Question No.42

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

image

Evaluate the following SQL statement:

image

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

  1. It shows COST_REMARK for all the promos in the table.

  2. It produces an error because the SUBQUERY gives an error.

  3. It shows COST_REMARK for all the promos in the promo category #39;TV#39;

  4. It produces an error because SUBQUERIES cannot be used with the case expression.

Correct Answer: A

Question No.43

This statement will fail:

create unique bitmap index on employees(department_id,hire_date);

Why?

  1. Bitmap indexes cannot be unique.

  2. The two columns are of different data types.

  3. A bitmap index can be on only one column.

  4. There is already a B*Tree index on DEPARTMENT_ID.

Correct Answer: A

Question No.44

Evaluate the following SQL statement:

image

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

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

  2. It produces an error because positional notation cannot be used in the order by clause with set operators.

  3. It executes successfully but ignores the order by clause because it is not located at the end of the compound statement.

  4. It produces an error because the order by clause should appear only at the end of a compound query-that is, with the last select statement.

Correct Answer: D

Question No.45

Examine the structure of the products table:

image

You want to display the names of the products that have the highest total value for UNIT_PRICE

* QTY_IN_HAND.

Which SQL statement gives the required output?

image

  1. Option A

  2. Option B

  3. Option C

  4. Option D

Correct Answer: A

Question No.46

Which of these is a defining characteristic of a complex view, rather than a simple view? (Choose one or more correct answers.)

  1. Restricting the projection by selecting only some of the table#39;s columns

  2. Naming the view#39;s columns with column aliases

  3. Restricting the selection of rows with a WHERE clause

  4. Performing an aggregation

  5. Joining two tables

Correct Answer: DE

Question No.47

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

image

Examine the data in the ename and hiredate columns of the employees table:

image

You want to generate a list of user IDs as follows:

image

You issue the following query:

image

What is the outcome?

  1. It executes successfully and gives the correct output.

  2. It executes successfully but does not give the correct output.

  3. It generates an error because the REPLACE function is not valid.

  4. It generates an error because the SUBSTR function cannot be nested in the CONCAT function.

    Correct Answer: A

    Explanation:

    REPLACE (text, search_string, replacement_string)

    Searches a text expression for a character string and, if found, replaces it with a specified

    replacement string

    The REPLACE Function

    The REPLACE function replaces all occurrences of a search item in a source string with a replacement term and returns the modified source string. If the length of the replacement term is different from that of the search item, then the lengths of the returned and source strings will be different. If the search string is not found, the source string is returned unchanged. Numeric and date literals and expressions are evaluated before being implicitly cast as characters when they occur as parameters to the REPLACE function. The REPLACE function takes three parameters, with the first two being mandatory. Its syntax is REPLACE (source string, search item, [replacement term]). If the replacement term parameter is omitted, each occurrence of the search item is removed from the source string. In other words, the search item is replaced by an empty string. .

    The following queries illustrate the REPLACE function with numeric and date expressions: Query 1: select replace(10000-3, #39;9#39;, #39;85#39;) from dual

    Query 2: select replace(sysdate, #39;DEC#39;, #39;NOV#39;) from dual

    Question No.48

    The following parameter are set for your Oracle 12c database instance: OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE

    You want to manage the SQL plan evolution task manually. Examine the following steps:

    1. Set the evolve task parameters.

    2. Create the evolve task by using the DBMS_SPM.CREATE_EVOLVE_TASK function.

    3. Implement the recommendations in the task by using the DBMS_SPM.IMPLEMENT_EVOLVE_TASK function.

    4. Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function.

      A.

      2, 4, 5

      B.

      2, 1, 4, 3, 5

      C.

      1, 2, 3, 4, 5

      D.

      1, 2, 4, 5

    5. Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK function. Identify the correct sequence of steps:

Correct Answer: B

Question No.49

You issued the following command: SQLgt; DROP TABLE employees; Which three statements are true?

  1. All uncommitted transactions are committed.

  2. All indexes and constraints defined on the table being dropped are also dropped.

  3. Sequences used in the employees table become invalid.

  4. The space used by the employees table is reclaimed immediately.

  5. The employees table can be recovered using the rollback command.

  6. The employees table is moved to the recycle bin.

Correct Answer: ABF

Explanation:

A: If a user issues a DDL (CREATE, ALTER, or DROP) or DCL (GRANT or REVOKE) command, the transaction in progress (if any) will be committed.

B: Dropping a table invalidates dependent objects, such as indexes and constraints. F: The DROP TABLE statement moves a table or object table to the recycle bin.

Incorrect:

Not B: In general sequences used in the table would not by affected when the table is dropped. Not D: Unless you specify the PURGE clause, the DROP TABLE statement does not result in space being released back to the tablespace for use by other objects, and the space continues to count toward the user#39;s space quota.

Not E: Dropping a table invalidates dependent objects and removes object privileges on the table. If you want to re-create the table, then you must regrant object privileges on the table, re-create the indexes, integrity constraints, and triggers for the table, and respecify its storage parameters. References:

Question No.50

Evaluate the following SQL statement:

image

Which statement is true regarding the above query if one of the values generated by the subquery is null?

  1. It produces an error.

  2. It executes but returns no rows.

  3. It generates output for null as well as the other values produced by the subquery.

  4. It ignores the null value and generates output for the other values produced by the subquery.

Correct Answer: D

Get Full Version of the Exam
1z0-061 Dumps
1z0-061 VCE and PDF