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

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

Question No.291

View the Exhibit and examine the structure of the ORDERS and CUSTOMERS tables.

image

Evaluate the following SQL command:

SQLgt; SELECT o.order_id, c.cust_name, o.order_total, c.credit_limit FROM orders o JOIN customers c

USING (customer_id)

WHERE o.order_total gt; c.credit_limit FOR UPDATE

ORDER BY o.order_id;

Which two statements are true regarding the outcome of the above query? (Choose two.)

  1. It locks all the rows that satisfy the condition in the statement.

  2. It locks only the columns that satisfy the condition in both the tables.

  3. The locks are released only when a COMMIT or ROLLBACK is issued.

  4. The locks are released after a DML statement is executed on the locked rows.

Correct Answer: AC

Explanation:

FOR UPDATE Clause in a SELECT Statement

Locks the rows in the EMPLOYEES table where job_id is SA_REP. Lock is released only when you issue a ROLLBACK or a COMMIT.

If the SELECT statement attempts to lock a row that is locked by another user, the database waits until the row is available, and then returns the results of the SELECTstatement SELECT employee_id, salary, commission_pct, job_id FROM employees

WHERE job_id = #39;SA_REP#39; FOR UPDATE

ORDER BY employee_id;

Question No.292

View the Exhibit and examine the structure of CUSTOMERS table.

image

Evaluate the following query:

image

Which statement is true regarding the above query?

  1. It executes successfully.

  2. It produces an error because the condition on the CUST_CITY column is not valid.

  3. It produces an error because the condition on the CUST_FIRST_NAME column is not valid.

  4. It produces an error because conditions on the CUST_CREDIT_LIMIT column are not valid.

Correct Answer: A

Question No.293

Which two statements are true regarding tables? (Choose two.)

  1. A table name can be of any length.

  2. A table can have any number of columns.

  3. A column that has a DEFAULT value cannot store null values.

  4. A table and a view can have the same name in the same schema.

  5. A table and a synonym can have the same name in the same schema.

  6. The same table name can be used in different schemas in the same database.

Correct Answer: EF Explanation: Synonyms

Synonyms are database objects that enable you to call a table by another name. You can create synonyms to give an alternative name to a table.

Question No.294

In which four clauses can a sub query be used? (Choose four.)

  1. in the INTO clause of an INSERT statement

  2. in the FROM clause of a SELECT statement

  3. in the GROUP BY clause of a SELECT statement

  4. in the WHERE clause of a SELECT statement

  5. in the SET clause of an UPDATE statement

  6. in the VALUES clause of an INSERT statement

Correct Answer: ABDE

Explanation:

A: a sub query is valid on the INTO clause of an ISERT Statement

B: a sub query can be used in the FROM clause of a SELECT statement D: a sub query can be used in the WHERE clause of a SELECT statement, E: a sub query can be used in the SET clauses of an UPDATE statement,

Incorrect answer:

C. sub query cannot be used

F. is incorrect.

Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 6-5

Question No.295

Which three statements are true regarding subqueries? (Choose three.)

  1. Subqueries can contain GROUP BY and ORDER BY clauses.

  2. Main query and subquery can get data from different tables.

  3. Main query and subquery must get data from the same tables.

  4. Subqueries can contain ORDER BY but not the GROUP BY clause.

  5. Only one column or expression can be compared between the main query and subquery.

  6. Multiple columns or expressions can be compared between the main query and subquery.

Correct Answer: ABF

Explanation:

SUBQUERIES can be used in the SELECT list and in the FROM, WHERE, and HAVING clauses of a query.

A subquery can have any of the usual clauses for selection and projection. The following are required clauses:

image

image

A SELECT list A FROM clause

The following are optional clauses:

image

image

image

WHERE GROUP BY HAVING

The subquery (or subqueries) within a statement must be executed before the parent query that calls it, in order that the results of the subquery can be passed to the parent.

Question No.296

Which object privileges can be granted on a view?

  1. none

  2. DELETE, INSERT, SELECT

  3. ALTER, DELETE, INSERT, SELECT

  4. DELETE, INSERT, SELECT, UPDATE

Correct Answer: D

Explanation:

Object privilege on VIEW is DELETE, INSERT, REFERENCES, SELECT and UPDATE.

Incorrect answer:

  1. Object privilege on VIEW is DELETE, INSERT, REFERENCES, SELECT and UPDATE

  2. Object privilege on VIEW is DELETE, INSERT, REFERENCES, SELECT and UPDATE

  3. Object privilege on VIEW is DELETE, INSERT, REFERENCES, SELECT and UPDATE Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 13-12

Question No.297

The EMPLOYEES table contains these columns: EMPLOYEE_ID NUMBER(4)

LAST_NAME VARCHAR2 (25) JOB_ID VARCHAR2(10)

You want to search for strings that contain #39;SA_#39; in the JOB_ID column. Which SQL statement do you use?

  1. SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE #39;%SA\_#39; ESCAPE #39;\#39;;

  2. SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE #39;%SA_#39;;

  3. SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE #39;%SA_#39; ESCAPE quot;\quot;;

  4. SELECT employee_id, last_name, job_id FROM employees WHERE job_id = #39;%SA_#39;;

Correct Answer: A

Explanation:

ESCAPE identifier to search for the _ symbol

Incorrect answer:

  1. ESCAPE identifier must be use

  2. wrong syntax

  3. wrong syntax

Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 2-13

Question No.298

Sales data of a company is stored in two tables, SALES1 and SALES2, with some data being duplicated across the tables. You want to display the results the results from the SALES1 table, which are not present in the SALES2 table.

image

Which set operator generates the required output?

  1. UNION

  2. INTERSECT

  3. PLUS

  4. MINUS

  5. SUBSTRACT

Correct Answer: D

Question No.299

Which describes the default behavior when you create a table?

  1. The table is accessible to all users.

  2. Tables are created in the public schema.

  3. Tables are created in your schema.

  4. Tables are created in the DBA schema.

  5. You must specify the schema when the table is created.

Correct Answer: C

Explanation:

Sorted by highest to lowest is DESCENDING order Incorrect answer:

  1. grant the table privilege to PUBLIC

  2. login as sysoper

  1. login as DBA or sysdba

  2. no such option is allow.

Refer: Introduction to Oracle9i: SQL, Oracle University Study Guide, 9-9

Question No.300

Examine the structure of the PRODUCTS table:

image

You want to change the definition of the PRODUCTS table. The PROD_DETAILS column must be changed to allow 4000 characters. Which statement is valid?

  1. ALTER TABLE productsMODIFY (prod_details CHAR2 (4000));

  2. ALTER TABLE productsMODIFY COLUMN (prod_details CHAR (4000));

  3. ALTER TABLE productsCHANGE (prod_details VARCHAR2 (4000));

  4. ALTER TABLE productsMODIFY (prod_details VARCHAR2 (4000));

Correct Answer: B

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