1Z0-061 Free Practice Test

- (Topic 4)
View the Exhibit and examine the structure and data in the INVOICE table.
<>

1. A. inv_amt =\'0255982’: requires explicit conversion
2. B. inv_date > \'01-02-2008’: uses implicit conversion
3. C. CONCAT (inv_amt, inv_date): requires explicit conversion
4. D. inv_date = \'15-february-2008’: uses implicit conversion
5. E. inv_no BETWEEN \'101\' AND \'110’: uses implicit conversion

Correct Answer: DE
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.

- (Topic 2)
Examine the structure of the EMPLOYEES table:
< ><>>< ><>

1. A. INSERT INTO employees VALUES (emp_id_seq.NEXTVAL, \'&ename\', \'&jobid\', 2000, NULL, &did);
2. B. INSERT INTO employees VALUES (emp_id_seq.NEXTVAL, \'&ename\', \'&jobid\', 2000, NULL, &did IN (20, 50));
3. C. INSERT INTO (SELECT * FROM employees WHERE department_id IN (20, 50)) VALUES (emp_id_seq.NEXTVAL, \'&ename\', \'&jobid\', 2000, NULL, &did);
4. D. INSERT INTO (SELECT * FROM employees WHERE department_id IN (20, 50) WITH CHECK OPTION)VALUES (emp_id_seq.NEXTVAL, \'&ename\', \'&jobid\', 2000, NULL, &did);
5. E. INSERT INTO (SELECT * FROM employees WHERE (department_id = 20 AND department_id = 50) WITH CHECK OPTION ) VALUES (emp_id_seq.NEXTVAL, \'&ename\', \'&jobid\', 2000, NULL, &did);

Correct Answer: D

- (Topic 1)
View the Exhibits and examine the structures of the products, sales, and customers tables.
< ><>< ><>< ><>>>< >

1. A. Option A
2. B. Option B
3. C. Option C
4. D. Option D

Correct Answer: AC

- (Topic 2)
Here is the structure and data of the CUST_TRANS table: Exhibit:
<>

1. A. SELECT transdate + \'10\' FROM cust_trans;
2. B. SELECT * FROM cust_trans WHERE transdate = \'01-01-07\';
3. C. SELECT transamt FROM cust_trans WHERE custno > \'11\';
4. D. SELECT * FROM cust_trans WHERE transdate=\'01-JANUARY-07\';
5. E. SELECT custno + \'A\' FROM cust_trans WHERE transamt > 2000;

Correct Answer: ACD

- (Topic 1)
You need to generate a list of all customer last names with their credit limits from the customers table.
Those customers who do not have a credit limit should appear last in the list. Which two queries would achieve the required result? (Choose two.)

1. A. Option A
2. B. Option B
3. C. Option C
4. D. Option D

Correct Answer: BC
If the ORDER BY clause is not used, the sort order is undefined, and the Oracle server may not fetch rows in the same order for the same query twice. Use the ORDER BY clause
to display the rows in a specific order.
Note: Use the keywords NULLS FIRST or NULLS LAST to specify whether returned rows containing null values should appear first or last in the ordering sequence. ANSWER C Sorting
The default sort order is ascending:
• Numeric values are displayed with the lowest values first (for example, 1 to 999).
• Date values are displayed with the earliest value first (for example, 01-JAN-92 before 01- JAN-95).
• Character values are displayed in the alphabetical order (for example, “A” first and “Z” last).
• Null values are displayed last for ascending sequences and first for descending sequences.
- ANSWER B
• You can also sort by a column that is not in the SELECT list.