Free Oracle Autonomous Database Cloud 2020 Specialist Exam 1Z0-931-20 Exam Practice Test

Which management operation is correct about Autonomous Databases on shared Exadata infrastructure?

• You can skip a scheduled maintenance run. For Autonomous Databases on shared Exadata infrastructure, you can skip maintenance runs for up to two consecutive quarters if needed.
• You can choose to use Release Update (RU) or Release Update Revision (RUR) updates for your about Autonomous Databases on shared Exadata infrastructure.
• You cannot configure the scheduling for your Autonomous Databases on shared Exadata infrastructure.
• You can perform a 'rolling restart' on all the Autonomous Databases. During a rolling restart, each node of an Autonomous Database is restarted separately while the remaining nodes continue to be available.

You are the admin user of an Autonomous Database (ADB) instance. A new business analyst has joined the team and would like to explore ADB tables using SQL Developer Web.What steps do you need to take?

• Create a database user (with connect, resource, object privileges), enable the schema to use SQL Developer and provide the user with the user-specific modified URL.
• Create a database user with the default privileges.
• Create a database user with connect, resource, and object privileges.
• Create an IDCS user. Create a database user with connect, resource, and object privileges.

What command should you issue to enable application continuity on Autonomous Database Shared Infrastructure?

• alter database set application_continuity=true
• alter session set application_continuity=true
• exec dbms_cloucl_admin. enable_app_cont ( ' <service_name> ' ) ;
• alter system set application_continuity=true

When enabling auto-scaling, which three options do not change?

• Number of OCPUs displayed in the console.
• Amount of storage
• I/O resources
• parallelism settings
• Level of concurrency

Which three event types are supported for Autonomous Database?

• Terminate End
• Maintenance Begin
• Change Compartment Begin
• Change Autoscaling Configuration Compartment
• Update IORM Begin

What is the default port number for accessing a newly created Autonomous Database?

• 1524
• 1522
• 1521
• 1523
• 1526

An Autonomous Database (ADB) user with an instance wallet has left the company and they shared a database user id with other users when accessing ADB.Other than changing the shared user password, what can the admin do to protect the instance?

• Trust the user who left to not access the database.
• Shutdown and restart the instance.
• Rotate the instance wallet and share the new wallet with the remaining users.
• Delete the user.

What is the correct way to list all files in the default data pump directory?

• By executing select * from DBMS_CLOUD.LIST_FILES('DATA_PUMP_DIR');
• You cannot list files in the default data pump directory from Autonomous Data Warehouse (ADW).
• Log onto ADW server and issue is -al on the command line.
• By executing select * from utl_file . list ( 'DATA_PUMP_DIR ' ) ;

Which statement is true when you provision an Autonomous Database using the cloning method?

• After an Autonomous database is created using a clone, the network access option can be changed.
• A clone database source can be a running database instance.
• A clone database source can be from a point-in-time backup that is less than 2 hours old.
• When cloning an Autonomous Database, Oracle Machine Learning workspaces, projects, and notebooks of the source database are cloned to the new database.

Which statement is FALSE about Autonomous Database Maintenance on dedicated Exadata infrastructure?

• If a scheduled container database maintenance run cannot take place, Oracle will automatically reschedule the container database maintenance for the following quarter.
• Autonomous Exadata Infrastructure maintenance takes place at least once each quarter and is mandatory.
• You can change your container database maintenance window or reschedule a single container database maintenance run to ensure that your container database maintenance runs follow infrastructure maintenance within the same quarter.
• Autonomous Exadata Infrastructure maintenance runs are for infrastructure patching (including patching of the Exadata grid infrastructure code and operating systems updates), and include database patching.