1z1-061 by Oracle Actual Free Exam Questions And Answers

Question 1

The PRODUCTS table has these columns:
PRODUCT_ID NUMBER(4)
PRODUCT_NAME VARCHAR2(45)
PRICE NUMBER(8, 2)
Evaluate this SQL statement:
SELECT *
FROM PRODUCTS
ORDER BY price, product_name;
What is true about the SQL statement?

A. The results are sorted numerically.

B. The results are sorted numerically and then alphabetically.

C. The results are not sorted.

D. The results are sorted alphabetically.

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 2

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. Use ALTER INDEX ENAME_I ADD COLUMN DOB;.

B. This can only be done if the column DOB is NULL in all existing rows.

C. You can't do this because of the data type mismatch.

D. You must drop the index and re-create it.

Discussion 0

Correct Answer: D Vote an answer

Question 3

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

Which two tasks would require subqueries or joins to be executed in a single statement?
(Choose two.)

A. listing of customers who do not have a credit limit and were born before 1980

B. finding the number of customers, in each city, whose credit limit is more than the average credit limit of all the customers

C. finding the number of customers, in each city, whose marital status is 'married'

D. listing of those customers whose credit limit is the same as the credit limit of customers residing in the city 'Tokyo'

E. finding the average credit limit of male customers residing in 'Tokyo' or 'Sydney'

Discussion 0

Correct Answer: B,D Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 4

See the Exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS and ITEMS tables:

The PROD_ID column is the foreign key in the SALES table, which references the PRODUCTS table.
Similarly, the CUST_ID and TIME_ID columns are also foreign keys in the SALES table referencing the CUSTOMERS and TIMES tables, respectively.
Evaluate the following the CREATE TABLE command:
Exhibit:

Which statement is true regarding the above command?

A. The NEW_SALES table would get created and all the FOREIGN KEY constraints defined on the specified columns would be passed to the new table

B. The NEW_SALES table would not get created because the column names in the CREATE TABLE command and the SELECT clause do not match

C. The NEW_SALES table would not get created because the DEFAULT value cannot be specified in the column definition

D. The NEW_SALES table would get created and all the NOT NULL constraints defined on the specified columns would be passed to the new table

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 5

You want to create a table employees in which the values of columns EMPLOYEES_ID and LOGIN_ID must be unique and not null. Which two SQL statements would create the required table?

A. Option B

B. Option F

C. Option A

D. Option D

E. Option C

F. Option E

Discussion 0

Correct Answer: B,C Vote an answer

Question 6

This statement will fail:
create unique bitmap index on employees(department_id,hire_date);
Why?

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

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

C. The two columns are of different data types.

D. Bitmap indexes cannot be unique.

Discussion 0

Correct Answer: D Vote an answer

Question 7

You own a table called EMPLOYEES with this table structure:
EMPLOYEE_ID NUMBER Primary Key
FIRST_NAME VARCHAR2(25)
LAST_NAME VARCHAR2(25)
HIRE_DATE DATE
What happens when you execute this DELETE statement?
DELETE employees;

A. You get an error because of a primary key violation.

B. The data and structure of the EMPLOYEES table are deleted.

C. The data in the EMPLOYEES table is deleted but not the structure.

D. You get an error because the statement is not syntactically correct.

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 8

You issue the following command to drop the products table:
SQL> DROP TABLE products;
Which three statements are true about the implication of this command? (Choose three.)

A. All data along with the table structure is deleted.

B. A pending transaction in the session is committed.

C. All data in the table is deleted but the table structure remains.

D. All indexes on the table remain but they are invalidated.

E. All views and synonyms remain but they are invalidated.

Discussion 0

Correct Answer: A,B,E Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 9

Examine the structure of the INVOICE table:
Exhibit:

Which two SQL statements would execute successfully? (Choose two.)

A. SELECT inv_no, NVL2(inv_date, 'Pending', 'Incomplete')FROM invoice;

B. SELECT inv_no, NVL2(inv_date, sysdate-inv_date, sysdate)FROM invoice;

C. SELECT inv_no, NVL2(inv_amt, inv_date, 'Not Available')FROM invoice;

D. SELECT inv_no, NVL2(inv_amt, inv_amt*.25, 'Not Available')FROM invoice;

Discussion 0

Correct Answer: A,B Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 10

Examine the structure and data in the PRIC E_LIST table: Name Null? Type
------------ ------------- -------------------
PROD_D NOT NULL NUMBER(3)
PROD_PRICE VARCHAR2(10)
PROD_ID PROD PRICE
----------- ------------------------
100 $234.55
101 $6, 509.75
102 $1, 234
in the same format as the PROD_PRICE. Which SQL statement would give the required result?

A. SELECT TO_NUMBER(TO_NUMBER(prod_price., $99.999.99')* .25/$99.999.00') FROM PRICE_LIST:

B. . SELECT TO_CHAR(TO_NUMBER(prod_price)* .25.'$99.999.00') FROM PRICE_LIST;

C. SELECT TO_CRAR(TO_NUMBER(prod_price.'S99.999.99')* .25.'$99.999.00') FROM PRICE_LIST:

D. SELECT TO_CHAR(prod_price* .25.'$99.999.99') FROM PRICEJLIST:

Discussion 0

Correct Answer: C Vote an answer

Question 11

You are the DBA for an academic database. You need to create a role that allows a group of users to modify existing rows in the STUDENT_GRADES table.
Which set of statements accomplishes this?

A. CREATE NEW ROLE registrar; GRANT ALL ON student_grades TO registrar; GRANT registrar to user1, user2, user3

B. CREATE ROLE registrar; GRANT MODIFY ON student_grades TO registrar; GRANT registrar to user1, user2, user3

C. CREATE registrar; GRANT CHANGE ON student_grades TO registrar; GRANT registrar;

D. CREATE ROLE registrar; GRANT UPDATE ON student_grades TO registrar; GRANT registrar to user1, user2, user3;

E. CREATE ROLE registrar; GRANT UPDATE ON student_grades TO registrar; GRANT ROLE registrar to user1, user2, user3

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 12

You want to display 5 percent of the rows from the sales table for products with the lowest AMOUNT_SOLD and also want to include the rows that have the same AMOUNT_SOLD even if this causes the output to exceed 5 percent of the rows.
Which query will provide the required result?

A. Option B

B. Option A

C. Option D

D. Option C

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 13

Evaluate the following SQL statements:
Exhibit:

Exhibit:

The above command fails when executed. What could be the reason?

A. The BETWEEN clause cannot be used for the CHECK constraint

B. The CHECK constraint cannot be placed on columns having the DATE data type

C. ORD_NO and ITEM_NO cannot be used as a composite primary key because ORD_NO is also the FOREIGN KEY

D. SYSDATE cannot be used with the CHECK constraint

Discussion 0

Correct Answer: D Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 14

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

Examine the following two SQL statements:

Which statement is true regarding the above two SQL statements?

A. statement 2 gives an error, statement 1 executes successfully

B. statement 1 and statement 2 execute successfully and give the same output

C. statement 1 and statement 2 execute successfully and give a different output

D. statement 1 gives an error, statement 2 executes successfully

Discussion 0

Correct Answer: C Vote an answer

Question 15

Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables:

Which MERGE statement is valid?

A. MERGE new_employees c FROM employees e ON (c.employee_id = e.employee_id) WHEN MATCHED THEN UPDATE SET name = e.first_name ||', '|| e.last_name WHEN NOT MATCHED THEN INSERT INTO new_employees valueS(e.employee_id, e.first_name ||', '||e.last_name);

B. MERGE INTO new_employees c USING employees e ON (c.employee_id
e.employee_id) WHEN MATCHED THEN UPDATE SET name = e.first_name ||', '|| e.last_name WHEN NOT MATCHED THEN INSERT value S(e.employee_id, e.first_name
||', '||e.last_name);

C. MERGE new_employees c USING employees e ON (c.employee_id = e.employee_id) WHEN EXISTS THEN UPDATE SET name = e.first_name ||', '|| e.last_name WHEN NOT MATCHED THEN INSERT valueS(e.employee_id, e.first_name ||', '||e.last_name);

D. name = e.first_name ||', '|| e.last_name WHEN NOT MATCHED THEN INSERT value S(e.employee_id, e.first_name ||', '||e.last_name);

E. MERGE INTO new_employees cUSING employees e ON (c.employee_id
e.employee_id) WHEN EXISTS THEN UPDATE SET

Discussion 0

Correct Answer: B Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Oracle Database 12c: SQL Fundamentals - 1z1-061 Exam Practice Test

Contact Us

Useful Links

Latest Updated