Oracle - System Tables MCQ

Oracle – System Tables

1 / 25

1. Which Oracle system table stores information about database users and their privileges?

DBA_USERS

USER_INFO

SYSTEM_USERS

SYS_USERS

2 / 25

2. What is the primary purpose of the DBA_OBJECTS system table in Oracle?

To store user-defined functions and procedures.

To store user login information.

To track changes to system tables.

To store information about database objects, such as tables, views, and indexes.

3 / 25

3. Which Oracle system table contains information about the columns in database tables?

COLUMN_INFO

SYS_COLUMNS

DBA_COLUMNS

TABLE_COLUMNS

4 / 25

4. In Oracle, where can you find information about database constraints, such as primary keys and foreign keys?

SYS_CONSTRAINTS

DBA_CONSTRAINTS

TABLE_CONSTRAINTS

CONSTRAINT_INFO

5 / 25

5. Which Oracle system table stores information about database indexes?

DATABASE_INDEXES

INDEX_INFO

DBA_INDEXES

SYS_INDEXES

6 / 25

6. What is the primary purpose of the DBA_TABLES system table in Oracle?

To track changes to system tables.

To store user login information.

To store information about database tables, including their names and sizes.

To store user-defined functions and procedures.

7 / 25

7. In Oracle, where can you find information about database views, including their definitions?

SYS_VIEWS

DATABASE_VIEWS

VIEW_INFO

DBA_VIEWS

8 / 25

8. Which Oracle system table contains information about database triggers?

DBA_TRIGGERS

DATABASE_TRIGGERS

TRIGGER_INFO

SYS_TRIGGERS

9 / 25

9. What is the primary purpose of the DBA_ROLES system table in Oracle?

To store user-defined roles.

To store information about user roles and their privileges.

To store user login information.

To track changes to system tables.

10 / 25

10. In Oracle, where can you find information about the grants of privileges to users and roles?

DBA_TAB_PRIVS

SYS_PRIVS

PRIVILEGE_INFO

DATABASE_PRIVILEGES

11 / 25

11. Which Oracle system table stores information about database sequences?

DATABASE_SEQUENCES

DBA_SEQUENCES

SYS_SEQUENCES

SEQUENCE_INFO

12 / 25

12. What is the primary purpose of the DBA_DATA_FILES system table in Oracle?

To store information about data files associated with tablespaces.

To track changes to system tables.

To store user login information.

To store user-defined data files.

13 / 25

13. In Oracle, where can you find information about database tablespaces, including their names and sizes?

TABLESPACE_INFO

DBA_TABLESPACES

SYS_TABLESPACES

DATABASE_TABLESPACES

14 / 25

14. Which Oracle system table contains information about database profiles and their settings?

SYS_PROFILES

DATABASE_PROFILES

PROFILE_INFO

DBA_PROFILES

15 / 25

15. What is the primary purpose of the DBA_SYNONYMS system table in Oracle?

To store user login information.

To store information about database synonyms.

To store user-defined synonyms.

To track changes to system tables.

16 / 25

16. In Oracle, where can you find information about database links and their configurations?

DATABASE_LINKS

SYS_DB_LINKS

DB_LINK_INFO

DBA_DB_LINKS

17 / 25

17. Which Oracle system table stores information about database roles and their granted privileges?

ROLE_PRIVILEGE_INFO

SYS_ROLE_PRIVS

DBA_ROLE_PRIVS

DATABASE_ROLE_PRIVILEGES

18 / 25

18. What is the primary purpose of the DBA_AUDIT_TRAIL system table in Oracle?

To store information about database audits and audit trail records.

To track changes to system tables.

To store user-defined audit settings.

To store user login information.

19 / 25

19. In Oracle, where can you find information about database profiles and their assigned resources?

SYS_RESOURCE_LIMITS

DATABASE_RESOURCES

DBA_RESOURCE_LIMITS

RESOURCE_INFO

20 / 25

20. Which Oracle system table contains information about database system privileges granted to users and roles?

SYS_PRIVILEGE_INFO

DBA_SYS_PRIVS

DATABASE_SYS_PRIVILEGES

SYS_SYS_PRIVS

21 / 25

21. What is the primary purpose of the DBA_SEGMENTS system table in Oracle?

To store user login information.

To store information about database segments, such as tables, indexes, and partitions.

To store user-defined segments.

To track changes to system tables.

22 / 25

22. In Oracle, where can you find information about database profiles and their password settings?

DBA_PROFILES

DATABASE_PROFILE_PASSWORDS

PROFILE_PASSWORD_INFO

SYS_PROFILES

23 / 25

23. Which Oracle system table stores information about database materialized views?

DBA_MVIEWS

DATABASE_MVIEWS

SYS_MVIEWS

MVIEWS_INFO

24 / 25

24. What is the primary purpose of the DBA_TABLESPACES system table in Oracle?

To store user-defined tablespaces.

To store user login information.

To track changes to system tables.

To store information about database tablespaces, including their names and sizes.

25 / 25

25. In Oracle, where can you find information about database triggers and their event types?

SYS_TRIGGER_EVENTS

DBA_TRIGGER_EVENTS

DATABASE_TRIGGER_EVENTS

TRIGGER_EVENT_INFO

Your score is

0%

Oracle – System Tables MCQ