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

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

Question No.261

The CUSTOMERS table has these columns:

image

A promotional sale is being advertised to the customers in France. Which WHERE clause identifies customers that are located in France?

  1. WHERE lower(country_address) = quot;francequot;

  2. WHERE lower(country_address) = #39;france#39;

  3. WHERE lower(country_address) IS #39;france#39;

  4. WHERE lower(country_address) = #39;%france%#39;

  5. WHERE lower(country_address) LIKE %france%

Correct Answer: B

Explanation:

WHERE lower(country_address)=#39;france#39;

Incorrect answer:

A. invalid use of symbol quot;quot;

  1. invalid use of IS keyword

  2. invalid use of % in condition

  3. invalid use of condition

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

Question No.262

Examine the structure of the DEPARTMENTS table:

image

You execute the following command: SQLgt; ALTER TABLE departments SET UNUSED (country);

Which two statements are true? (Choose two.)

  1. Synonyms existing om the DEPARTMENTS table would have to be re-created.

  2. Unique key constraints defined on the COUNTRY column are removed.

  3. Views created on the DEPARTMENTS table that include the COUNTRY column are automatically modified and remain valid.

  4. Indexes created on the COUNTRY column exist until the DROP UNUSED COLUMNS command is executed.

  5. A new column, COUNTRY, can be added to the DEPARTMENTS table after executing the command.

Correct Answer: CE

Question No.263

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

You want to generate a report showing the last names and credit limits of all customers whose last names start with A, B, or C, and credit limit is below 10, 000.

Evaluate the following two queries:

image

Which statement is true regarding the execution of the above queries?

image

  1. Only the first query gives the correct result.

  2. Only the second query gives the correct result.

  3. Both execute successfully and give the same result.

  4. Both execute successfully but do not give the required result.

Correct Answer: A

Question No.264

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

  1. Savepoints are effective only for COMMIT.

  2. Savepoints may be used to ROLLBACK.

  3. Savepoints can be used for only DML statements.

  4. Savepoints are effective for both COMMIT and ROLLBACK.

  5. Savepoints can be used for both DML and DDL statements.

Correct Answer: BC

Question No.265

View the Exhibit and examine the structure and data in the INVOICE table.

image

Which two statements are true regarding data type conversion in expressions used in queries?

  1. inv_amt =#39;0255982#39;: requires explicit conversion

  2. inv_date gt; #39;01-02-2008#39;: uses implicit conversion

  3. CONCAT (inv_amt, inv_date): requires explicit conversion

  4. inv_date = #39;15-february-2008#39;: uses implicit conversion

  5. inv_no BETWEEN #39;101#39; AND #39;110#39;: uses implicit conversion

Correct Answer: DE

Explanation:

In some cases, the Oracle server receives data of one data type where it expects data of a different data type.

When this happens, the Oracle server can automatically convert the data to the expected data type. This data type conversion can be done implicitly by the Oracle server or explicitly by the user.

Explicit data type conversions are performed by using the conversion functions. Conversion functions convert a value from one data type to another. Generally, the form of the function names follows the convention data type TO data type. The first data type is the input data type and the second data type is the output.

Note: Although implicit data type conversion is available, it is recommended that you do the explicit data type conversion to ensure the reliability of your SQL statements.

Question No.266

View the Exhibits and examine the structures of the COSTS and PROMOTIONS tables.

image

Evaluate the following SQL statement:

image

What would be the outcome of the above SQL statement?

  1. It displays prod IDs in the promo with the lowest cost.

  2. It displays prod IDs in the promos with the lowest cost in the same time interval.

  3. It displays prod IDs in the promos with the highest cost in the same time interval.

  4. It displays prod IDs in the promos with cost less than the highest cost in the same time interval.

Correct Answer: D

Question No.267

Examine the data in the ORD_ITEMS table: ORD_NO ITEM_NO QTY

1 111 10

1 222 20

1 333 30

2 333 30

2 444 40

3 111 40

Evaluate the following query: SQLgt;SELECT item_no, AVG(qty) FROM ord_items

HAVING AVG(qty) gt; MIN(qty) * 2

GROUP BY item_no;

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

  1. It gives an error because the HAVING clause should be specified after the GROUP BY clause.

  2. It gives an error because all the aggregate functions used in the HAVING clause must be specified in the SELECT list.

  3. It displays the item nos with their average quantity where the average quantity is more than double the minimum quantity of that item in the table.

  4. It displays the item nos with their average quantity where the average quantity is more than double the overall minimum quantity of all the items in the table.

Correct Answer: C

Question No.268

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

  1. A foreign key cannot contain NULL values.

  2. The column with a UNIQUE constraint can store NULLS.

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

  4. You can have more than one column in a table as part of a primary key.

Correct Answer: BD

Question No.269

The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER(12)

SEMESTER_END DATE GPA NUMBER(4, 3)

Which statement finds the highest grade point average (GPA) per semester?

  1. SELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL;

  2. SELECT (gpa) FROM student_grades GROUP BY semester_end WHERE gpa IS NOT NULL;

  3. SELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL GROUP BY semester_end;

  4. SELECT MAX(gpa) GROUP BY semester_end WHERE gpa IS NOT NULL FROM student_grades;

  5. SELECT MAX(gpa) FROM student_grades GROUP BY semester_end WHERE gpa IS NOT NULL;

Correct Answer: C

Explanation:

For highest gpa value MAX function is needed, for result with per semester GROUP BY clause is needed

Incorrect answer:

  1. per semester condition is not included

  2. result would not display the highest gpa value

  1. invalid syntax error

  2. invalid syntax error

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

Question No.270

What is the primary difference between the relational database (RDB) and object-oriented database (OODB) models?

  1. OODB supports multiple objects in the same database, whereas RDB supports only tables.

  2. RDB supports E.F. Codd鈥檚 rules, whereas OODB does not support them.

  3. OODB incorporates methods with data structure definition, whereas RDB does not allow this.

  4. RDB allows the definition of relationships between different tables, whereas OODB does not allow this.

Correct Answer: C

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