1Z0-931 Oracle Autonomous Database Cloud 2019 Specialist

Questão 1 de 68

1

What are two advantages of using Data Pump to migrate your Oracle Databases to Autonomous Database? (Choose two.)

Selecione uma ou mais das seguintes:

Data Pump can exclude migration of objects like indexes and materialized views that are not needed by Autonomous Database.
Data Pump is platform independent - it can migrate Oracle Databases running on any platform.
Data Pump is faster to migrate database than using RMAN (= Recovery MANager).
Data Pump creates the tablespaces used by your Autonomous Database.

Explicação

Questão 2 de 68

1

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

Selecione uma das seguintes:

UPDATE_OBJECT_INFO
MODIFY_SNAPSHOT_SETTINGS
CREATE_BASELINE_TEMPLATE
MODIFY_BASELINE_WINDOW_SIZE

Explicação

Questão 3 de 68

1

Which task is NOT automatically performed by the Oracle Autonomous Database?

Selecione uma das seguintes:

Backing up the database.
Mask your sensitive data.
Patching the database.
Automatically optimize the workload.

Explicação

Questão 4 de 68

1

Which three statements are true about procedures in the DBMS_CLOUD package? (Choose three.)

Selecione uma ou mais das seguintes:

The DBMS_CLOUD.PUT_OBJECT procedure copies a file from Cloud Object Storage to the Autonomous Data Warehouse
The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database.
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.
The DBMS_CLOUD.DELETE_FILE procedure removes the credentials file from the Autonomous Data Warehouse database
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.

Explicação

Questão 5 de 68

1

Which of these database features is NOT part of the Autonomous Database?

Selecione uma das seguintes:

Online Indexing
Flashback Database
Real Application Clusters (RAC)
Java in the Database

Explicação

Questão 6 de 68

1

Which two statements are true with regards to Oracle Data Sync? (Choose two.)

Selecione uma ou mais das seguintes:

Data Sync can connect to any JDBC compatible source like MongoDB, RedShift and Sybase.
Data Sync can use a normal OCI (thick) client connection to connect to an Oracle database.
Data Sync can load your data in parallel in order to speed up the loading process.
Data Sync has default drivers available that supported loading data from DB2, Microsoft SQL Server, MySQL and Teradata.

Explicação

Questão 7 de 68

1

Which statement is false about Autonomous Database Oracle Client Credentials (Wallets)?

Selecione uma das seguintes:

In addition to the Oracle Client Credential Wallet, a user must have a username and password in order to connect to the Autonomous Database.
The Oracle Client Credential file is downloaded as a ZIP file
The Wallet for the Autonomous Database is the same as the Transparent Data Encryption (TDE) wallet.
You MUST have an Oracle Client Credential Wallet in order to connect to the Autonomous Database.

Explicação

Questão 8 de 68

1

What is the predefined role that exists in Autonomous Database that includes common privileges that are used by a Data Warehouse developer?

Selecione uma das seguintes:

ADBDEV
ADMIN
DWROLE
ADWC

Explicação

Questão 9 de 68

1

Which two system privileges does a user need to create analytic views? (Choose two.)

Selecione uma ou mais das seguintes:

CREATE ANALYTIC MEASURE
CREATE ANALYTIC LEVEL
CREATE ANALYTIC HIERARCHY
CREATE ANALYTIC VIEW
CREATE ATTRIBUTE DIMENSION

Explicação

Questão 10 de 68

1

What are three methods to load data into the Autonomous Database? (Choose three.)

Selecione uma ou mais das seguintes:

Oracle GoldenGate
Transportable Tablespace
RMAN Restore
Oracle Data Pump
SQL*Loader
MV2ADB

Explicação

Questão 11 de 68

1

While Autonomous Transaction Processing and Autonomous Data Warehouse use the same Oracle database, which statement is true about the workloads?

Selecione uma das seguintes:

Autonomous Transaction Processing memory usage optimizes workloads for parallel joins and aggregations
Autonomous Data Warehouse workloads are optimized for mixed workloads
Autonomous Transaction Processing workloads are optimized for data warehouse, data mart, and data lake.
Data that is bulk loaded, by default, uses the row format in Autonomous Transaction Processing where Autonomous Data Warehouse data format is columnar

Explicação

Questão 12 de 68

1

When scaling OCPUs in Autonomous Database, which statement is true in regards to active transactions?

Selecione uma das seguintes:

Active transactions continue running unaffected
Active transactions are paused
Scaling cannot happen while there are active transactions in the database
Active transactions are terminated and rolled back

Explicação

Questão 13 de 68

1

Which three statements are correct when the Autonomous Database is stopped? (Choose three.)

Selecione uma ou mais das seguintes:

User with DWROLE can still access the database
Tools are no longer able to connect to a stopped instance
CPU billing is halted based on full-hour cycles of usage
In-flight transactions and queries are stopped

Explicação

Questão 14 de 68

1

Which two are correct actions to take in order to Download the Autonomous Database Credentials? (Choose two.)

Selecione uma ou mais das seguintes:

Click on the Autonomous Data Warehouse in the menu, click a database name, then Choose DB Connection button, then Download the Wallet
Click on the Autonomous Data Warehouse section, pick a database, then Choose Actions, then Download the Wallet
Find the Service Console for your Autonomous Database, then pick Administration, then Download the Client Credentials (Wallet).
Click on the Object Storage and find your Autonomous Bucket and Download the Wallet Credentials.
Click the Compute section of the menu, then choose Instance Configurations, then Download Wallet

Explicação

Questão 15 de 68

1

How many pre-defined service names are configured in tnsnames.ora for a single Autonomous Transaction Processing database instance, and what are they called?

Selecione uma das seguintes:

Two. They are called ATP and ADW.
None. There are no pre-defined service names in tnsnames.ora
Three. They are called high, medium and low
Five. They are called tpurgent, tp, high, medium and low

Explicação

Questão 16 de 68

1

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?

Selecione uma das seguintes:

tnsnames.ora
keystore.jks
sqlnet.ora
cwallet.sso
ojdbc.properties

Explicação

Questão 17 de 68

1

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?

Selecione uma das seguintes:

Data Sync can only load files into tables (insert-only), the customer has to write the additional code.
Data Sync can not transform your data while loading it into the destination table
Data Sync can load a combination of data source, such as .csv, .xlsx and Oracle relational files
Data Sync can only load data from one source into one destination table

Explicação

Questão 18 de 68

1

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?

Selecione uma das seguintes:

The migration can be technically a success but the 3-rd party vendor needs to support the result
The suggested datapump version will create an alias for non-standard tablespace names so the migration is successful.
The tablespace names will result in a blocking error during datapump import because of ADB limitations
The migration can be a success, both technically and functional due to datapump enhancements

Explicação

Questão 19 de 68

1

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?

Selecione uma das seguintes:

Migration to ADB is not possible using Golden Gate because the apply-process cannot be installed on ADB
Only the migration to ADB is possible from an on-premise installation of Golden Gate
Golden Gate on premise is not certified with ADB because Golden Gate Cloud Service exists for this
The fallback scenario is not possible using Golden Gate because the capture-process cannot be installed on ADB
The described scenario is correct, can be used for migration and fallback scenarios

Explicação

Questão 20 de 68

1

Which statement is true regarding database client credentials file required to connect to your Autonomous Database?

Selecione uma das seguintes:

Place the credential files on a share drive that all users can use to connect to the database
The Transparent Data Encryption (TDE) wallet can be used for your client credentials to connect to your database
Store credential files in a secure location and share the files only with authorized users to prevent unauthorized access to the database
When you share the credential files with authorized users, mail the wallet password and the file in the same email

Explicação

Questão 21 de 68

1

In which way can a SQL Developer help you test your data loading scenario to Autonomous Database (ADB)?

Selecione uma das seguintes:

In the TEST phase of the wizard, a subset of accepted records is displayed based on your definition
In the TEST phase of the wizard a list is generated containing the records that would be rejected during import.
In the Column Definition Phase, the system cross-references with the file-contents and shows the conflicts with the definition
In the TEST phase, a temporary table will be populated with the records before inserting them in the destination table

Explicação

Questão 22 de 68

1

Where can a user's public ssh key be added on the Oracle Cloud Infrastructure Console in order to execute API calls?

Selecione uma das seguintes:

On the Autonomous Database Console
SSH keys are not required in Oracle Cloud Infrastructure
SSH keys cannot be added from console. They have to be added using REST APIs only
Navigate to Identity, select Users panel on the console and select "Add Public Key"

Explicação

Questão 23 de 68

1

Which statement is true in regards to database links?

Selecione uma das seguintes:

You can call PL/SQL procedures and functions using a database link
Connect from Autonomous Database to remote database using a database link
Connect to Autonomous Database from remote database using a database link
Create a database link from one Autonomous Database to another Autonomous Database instance

Explicação

Questão 24 de 68

1

How can an Autonomous Database resource be provisioned without logging into the Oracle Cloud Infrastructure console?

Selecione uma das seguintes:

Using Database Configuration Assistant (DBCA) on the database server.
It cannot be done
Connecting to the Cloud Infrastructure Command console via SSH wallet
Using the Oracle Cloud Infrastructure Command Line interface tool or REST API calls

Explicação

Questão 25 de 68

1

Which Autonomous Database Cloud service ignores hints in SQL Statements by default?

Selecione uma das seguintes:

Autonomous Transaction Processing
Autonomous Data Warehouse
Neither service ignores hints by default
Both services ignore hints by default

Explicação

Questão 26 de 68

1

Once you have a connection to the Autonomous Data Warehouse, how do you import tables into the Oracle Analytics Cloud (OAC)?

Selecione uma das seguintes:

Replicate the table using Golden Gate
Create a Data Set
Load data using Data Pump
Import Table

Explicação

Questão 27 de 68

1

Which is correct about security features that are available in Oracle Autonomous Database?

Selecione uma das seguintes:

TDE but not Data Redaction
Data Redaction and TDE are both supported
Data Redaction but not TDE
Neither Data Redaction nor TDE are supported

Explicação

Questão 28 de 68

1

What is the default retention period for both Automatic and Manual Autonomous Database Backups?

Selecione uma das seguintes:

One Year
7 days
60 days
30 days
90 days

Explicação

Questão 29 de 68

1

Which three statements are true regarding how Autonomous Database provides data security? (Choose three.)

Selecione uma ou mais das seguintes:

Data is encrypted at rest using transparent data encryption
Network connections from clients to Autonomous Database are encrypted using the client credentials wallet.
Users are given OS logons or SYSDBA privileges to prevent phishing attacking
Oracle automatically applies security updates to ensure data is not vulnerable to known attack vectors

Explicação

Questão 30 de 68

1

When exporting a notebook, what type of file is created?

Selecione uma das seguintes:

XML
TXT
JSON
SQL
ASCII

Explicação

Questão 31 de 68

1

What two tasks can be executed from the service console for Autonomous Databases? (Choose two.)

Selecione uma ou mais das seguintes:

Autonomous Databases monitoring for usage and query performance
Creating schemas
Creating and scaling of Autonomous Database service
Wizard to download connection wallet for connection from desktop tools

Explicação

Questão 32 de 68

1

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?

Selecione uma das seguintes:

SCOTT
ADMIN
SYS
DWDEV

Explicação

Questão 33 de 68

1

What REST verb is used to create an Autonomous Database service using REST APIs?

Selecione uma das seguintes:

A "POST" REST call
A "PUT" REST call
An "INSERT" REST call
A "GET" REST call

Explicação

Questão 34 de 68

1

Which operating system can Data Visualization Desktop be run on?

Selecione uma das seguintes:

AIX
Linux
Windows
Solaris

Explicação

Questão 35 de 68

1

Which two PL/SQL functions can be used to validate an analytic view? (Choose two.)

Selecione uma ou mais das seguintes:

VALIDATE_LEVELS
VALIDATE_HIERARCHY
VALIDATE_DIMENSION
VALIDATE_ANALYTIC_VIEW
VALIDATE_MEASURES

Explicação

Questão 36 de 68

1

Which three tasks by default are taken care of by the Autonomous Database? (Choose three.)

Selecione uma ou mais das seguintes:

Backups
Firmware Patching
Data Loading
Database Upgrades
Application User Creation

Explicação

Questão 37 de 68

1

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?

Selecione uma das seguintes:

Since the application needs to be highly available, it should to be deployed on a Kubernetes Cluster
ADW since operational reporting is a higher priority in this scenario
It is best to build a separate data warehouse, and move the OLTP data on a nightly basis
ATP. Using 'tpurgent' and 'high' TNS services to separate connection types

Explicação

Questão 38 de 68

1

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?

Selecione uma das seguintes:

HIGH
TP
MEDIUM
TPURGENT

Explicação

Questão 39 de 68

1

Which two statements are true when running DBMS_CLOUD.COPY_DATA? (Choose two.)

Selecione uma ou mais das seguintes:

The source file can be in either Oracle Standard Storage or Oracle Archive Storage bucket in the Object Store.
The source files can reside in Oracle Object Storage, Amazon S3 Object storage, or Azure Blob storage
A valid credential must be created prior to running the DBMS_CLOUD.COPY_DATA procedure
The source file will be automatically removed after the DBMS_CLOUD.COPY_DATA procedure finishes successfully
The target table will be created in Autonomous Database if it does not already exist

Explicação

Questão 40 de 68

1

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?

Selecione uma das seguintes:

In Autonomous Data Warehouse direct access to the database node and the local file system is allowed
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
Adding, removing, or modifying tablespaces is allowed
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

Explicação

Questão 41 de 68

1

What are two security features enabled by default by the Autonomous Database?
(Choose two.)

Selecione uma ou mais das seguintes:

Transparent Data Encryption
Encrypted Database Links
SQL Net Encryption
One SYSDBA account
Read Only access to OS Audit logs

Explicação

Questão 42 de 68

1

Which method can be used to migrate on-premises databases to Autonomous Databases in cloud?

Selecione uma das seguintes:

Original Import/Export tools
Physical migration method like database cloning
Data Pump
RMAN backup & restore

Explicação

Questão 43 de 68

1

Which two statements are true about the Oracle Cloud Infrastructure (OCI)? (Choose two.)

Selecione uma ou mais das seguintes:

An OCI region is a localized geographic area, and an availability domain is one or more data centers located within a region
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
A single fault domain can be associated with multiple regions and availability domains
Regions are dependent on other regions and must be located with 5 thousand kilometers of each other

Explicação

Questão 44 de 68

1

Which two methods can you use to create users and grant roles in Autonomous Database services? (Choose two.)

Selecione uma ou mais das seguintes:

through the Oracle Cloud Infrastructure service console
through SQL/Developer s
using DBMS_CLOUD_ADMIN package
through SQLPIus

Explicação

Questão 45 de 68

1

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

Selecione uma das seguintes:

TPURGENT
MEDIUM
HIGH
LOW
TPPERFORMANT

Explicação

Questão 46 de 68

1

When you choose to scale your Autonomous Database, which statement is true in regards to OCPUs and storage?

Selecione uma das seguintes:

Storage in TB cannot be larger than the number of OCPUs
OCPUs and storage must remain in sync
Increasing OCPUs will automatically increase storage
OCPUs and storage can be scaled independently

Explicação

Questão 47 de 68

1

Which two options are available to restore an Autonomous Data Warehouse? (Choose two.)

Selecione uma ou mais das seguintes:

Backup and recovery must be done using Recovery Manager(RMAN).
Select the snapshot of the backup.
Select the archived redo logs.
Select the backup from which restore needs to be done
Specify the point in time (timestamp) to restore.

Explicação

Questão 48 de 68

1

Which is NOT required to connect to Autonomous Database from SQL developer?

Selecione uma das seguintes:

Database name
Service name
Wallet file
Username and password

Explicação

Questão 49 de 68

1

What are the two methods that could be used during the migration of your existing Oracle database to Autonomous Database? (Choose two.)

Selecione uma ou mais das seguintes:

Golden Gate
Recovery Manager (RMAN)
CSV files copied to Autonomous Database block storage
Data Pump

Explicação

Questão 50 de 68

1

Which open source orchestration tool can be used to provision autonomous database resources in Oracle Cloud Infrastructure?

Selecione uma das seguintes:

Terraform
REST API
Dlocker
Enterprise Manager

Explicação

Questão 51 de 68

1

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?

Selecione uma das seguintes:

Create, Query, Update, List, Start
Create, Get, List, Stop, Restore
Start, Delete, Update, Query, Stop
Create, Query, List, Stop, Restore

Explicação

Questão 52 de 68

1

What two methods can you use to define Machine Learning Users? (Choose two.)

Selecione uma ou mais das seguintes:

Use DBMS_CLOUD_ADMIN package
SQL/Developer
Oracle Cloud Infrastructure Console
Client tools

Explicação

Questão 53 de 68

1

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.)

Selecione uma ou mais das seguintes:

SQL Developer can be used to export/move/import of a database to ADB in 1 set of wizard steps
SQL Developer can import files (.dmp and .csv for example) into ADB which are located on Amazon S3 Object storage
SQL Developer can import .csv files into ADB which are located on the system where SQL Developer is running
SQL Developer can only export/move/import files using datapump from databases running on Linux systems
Se puede ejecutar SQL Developer desde la consola

Explicação

Questão 54 de 68

1

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?

Selecione uma das seguintes:

18.1 onwards
Any version
17.4 onwards
12c Release 2 onwards

Explicação

Questão 55 de 68

1

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)?

Selecione uma das seguintes:

Pluggable databases cannot be migrated to ADB using plug, unplug or clone
Create a database link from source database to the ADB environment and clone the PDB.
Unplug to an xml file so database files and xml file can be uploaded to object storage
Unplug into a pdb archive which can be uploaded to object storage

Explicação

Questão 56 de 68

1

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.)

Selecione uma ou mais das seguintes:

Create Oracle Machine Learning User
Create workspaces
Create Notebooks
Run SQL Scripts
Create projects

Explicação

Questão 57 de 68

1

Which can be Scaled independently of the number of CPUs in an Autonomous Database?

Selecione uma das seguintes:

Memory
Concurrency
Sessions
Parallelism
Storage

Explicação

Questão 58 de 68

1

Which statement about the Export Wizard used to export database objects and data is NOT correct?

Selecione uma das seguintes:

If "Dependents" is checked as a DDL Option, for non-privileged users, only dependent objects in their schema are exported.
Export DDL includes features such as "Show schema," "Storage," and "Terminator."
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
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

Explicação

Questão 59 de 68

1

When you connect Oracle Analytics Cloud to the Autonomous Data Warehouse, what file needs to be uploaded?

Selecione uma das seguintes:

TNSNAMES.ORA
CWALLET.SSO
OJDBC.PROPERTIES
SQLNET.ORA

Explicação

Questão 60 de 68

1

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?

Selecione uma das seguintes:

Medium provides intermediate resource and concurrency, and queries run in a serial
Low provides highest concurrency, lowest resources, and DoP =1
High provides highest resources, lowest concurrency, and DoP is 1
High provides highest concurrency and lowest resources, and DoP is 1

Explicação

Questão 61 de 68

1

When running lots of high concurrent queries in Autonomous Database, you should use which predefined service connection?

Selecione uma das seguintes:

DBNAME_MEDIUM
DBNAME_HIGH
DBNAME_CONCURRENT
DBNAME_LOW

Explicação

Questão 62 de 68

1

Which three data dictionary views contain information about analylic view objects?

Selecione uma ou mais das seguintes:

ALL_ANALYTIC_VIEW_PATHS
ALL_ANALYTIC_VIEW_DIM_CLASS
ALL_ANALYTIC_VIEW_ID_ATTRS
ALL_ANALYTIC_VIEW_LVLGRPS
ALL_ANALYTIC_VIEW_KEYS

Explicação

Questão 63 de 68

1

Which is the default port number for ADW and ATP?

Selecione uma das seguintes:

1521
1522
1523
1524
1525
1526

Explicação

Questão 64 de 68

1

Depending on your JDBC or UCP connections are set up, you will need to do some of the following.

Selecione uma das seguintes:

You will need JDK 8 or higher, specifically the JDK8u161 or higher, installed.
Also, there are specific JAR files needed to be in place.
If you're using JDBC Thin Driver 12.2.0.1 ojdbc8.jar, then you will need the 12.2.0 upc.jar.
If you're using the patched JDBC Thin Driver 12.1.0.2 ojdbc7.jar, then you will need the 12.1.0.2 upc.jar.

Explicação

Questão 65 de 68

1

Elementos que te llevas al importar en Data Pump (Elegir 2 opciones)

Selecione uma ou mais das seguintes:

Data
Schema
Tablespaces

Explicação

Questão 66 de 68

1

Sobre que infraestructura esta funcionando ADB:

Selecione uma das seguintes:

Bar-metal
Exadata
Oracle Linux

Explicação

Questão 67 de 68

1

A la hora de cargar datos, que procedimientos de DBMS_CLOUD se utilizan (elegir 2)

Selecione uma ou mais das seguintes:

COPY_DATA
CREATE_EXTERNAL_TABLE
GET_DATA
CREATE TABLE AS SELECT

Explicação

Questão 68 de 68

1

¿Qué dos diferencias hay en cuanto a optimización entre ATP y ADW?

Selecione uma ou mais das seguintes:

Undo Manage
Memory usage
Data format
Index storage
Backup

	Criado por Dani Rodrigáñez mais de 4 anos atrás