Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Oracle > Autonomous Database > Flashcards

Autonomous Database Flashcards

1
Q

Which three options are supported when migrating to Autonomous Database (ADB)? (Choose three.)
A. RMAN Cross-Platform backup and restore
B. Golden Gate on-premise installation
C. PDB unplug / plug operation
D. Datapump export / import
E. Dataguard Physical Standby
F. Golden Gate Cloud service

A

B. Golden Gate on-premise installation
D. Datapump export / import
F. Golden Gate Cloud service

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q 
Which Autonomous Database Service is NOT used to connect to an Autonomous Transaction Processing instance? (Choose the best answer.)
A. HIGH
B. TPPERFORMANT
C. MEDIUM
D. TPURGENT
E. LOW
A

B. TPPERFORMANT

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q 
Which can be Scaled independently of the number of CPUs in an Autonomous Database? (Choose the best answer.)
A. Sessions
B. Storage
C. Parallelism
D. Concurency
E. Memory
A

B Key Features

Fully elastic scaling: Scale compute and storage independently to fit your database workload with no downtime:

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

When in the SQL Monitoring tab of the Performance Hub you see a clock icon in the status column.
What does this mean? (Choose the best answer.)
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.

A

C)
https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/perfhub.htm

A spinning icon indicates that the SQL statement is running.
A green check mark icon indicates that the SQL statement completed its execution during the specified time period.
A red cross icon indicates that the SQL statement did not complete. The icon displays when an error occurs because the session was terminated.
A clock icon indicates that the SQL statement is queued.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Where can a userג€™s public ssh key be added on the Oracle Cloud Infrastructure Console in order to execute API calls? (Choose the best answer.)
A. SSH keys are not required in Oracle Cloud Infrastructure.
B. SSH keys cannot be added from console. They have to be added using REST APIs only.
C. On the Autonomous Database Console.
D. Navigate to Identity, select Users panel on the console and select “Add Public Key”

A

D. Navigate to Identity, select Users panel on the console and select “Add Public Key”

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q 
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
A

D. DBNAME_LOW

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q 
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
A

C. Data Organization

D. Memory Usage

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

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

A

A. Fleet Administrator, Autonomous Exadata Infrastructure -> Autonomous Container DB -> Database Administrator > Autonomous DB

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

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

A

A. Oracle Cloud Infrastructure Object Storage

E. Oracle Cloud Infrastructure Object Storage Classic

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

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

A

A. Create at least 2 of each resource.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q 
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
A

C. Subnet
D. VCN
E. Network Security Group

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Which two options are available to restore an Autonomous Data Warehouse? (Choose two.)
A. Select the snapshot of the backup.
B. Select the backup from which restore needs to be done.
C. Backup and recovery must be done using Recovery Manager (RMAN).
D. Select the archived redo logs.
E. Specify the point in time (timestamp) to restore.

A

B. Select the backup from which restore needs to be done.

E. Specify the point in time (timestamp) to restore.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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

A

B. Maintenance Begin
C. Terminate End
E. Change Compartment Begin

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

While Autonomous Transaction Processing and Autonomous Data Warehouse use the same Oracle database, which statement is true about the workloads?
(Choose the best answer.)
A. Data that is bulk loaded, by default, uses the row format in Autonomous Transaction Processing where Autonomous Data Warehouse data format is columnar.
B. Autonomous Data Warehouse workloads are optimized for mixed workloads.
C. Autonomous Transaction Processing memory Usage optimizes workloads for parallel joins and aggregations.
D. Autonomous Transaction Processing workloads are optimized for data warehouse, data mart, and data lake.

A

A. Data that is bulk loaded, by default, uses the row format in Autonomous Transaction Processing where Autonomous Data Warehouse data format is columnar.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

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.

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What are two differentiators of Oracle Autonomous Database Dedicated Infrastructure? (Choose two.)
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.

A

B. It offers greater control and isolation starting at the Exadata cloud infrastructure level.
E. Users can customize the maintenance schedule.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

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.

A

C. Oracle Data Safe only supports Autonomous Databases.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

Which statement is true when you provision an Autonomous Database using the cloning method? (Choose the best answer.)
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.

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

Which two methods can you use to create users and grant roles in Autonomous Database services? (Choose two.)
A. through SQLPlus
B. through SQL/Developer
C. through the Oracle Cloud Infrastructure service console
D. using DBMS_CLOUD_ADMIN Package

A

A. through SQLPlus

B. through SQL/Developer

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

Which statement is NOT correct when setting up compartment quotas? (Choose the best answer.)
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.

A

C. Compartment quotas are set by Oracle.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

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.

A

A. Private Endpoints can be configured when you clone a Shared Autonomous Database that was initially created with public endpoints.
C. A Network Security Group is required within your Virtual Cloud Network before you can provision a Shared Autonomous Database to use Private Endpoints.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

Which two statements are true when running DBMS_CLOUD.COPY_DATA? (Choose two.)
A. The source file will be automatically removed after the DBMS_CLOUD.COPY_DATA procedure finishes successfully.
B. The source files can reside in Oracle Object Storage, Amazon S3 Object storage, or Azure Blob storage.
C. The target table will be created in Autonomous Database if it does not already exist.
D. The source file can be in either Oracle Standard Storage or Oracle Archive Storage bucket in the Object Store.
E. A valid credential must be created prior to running the DBMS_CLOUD.COPY_DATA procedure.

A

B. The source files can reside in Oracle Object Storage, Amazon S3 Object storage, or Azure Blob storage.
E. A valid credential must be created prior to running the DBMS_CLOUD.COPY_DATA procedure.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

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;

A

C. Execute DBMS_CLOUD_ADMIN.GRANT_TABLESPACE_QUOTA (username => ג€˜MTHEOג€™,tablespace_quota => ג€˜UNLIMITEDג€™);

24
Q

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? (Choose the best answer.)
A. Since the application needs to be highly available, it should to be deployed on a Kubernetes Cluster.
B. ATP. Using ג€˜tpurgentג€™ and ג€˜highג€™ TNS services to separate connection types.
C. It is best to build a Separate data warehouse, and move the OLTP data on a nightly basis.
D. ADW since operational reporting is a higher priority in this scenario.

A

B. ATP. Using ג€˜tpurgentג€™ and ג€˜highג€™ TNS services to separate connection types.

25
Q

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. Delete the user.
B. Rotate the instance wallet and share the new wallet with the remaining users.
C. Shutdown and restart the instance.
D. Trust the user who left to not access the database.

A

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

26
Q

Which workload type does the Autonomous Database on dedicated infrastructure service currently support? (Choose the best answer.)
A. Autonomous Data Warehouse only
B. Hybrid Columnar compression
C. Autonomous Transaction Processing only
D. ATP and ADW

A

D. ATP and ADW

27
Q

Which two statements are correct about Autonomous Data Warehouse on Shared Exadata Infrastructure? (Choose two.)
A. You have direct access to the database node.
B. Compression is enabled by default. Autonomous Data Warehouse uses Hybrid Columnar Compression for all tables by default.
C. Oracle Database Result Cache is enabled by default for all SQL statements.
D. Parallelism is not enabled by default.

A

B. Compression is enabled by default. Autonomous Data Warehouse uses Hybrid Columnar Compression for all tables by default.
C. Oracle Database Result Cache is enabled by default for all SQL statements.

28
Q 
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. ORDS_ADMIN.GRANT_SCHEMA
B. ORDS_ADMIN.ENABLE_SCHEMA
C. SQLDEV_ADMIN.GRANT_SCHEMA
D. ORDS_PRIV.ENABLE_SCHEMA
A

B. ORDS_ADMIN.ENABLE_SCHEMA

29
Q
  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?
    a) MEDIUM
    b) TP
    c) HIGH
    d) TPURGENT
A

d) TPURGENT

30
Q
  1. Given the steps:
  2. Create Oracle Machine Learning User
  3. Create projects
  4. Create workspaces
  5. Create Notebooks
  6. Run SQL Scripts
    Which two steps are out of order when working with Oracle Machine learning?
    a) Run SQL Scripts
    b) Create Notebooks
    c) Create workspaces
    d) Create projects
    e) Create Oracle Machine Learning User
A

a) Run SQL Scripts

d) Create projects

31
Q
  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)?
    a) Unplug into a pdb archive which can be uploaded to object storage.
    b) Create a database link from source database to the ADB environment and clone the PDB.
    c) Pluggable databases cannot be migrated to ADB using plug, unplug or clone.
    d) Unplug to an xml file so database files and xml file can be uploaded to object storage.
A

c) Pluggable databases cannot be migrated to ADB using plug, unplug or clone.

32
Q
  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?
    a) Five. They are called tpurgent, tp, high, medium and low.
    b) Three. They are called high, medium and low.
    c) None. There are no pre-defined service names in tnsnames.ora.
    d) Two. They are called ATP and ADW.
A

a) Five. They are called tpurgent, tp, high, medium and low.

33
Q
  1. When you connect Oracle Analytics Cloud to the Autonomous Data Warehouse, what file needs to be uploaded?
    a) OJDBC.PROPERTIES
    b) CWALLET.SSO
    c) SQLNET.ORA
    d) TNSNAMES.ORA
A

b) CWALLET.SSO

34
Q
  1. Which statement is true in regards to database links?
    a) Connect from Autonomous Database to remote database using a database link.
    b) Connect to Autonomous Database from remote database using a database link.
    c) You can call PL/SQL procedures and functions using a database link.
    d) Create a database link from one Autonomous Database to another Autonomous Database instance.
A

b) Connect to Autonomous Database from remote database using a database link.

35
Q
  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)?
    a) Unplug into a pdb archive which can be uploaded to object storage.
    b) Create a database link from source database to the ADB environment and clone the PDB.
    c) Pluggable databases cannot be migrated to ADB using plug, unplug or clone.
    d) Unplug to an xml file so database files and xml file can be uploaded to object storage.
A

b) Create a database link from source database to the ADB environment and clone the PDB.

36
Q

When running lots of high concurrent wueries in ADB- what predefined service?

A

DBNAME_LOW

37
Q

Clock Item on the Status Column

A

SQL Statement is queued

38
Q

Which ADB is not used to connect to ATP Instance

A

TPPERFORMANT

39
Q

Where can a User’s public key be added

A

Identity - select user panel on the console - “Add Public Key”

40
Q

Autonomous Database’s auto scaling feature allows your database to use up to three times the current base number of CPU cores at any time. As demand
increases, auto scaling automatically increases the number of cores in use. Likewise, as demand drops, auto scaling automatically decreases the number of cores
in use.
Which statement is FALSE regarding the auto scaling feature?
A. For databases on dedicated Exadata infrastructure, the maximum number of cores is limited by the number of free cores that aren’t being used by other auto
scaling databases to meet high-load demands.
B. The base number of OCPU cores allocated to a database is not guaranteed.
C. For databases on dedicated Exadata infrastructure, the maximum number of cores available to a database depends on the total number of cores available in
the Exadata infrastructure instance.
D. Auto scaling is enabled by default and can be enabled or disabled at any time.

A

A. For databases on dedicated Exadata infrastructure, the maximum number of cores is limited by the number of free cores that aren’t being used by other auto
scaling databases to meet high-load demands.

41
Q

You have an Autonomous Transaction Processing Database with three OCPUs and auto scaling turned on and your application is using the TPURGENT service.
The load on the database increases from three OCPUs to nine OCPUs.
What is the total number of concurrent statements that the TPURGENT service can support?
A. 900
B. 1800
C. 2700
D. 1500

A

2700

42
Q

How can an Autonomous Database resource be provisioned without logging into the Oracle Cloud Infrastructure console?
A. It cannot be done.
B. Using Database Configuration Assistant (DBCA) on the database server.
C. Using the Oracle Cloud Infrastructure Command Line interface tool or REST API calls.
D. Connecting to the Cloud Infrastructure Command console via SSH wallet

A

C. Using the Oracle Cloud Infrastructure Command Line interface tool or REST API calls.

43
Q

You have a requirement to create an Autonomous Transaction Processing database that can support at least 200 concurrent statements per OCPU as well as
parallelism.
Which service will you need to connect to?
A. TPURGENT
B. TP
C. MEDIUM
D. LOW

A

TPURGENT

44
Q

Define TPURGENT, TP, High, Medium, LOW

A

tpurgent 300 × number of OCPUs Parallelism Yes
tp 300 × number of OCPUs No
high 3 Subject to queing
medium 1.26 × number of OCPUs Parallelism Limit 4
low 300 × number of OCPUs No

45
Q 
Which three security features are available in Oracle Autonomous Database Shared Infrastructure?
A. Transparent Data Encryption
B. Database Vault
C. Customer Managed Keys
D. Data Redaction
E. Audit Vault
A

A. Transparent Data Encryption
B. Database Vault
C. Customer Managed Keys

46
Q

Which two statements are correct about Autonomous Data Warehouse on Shared Exadata Infrastructure?
A. Parallelism is not enabled by default.
B. Compression is enabled by default
C. Autonomous Data Warehouse uses Hybrid Columnar Compression for all tables by default.
D. Oracle Database Result Cache is enabled by default for all SQL statements.
E. You have direct access to the database node.

A

A. Parallelism is not enabled by default.

B. Compression is enabled by default

47
Q

Which two are correct actions to take in order to Download the Autonomous Database Credentials?
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. Click the Compute section of the menu, then choose Instance Configurations, then Download Wallet.
D. Click on the Object Storage and find your Autonomous Bucket and Download the Wallet Credentials.
E. Find the Service Console for your Autonomous Database, then pick Administration, then Download the Client Credentials (Wallet).

A

A. Click on the Autonomous Data Warehouse in the menu, click a database name, then Choose DB Connection button, then Download the Wallet.
E. Find the Service Console for your Autonomous Database, then pick Administration, then Download the Client Credentials (Wallet).

48
Q

Which two statements are FALSE about creating a metadata-only clone with a private endpoint network access option?
A. Current settings for ACLs are cloned.
B. Clone can be in a different region.
C. All OML notebooks are cloned.
D. All underlying data for OML notebooks is cloned.
E. All resource management rules are cloned.

A

C. All OML notebooks are cloned.

E. All resource management rules are cloned.

49
Q 
When using Data Pump to migrate your Oracle database to Autonomous Database, which two objects are imported?
A. Data
B. Schemas
C. Tablespaces
D. Reports
A

A. Data

B. Schemas

50
Q

NEW QUESTION 19
What is the correct way to list all files in the default data pump directory?
A. By executing select * from DBMS_CLOUD.LIST_FILES(‘DATA_PUMP_DIR’);
B. You cannot list files in the default data pump directory from Autonomous Data Warehouse (ADW).
C. Log onto ADW server and issue is -al on the command line.
D. By executing select * from utl_file . list ( ‘DATA_PUMP_DIR ‘ ) ;

A

A. By executing select * from DBMS_CLOUD.LIST_FILES(‘DATA_PUMP_DIR’);

51
Q

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. AT
E. Using ‘tpurgent’ and ‘high’ TNS services to separate connection types.

A

D. AT

52
Q

What command should you issue to enable application continuity on Autonomous Database Shared Infrastructure?
A. alter database set application_continuity=true
B. alter session set application_continuity=true
C. exec dbms_cloucl_admi
D. enable_app_cont ( ‘ ‘ ) ;
E. alter system set application_continuity=true

A

D. enable_app_cont ( ‘ ‘ ) ;

53
Q

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

A

D. Data that is bulk loaded, by default, uses the row format in Autonomous Transaction Processing where Autonomous Data Warehouse data format is columnar

54
Q

Which statement is FALSE about Autonomous Database Maintenance on dedicated Exadata infrastructure?
A. If a scheduled container database maintenance run cannot take place, Oracle will automatically reschedule the container database maintenance for the
following quarter.
B. Autonomous Exadata Infrastructure maintenance takes place at least once each quarter and is mandatory.
C. You can change your container database maintenance window or reschedule a single container database maintenance run to ensure that your container
database maintenance runs follow infrastructure maintenance within the same quarter.
D. Autonomous Exadata Infrastructure maintenance runs are for infrastructure patching (including patching of the Exadata grid infrastructure code and operating
systems updates), and include database patching.

A

D. Autonomous Exadata Infrastructure maintenance runs are for infrastructure patching (including patching of the Exadata grid infrastructure code and operating
systems updates), and include database patching.

55
Q

Which statement is NOT correct when using Automatic Indexing on Autonomous Data Warehouse?
A. Process includes identify candidates, create invisible auto indexes , verify with implement if performance improved and delete unused.
B. You can use the dbms_auto_index package to report on the automatic task and to set your preferences.
C. It is enabled by default.
D. You can control behavior at the statement level using the use_aoto_indexes or NO_USE_AUTO_INDEXES hints.
E. The indexing feature is implemented as an automatic task that runs at a fixed interval.

A

E. The indexing feature is implemented as an automatic task that runs at a fixed interval.

56
Q 
Which data file format is NOT supported when using the package DBMS_CLOUD on Shared Exadata Infrastructure?
A. Data Pump Export File
B. Avro
C. Parquet
D. Text
E. JSON
F. Microsoft SQL Server (.mdf)
A

Avro

Oracle (8 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions