Oracle__2. Oracle 1Z0-051 Exam - Privileges Flashcards

1
Q

What happens to transactions if a GRANT command is executed?

A

An implicit commit will be execute before the GRANT command.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

What happens to transactions if an ALTER VIEW is executed?

A

An implicit commit will be execute before the ALTER VIEW command.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What privileges does the user Scott have after this statement is executed? CREATE USER scott IDENTIFIED BY tiger

A

no privileges

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

What is the password for scott after this statement is executed? CREATE USER scott IDENTIFIED BY tiger

A

tiger

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What is allowed after this statement is executed? GRANT SELECT, INSERT, UPDATE ON student_grade TO manager WITH GRANT OPTIONS

A

The role/user manager can give select or insert or update privileges to the table student_grade to others

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Can only an owner change an object?

A

No. Permissions can be granted to others

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

What is the syntax for creating a Role?

A

CREATE ROLE rolename

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

What is the syntax for granting select and update on TABLEA for user USER1?

A

GRANT SELECT, UPDATE ON tablea TO user1

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

What is the syntax for creating user USER1 with password1?

A

CREATE USER User1 IDENTIFIED BY password1.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

What Command is the opposite of GRANT?

A

REVOKE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

What is the syntax to grant SELECT access to all users for Table1?

A

GRANT SELECT ON table1 TO PUBLIC

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

What privilege is needed for a user to delete records or truncate a table?

A

DELETE ANY TABLE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

What is the syntax to give the create table and create view to the manager role?

A

GRANT CREATE TABLE, CREATE VIEW TO manager

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

What does the WITH GRANT OPTION clause allow?

A

The grantee (user or role) can grant privileges to other users or role

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

What privileges is granted to a user/role to allow deletes and truncates on a table?

A

DELETE ANY TABLE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What 4 privileges can be granted on a view?

A

DELETEINSERTSELECTUPDATE

17
Q

What is a system privilege?

A

permission to create, delete or alter a database object

18
Q

What is the syntax for unlocking a user account name hr?

A

ALTER USER hr IDENTIFIED BY hrpassword ACCOUNT UNLOCK