Oracle Autonomous Database Certification Questions

Oracle Autonomous Database Certification Questions: In this article we will see some questions and answers about Oracle Autonomous Database Certification for Practices.

  1. Which are the things required for provisioning an ADB instance? (Choose three)

A- FRA Size
B- Database name
C- Workload type
D- Backup location
E- Number of tablespaces
F- Number of CPUs

Ans:- B,C,F

  1. What is the default port number for ATP?

A- 1525
B- 1521
C- 1527
D- 1522

Ans:- D

  1. How many CPU shares can be used by a SQL statement in a Low database service?

A- 4
B- 3
C- 2
D- 1

Ans:- D

  1. Which are the capabilities of Oracle Autonomous Database that can accelerate innovation? (Choose three)

A- Instant scaling of storage
B- Scaling of CPUs with very minimum downtime
C- Built-in AI and ML helps find patterns that could identify undiscovered anomalies
D- Provisions data warehouse in seconds

Ans:- A,C,D

  1. In which Oracle client credentials’ file (wallet file) can we find the port number?

A- ojdbc.properties
B- truststore.jks
C- sqlnet.ora
D- tnsnames.ora
E- listener.ora

Ans:- D

  1. Which statements are true about ADB? (Choose two)

A- Instant scaling available for CPUs only
B- Provisioning takes a long time
C- Reduces data management costs
D- Reduces the administration costs with complete automation of operations and tuning
E- Scaling for storage needs a restart

Ans:- C,D

  1. Which statements are true about OCI compartments? (Choose two)

A- Compartments are used to organize resources and make it easy to control access
B- An administrator can create more compartments in the root compartment
C- A user should create the root compartment before provisioning the instance
D- A user can have only one compartment

Ans:- A,B

  1. What is the number of concurrent queries supported by the medium database service with 16 OCPUs?

A- 3
B- 40
C- 32
D- 20

Ans:- D

  1. From which cloud services does DBMS_CLOUD provide support for loading data from files to tables in ADB? (Choose three)

A- Dell EMC Elastic Cloud Storage
B- Amazon AWS S3
C- OCI Object Storage Classic
D- OCI Object Storage
E- IBM Spectrum Storage

Ans:- B,C,D

  1. Which procedure can be used to load data directly into existing ADB tables?

A- DBMS_CLOUD.LIST_FILES
B- DBMS_CLOUD.CREATE_EXTERNAL_TABLE
C- DBMS_CLOUD.PUT_OBJECT
D- DBMS_CLOUD.COPY_DATA

Ans:- D

  1. Which user can create a new user in ADB?

A- SYSTEM
B- DBSNMP
C- ADMIN
D- SYS

Ans:- C

  1. Which dictionary views can be used to see the results of validate operations? (Choose two)

A- dba_workload_filters
B- dba_load_operations
C- dba_workload_sql_map
D- user_load_operations

Ans:- B,D

  1. From which cloud services can Oracle Data Pump import data from dump files to ADB? (Choose three)

A- AWS S3
B- OCI Object Storage Classic
C- OCI Object Storage
D- IBM Spectrum Storage
E- Dell EMC Elastic Cloud Storage
F- Azure Blob Storage

Ans:- A,B,C

  1. Which procedure can be used to move the Data Pump Import log file from ADB to Oracle Cloud Object Storage?

A- DBMS_CLOUD.PUT_OBJECT
B- DBMS_CLOUD.CREATE_EXTERNAL_TABLE
C- DBMS_CLOUD.COPY_DATA
D- DBMS_CLOUD.LIST_FILES

Ans:- A

  1. From where can you create Oracle Machine Learning users?

A- From the Admin Password tab from the Details tab
B- From the Administration tab in the Service Console
C- From the Activity tab in the Service tab
D- From the Overview tab in the Service Console

Ans:- B

  1. Which statements are true about built-in SQL Worksheet and Notebook? (Choose two)

A- Quickly start running queries with built-in web-based notebooks
B- Based on Apache Tomcat
C- Need to install client query tool for the PL/SQL
D- No need to install a client query tool

Ans:- A,D

  1. With which of the following does Oracle Machine Learning allow access to data in ADB?

A- Data Ingestion and Selection only
B- Data Ingestion and Selection, Data Viewing and Discovery, and Data Analysis
C- Data Ingestion and Selection and Data Viewing and Discovery
D- Data Viewing and Discovery and Data Ingestion and Selection

Ans:- B

  1. How many SQL statements can a paragraph contain?

A- 1
B- 5
C- 10
D- 2

Ans:- A

  1. Which statements are true about scaling on demand? (Choose two)

A- Independently scale compute or storage
B- Resizing occurs instantly, fully online
C- Compute and storage must be scaled together
D- Resizing needs a restart

Ans:- A,B

  1. Which statement is true about the automated management of ADB?

A- It includes scaling, backup and recovery, and patching
B- It includes provisioning new instances, scaling, patching, and backup and recovery
C- It includes provisioning new instances, scaling, and backup and recovery
D- It includes provisioning new instances, scaling, and patching

Ans:- B

  1. What is the retention period for backups in ADB?

A- 60 days
B- 45 days
C- 30 days
D- 7 days

Ans:- A

  1. What is the default retention period for performance data?

A- 7 days
B- 8 days
C- 15 days
D- 14 days

Ans:- B

  1. Which statements are true about the billing when you stop an ADB instance? (Choose two)

A- Billing for storage continues
B- Billing for CPU stops
C- Billing for both CPU and storage continues
D- Billing for both CPU and storage stops

Ans:- A,B

  1. What are the prerequisites for taking manual backups in ADB? (Choose two)

A- Create a bucket to hold backups
B- Define OCI Object Storage credentials only
C- Create a compartment to hold the backups
D- Define OCI Object Storage credentials and tenancy URL

Ans:- A,D

  1. Which statements are true about automated tuning? (Choose three)

A- Parallel execution of the queries needs to be monitored manually
B- Built-in resource management plans
C- Simple web-based monitoring console
D- Fast performance out of the box with zero tuning
E- Partitioning not covered under automated tuning

Ans:- B,C,D

  1. Which statements are true about backup and recovery in ADB? (Choose three)

A- Automatic backups provide weekly backup and daily incremental backup
B- Manual backups cannot be taken
C- Database is automatically backed up
D- Manual recovery cannot be initiated
E- Database can be recovered to any point in time in the retention period

Ans:- A,C,E

  1. Which chart shows the average number of queued SQL statements in each consumer group?

A- Average SQL Statements Response Time
B- Running SQL Statements
C- Running Statements
D- Queued Statements

Ans:- D

  1. Which chart shows the average number of running SQL statements historically?

A- Queued Statements
B- Average SQL Statements Response Time
C- Running SQL Statements
D- SQL statements executed per second

Ans:- C

  1. Which statements are true about network security? (Choose two)

A- Access can be restricted between tenancies and within the tenancy itself
B- Permissions can be used to isolate networking between compartments and VCNs
C- Subnets can be created only within an availability domain
D- Access between tenancies can be restricted with the same availability domain
E- Tenancies cannot be completely network isolated

Ans:- A,B

  1. Which DB system type provides Instance isolation?

A- Virtual Machine DB Systems only
B- Bare Metal and Virtual Machine DB Systems
C- Bare Metal and Exadata DB Systems
D- Exadata DB Systems only
E- Bare Metal DB Systems only

Ans:- E

  1. Which statements are true about the API Signing Key? (Choose two)

A- It is an RSA key pair in the PEM format
B- An RSA key pair in PEM format must have a minimum of 1024 bits
C- It is required when using OCI API in conjunction with the SDK/CLI
D- It must be generated with a passphrase

Ans:- A,C

  1. Which of these do you need to enter when you set up the Config File using the oci setup config command? (Choose three)

A- User OCID
B- Tenancy OCID
C- Location of the config file
D- OCI Region OCID
E- File format of the config file

Ans:- A,B,C

  1. Which statements are true about REST APIs and RESTful services? (Choose two)

A- REST APIs also use the HTTP communication protocol but mainly use JSON for communication
B- RESTful services are complex when compared to traditional XML SOAP communications
C- REST stands for Representational State Transfer
D- REST APIs only use JSON for communication

Ans:- A,C

  1. Which statements are true about OCI CLI? (Choose two)

A- Calls OCI REST APIs
B- Runs on Linux operating systems only
C- Is easy to use but involves complex installation and configuration
D- Does not use REST APIs
E- Is easy to use and lightweight to install

Ans:- A,E

  1. What is the main use case for REST APIs?

A- Monitoring only
B- Monitoring, DevOps & Development
C- Monitoring & Development
D- DevOps only
E- Monitoring & DevOps

Ans:- B,C

  1. Which of the following workloads are best suited for ATP? (Choose two)

A- Data Mart
B- IOT
C- Transactions
D- Analytics

Ans:- B,C

  1. Which of the following are features of ADB? (Choose three)

A- Self-driving
B- Self-repairing
C- Manual repairing
D- Self-administration
E- Self-securing

Ans:- A,B,E

  1. Which of the following can be methods of migration to ADW (Choose two)

A- RMAN
B- Golden Gate
C- RMAN Transportable Tablespace with Data Pump
D- Data Pump
E- Transportable Tablespace

Ans:- B,D

  1. Which stack is the responsibility of the consumer in case of Platform as a Service?

A- Storage
B- Operating system
C- Applications
D- Server

Ans:- C

  1. Which of the following workloads are best suited for ADW? (Choose three)

A- OLTP
B- Data Mart
C- Analytics
D- Transactions
E- Data Lake
F- Reporting

Ans:- B,C,E

  1. For which of the following elements is an enterprise data warehouse best suited? (Choose three)

A- RAW data
B- Batch data
C- Transactional data
D- Summary data
E- Metadata

Ans:- A,D,E

  1. Which objects types can be migrated using SQL Developer?

A- Tables
B- Views
C- Constraints
D- Indexes
E- All of the above

Ans:- E

  1. How does data pump load and unload table data?

A- Direct path
B- External tables
C- Both

Ans:- C

  1. Which of the following are key features of Oracle Data Pump?

A- Fast Performance
B- Fine-grained object selection
C- Monitoring and estimating capability
D- Network mode
E- All of the above

Ans:- E

  1. Which of the following file formats are available in Oracle SQL Developer while exporting user data? (Choose three)

A- DMP
B- XML
C- CSV
D- XLS

Ans:- B,C,D

  1. What do you download in order to be able to connect to an ADW instance?

A- tnsnames.ora file
B- sqlnet.ora
C- credential zip file

Ans:- C

  1. Oracle ADB is a family comprising of which services? (Choose two)

A- Oracle Machine Learning
B- Autonomous Analytics
C- Autonomous Data Warehouse
D- Autonomous Transaction Processing

Ans:- C,D

  1. Which Oracle Cloud Services are compatible with Oracle Machine Learning?

A- Autonomous Transaction Processing
B- Integration Cloud
C- Autonomous Analytics Cloud
D- Autonomous Data Warehouse Cloud

Ans:- A,C,D

  1. Oracle Machine Learning supports all Machine Learning algorithms.
  • True
  • False

Ans:- true

  1. Which languages are supported by Oracle Machine Learning? (Choose two)

A- Python
B- PL/SQL
C- R
D- SQL

Ans:- B,D

  1. What are the different components in Oracle Machine Learning?

A- OML User Administration Application
B- OML Application
C- Zeppelin Server
D- all of the above

Ans:- D

  1. Which components are contained in the workspace? (Choose two)

A- Templates
B- Projects
C- Notebooks
D- SQL Scripts

Ans:- B,C

  1. To run the SQL script in SQL Scratchpad, which interpreter is mandatory in the first line?

A- %sh
B- %spark
C- %sql
D- %md

Ans:- C

  1. Which of the following SQL statements are available in ADW?

A- ALTER PROFILE
B- ALTER TABLESPACE
C- CREATE TABLESPACE
D- none of the above

Ans:- D

  1. What is the typical workflow for analyzing data in Oracle Machine Learning?

A- Get predictions from the model, prepare the data, create the model, and deploy the trained model
B- Train and evaluate the model, prepare the data, create the model, and deploy the trained model
C- Prepare the data, create the model, train and evaluate the model, and deploy the trained model
D- Create the model, prepare the data, train and evaluate the model, and deploy the trained model

Ans:- C

  1. Which workspace permissions are available in Oracle Machine Learning? (Choose three)

A- Manager
B- Viewer
C- Consumer
D- Developer

Ans:- A,B,D

  1. In Oracle Machine Learning, in which file format can SQL Scripts be saved?

A- SQL
B- ORC
C- AVRO
D- JSON

Ans:- D

  1. Which of the following do not support Apache Zeppelin dynamic forms in Oracle Machine Learning? (Choose three)

A- Text input form
B- Check box form
C- Select form
D- Text output form

Ans:- A,B,C

  1. What are the different output formats supported by the SET SQLFORMAT command? (Choose three)

A- CSV
B- JSON
C- TXT
D- HTML

Ans:- A,B,D

  1. In Oracle Machine Learning, when you access the Compute Resources page as the Administrator user, which connection details do you get to see? (Choose three)

A- Comment
B- Service Name
C- Host
D- Name

Ans:- A,C,D

  1. What are the different templates that are available in Oracle Machine Learning? (Choose three)

A- Shared templates
B- Personal templates
C- Example templates
D- Fixed templates

Ans:- A,B,C

  1. Which notebooks can be used by a user to schedule a job? (Choose two)

A- notebooks owned by the user
B- notebooks from shared templates
C- notebooks from personal templates
D- notebook shared by another user

Ans:- A,D

  1. Which of the following contain information about the templates displayed on the Shared templates page?

A- Number of creations
B- Template name
C- Create notebooks
D- View templates

Ans:- B

  1. Which tasks can be performed with personal templates? (Choose three)

A- Customize selected templates in edit mode
B- View selected templates in read-only mode
C- Delete selected templates
D- Create new notebooks from selected templates

Ans:- B,C,D

  1. What is the maximum character limit for a job name?

A- 128 bytes
B- 100 bytes
C- 130 bytes
D- 64 bytes

Ans:- A

  1. Who can have read access to notebooks in Oracle Machine Learning?

A- an administrator and a developer
B- an administrator
C- a developer
D- a manager

Ans:- B

  1. Which editions are included as part of Oracle Autonomous Analytics Cloud?

A- Enterprise edition
B- Data lake edition
C- Standard edition
D- Governance edition

Ans:- A,B,C

  1. What are the features available in Oracle Autonomous Analytics Cloud? (Choose two)

A- Data visualization
B- Data modeling
C- Machine learning
D- Real-time processing

Ans:- A,C

  1. Which connection type is supported by Oracle Autonomous Analytics Cloud?

A- Oracle Autonomous Data Warehouse Cloud
B- Oracle Talent Acquisition Cloud
C- DB2
D- Apache Hive
E- all of the above

Ans:- E

  1. Oracle ATP supports third-party data integration tools.

A- True
B- False

Ans:- true

  1. You can create connections to ADW and ATP service instances from OAC.

A- True
B- False

Ans:- true

  1. In Oracle OAC, from which of the following can you create a data set?

A- Connection
B- File
C- all of the above
D- Subject Area

Ans:- C

I hope my written content will helped you. Your suggestions/feedback are most welcome from orakldba.com.
Keep learning… Have a great day!!!
Please comment here for your any query related to above content. You could write to mail me through : orakldba@gmail.com.

Leave a Comment