wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Automous Database Fran

Total questions: 119

Worksheet time: 54mins

Name
Class
Date
1.
What are two advantages of using Data Pump to migrate your Oracle Databases to Autonomous Database?
a)
Data Pump can exclude migration of objects like indexes and materialized views that are not needed by Autonomous Database
b)
Data Pump is platform independent - it can migrate Oracle Databases running on any platform
c)
Data Pump is faster to migrate database than using RMAN (= Recovery MANager).
d)
Data Pump creates the tablespaces used by your Autonomous Database
2.
Which task is NOT automatically performed by the Oracle Autonomous Database?
a)
Backing up the database
b)
Mask your sensitive data
c)
Patching the database
d)
Automatically optimize the workload
3.
Which of these database features is NOT part of the Autonomous Database?
a)
Online Indexing
b)
Flashback Database
c)
Real Application Clusters (RAC)
d)
Java in the Database
4.
Which two statements are true with regards to Oracle Data Sync? (Choose two.)
a)

Data Sync can connect to any JDBC compatible source like MongoDB, RedShift and Sybase.

b)
Data Sync can use a normal OCI (thick) client connection to connect to an Oracle database.
c)
Data Sync can load your data in parallel in order to speed up the loading process.
d)
Data Sync has default drivers available that supported loading data from DB2, Microsoft SQL Server, MySQL and Teradata
5.
Which statement is false about Autonomous Database Oracle Client Credentials (Wallets)? OK?
a)

In addition to the Oracle Client Credential Wallet, a user must have a username and password in order to connect to the Autonomous Database.

b)

The Oracle Client Credential file is downloaded as a ZIP file.

c)
The Wallet for the Autonomous Database is the same as the Transparent Data Encryption (TDE) wallet.
d)

You MUST have an Oracle Client Credential Wallet in order to connect to the Autonomous Database.

6.
What is the predefined role that exists in Autonomous Database that includes common privileges that are used by a Data Warehouse developer?
a)
ADBDEV
b)
ADMIN
c)
DWROLE
d)
ADWC
7.
Which two system privileges does a user need to create analytic views? (Choose two.)
a)
CREATE ANALYTIC MEASURE
b)
CREATE ANALYTIC LEVEL
c)
CREATE ANALYTIC HIERARCHY
d)
CREATE ANALYTIC VIEW
e)
CREATE ATTRIBUTE DIMENSION
8.
While Autonomous Transaction Processing and Autonomous Data Warehouse use the same Oracle database, which statement is true about the workloads?
a)
Autonomous Transaction Processing memory usage optimizes workloads for parallel joins and aggregations
b)
Autonomous Data Warehouse workloads are optimized for mixed workloads.
c)
Autonomous Transaction Processing workloads are optimized for data warehouse, data mart, and data lake
d)
Data that is bulk loaded, by default, uses the row format in Autonomous Transaction Processing where Autonomous Data Warehouse data format is columnar
9.
When scaling OCPUs in Autonomous Database, which statement is true in regards to active transactions?
a)
Active transactions continue running unaffected.
b)
Active transactions are paused
c)
Scaling cannot happen while there are active transactions in the database
d)
Active transactions are terminated and rolled back
10.
Which two are correct actions to take in order to Download the Autonomous Database Credentials? (Choose two.)
a)
Click on the Autonomous Data Warehouse in the menu, click a database name, then Choose DB Connection button, then Download the Wallet
b)
Click on the Autonomous Data Warehouse section, pick a database, then Choose Actions, then Download the Wallet
c)
Find the Service Console for your Autonomous Database, then pick Administration, then Download the Client Credentials (Wallet).
d)
Click on the Object Storage and find your Autonomous Bucket and Download the Wallet Credentials
e)
Click the Compute section of the menu, then choose Instance Configurations, then Download Wallet.
11.
How many pre-defined service names are configured in tnsnames.ora for a single Autonomous Transaction Processing database instance, and what are they called?
a)
Two. They are called ATP and ADW
b)
None. There are no pre-defined service names in tnsnames.ora
c)
Three. They are called high, medium and low
d)
Five. They are called tpurgent, tp, high, medium and low
12.

If you need to connect to Autonomous Data Warehouse (ADW) using Java Database Connectivity (JDBC) via an HTTP proxy, where do you set the proxy details?

a)
tnsnames.ora
b)
keystore.jks
c)
sqlnet.ora
d)
cwallet.sso
e)
ojdbc.properties
13.
Your customer receives information in various formats like .csv files from their suppliers. The business user would like to collect all of this information and store it in a ATP environment. The Oracle adviser recommends to use Oracle Data Sync for this. Which statement is true regarding Oracle Data Sync?
a)
Data Sync can only load files into tables (insert-only), the customer has to write the additional code
b)
Data Sync can not transform your data while loading it into the destination table
c)
Data Sync can load a combination of data source, such as .csv, .xlsx and Oracle relational files
d)
Data Sync can only load data from one source into one destination table.
14.
The 3rd party application that your customer wants to migrate to Autonomous Database (ADB) has some specific demands like tablespace names, usernames and init.ora parameters. The decision was made to adhere to the suggested migration method using an instant client and the datapump version that was suggested (and came with it).  Which statement is true about the migration of the application's database success?
a)
The migration can be technically a success but the 3-rd party vendor needs to support the result.
b)
The suggested datapump version will create an alias for non-standard tablespace names so the migration is successful
c)
The tablespace names will result in a blocking error during datapump import because of ADB limitations
d)
The migration can be a success, both technically and functional due to datapump enhancements
15.
A customer wants to migrate to Autonomous Database (ADB) but only allows for a very small window of downtime. Golden Gate was advised to be used during the migration. For maximum reassurance of their end-users, the customer also would like to use Golden Gate as a fall-back scenario for the first 6 months after the migration. If customers complain, the on-premise data can be synchronised with the ADB Instance for a switch back. Which statement about the migration using Golden Gate is correct?
a)
Migration to ADB is not possible using Golden Gate because the apply-process cannot be installed on ADB.
b)
Only the migration to ADB is possible from an on-premise installation of Golden Gate.
c)
Golden Gate on premise is not certified with ADB because Golden Gate Cloud Service exists for this
d)
The fallback scenario is not possible using Golden Gate because the capture-process cannot be installed on ADB
e)
The described scenario is correct, can be used for migration and fallback scenarios.
16.
Which statement is true regarding database client credentials file required to connect to your Autonomous Database?
a)
Place the credential files on a share drive that all users can use to connect to the database.
b)
The Transparent Data Encryption (TDE) wallet can be used for your client credentials to connect to your database
c)
Store credential files in a secure location and share the files only with authorized users to prevent unauthorized access to the database
d)
When you share the credential files with authorized users, mail the wallet password and the file in the same email
17.
In which way can a SQL Developer help you test your data loading scenario to Autonomous Database (ADB)?
a)
In the TEST phase of the wizard, a subset of accepted records is displayed based on your definition
b)
In the TEST phase of the wizard a list is generated containing the records that would be rejected during import
c)
In the Column Definition Phase, the system cross-references with the file-contents and shows the conflicts with the definition
d)
In the TEST phase, a temporary table will be populated with the records before inserting them in the destination table
18.
Where can a user's public ssh key be added on the Oracle Cloud Infrastructure Console in order to execute API calls?
a)
On the Autonomous Database Console
b)
SSH keys are not required in Oracle Cloud Infrastructure.
c)
SSH keys cannot be added from console. They have to be added using REST APIs only.
d)
Navigate to Identity, select Users panel on the console and select "Add Public Key".
19.
Which statement is true in regards to database links?
a)
You can call PL/SQL procedures and functions using a database link.
b)
Connect from Autonomous Database to remote database using a database link.
c)
Connect to Autonomous Database from remote database using a database link
d)
Create a database link from one Autonomous Database to another Autonomous Database instance
20.
How can an Autonomous Database resource be provisioned without logging into the Oracle Cloud Infrastructure console?
a)
Using Database Configuration Assistant (DBCA) on the database server.
b)
It cannot be done.
c)
Connecting to the Cloud Infrastructure Command console via SSH wallet
d)
Using the Oracle Cloud Infrastructure Command Line interface tool or REST API calls
21.
Which is correct about security features that are available in Oracle Autonomous Database?
a)
TDE but not Data Redaction
b)
Data Redaction and TDE are both supported.
c)
Data Redaction but not TDE
d)
Neither Data Redaction nor TDE are supported
22.
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.
23.
Once you have a connection to the Autonomous Data Warehouse, how do you import tables into the Oracle Analytics Cloud (OAC)?
a)
Replicate the table using Golden Gate
b)
Create a Data Set
c)
Load data using Data Pump
d)
Import Table
24.
What is the default retention period for both Automatic and Manual Autonomous Database Backups?
a)
One Year
b)
7 days
c)
60 days
d)
30 days
e)
90 days
25.
When exporting a notebook, what type of file is created?
a)
XML
b)
TXT
c)
JSON
d)
SQL
e)
ASCII
26.
What two tasks can be executed from the service console for Autonomous Databases? (Choose two.)
a)
Autonomous Databases monitoring for usage and query performance
b)
Creating schemas
c)
Creating and scaling of Autonomous Database service
d)
Wizard to download connection wallet for connection from desktop tools
27.
What predefined user is created when an Autonomous Database (ADB) instance is created that you connect to in order to create other users and grant roles?
a)
SCOTT
b)
ADMIN
c)
SYS
d)
DWDEV
28.
What REST verb is used to create an Autonomous Database service using REST APIs?  
a)
A "POST" REST call
b)
A "PUT" REST call
c)
An "INSERT" REST call
d)
A "GET" REST call
29.
Which three statements are true about procedures in the DBMS_CLOUD package? (Choose three.)
a)

The DBMS_CLOUD.PUT_OBJECT procedure copies a file from Cloud Object Storage to the Autonomous Data Warehouse.

b)
The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database.
c)
The DBMS_CLOUD.VALIDATE_EXTERNAL_TABLE procedure validates the source files for an external table, generates log information, and stores the rows that do not match the format options specified for the external table in a badfile table on Autonomous Data Warehouse.
d)

The DBMS_CLOUD.DELETE_FILE procedure removes the credentials file from the Autonomous Data Warehouse database.

e)
The DBMS_CLOUD.CREATE_EXTERNAL_TABLE procedure creates an external table on files in the cloud. You can run queries on external data from the Autonomous Data Warehouse
30.
Variante(*): La opción de GoldenGate puede dividirse en dos GG distintos(**) y no aparecer otras opciones, como “SQL*Loader”. Solución: Las tres opciones correctas serían las dos variantes de GG(**) y “Oracle Data Pump”. What are three methods to load data into the Autonomous Database? (Choose three.)
a)
Oracle GoldenGate <= SG p82
b)
Transportable Tablespace
c)
RMAN Restore
d)
Oracle Data Pump <= SG p143
e)
SQL*Loader <= SG p143
31.
Which three statements are correct when the Autonomous Database is stopped? (Choose three.)
a)
User with DWROLE can still access the database
b)
Tools are no longer able to connect to a stopped instance
c)
CPU billing is halted based on full-hour cycles of usage.
d)
In-flight transactions and queries are stopped
32.
Which three statements are true regarding how Autonomous Database provides data security? (Choose three.)
a)
Data is encrypted at rest using transparent data encryption
b)
Network connections from clients to Autonomous Database are encrypted using the client credentials wallet
c)

Users are given OS logons or SYSDBA privileges to prevent phishing attacking.

d)
Oracle automatically applies security updates to ensure data is not vulnerable to known attack vectors
33.
What are two advantages of using Data Pump to migrate your Oracle Databases to Autonomous Database?
a)
Data Pump can exclude migration of objects like indexes and materialized views that are not needed by Autonomous Database
b)
Data Pump is platform independent - it can migrate Oracle Databases running on any platform
c)
Data Pump is faster to migrate database than using RMAN (= Recovery MANager).
d)
Data Pump creates the tablespaces used by your Autonomous Database
34.
Which task is NOT automatically performed by the Oracle Autonomous Database?
a)
Backing up the database
b)
Mask your sensitive data
c)
Patching the database
d)
Automatically optimize the workload
35.
Which of these database features is NOT part of the Autonomous Database?
a)
Online Indexing
b)
Flashback Database
c)
Real Application Clusters (RAC)
d)
Java in the Database
36.
Which two statements are true with regards to Oracle Data Sync? (Choose two.)
a)

Data Sync can connect to any JDBC compatible source like MongoDB, RedShift and Sybase.

b)
Data Sync can use a normal OCI (thick) client connection to connect to an Oracle database.
c)
Data Sync can load your data in parallel in order to speed up the loading process.
d)
Data Sync has default drivers available that supported loading data from DB2, Microsoft SQL Server, MySQL and Teradata
37.
Which statement is false about Autonomous Database Oracle Client Credentials (Wallets)? OK?
a)
In addition to the Oracle Client Credential Wallet, a user must have a username and password in order to connect to the Autonomous Database. <= SGp116, password/auto-login
b)
The Oracle Client Credential file is downloaded as a ZIP file. <= SGp133,135
c)
The Wallet for the Autonomous Database is the same as the Transparent Data Encryption (TDE) wallet.
d)
You MUST have an Oracle Client Credential Wallet in order to connect to the Autonomous Database. <= SGp341
38.
What is the predefined role that exists in Autonomous Database that includes common privileges that are used by a Data Warehouse developer?
a)
ADBDEV
b)
ADMIN
c)
DWROLE
d)
ADWC
39.
Which two system privileges does a user need to create analytic views? (Choose two.)
a)
CREATE ANALYTIC MEASURE
b)
CREATE ANALYTIC LEVEL
c)
CREATE ANALYTIC HIERARCHY
d)
CREATE ANALYTIC VIEW
e)
CREATE ATTRIBUTE DIMENSION
40.
While Autonomous Transaction Processing and Autonomous Data Warehouse use the same Oracle database, which statement is true about the workloads?
a)
Autonomous Transaction Processing memory usage optimizes workloads for parallel joins and aggregations
b)
Autonomous Data Warehouse workloads are optimized for mixed workloads.
c)
Autonomous Transaction Processing workloads are optimized for data warehouse, data mart, and data lake
d)
Data that is bulk loaded, by default, uses the row format in Autonomous Transaction Processing where Autonomous Data Warehouse data format is columnar
41.
When scaling OCPUs in Autonomous Database, which statement is true in regards to active transactions?
a)
Active transactions continue running unaffected.
b)
Active transactions are paused
c)
Scaling cannot happen while there are active transactions in the database
d)
Active transactions are terminated and rolled back
42.
Which two are correct actions to take in order to Download the Autonomous Database Credentials? (Choose two.)
a)
Click on the Autonomous Data Warehouse in the menu, click a database name, then Choose DB Connection button, then Download the Wallet
b)
Click on the Autonomous Data Warehouse section, pick a database, then Choose Actions, then Download the Wallet
c)
Find the Service Console for your Autonomous Database, then pick Administration, then Download the Client Credentials (Wallet).
d)
Click on the Object Storage and find your Autonomous Bucket and Download the Wallet Credentials
e)
Click the Compute section of the menu, then choose Instance Configurations, then Download Wallet.
43.
How many pre-defined service names are configured in tnsnames.ora for a single Autonomous Transaction Processing database instance, and what are they called?
a)
Two. They are called ATP and ADW
b)
None. There are no pre-defined service names in tnsnames.ora
c)
Three. They are called high, medium and low
d)
Five. They are called tpurgent, tp, high, medium and low
44.

If you need to connect to Autonomous Data Warehouse (ADW) using Java Database Connectivity (JDBC) via an HTTP proxy, where do you set the proxy details?

a)
tnsnames.ora
b)
keystore.jks
c)
sqlnet.ora
d)
cwallet.sso
e)
ojdbc.properties
45.
Your customer receives information in various formats like .csv files from their suppliers. The business user would like to collect all of this information and store it in a ATP environment. The Oracle adviser recommends to use Oracle Data Sync for this. Which statement is true regarding Oracle Data Sync?
a)
Data Sync can only load files into tables (insert-only), the customer has to write the additional code
b)
Data Sync can not transform your data while loading it into the destination table
c)
Data Sync can load a combination of data source, such as .csv, .xlsx and Oracle relational files
d)
Data Sync can only load data from one source into one destination table.
46.
The 3rd party application that your customer wants to migrate to Autonomous Database (ADB) has some specific demands like tablespace names, usernames and init.ora parameters. The decision was made to adhere to the suggested migration method using an instant client and the datapump version that was suggested (and came with it).  Which statement is true about the migration of the application's database success?
a)
The migration can be technically a success but the 3-rd party vendor needs to support the result.
b)
The suggested datapump version will create an alias for non-standard tablespace names so the migration is successful
c)
The tablespace names will result in a blocking error during datapump import because of ADB limitations
d)
The migration can be a success, both technically and functional due to datapump enhancements
47.
A customer wants to migrate to Autonomous Database (ADB) but only allows for a very small window of downtime. Golden Gate was advised to be used during the migration. For maximum reassurance of their end-users, the customer also would like to use Golden Gate as a fall-back scenario for the first 6 months after the migration. If customers complain, the on-premise data can be synchronised with the ADB Instance for a switch back. Which statement about the migration using Golden Gate is correct?
a)
Migration to ADB is not possible using Golden Gate because the apply-process cannot be installed on ADB.
b)
Only the migration to ADB is possible from an on-premise installation of Golden Gate.
c)
Golden Gate on premise is not certified with ADB because Golden Gate Cloud Service exists for this
d)
The fallback scenario is not possible using Golden Gate because the capture-process cannot be installed on ADB
e)
The described scenario is correct, can be used for migration and fallback scenarios.
48.
Which statement is true regarding database client credentials file required to connect to your Autonomous Database?
a)
Place the credential files on a share drive that all users can use to connect to the database.
b)
The Transparent Data Encryption (TDE) wallet can be used for your client credentials to connect to your database
c)
Store credential files in a secure location and share the files only with authorized users to prevent unauthorized access to the database
d)
When you share the credential files with authorized users, mail the wallet password and the file in the same email
49.
In which way can a SQL Developer help you test your data loading scenario to Autonomous Database (ADB)?
a)
In the TEST phase of the wizard, a subset of accepted records is displayed based on your definition
b)
In the TEST phase of the wizard a list is generated containing the records that would be rejected during import
c)
In the Column Definition Phase, the system cross-references with the file-contents and shows the conflicts with the definition
d)
In the TEST phase, a temporary table will be populated with the records before inserting them in the destination table
50.
Where can a user's public ssh key be added on the Oracle Cloud Infrastructure Console in order to execute API calls?
a)
On the Autonomous Database Console
b)
SSH keys are not required in Oracle Cloud Infrastructure.
c)
SSH keys cannot be added from console. They have to be added using REST APIs only.
d)
Navigate to Identity, select Users panel on the console and select "Add Public Key".
51.
Which statement is true in regards to database links?
a)
You can call PL/SQL procedures and functions using a database link.
b)
Connect from Autonomous Database to remote database using a database link.
c)
Connect to Autonomous Database from remote database using a database link
d)
Create a database link from one Autonomous Database to another Autonomous Database instance
52.
How can an Autonomous Database resource be provisioned without logging into the Oracle Cloud Infrastructure console?
a)
Using Database Configuration Assistant (DBCA) on the database server.
b)
It cannot be done.
c)
Connecting to the Cloud Infrastructure Command console via SSH wallet
d)
Using the Oracle Cloud Infrastructure Command Line interface tool or REST API calls
53.
Which is correct about security features that are available in Oracle Autonomous Database?
a)
TDE but not Data Redaction
b)
Data Redaction and TDE are both supported.
c)
Data Redaction but not TDE
d)
Neither Data Redaction nor TDE are supported
54.
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.
55.
Once you have a connection to the Autonomous Data Warehouse, how do you import tables into the Oracle Analytics Cloud (OAC)?
a)
Replicate the table using Golden Gate
b)
Create a Data Set
c)
Load data using Data Pump
d)
Import Table
56.
What is the default retention period for both Automatic and Manual Autonomous Database Backups?
a)
One Year
b)
7 days
c)
60 days
d)
30 days
e)
90 days
57.
When exporting a notebook, what type of file is created?
a)
XML
b)
TXT
c)
JSON
d)
SQL
e)
ASCII
58.
What two tasks can be executed from the service console for Autonomous Databases? (Choose two.)
a)
Autonomous Databases monitoring for usage and query performance
b)
Creating schemas
c)
Creating and scaling of Autonomous Database service
d)
Wizard to download connection wallet for connection from desktop tools
59.
What predefined user is created when an Autonomous Database (ADB) instance is created that you connect to in order to create other users and grant roles?
a)
SCOTT
b)
ADMIN
c)
SYS
d)
DWDEV
60.
What REST verb is used to create an Autonomous Database service using REST APIs?  
a)
A "POST" REST call
b)
A "PUT" REST call
c)
An "INSERT" REST call
d)
A "GET" REST call
61.
Which operating system can Data Visualization Desktop be run on?
a)
AIX
b)
Linux
c)
Windows
d)
Solaris
62.
Which two PL/SQL functions can be used to validate an analytic view? (Choose two.)
a)
VALIDATE_LEVELS
b)
VALIDATE_HIERARCHY
c)
VALIDATE_DIMENSION
d)

VALIDATE_ANALYTIC_VIEW

e)

VALIDATE_MEASURES

63.
A Corporation is building a web application to allow its customers to schedule service requests online. There is also a need to run operational reports at times during non-peak hours. The architecture team is debating whether such reports should be run on the OLTP database or in a separate data mart. The DBA Manager does not want to add anymore admin responsibility to the team and is looking for a database option that's low to zero maintenance, but meets their strict performance requirements as well. Which Oracle Cloud Infrastructure database service is appropriate for this scenario?
a)
Since the application needs to be highly available, it should to be deployed on a Kubernetes Cluster
b)
ADW since operational reporting is a higher priority in this scenario
c)
It is best to build a separate data warehouse, and move the OLTP data on a nightly basis
d)
ATP. Using 'tpurgent' and 'high' TNS services to separate connection types
64.
As a database architect you are tasked with configuring a high concurrency, production OLTP application to connect to an Autonomous Transaction Processing database with a requirement to have some reporting queries run in parallel mode. Which connection service is appropriate for such a workload?
a)
HIGH
b)
TP
c)
MEDIUM
d)
TPURGENT
65.
Which two statements are true when running DBMS_CLOUD.COPY_DATA? (Choose two.)
a)
The source file can be in either Oracle Standard Storage or Oracle Archive Storage bucket in the Object Store
b)
The source files can reside in Oracle Object Storage, Amazon S3 Object storage, or Azure Blob storage
c)
A valid credential must be created prior to running the DBMS_CLOUD.COPY_DATA procedure.
d)
The source file will be automatically removed after the DBMS_CLOUD.COPY_DATA procedure finishes successfully
e)
The target table will be created in Autonomous Database if it does not already exist
66.
Autonomous Data Warehouse configures and optimizes your database for you, therefore you do not need to perform some of the administration operations for configuring the database. Which statement is true regarding the default configuration of the Autonomous Data Warehouse?
a)
In Autonomous Data Warehouse direct access to the database node and the local file system is allowed.
b)
Degree of parallelism for SQL statements is set based on the number of OCPUs in the system and the database service the user is connecting to
c)
Adding, removing, or modifying tablespaces is allowed.
d)
Compression is not enabled by default and you must specify the compression method for your tables with the compression clause in your CREATE TABLE and ALTER TABLE commands.
67.
What are two security features enabled by default by the Autonomous Database? (Choose two.)
a)
Transparent Data Encryption
b)
Encrypted Database Links
c)
SQL Net Encryption
d)
One SYSDBA account
e)
Read Only access to OS Audit logs
68.
Which method can be used to migrate on-premises databases to Autonomous Databases in cloud?
a)
Original Import/Export tools
b)
Physical migration method like database cloning
c)
Data Pump
d)
RMAN backup & restore
69.
Which two statements are true about the Oracle Cloud Infrastructure (OCI)? (Choose two.)
a)
An OCI region is a localized geographic area, and an availability domain is one or more data centers located within a region
b)
Because availability domains do not share infrastructure such as power or cooling, or the internal availability domain network, a failure at one availability domain within a region is unlikely to impact the availability of the others within the same region
c)
A single fault domain can be associated with multiple regions and availability domains.
d)
Regions are dependent on other regions and must be located with 5 thousand kilometers of each other
70.
Which two methods can you use to create users and grant roles in Autonomous Database services? (Choose two.)
a)
through the Oracle Cloud Infrastructure service console
b)
through SQL/Developer s
c)
using DBMS_CLOUD_ADMIN package
d)
through SQLPIus
71.
Which Autonomous Database Service is NOT used to conned to an Autonomous Transaction Processing instance?
a)
TPURGENT
b)
MEDIUM
c)
HIGH
d)
TPPERFORMANT
e)
LOW
72.
When you choose to scale your Autonomous Database, which statement is true in regards to OCPUs and storage?
a)
Storage in TB cannot be larger than the number of OCPUs
b)
OCPUs and storage must remain in sync
c)
Increasing OCPUs will automatically increase storage
d)
OCPUs and storage can be scaled independently
73.
Which two options are available to restore an Autonomous Data Warehouse? (Choose two.)
a)
Backup and recovery must be done using Recovery Manager(RMAN)
b)
Select the snapshot of the backup.
c)
Select the archived redo logs
d)
Select the backup from which restore needs to be done
e)
Specify the point in time (timestamp) to restore
74.
Which is NOT required to connect to Autonomous Database from SQL developer?
a)
Database name
b)
Service name
c)
Wallet file
d)
Username and password
75.
What are the two methods that could be used during the migration of your existing Oracle database to Autonomous Database? (Choose two.)
a)
Golden Gate
b)
Recovery Manager (RMAN)
c)
CSV files copied to Autonomous Database block storage
d)
Data Pump
76.
Which open source orchestration tool can be used to provision autonomous database resources in Oracle Cloud Infrastructure?
a)
Terraform
b)
REST API
c)
Dlocker
d)
Enterprise Manager
77.
Which is the correct subset of services offered via OCI-CLI (command line interface) for Autonomous Database (ABD) via calls made to the OCI API's?
a)
Create, Query, Update, List, Start
b)
Create, Get, List, Stop, Restore
c)
Start, Delete, Update, Query, Stop
d)
Create, Query, List, Stop, Restore
78.
What two methods can you use to define Machine Learning Users? (Choose two.)
a)
Use DBMS_CLOUD_ADMIN package
b)
SQL/Developer
c)
Oracle Cloud Infrastructure Console
d)
Client tools
79.
Which Java Database Connectivity (JDBC) thin client version supports the use of HTTP proxy settings that does NOT support TCP to connect to Autonomous Data Warehouse?
a)
18.1 onwards
b)
Any version
c)
17.4 onwards
d)
12c Release 2 onwards
80.
Your customer has upgraded their on premise 11.2 database to 12.2. During this migration the database was migrated to a pluggable database and is now in production. How should the customer unplug their database to migrate to Autonomous Database (ADB)?
a)
Pluggable databases cannot be migrated to ADB using plug, unplug or clone
b)
Create a database link from source database to the ADB environment and clone the PDB
c)
Unplug to an xml file so database files and xml file can be uploaded to object storage
d)
Unplug into a pdb archive which can be uploaded to object storage
81.
Given the steps: 1. Create Oracle Machine Learning User 2. Create projects 3. Create workspaces 4. Create Notebooks 5. Run SQL Scripts   Which two steps are out of order when working with Oracle Machine learning? (Choose two.)
a)
Create Oracle Machine Learning User
b)
Create workspaces
c)
Create Notebooks
d)
Run SQL Scripts
e)
Create projects
82.
Which can be Scaled independently of the number of CPUs in an Autonomous Database?
a)
Memory
b)
Concurrency
c)
Sessions
d)
Parallelism
e)
Storage
83.
Which statement about the Export Wizard used to export database objects and data is NOT correct?
a)
If "Dependents" is checked as a DDL Option, for non-privileged users, only dependent objects in their schema are exported
b)
Export DDL includes features such as "Show schema," "Storage," and "Terminator."
c)
If "Clipboard" is selected as the "Output," the output will be placed on the system clipboard, so that it can be pasted into a file, a command line, or other location appropriate for the format
d)

If "Grants" is checked as a DDL Option, GRANT statements are included for any grant objects on the exported objects, including those owned by the SYS schema.

84.
When you connect Oracle Analytics Cloud to the Autonomous Data Warehouse, what file needs to be uploaded?
a)
TNSNAMES.ORA
b)
CWALLET.SSO
c)
OJDBC.PROPERTIES
d)
SQLNET.ORA
85.
Users are required to select a service when connecting to Autonomous Data Warehouse and these services match to one of three different consumer groups: High, Medium, and Low. Which statement about these consumer groups is correct?
a)
Medium provides intermediate resource and concurrency, and queries run in a serial
b)
Low provides highest concurrency, lowest resources, and DoP =1
c)
High provides highest resources, lowest concurrency, and DoP is 1
d)
High provides highest concurrency and lowest resources, and DoP is 1
86.

When running lots of high concurrent queries in Autonomous Database, you should use which predefined service connection? (Choose the best answer.)

a)
DBNAME_MEDIUM
b)
DBNAME_HIGH
c)
DBNAME_CONCURRENT
d)
DBNAME_LOW
87.
Which is the default port number for ADW and ATP?
a)
1521
b)
1522
c)
1523
d)
1524
e)
1525
88.
Elementos que te llevas al importar en Data Pump (Elegir 2 opciones)
a)
Data
b)
Backup
c)
Tablespaces
d)
Schemas
e)
Memory usage
89.
Sobre que infraestructure esta funcionando ADB:
a)
Data format
b)
Index storage
c)
Bar-Metal
d)
CREATE_EXTERNAL_TABLE
e)
Exadata
90.
A la hora de cargar datos, que procedimientos de DBMS_CLOUD se utilizan
a)
COPY_DATA
b)
CREATE_EXTERNAL_TABLE
c)
Data format
d)
Index storage
e)
Backup
91.
¿Qué dos diferencias hay en cuanto a optimización entre ATP y ADW?
a)
Undo Manage
b)
Memory usage
c)
Data format
d)
Index storage
e)
Backup
92.
Which three statements are true about procedures in the DBMS_CLOUD package? (Choose three.)
a)
The DBMS_CLOUD.PUT_OBJECT procedure copies a file from Cloud Object Storage to the Autonomous Data Warehouse. (descartada, sería al revés to/from)
b)
The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database.
c)
The DBMS_CLOUD.VALIDATE_EXTERNAL_TABLE procedure validates the source files for an external table, generates log information, and stores the rows that do not match the format options specified for the external table in a badfile table on Autonomous Data Warehouse.
d)
The DBMS_CLOUD.DELETE_FILE procedure removes the credentials file from the Autonomous Data Warehouse database. DBMS_CLOUD.DELETE_FILE no existe, sería DBMS_CLOUD.DROP_CREDENTIAL
e)
The DBMS_CLOUD.CREATE_EXTERNAL_TABLE procedure creates an external table on files in the cloud. You can run queries on external data from the Autonomous Data Warehouse
93.
Variante(*): La opción de GoldenGate puede dividirse en dos GG distintos(**) y no aparecer otras opciones, como “SQL*Loader”. Solución: Las tres opciones correctas serían las dos variantes de GG(**) y “Oracle Data Pump”. What are three methods to load data into the Autonomous Database? (Choose three.)
a)
Oracle GoldenGate <= SG p82
b)
Transportable Tablespace
c)
RMAN Restore
d)
Oracle Data Pump <= SG p143
e)
SQL*Loader <= SG p143
94.
Which three statements are correct when the Autonomous Database is stopped? (Choose three.)
a)
User with DWROLE can still access the database
b)
Tools are no longer able to connect to a stopped instance
c)
CPU billing is halted based on full-hour cycles of usage.
d)
In-flight transactions and queries are stopped
95.
Which three statements are true regarding how Autonomous Database provides data security? (Choose three.)
a)
Data is encrypted at rest using transparent data encryption
b)
Network connections from clients to Autonomous Database are encrypted using the client credentials wallet
c)

Users are given OS logons or SYSDBA privileges to prevent phishing attacking.

d)
Oracle automatically applies security updates to ensure data is not vulnerable to known attack vectors
96.
Which three tasks by default are taken care of by the Autonomous Database? (Choose three.)
a)
Backups
b)
Firmware Patching
c)
Data Loading
d)
Database Upgrades
e)
Application User Creation
97.
Migrating an on-premise database to Autonomous Database (ADB) for large amounts of data involves multiple steps like creating a credential object, creating (access to) a storage object/location, running datapump export and running a datapump import. Which three statements are true for SQL Developer (18.3 and up) in combination with ADB Data Loading? (Choose three.)
a)
SQL Developer can be used to export/move/import of a database to ADB in 1 set of wizard steps
b)
SQL Developer can import files (.dmp and .csv for example) into ADB which are located on Amazon S3 Object storage
c)
SQL Developer can import .csv files into ADB which are located on the system where SQL Developer is running
d)
SQL Developer can only export/move/import files using datapump from databases running on Linux systems
e)
Se puede ejecutar SQL Developer desde la consola
98.
Which three data dictionary views contain information about analylic view objects?
a)
ALL_ANALYTIC_VIEW_PATHS
b)
ALL_ANALYTIC_VIEW_DIM_CLASS
c)
ALL_ANALYTIC_VIEW_ID_ATTRS
d)
ALL_ANALYTIC_VIEW_LVLGRPS
e)
ALL_ANALYTIC_VIEW_KEYS
99.

How do you change the tablespace quota for a user on Autonomous Database on Shared Infrastructure? (Choose the best answer.)

a)

  • Execute alter tablespace DATA set quota = 10G;

b)

  • Execute alter tablespace for user MTHEO tablespace DATA quota = 10G;

c)

  • Execute DBMS_CLOUD_ADMIN.GRANT_TABLESPACE_QUOTA (username => 'MTHEO',tablespace_quota => 'UNLIMITED');

d)

  • Execute alter user MTHEO quota unlimited on tablespace DATA;

100.

When in the SQL Monitoring tab of the Performance Hub you see a clock icon in the status column.

What does this mean?

a)

  • The SQL statement is executing.

b)

  • The SQL statement did not complete either due to an error.

c)

  • The SQL statement is queued.

d)

  • The SQL statement completed its execution.

101.

Which Autonomous Database Service is NOT used to connect to an Autonomous Transaction Processing instance?

a)

  • HIGH

b)

  • TPPERFORMANT

c)

  • MEDIUM

d)

  • TPURGENT

e)

  • LOY

102.

Which three options are supported when migrating to Autonomous Database (ADB)?

a)

  • RMAN Cross-Platform backup and restore

b)

  • Golden Gate on-premise installation

c)

  • PDB unplug / plug operation

d)

  • Datapump export / import

e)

  • Golden Gate Cloud service

103.

Which two optimizations are different between Autonomous Data Warehouse and Autonomous Transaction Processing? (Choose two.)

a)

  • Backup Retention

b)

  • Index Storage

c)

  • Data Organization

d)

  • Memory Usage

e)

  • Undo Management

104.

To who, and in which order, are dedicated Exadata Infrastructure resources provisioned? (Choose the best answer.)

a)

  • Fleet Administrator, Autonomous Exadata Infrastructure -> Autonomous Container DB -> Database Administrator > Autonomous DB

b)

  • Fleet Administrator, Autonomous Exadata Infrastructure > Database Administrator -> Autonomous Container DB -> Autonomous DB

c)

  • Database Administrator, Autonomous Container DB -> Autonomous DB -> Fleet Administrator -> Autonomous Exadata Infrastructure

d)

  • Database Administrator, Autonomous Exadata Infrastructure -> Fleet Administrator -> Autonomous Container DB -> Autonomous DB

105.

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

106.

According to Oracle documentation, it is a best practice when planning and instituting Access Controls for your Autonomous Dedicated environment regarding
Subnets, Compartments and User Groups.
Which statement is true?

a)

  • Create at least 2 of each resource.

b)

  • Only 1 Subnet and 1 Compartment are allowed, multiple Groups highly advised.

c)

  • Only 1 of each is allowed to be allocated per environment.

d)

  • Create a Separate VCN that contains only public subnets.

107.

Which three Oracle Cloud Infrastructure (OCI) resources do you need to configure before provisioning your Autonomous Database with Private Endpoint?

(Choose three.)

a)

  • Security List

b)

  • Route Table

c)

  • Subnet

d)

  • VCN

e)

  • Network Security Group

108.

Which three event types are supported for Autonomous Database? (Choose three.)

a)

  • Update IORM Begin

b)

    • Maintenance Begin

c)

    • Terminate End

d)

  • Change Autoscaling Configuration Compartment

e)

  • Change Compartment Begin

109.

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? (Choose the best answer.)

a)

  • Create a new developer account.

b)

  • Access the APEX Administration Services and create the workspace for the developer.

c)

  • Create a database user with the APEX role.

d)

  • Create an IDCS user with the APEX role.

110.

What are two differentiators of Oracle Autonomous Database Dedicated Infrastructure?

a)

  • Users have OS access to the database machine.

b)

  • It offers greater control and isolation starting at the Exadata cloud infrastructure level.

c)

  • Users can customize the OS stack and add additional packages.

d)

  • Users have SYS privileges in the database.

e)

  • Users can customize the maintenance schedule.

111.

Oracle Data Safe is a unified control center for your Oracle databases which helps you understand the sensitivity of your data, evaluate risks to data, mask sensitive data, implement and monitor security controls, assess user security, monitor user activity, and address data security compliance requirements.
Which statement is FALSE? (Choose the best answer.)

a)

  • Oracle Data Safe helps you assess the security of your cloud database configurations by analyzing database configurations.

b)

  • Oracle Data Safe evaluates user types, how users are authenticated, and the password policies assigned to each user.

c)

  • Oracle Data Safe only supports Autonomous Databases.

d)

  • Oracle Data Safe helps you find sensitive data in your database by inspecting the actual data in your database and its data dictionary.

112.

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

a)

  • A clone database source can be a running database instance.

b)

  • A clone database source can be from a point-in-time backup that is less than 2 hours old.

c)

  • When cloning an Autonomous Database, Oracle Machine Learning workspaces, projects, and notebooks of the source database are cloned to the new database.

d)

  • After an Autonomous database is created using a clone, the network access option can be changed.

113.

Which statement is NOT correct when setting up compartment quotas?

a)

  • Compartment quotas use policies that allow allocation of resources with a high level of flexibility.

b)

  • Along with compartment budgets, compartment quotas create a powerful toolset to manage your spending.

c)

  • Compartment quotas are set by Oracle.

d)

  • There are three types of quota policy statements which are set, unset and zero.

114.

Which two statements are true about using an Autonomous Database with Private Endpoints? (Choose two.)

a)

  • Private Endpoints can be configured when you clone a Shared Autonomous Database that was initially created with public endpoints.

b)

  • You can configure Private Endpoints for an Always Free Autonomous Database.

c)

  • A Network Security Group is required within your Virtual Cloud Network before you can provision a Shared Autonomous Database to use Private Endpoints.

d)

  • An Autonomous Database with private endpoints can be accessed from the public internet by adding your ip address to an Access Control List.

115.

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? (Choose the best answer.)

a)

  • A. Delete the user.

b)

  • B. Rotate the instance wallet and share the new wallet with the remaining users.

c)

  • C. Shutdown and restart the instance.

d)

  • D. Trust the user who left to not access the database.

116.

Which workload type does the Autonomous Database on dedicated infrastructure service currently support?

a)

  • A. Autonomous Data Warehouse only

b)

  • B. Hybrid Columnar compression

c)

  • C. Autonomous Transaction Processing only

d)

  • D. ATP and ADW

117.

Which two statements are correct about Autonomous Data Warehouse on Shared Exadata Infrastructure?(Choose two.)

a)

  • A. You have direct access to the database node.

b)

  • B. Compression is enabled by default. Autonomous Data Warehouse uses Hybrid Columnar Compression for all tables by default.

c)

  • C. Oracle Database Result Cache is enabled by default for all SQL statements.

d)

  • D. Parallelism is not enabled by default.

118.

For someone that is not a service administrator to use SQL Developer Web, what package would you need to use to give them access?(Choose the best answer.)

a)

  • A. ORDS_ADMIN.GRANT_SCHEMA

b)

  • B. ORDS_ADMIN.ENABLE_SCHEMA

c)

  • C. SQLDEV_ADMIN.GRANT_SCHEMA

d)

  • D. ORDS_PRIV.ENABLE_SCHEMA

119.

The default eight-day retention period for Autonomous Database performance data can be modified using which DBMS_WORKLOAD_REPOSITORY subprogram procedure?

a)

A. UPDATE_OBJECT_INFO

b)

B. MODIFY_SNAPSHOT_SETTINGS

c)

C. CREATE_BASELINE_TEMPLATE

d)

D. MODIFY_BASELINE_WINDOW_SIZE

Similar Resources on Wayground

SOAL PPG 2022

120 questions

SOAL PPG 2022

quiz

Worksheet

•

Professional Development

Hamilton Quiz

120 questions

Hamilton Quiz

quiz

Worksheet

•

KG - Professional Dev...

BMET Course 110

121 questions

BMET Course 110

quiz

Worksheet

•

Professional Development

sinh vật và bảo vệ sinh vật

124 questions

sinh vật và bảo vệ sinh vật

quiz

Worksheet

•

Professional Development

CN-I MCQ test

117 questions

CN-I MCQ test

quiz

Worksheet

•

Professional Development

Unit20_CBT_Revision-B

121 questions

Unit20_CBT_Revision-B

quiz

Worksheet

•

Professional Development

SOLAR PRACTICE TEST

115 questions

SOLAR PRACTICE TEST

quiz

Worksheet

•

Professional Development