Oracle Autonomous Database Cloud 2024 Professional (1z0-931-24) Free Questions - Part 2
Question No : 16) Which is NOT needed to manage Oracle Autonomous Database with REST APIS?
A. User's OCID
B. Tenancy's OCID
C. Database ADMIN password
D. Fingerprint of the public key
Question No : 17) Which Autonomous Database Cloud service ignores hints in SQL Statements by default?
A. Autonomous Transaction Processing
B. Autonomous Data Warehouse
C. Neither service ignores hints by default
D. Both services ignore hints by default
Question No : 18) What is the correct way to list all files in the default data pump directory?
A. By executing select * from DBMS_CLOUD.LIST_FILES('DATA_PUMP_DIR');
B. You cannot list files in the default data pump directory from Autonomous Data Warehouse (ADW).
C. Log onto ADW server and issue is -al on the command line.
D. By executing select * from utl_file . list ( ‘DATA_PUMP_DIR ' ) ;
Question No : 19) During the provisioning of an Autonomous Database on Dedicated hardware, what does the Database Administrator need to select to determine where the Autonomous Database is created on the Dedicated infrastructure?
A. the name or OCID of the Exadata infrastructure which was assigned by the the Fleet Administrator
B. the Client Credentials wallet which is used to connect to the Autonomous Database
C. the 'High Availability Container Database' in which the Autonomous instance should run
D. the Compartment of the Dedicated infrastructure as each compartment only runs 1 Dedicated environment
E. the Listener endpoint where the Autonomous Database should register on
Question No : 20) Oracle Autonomous Database on Dedicated Infrastructure is composed of which Oracle Cloud resources?
A. Virtual Cloud Network, Compartments, Policies, and Autonomous Exadata infrastructure
B. Oracle Machine Learning Zeppelin Notebook, Autonomous Exadata infrastructure, Fleet Administrator, and Database Administrator
C. Autonomous Exadata infrastructure, Autonomous Backup, Autonomous Container Database, and Autonomous Database
D. Fleet Administrator, Database Administrator, Database User, and Autonomous Exadata infrastructure
Question No : 21) 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?
A. Trust the user who left to not access the database.
B. Shutdown and restart the instance.
C. Rotate the instance wallet and share the new wallet with the remaining users.
D. Delete the user.
Question No : 22) Which two cloud services are supported to import data pump files from using Dedicated Exadata Infrastructure? (Choose two.)
A. Oracle Cloud Infrastructure Object Storage
B. Google Cloud Storage
C. Amazon S3
D. Azure Blob Storage
E. Oracle Cloud Infrastructure Object Storage Classic
Question No : 23) Which stage of the indexing pipeline divides text into tokens?
A. SECTIONER
B. FILTER
C. Otokenizer
D. LEXER
Question No : 24) While creating an Autonomous Container Database on dedicated infrastructure through the Oracle Cloud Infrastructure (OCI) console, which patch type is offered to be applied during maintenance?
A. Release Update (RU)
B. Prior Release Update Revision (PRUR)
C. Prior Release Update (PRU)
D. Quarterly Bundle Patch (QBP)
Question No : 25) Which statement is FALSE about setting up compartment quotas?
A. Quotas set on a parent compartment override quotas set on child compartments.
B. Compartment quotas cannot be set on the root compartment.
C. Compartment quotas use policies that allow allocation of resources with a high level of flexibility.
D. You cannot manage quotas in a compartment, unless you belong to a group that has the correct permissions.
Question No : 26) Which can be Scaled Independently of the number of CPUs In an Autonomous Database?
A. Parallelism
B. Storage
C. Concurency
D. Memory
E. Sessions
Question No : 27) How can an Autonomous Database resource be provisioned without logging into the Oracle Cloud Infrastructure console?
A. It cannot be done.
B. Using Database Configuration Assistant (DBCA) on the database server.
C. Using the Oracle Cloud Infrastructure Command Line interface tool or REST API calls.
D. Connecting to the Cloud Infrastructure Command console via SSH wallet.
Question No : 28) What command should you issue to enable application continuity on Autonomous Database Shared Infrastructure?
A. alter database set application_continuity=true
B. alter session set application_continuity=true
C. exec dbms_cloucl_admin. enable_app_cont ( ' ' ) ;
D. alter system set application_continuity=true
Question No : 29) You are the admin of an Autonomous Database (ADB) instance, and a new developer has requested a new workspace in APEX. What statement describes the step to provide the developer a new workspace in APEX?
A. Create an IDCS user with the APEX role.
B. Access the APEX Administration Services and create the workspace for the developer.
C. Create a new developer account.
D. Create a database user with the APEX role.
Question No : 30) A Business Analyst joined in your organization and wanted to explore the database tools. Which statement provides access to data tools page for business analyst. When restoring/cloning the ADB, you must select a backup which is atleast___hours/minutes old.
A. 24 hrs
B. 2 hrs
C. 5 min
D. 1 day
1z0-931-24 Answers