Oracle - Synonyms Privileges Passwords and Roles MCQ

Oracle – Synonyms Privileges Passwords and Roles

1 / 25

1. What is the primary purpose of an Oracle synonym?

Data compression

Secure password storage

Alias for database users

Data encryption

2 / 25

2. Which Oracle privilege is required for connecting to the database?

CREATE

CONNECT

INSERT

SELECT

3 / 25

3. What does the GRANT command do in Oracle?

Revoke privileges from a user

Delete a table

Create a new user

Assign privileges to a user

4 / 25

4. Which Oracle privilege allows a user to modify data in a table?

SELECT

UPDATE

CREATE

INSERT

5 / 25

5. What is the purpose of the CREATE USER command in Oracle?

Create a new role

Create a new table

Create a new schema

Create a new synonym

6 / 25

6. In Oracle, what is a role?

A collection of privileges

A database user

A type of data encryption

A synonym for a table

7 / 25

7. What is the purpose of the PASSWORD command in Oracle?

Create a new user

Grant privileges to a role

Change a user's password

Delete a table

8 / 25

8. Which Oracle privilege allows a user to delete rows from a table?

DELETE

CREATE

EXECUTE

SELECT

9 / 25

9. In Oracle, how can you grant a role to a user?

Using the REVOKE command

Using the CREATE ROLE command

Using the DROP ROLE command

Using the GRANT command

10 / 25

10. What is the purpose of the CONNECT role in Oracle?

Allow a user to connect to the database

Create a new user

Delete a table

Grant all privileges to a user

11 / 25

11. Which Oracle privilege is used to create new views in a schema?

UPDATE

DELETE

CREATE VIEW

SELECT

12 / 25

12. What is the primary use of the ALTER USER command in Oracle?

Delete a role

Create a new user

Grant privileges to a role

Modify user account settings

13 / 25

13. What is a synonym in Oracle?

A data type

A database user

A database backup

An alternative name for an object

14 / 25

14. Which statement is true about Oracle privileges?

Privileges control access to objects in the database

Privileges are assigned to users at birth

Privileges are only applicable to tables

Privileges are required for connecting to the database

15 / 25

15. In Oracle, what is the purpose of the DEFAULT ROLE clause when creating a user?

To create a new role

To assign a role as the user's default

To assign privileges to the user

To revoke all roles from the user

16 / 25

16. Which Oracle privilege allows a user to execute stored procedures and functions?

SELECT

EXECUTE

CREATE PROCEDURE

DELETE

17 / 25

17. What is the purpose of the CREATE ROLE command in Oracle?

Create a new table

Create a new user

Create a new synonym

Create a collection of privileges

18 / 25

18. Which Oracle privilege allows a user to create indexes on tables?

ALTER TABLE

DELETE

SELECT

CREATE INDEX

19 / 25

19. In Oracle, what is the purpose of the RESOURCE role?

To manage database backups

To grant DBA privileges

To control user connections

To provide basic privileges for schema objects

20 / 25

20. Which statement is true about Oracle roles?

Roles can be assigned to multiple users

Roles are always created by default

Roles are used for data encryption

Roles cannot be granted to other roles

21 / 25

21. What is the purpose of the PASSWORD EXPIRE option in Oracle?

Delete a user account

Grant privileges to a role

Force a user to change their password

Create a new schema

22 / 25

22. Which Oracle privilege allows a user to create synonyms in their schema?

ALTER TABLE

SELECT

CREATE SYNONYM

DELETE

23 / 25

23. In Oracle, what is the purpose of the DROP USER command?

Create a new table

Delete a user account

Create a new user

Grant privileges to a user

24 / 25

24. What is the purpose of the NOAUDIT statement in Oracle?

Grant privileges to a user

Revoke privileges from a user

Disable auditing for specified operations

Create a new schema

25 / 25

25. Which Oracle privilege allows a user to create triggers on tables?

ALTER TABLE

EXECUTE

CREATE TRIGGER

DELETE

Your score is

0%

Oracle – Synonyms Privileges Passwords and Roles MCQ