ADB Certification Practice Questions
Which workspace permissions are available in Oracle Machine Learning? (Choose three) - Manager - Viewer - Consumer - Developer
- Manager - Viewer - Developer
What do you download in order to be able to connect to an ADW instance? - tnsnames.ora file - sqlnet.ora - credential zip file
Credential zip file
Which statement is true about the automated management of ADB? - It includes scaling, backup and recovery, and patching - It includes provisioning new instances, scaling, patching, and backup and recovery - It includes provisioning new instances, scaling, and backup and recovery - It includes provisioning new instances, scaling, and patching
It includes provisioning new instances, scaling, patching, and backup and recovery
In Oracle Machine Learning, in which file format can SQL Scripts be saved? - SQL - ORC - AVRO - JSON
JSON
What is the main use case for REST APIs? - Monitoring only - Monitoring, DevOps & Development - Monitoring & Development - DevOps only - Monitoring & DevOps
Monitoring, DevOps & Development
Which of the following contain information about the templates displayed on the Shared templates page? - Number of creations - Template name - Create notebooks - View templates
Template name
In which Oracle client credentials' file (wallet file) can we find the port number? - ojdbc.properties - truststore.jks - sqlnet.ora - tnsnames.ora - listener.ora
tnsnames.ora
To run the SQL script in SQL Scratchpad, which interpreter is mandatory in the first line? - %sh - %spark - %sql - %md
%sql
From which cloud services can Oracle Data Pump import data from dump files to ADB? (Choose three) - AWS S3 - OCI Object Storage Classic - OCI Object Storage - IBM Spectrum Storage - Dell EMC Elastic Cloud Storage - Azure Blob Storage
- AWS S3 - OCI Object Storage Classic - OCI Object Storage
Which statements are true about network security? (Choose two) - Access can be restricted between tenancies and within the tenancy itself - Permissions can be used to isolate networking between compartments and VCNs - Subnets can be created only within an availability domain - Access between tenancies can be restricted with the same availability domain - Tenancies cannot be completely network isolated
- Access can be restricted between tenancies and within the tenancy itself - Permissions can be used to isolate networking between compartments and VCNs
From which cloud services does DBMS_CLOUD provide support for loading data from files to tables in ADB? (Choose three) - Dell EMC Elastic Cloud Storage - Amazon AWS S3 - OCI Object Storage Classic - OCI Object Storage - IBM Spectrum Storage
- Amazon S3 - OCI Object Storage Classic - OCI Object Storage
Which statements are true about backup and recovery in ADB? (Choose three) - Automatic backups provide weekly backup and daily incremental backup - Manual backups cannot be taken - Database is automatically backed up - Manual recovery cannot be initiated - Database can be recovered to any point in time in the retention period
- Automatic backups provide weekly backup and daily incremental backup - Database is automatically backed up - Database can be recovered to any point in time in the retention period
Oracle ADB is a family comprising of which services? (Choose two) - Oracle Machine Learning - Autonomous Analytics - Autonomous Data Warehouse - Autonomous Transaction Processing
- Autonomous Data Warehouse - Autonomous Transaction Processing
Which Oracle Cloud Services are compatible with Oracle Machine Learning? - Autonomous Transaction Processing - Integration Cloud - Autonomous Analytics Cloud - Autonomous Data Warehouse Cloud
- Autonomous Transaction Processing - Autonomous Analytics Cloud - Autonomous Data Warehouse
Which statements are true about the API Signing Key? (Choose two) - It is an RSA key pair in the PEM format - An RSA key pair in PEM format must have a minimum of 1024 bits - It is required when using OCI API in conjunction with the SDK/CLI - It must be generated with a passphrase
- It is an RSA key pair in the PEM format - It is required when using OCI API in conjunction with the SDK/CLI
Which statements are true about the billing when you stop an ADB instance? (Choose two) - Billing for storage continues - Billing for CPU stops - Billing for both CPU and storage continues - Billing for both CPU and storage stops
- Billing for storage continues - Billing for CPU stops
Which statements are true about automated tuning? (Choose three) - Parallel execution of the queries needs to be monitored manually - Built-in resource management plans - Simple web-based monitoring console - Fast performance out of the box with zero tuning - Partitioning not covered under automated tuning
- Built-in resource management plans - Simple web-based monitoring console - Fast performance out of the box with zero tuning
What are the different output formats supported by the SET SQLFORMAT command? (Choose three) - CSV - JSON - TXT - HTML
- CSV - JSON - HTML
Which statements are true about OCI CLI? (Choose two) - Calls OCI REST APIs - Runs on Linux operating systems only - Is easy to use but involves complex installation and configuration - Does not use REST APIs - Is easy to use and lightweight to install
- Calls OCI REST APIs - Is easy to use and lightweight to install
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) - Comment - Service Name - Host - Name
- Comment - Host - Name
Which statements are true about OCI compartments? (Choose two) - Compartments are used to organize resources and make it easy to control access - An administrator can create more compartments in the root compartment - A user should create the root compartment before provisioning the instance - A user can have only one compartment
- Compartments are used to organize resources and make it easy to control access - An administrator can create more compartments in the root compartment
What are the prerequisites for taking manual backups in ADB? (Choose two) - Create a bucket to hold backups - Define OCI Object Storage credentials only - Create a compartment to hold the backups - Define OCI Object Storage credentials and tenancy URL
- Create a bucket to hold backups - Define OCI Object Storage credentials and tenancy URL
Which of the following workloads are best suited for ADW? (Choose three) - OLTP - Data Mart - Analytics - Transactions - Data Lake - Reporting
- Data Mart - Data Lake - Analytics
What are the features available in Oracle Autonomous Analytics Cloud? (Choose two) - Data visualization - Data modeling - Machine learning - Real-time processing
- Data visualization - Machine learning
Which are the things required for provisioning an ADB instance? (Choose three) - FRA Size - Database name - Workload type - Backup location - Number of tablespaces - Number of CPUs
- Database name - Workload type - Number of CPUs
Which editions are included as part of Oracle Autonomous Analytics Cloud? - Enterprise edition - Data lake edition - Standard edition - Governance edition
- Enterprise edition - Data lake edition - Standard edition
Which of the following can be methods of migration to ADW (Choose two) - RMAN - Golden Gate - RMAN Transportable Tablespace with Data Pump - Data Pump - Transportable Tablespace
- Golden Gate - Data Pump
Which of the following workloads are best suited for ATP? (Choose two) - Data Mart - IOT - Transactions - Analytics
- IOT - Transactions
Which statements are true about scaling on demand? (Choose two) - Independently scale compute or storage - Resizing occurs instantly, fully online - Compute and storage must be scaled together - Resizing needs a restart
- Independently scale compute or storage - Resizing occurs instantly, fully online
Which are the capabilities of Oracle Autonomous Database that can accelerate innovation? (Choose three) - Instant scaling of storage - Scaling of CPUs with very minimum downtime - Built-in AI and ML helps find patterns that could identify undiscovered anomalies - Provisions data warehouse in seconds
- Instant scaling of storage - Built-in AI and ML helps find patterns that could identify undiscovered anomalies - Provisions data warehouse in seconds
Which languages are supported by Oracle Machine Learning? (Choose two) - Python - PL/SQL - R - SQL
- PL/SQL - SQL
Which components are contained in the workspace? (Choose two) - Templates - Projects - Notebooks - SQL Scripts
- Projects - Notebooks
Which statements are true about built-in SQL Worksheet and Notebook? (Choose two) - Quickly start running queries with built-in web-based notebooks - Based on Apache Tomcat - Need to install client query tool for the PL/SQL - No need to install a client query tool
- Quickly start running queries with built-in web-based notebooks - No need to install a client query tool
For which of the following elements is an enterprise data warehouse best suited? (Choose three) - RAW data - Batch data - Transactional data - Summary data - Metadata
- RAW data - Summary data - Metadata
Which statements are true about REST APIs and RESTful services? (Choose two) - REST APIs also use the HTTP communication protocol but mainly use JSON for communication - RESTful services are complex when compared to traditional XML SOAP communications - REST stands for Representational State Transfer REST APIs only use JSON for communication
- REST APIs also use the HTTP communication protocol but mainly use JSON for communication - REST stands for Representational State Transfer
Which statements are true about ADB? (Choose two) - Instant scaling available for CPUs only - Provisioning takes a long time - Reduces data management costs - Reduces the administration costs with complete automation of operations and tuning - Scaling for storage needs a restart
- Reduces data management costs - Reduces the administration costs with complete automation of operations and tuning
Which of the following are features of ADB? (Choose three) - Self-driving - Self-repairing - Manual repairing - Self-administration - Self-securing
- Self-driving - Self-repairing - Self-securing
What are the different templates that are available in Oracle Machine Learning? (Choose three) - Shared templates - Personal templates - Example templates - Fixed templates
- Shared templates - Personal templates - Example templates
Which of the following do not support Apache Zeppelin dynamic forms in Oracle Machine Learning? (Choose three) - Text input form - Check box form - Select form - Text output form
- Text input form - Check box form - Select form
Which of these do you need to enter when you set up the Config File using the oci setup config command? (Choose three) - User OCID - Tenancy OCID - Location of the config file - OCI Region OCID - File format of the config file
- User OCID - Tenancy OCID - Location of the config file
Which tasks can be performed with personal templates? (Choose three) - Customize selected templates in edit mode - View selected templates in read-only mode - Delete selected templates - Create new notebooks from selected templates
- View selected templates in read-only mode - Delete selected templates - Create new notebooks from selected templates
Which of the following file formats are available in Oracle SQL Developer while exporting user data? (Choose three) - DMP - XML - CSV - XLS
- XML - CSV - XLS
Which dictionary views can be used to see the results of validate operations? (Choose two) - dba_workload_filters - dba_load_operations - dba_workload_sql_map - user_load_operations
- dba_load_operations - user_load_operations
Which notebooks can be used by a user to schedule a job? (Choose two) - notebooks owned by the user - notebooks from shared templates - notebooks from personal templates - notebook shared by another user
- notebooks owned by the user - notebook shared by another user
How many CPU shares can be used by a SQL statement in a Low database service? - 4 - 3 - 2 - 1
1
How many SQL statements can a paragraph contain? - 1 - 5 - 10 -2
1
What is the maximum character limit for a job name? - 128 bytes - 100 bytes - 130 bytes - 64 bytes
128 bytes
What is the default port number for ATP? - 1525 - 1521 - 1527 - 1522
1522
What is the number of concurrent queries supported by the medium database service with 16 OCPUs? - 3 - 40 - 32 - 20
20
What is the retention period for backups in ADB? - 60 days - 45 days - 30 days - 7 days
60 days
What is the default retention period for performance data? - 7 days - 8 days - 15 days - 14 days
8 days
Which user can create a new user in ADB? - SYSTEM - DBSNMP - ADMIN - SYS
ADMIN
In Oracle OAC, from which of the following can you create a data set? - Connection - File - all of the above - Subject Area
All of the above
What are the different components in Oracle Machine Learning? - OML User Administration Application - OML Application - Zeppelin Server - all of the above
All of the above
Which connection type is supported by Oracle Autonomous Analytics Cloud? - Oracle Autonomous Data Warehouse Cloud - Oracle Talent Acquisition Cloud - DB2 - Apache Hive - all of the above
All of the above
Which objects types can be migrated using SQL Developer? - Tables - Views - Constraints - Indexes - All of the above
All of the above
Which of the following are key features of Oracle Data Pump? - Fast Performance - Fine-grained object selection - Monitoring and estimating capability - Network mode - All of the above
All of the above
Who can have read access to notebooks in Oracle Machine Learning? - an administrator and a developer - an administrator - a developer - a manager
An administrator
Which stack is the responsibility of the consumer in case of Platform as a Service? - Storage - Operating system - Applications - Server
Applications
Which DB system type provides Instance isolation? - Virtual Machine DB Systems only - Bare Metal and Virtual Machine DB Systems - Bare Metal and Exadata DB Systems - Exadata DB Systems only - Bare Metal DB Systems only
Bare Metal DB Systems only
How does data pump load and unload table data? - Direct path - External tables - Both
Both
Which procedure can be used to load data directly into existing ADB tables? - DBMS_CLOUD.LIST_FILES - DBMS_CLOUD.CREATE_EXTERNAL_TABLE - DBMS_CLOUD.PUT_OBJECT - DBMS_CLOUD.COPY_DATA
DBMS_CLOUD.COPY_DATA
Which procedure can be used to move the Data Pump Import log file from ADB to Oracle Cloud Object Storage? - DBMS_CLOUD.PUT_OBJECT - DBMS_CLOUD.CREATE_EXTERNAL_TABLE - DBMS_CLOUD.COPY_DATA - DBMS_CLOUD.LIST_FILES
DBMS_CLOUD.PUT_OBJECT
With which of the following does Oracle Machine Learning allow access to data in ADB? - Data Ingestion and Selection only - Data Ingestion and Selection, Data Viewing and Discovery, and Data Analysis - Data Ingestion and Selection and Data Viewing and Discovery Data Viewing and Discovery and Data Ingestion and Selection
Data Ingestion and Selection, Data Viewing and Discovery, and Data Analysis
From where can you create Oracle Machine Learning users? - From the Admin Password tab from the Details tab - From the Administration tab in the Service Console - From the Activity tab in the Service tab - From the Overview tab in the Service Console
From the Administration tab in the Service Console
Which of the following SQL statements are available in ADW? - ALTER PROFILE - ALTER TABLESPACE - CREATE TABLESPACE - none of the above
None of the above
What is the typical workflow for analyzing data in Oracle Machine Learning? - Get predictions from the model, prepare the data, create the model, and deploy the trained model - Train and evaluate the model, prepare the data, create the model, and deploy the trained model - Prepare the data, create the model, train and evaluate the model, and deploy the trained model - Create the model, prepare the data, train and evaluate the model, and deploy the trained model
Prepare the data, create the model, train and evaluate the model, and deploy the trained data
Which chart shows the average number of queued SQL statements in each consumer group? - Average SQL Statements Response Time - Running SQL Statements - Running Statements - Queued Statements
Queued Statements
Which chart shows the average number of running SQL statements historically? - Queued Statements - Average SQL Statements Response Time - Running SQL Statements - SQL statements executed per second
Running SQL Statements
Oracle ATP supports third-party data integration tools - True - False
True
Oracle Machine Learning supports all Machine Learning algorithms. - True - False
True
You can create connections to ADW and ATP service instances from OAC - True - False
True