File Info
| Exam | Oracle Datbase 12c SQL |
| Number | 1z0-071 |
| File Name | Oracle.1z0-071.PracticeTest.2019-02-22.115q.tqb |
| Size | 11 MB |
| Posted | Feb 22, 2019 |
| Download | Oracle.1z0-071.PracticeTest.2019-02-22.115q.tqb |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
Demo Questions
Question 1
Which statement is true regarding external tables?
- The CREATE TABLE AS SELECT statement can be used to upload data into a normal table in the database from an external table.
- The data and metadata for an external table are stored outside the database.
- The default REJECT LIMIT for external tables is UNLIMITED.
- ORACLE_LOADER and ORACLE_DATAPUMP have exactly the same functionality when used with an external table.
Correct answer: A
Explanation:
References:https://docs.oracle.com/cd/B28359_01/server.111/b28310/tables013.htm References:
https://docs.oracle.com/cd/B28359_01/server.111/b28310/tables013.htm
Question 2
Which two statements are true about Data Manipulation Language (DML) statements?
- An INSERT INTO...VALUES.. statement can add multiple rows per execution to a table.
- An UPDATE... SET... statement can modify multiple rows based on multiple conditions on a table.
- A DELETE FROM..... statement can remove rows based on only a single condition on a table.
- An INSERT INTO... VALUES..... statement can add a single row based on multiple conditions on a table.
- A DELETE FROM..... statement can remove multiple rows based on multiple conditions on a table.
- An UPDATE....SET.... statement can modify multiple rows based on only a single condition on a table.
Correct answer: BE
Explanation:
References:http://www.techonthenet.com/sql/and_or.php References:
http://www.techonthenet.com/sql/and_or.php
Question 3
Which two statements are true regarding roles? (Choose two.)
- A role can be granted to itself.
- A role can be granted to PUBLIC.
- A user can be granted only one role at any point of time.
- The REVOKE command can be used to remove privileges but not roles from other users.
- Roles are named groups of related privileges that can be granted to users or other roles.
Correct answer: BE
Explanation:
References:http://docs.oracle.com/cd/E25054_01/network.1111/e16543/authorization.htm#autoId28 References:
http://docs.oracle.com/cd/E25054_01/network.1111/e16543/authorization.htm#autoId28
