Download Oracle.1z0-071.PracticeTest.2019-02-22.115q.tqb
| Vendor: | Oracle |
| Exam Code: | 1z0-071 |
| Exam Name: | Oracle Datbase 12c SQL |
| Date: | Feb 22, 2019 |
| File Size: | 11 MB |
| Downloads: | 1 |
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
