1z0-071 Dumps & Test Certification 1z0-071 Cost - Christmas Offer
                     Oracle
1z0-071
https://www.realexamcollection.com/oracle/1z0-071-dumps.html
Practice Test Oracle - 1z0-071
Question #:1
View the Exhibit and examine the description for the SALES and CHANNELS tables.
You issued this SQL statement:
1 of 8
Practice Test Oracle - 1z0-071
Which statement is true regarding the result? (Choose the best answer.)
A.  The statement will fail because the subquery in the VALUES clause is not enclosed within single
quotation marks.
B.  The statement will fail because a subquery cannot be used in a VALUES clause.
C.  The statement will execute and a new row will be inserted in the SALES table.
D.  The statement will fail because the VALUES clause is not required with the subquery.
Answer: C
Question #:2
Examine this SQL statement:
Which two are true?
A.  The subquery is not a correlated subquery.
B.  The subquery is executed before the DELETE statement is executed.
C.  The DELETE statement executes successfully even if the subquery selects multiple rows.
D.  The subquery is executed for every row in the EMPLOYEES table.
E.  All existing rows in the EMPLOYEES table are deleted.
Answer: B D
Question #:3
Which two are true about granting privileges on objects?
2 of 8
Practice Test Oracle - 1z0-071
A.  An object privilege can be granted to other users only by the owner of that object.
B.  An object privilege can be granted to a role only by the owner of that object.
C.  A table owner must grant the REFERENCES privilege to allow other users to create FOREIGN KEY
constraints using that table.
D.  The owner of an object acquires all object privileges on that object by default.
E.  The WITH GRANT OPTION clause can be used only by DBA users.
Answer: C D
Explanation
References:
Question #:4
Examine the business rule:
Each student can work on multiple projects and each project can have multiple students.
You need to design an Entity Relationship Model (ERD) for optimal data storage and allow for generating
reports in this format:
STUDENT_ID FIRST_NAME LAST_NAME PROJECT_ID PROJECT_NAME PROJECT_TASK
Which two statements are true in this scenario? (Choose two.)
A.  The ERD must have a 1:M relationship between the STUDENTS and PROJECTS entities.
B.  The ERD must have a M:M relationship between the STUDENTS and PROJECTS entities that must be
resolved into 1:M relationships.
C.  STUDENT_ID must be the primary key in the STUDENTS entity and foreign key in the PROJECTS
entity.
D.  PROJECT_ID must be the primary key in the PROJECTS entity and foreign key in the STUDENTS
entity.
E.  An associative table must be created with a composite key of STUDENT_ID and PROJECT_ID, which
is the foreign key linked to the STUDENTS and PROJECTS entities.
Answer: B E
Explanation
References:
3 of 8
Practice Test Oracle - 1z0-071
http://www.oracle.com/technetwork/issue-archive/2011/11-nov/o61sql-512018.html
Question #:5
Which two statements are true about transactions in the Oracle Database server?
A.  If a session has an uncommitted transaction, then a DDL statement issues a COMMIT before starting a
new transaction.
B.  An uncommitted transaction commits automatically if the user exists SQL*Plus.
C.  Data Manipulation Language (DML) statements always start a new transaction.
D.  A user can always see uncommitted updates made by the same user in a different session.
E.  A Data Definition Language (DDL) statement does a COMMIT automatically only for the data
dictionary updates caused by the DDL.
F.  A session can always see uncommitted updates made by itself.
Answer: C F
Question #:6
In the customers table, the CUST_CITY column contains the value 'Paris' for the
CUST_FIRST_NAME 'Abigail'.
Evaluate the following query:
What would be the outcome?
A.  Abigail PA
B.  Abigail Pa
C.  Abigail IS
D.  An error message
Answer: B
4 of 8
Practice Test Oracle - 1z0-071
Question #:7
You issued this command:
SQL > DROP TABLE employees;
Which three statements are true? (Choose three.)
A.  Sequences used in the EMPLOYEES table become invalid.
B.  If there is an uncommitted transaction in the session, it is committed.
C.  All indexes and constraints defined on the table being dropped are also dropped.
D.  The space used by the EMPLOYEES table is always reclaimed immediately.
E.  The EMPLOYEES table can be recovered using the ROLLBACK command.
F.  The EMPLOYEES table may be moved to the recycle bin.
Answer: B C F
Question #:8
View the exhibit and examine the data in the PROJ_TASK_DETAILS table.
The PROJ_TASK_DETAILS table stores information about project tasks and the relation between them.
The BASED_ON column indicates dependencies between tasks.
Some tasks do not depend on the completion of other tasks.
You must generate a report listing all task IDs, the task ID of any task upon which it depends and the name of
5 of 8
Practice Test Oracle - 1z0-071
the employee in charge of the task upon which it depends.
Which query would give the required result? (Choose the best answer.)
A.  SELECT p.task_id, p.based_on, d.task_in_chargeFROM proj_task_details p JOIN proj_task_details
dON (p.task_id = d.task_id);
B.  SELECT p.task_id, p.based_on, d.task_in_chargeFROM proj_task_details p FULL OUTER JOIN
proj_task_details dON (p.based_on = d.task_id);
C.  SELECT p.task_id, p.based_on, d.task_in_chargeFROM proj_task_details p JOIN proj_task_details
dON (p.based_on = d.task_id);
D.  SELECT p.task_id, p.based_on, d.task_in_chargeFROM proj_task_details p LEFT OUTER JOIN
proj_task_details dON (p.based_on = d.task_id);
Answer: D
Question #:9
Examine the data in the CUST_NAME column of the CUSTOMERS table:
You want to display the CUST_NAME values where the last name starts with Mc or MC.
Which two WHERE clauses give the required result?
A.  WHERE SUBSTR (cust_name, INSTR (cust_name, ‘’) +1) LIKE ‘Mc%’
B.  WHERE INITCAP (SUBSTR (cust_name, INSTR(cust_name, ‘’)+1)) IN (‘MC%’, ‘Mc%)
C.  WHERE UPPER (SUBSTR (cust_name, INSTR(cust_name, ‘’)+1)) LIKE UPPER (‘MC%’)
D.  WHERE SUBSTR (cust_name, INSTR (cust_name, ‘’) +1) LIKE ‘Mc%’ OR ‘MC%’
E.  WHERE INITCAP (SUBSTR (cust_name, INSTR(cust_name, ‘’)+1)) LIKE ‘Mc%’
Answer: A
6 of 8
Practice Test Oracle - 1z0-071
Question #:10
View the Exhibit and examine the details of the PRODUCT_INFORMATION table. (Choose two.)
Evaluate this SQL statement:
SELECT TO_CHAR(list_price,'$9,999')
7 of 8
Practice Test Oracle - 1z0-071
From product_information;
Which two statements are true regarding the output? (Choose two.)
A.  A row whose LIST_PRICE column contains value 11235.90 would be displayed as #######.
B.  A row whose LIST_PRICE column contains value 1123.90 would be displayed as $1,123.
C.  A row whose LIST_PRICE column contains value 1123.90 would be displayed as $1,124.
D.  A row whose LIST_PRICE column contains value 11235.90 would be displayed as $1,123.
Answer: A C
https://www.realexamcollection.com/oracle/1z0-071-dumps.html
8 of 8