Download Oracle.1z0-071.PracticeTest.2019-04-08.119q.tqb
| Vendor: | Oracle |
| Exam Code: | 1z0-071 |
| Exam Name: | Oracle Datbase 12c SQL |
| Date: | Apr 08, 2019 |
| File Size: | 11 MB |
| Downloads: | 1 |
Demo Questions
Question 1
Which three statements are true regarding the WHERE and HAVING clauses in a SQL statement? (Choose three.)
- WHERE and HAVING clauses cannot be used together in a SQL statement.
- The HAVING clause conditions can have aggregate functions.
- The HAVING clause conditions can use aliases for the columns.
- The WHERE clause is used to exclude rows before the grouping of data.
- The HAVING clause is used to exclude one or more aggregated results after grouping data.
Correct answer: ABD
Question 2
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
Question 3
Which two statements are true regarding constraints? (Choose two)
- A constraint is enforced only for an INSERT operation on a table.
- A foreign key cannot contain NULL values.
- The column with a UNIQUE constraint can store NULLS.
- You can have more than one column in a table as part of a primary key.
Correct answer: CD
