Oracle Database 19c: Administration Workshop Quiz Questions and Answers

What is the purpose of the SQL Tuning Advisor?

Answer :
  • To identify and resolve performance issues

Which statement can be used to modify a profile in Oracle Database 19c?

Answer :
  • ALTER PROFILE

What is the difference between a network mode export and a local mode export in Oracle Data Pump?

Answer :
  • A network mode export is used for exporting data over a network, while a local mode export is used for exporting data on the local machine.

Which Oracle Database 19c feature allows you to perform database upgrades?

Answer :
  • Database Upgrade Assistant (DBU

What is the purpose of the resource plan directive in Oracle Database 19c?

Answer :
  • To allocate resources to maintenance tasks during each window

Which of the following statements is true about the GRANT command in Oracle Database 19c?

Answer :
  • It is used to grant privileges to users or roles in the database.

What is the purpose of the CREATE ROLE command in Oracle Database 19c?

Answer :
  • To create a new role in the database.

Which of the following statements is true about the ALTER PROFILE command in Oracle Database 19c?

Answer :
  • It is used to modify an existing user account in the database.

What is the purpose of the DROP USER command in Oracle Database 19c?

Answer :
  • To delete a user account from the database.

What is the purpose of the CREATE USER statement in Oracle Database 19c?

Answer :
  • It is used to create a new user account in the database.