Free Oracle 1z0-071 Practice Test & Real Exam Questions
Which two are SQL features? (Choose two.)
Correct Answer: C,D
Vote an answer
Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).
Which two are true about the WITH GRANT OPTION clause? (Choose two.)
Correct Answer: E,F
Vote an answer
Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).
Evaluate the following query
What is the correct output of the above query?
What is the correct output of the above query?
Correct Answer: C
Vote an answer
Which two statements are true regarding savepoints? (Choose two.)
Correct Answer: D,E
Vote an answer
Which two statements are true regarding views? (Choose two.)
Correct Answer: D,E
Vote an answer
Examine the description of the EMP_DETAILS table given below:
Which two statements are true regarding SQL statements that can be executed on the EMP_DETAIL TABLE?
Which two statements are true regarding SQL statements that can be executed on the EMP_DETAIL TABLE?
Correct Answer: C,D
Vote an answer
Examine the description of the EMPLOYEES table:
For each employee in department 90 you want to display:
1. their last name
2. the number of complete weeks they have been employed
The output must be sorted by the number of weeks, starting with the longest serving employee first.
Which statement will accomplish this?
For each employee in department 90 you want to display:
1. their last name
2. the number of complete weeks they have been employed
The output must be sorted by the number of weeks, starting with the longest serving employee first.
Which statement will accomplish this?
Correct Answer: B
Vote an answer
Which two statements execute successfully? (Choose two.)
Correct Answer: C,D
Vote an answer
Evaluate the following SQL statements that are issued in the given order:
CREATE TABLE emp
(emp_no NUMBER(2) CONSTRAINT emp_emp_no_pk PRIMARY KEY,
enameVARCHAR2(15),
salary NUMBER(8,2),
mgr_no NUMBER(2) CONSTRAINT emp_mgr_fk REFERENCES emp);
ALTER TABLE emp
DISABLE CONSTRAINT emp_emp_no_pk CASCADE;
ALTER TABLE emp
ENABLE CONSTRAINT emp_emp_no_pk;
What would be the status of the foreign key EMP_MGR_PK?
CREATE TABLE emp
(emp_no NUMBER(2) CONSTRAINT emp_emp_no_pk PRIMARY KEY,
enameVARCHAR2(15),
salary NUMBER(8,2),
mgr_no NUMBER(2) CONSTRAINT emp_mgr_fk REFERENCES emp);
ALTER TABLE emp
DISABLE CONSTRAINT emp_emp_no_pk CASCADE;
ALTER TABLE emp
ENABLE CONSTRAINT emp_emp_no_pk;
What would be the status of the foreign key EMP_MGR_PK?
Correct Answer: C
Vote an answer
Examine the data in the CUST_NAME column of the CUSTOMERS table.
CUST_NAME
----------------
Lex De Haan
Renske Ladwig
Jose Manuel Urman
Jason Mallin
You want to extract only those customer names that have three names and display the * symbol in place of the first name as follows:
CUST NAME
------------------
*** De Haan
**** Manuel Urman
Which two queries give the required output? (Choose two.)
CUST_NAME
----------------
Lex De Haan
Renske Ladwig
Jose Manuel Urman
Jason Mallin
You want to extract only those customer names that have three names and display the * symbol in place of the first name as follows:
CUST NAME
------------------
*** De Haan
**** Manuel Urman
Which two queries give the required output? (Choose two.)
Correct Answer: A,B
Vote an answer
Evaluate the following SQL statement:
SQL> SELECT cust_id, cust_last_name "Last Name"
FROM customers
WHERE country_id = 10
UNION
SELECT cust_id CUST_NO, cust_last_name
FROM customers
WHERE country_id = 30;
Which ORDER BY clause are valid for the above query? (Choose all that apply.)
SQL> SELECT cust_id, cust_last_name "Last Name"
FROM customers
WHERE country_id = 10
UNION
SELECT cust_id CUST_NO, cust_last_name
FROM customers
WHERE country_id = 30;
Which ORDER BY clause are valid for the above query? (Choose all that apply.)
Correct Answer: A,D,E
Vote an answer
Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).
On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command:
$> sqlldr hr/hr@pdb table=employees
Which two statements are true regarding the command?
$> sqlldr hr/hr@pdb table=employees
Which two statements are true regarding the command?
Correct Answer: B,C
Vote an answer
Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).
View the Exhibit and examine the structure of the CUSTOMERS and CUST_HISTORY tables.
The CUSTOMERS table contains the current location of all currently active customers.
The CUST_HISTORY table stores historical details relating to any changes in the location of all current as well as previous customers who are no longer active with the company.
You need to find those customers who have never changed their address.
Which SET operator would you use to get the required output?
The CUSTOMERS table contains the current location of all currently active customers.
The CUST_HISTORY table stores historical details relating to any changes in the location of all current as well as previous customers who are no longer active with the company.
You need to find those customers who have never changed their address.
Which SET operator would you use to get the required output?
Correct Answer: D
Vote an answer
Examine this statement:
Which two statements are true? (Choose two.)
Which two statements are true? (Choose two.)
Correct Answer: B,F
Vote an answer
