Free Oracle 1z1-061 Exam Dumps Questions & Answers

See the Exhibit and examine the structure of ORD table:
Exhibit:

Evaluate the following SQL statements that are executed in a user session in the specified order:
CREATE SEQUENCE ord_seq;
SELECT ord_seq.nextval
FROM dual;
INSERT INTO ord
VALUES (ord_seq.CURRVAL, '25-jan-2007, 101);
UPDATE ord
SET ord_no= ord_seq.NEXTVAL
WHERE cust_id =101;
What would be the outcome of the above statements?

• A.  All the statements would execute successfully and the ORD_NO column would have the value 20 for the CUST_ID 101 because the default CACHE value is 20.
• B.  The CREATE SEQUENCE command would not execute because the starting value of the sequence and the increment value have not been specified.
• C.  The CREATE SEQUENCE command would not execute because the minimum value and maximum value for the sequence have not been specified.
• D.  All the statements would execute successfully and the ORD_NO column would contain the value 2 for the CUST_ID 101.

You have created an index with this statement:
create index ename_i on employees(last_name,first_name);
How can you adjust the index to include the employees' birthdays, which is a date type column called DOB?

• A.  This can only be done if the column DOB is NULL in all existing rows.
• B.  You must drop the index and re-create it.
• C.  You can't do this because of the data type mismatch.
• D.  Use ALTER INDEX ENAME_I ADD COLUMN DOB;.

The customers table has the following structure:

You need to write a query that does the following tasks:
1. Display the first name and tax amount of the customers. Tax is 5% of their credit limit.
2. Only those customers whose income level has a value should be considered.
3. Customers whose tax amount is null should not be considered.
Which statement accomplishes all the required tasks?

• A.  Option C
• B.  Option D
• C.  Option B
• D.  Option A

View the Exhibit and examine the structure of CUSTOMERS table.

Evaluate the following query:

Which statement is true regarding the above query?

• A.  It produces an error because conditions on the CUST_CREDIT_LIMIT column are not valid.
• B.  It executes successfully.
• C.  It produces an error because the condition on the CUST_FIRST_NAME column is not valid.
• D.  It produces an error because the condition on the CUST_CITY column is not valid.

Which is an iSQL*Plus command?

• A.  UPDATE
• B.  DESCRIBE
• C.  INSERT
• D.  RENAME
• E.  SELECT
• F.  DELETE