Podcast
Questions and Answers
What is the purpose of the SYS user in Oracle?
What is the purpose of the SYS user in Oracle?
- Create user accounts and manage user privileges
- Execute SQL commands and manipulate database objects
- Perform all administrative functions and store base tables and views for the database data dictionary (correct)
- Manage client connections and SQLPLUS environment
Which privilege is granted to the SYS user in Oracle?
Which privilege is granted to the SYS user in Oracle?
- CREATE SESSION
- SELECT ANY TABLE
- CREATE TABLE
- SYSDBA (correct)
What is the role of the SYSTEM user in Oracle?
What is the role of the SYSTEM user in Oracle?
- Manage user roles and privileges
- Execute SQL commands and manage database objects
- Connect to SQLPLUS and create new users
- Perform administrative tasks such as shutdown server, backup, recovery, create any user, and drop any table (correct)
What are the base tables and views in the SYS schema used for?
What are the base tables and views in the SYS schema used for?
What caution is given regarding tables in the SYS schema?
What caution is given regarding tables in the SYS schema?