Database Cloud Service 1Z0-1093-21 Practice Test Engine Try These 56 Exam Questions [Q30-Q49] : Exams Labs Braindumps : http://blog.examslabs.com

NO.30 Which two circumstances are FALSE when you use the Console to recover a DB system database from a backup stored in Oracle Cloud Infrastructure Object Storage? (Choose all correct answers)

The pp system has no access to the Oracle Cloud Infrastructure Object Storage service location where the backup is stored.

You want to restore to an existing System Change Number (SCN).

Data Guard must be disabled, or you must first remove the Data Guard association by terminating the standby database before you can restore the database.

Restore the database from an unmanaged backup in Object Storage created directly by using RMAN.

Restore the database from a backup in Object Storage that was created by using the Console or the API.

NO.31 How many IP addresses do you need at a minimum for the client subnet when you plan to have four Exadata compute nodes on Exadata Cloud Service?

NO.32 Which tool should you use to run the LIST FLASHCACHE DETAIL command in the Exadata Cloud Service environment?

cellcli

OCI CLI

dbaascli

exacli

NO.33 Which three actions can you perform on a DB system that has an Oracle Data Guard association with a standby database?
(Choose all correct answers)

If the primary database becomes unavailable, then you can use Oracle Data Guard to fail over the standby database to the primary role.

You can write on both primary and standby databases because DB system standby databases in Oracle Cloud Infrastructure Database are logical standbys.

You can terminate a primary database DB system.

You can use the reinstate command to return a failed database into standby role after correcting the cause of failure.

You can switch over the primary database to the standby role, perform maintenance on the standby database, and then switch it back to the primary role.

NO.34 Which network is used to facilitate the secure monitoring and administration of Oracle-managed infrastructure components in Exadata Cloud@Customer?

InfiniBand network

Backup network

Client network

Control plane network

Cloud operations network

NO.35 You enable automatic backups on your Exadata Cloud@Customer.?

database archivelog files

database control files

Transparent Data Encryption (TDE) keystore (wallet)

server parameter file (SP file)

NO.36 What permissions do you need to perform actions on a NoSQL table?

NOSQL_TABLE_INSPECT, NOSQL_TABLE_UPDATE

NOSQL_TABLE_WRITE, NOSQL_ROWS_INSERT

NOSQL_TABLE_DESTROY, NOSQL_TABLE_ALTER

NOSQL_ROWS_READ, NOSQL_ROWS_DELETE

NO.37 You want to connect to your MySQL DB system’s endpoint. You create an Oracle Linux compute instance on the same Virtual Cloud Network as your MySQL DB system. Which TWO actions must you perform to connect to your MySQL Database Service system? (Choose all correct answers)

Install the MySQL client on your local computer.

Define a SQL Developer connection in your MySQL Database Service database system.

Connect to your database system by using the MySQL client on the Linux compute instance.

ssh into the compute instance from your local machine.

NO.38 You notice that throttling is occurring on your NoSQL Database Cloud Service. What must you increase to solve this?

storage capacity

index size

OCPU for all servers in the cluster

NO.39 Which FOUR storage options are available in Oracle Cloud Infrastructure (OCI)? (Choose all correct answers)

Local storage

Object Storage

EFS Storage

Block Storage

File Storage

EBS Storage

NO.40 You want to move an Exadata Cloud@Customer VM cluster to a different OCI compartment for increased isolation from other teams that use Exadata. What happens when you use the console to do this?

The VM cluster and associated databases will move to the new compartment. All other resources will remain in the existing compartment.

After it is deployed, a VM cluster cannot change compartments.

The vm cluster, compute nodes, and associated databases will move compartments. All other resources will remain in the existing compartment.

The vM cluster, compute nodes, and underlying Exadata infrastructure will move to the new compartment. All other resources remain the same.

NO.41 What TWO reasons do you need a minimum of three storage cells when using Exadata Cloud Service?
(Choose all correct answers)

for high availability

for Fast Start Failover of storage cells

for Data Guard

for Real Application Clusters

for triple mirroring of data

NO.42 Which THREE are prerequisites for using the MySQL Database Service? (Choose all correct answers)

You must create a tenancy and be able to sign in to it.

You must download the latest MySQL version from https://edelivery.oracle.com/.

You or your group must be granted the policies described in Mandatory Policies.

You must install the downloaded MySQL version onto Oracle Cloud Infrastructure.

You must create a compartment to store your resources.

NO.43 When you created your development database on Exadata Cloud@Customer, you selected “None” for backup location during provisioning. You now need to enable automatic backups on the development database with a retention period of 45 days. Which action should you perform?

No action can be taken, because a new backup location cannot be set after creation.

Change the database backup location to local storage backups and set retention to 45 days.

Change the database backup location to an NFS backup location with a 45-day retention period set.

Change the database backup location to Object Storage with the default retention period set.

NO.44 In addition to the automatic backup of your Oracle Database associated with a database deployment, you are planning to take an on-demand backup of a database on Exadata Cloud Service. How do you do this?

Disable the automatic backup configuration and then take an on-demand backup.

First connect to the Exadata Cloud Instance as the oracle user and then take a backup.

Use the Create Backup button in the backup section of the Database Details page.

Perform a recovery operation to a specific long-term backup.

NO.45 Which statement is FALSE about using compartments?

They allow you to isolate resources.

They can be used to secure resources.

They can be organized in a hierarchical fashion.

They are a physical concept that separates users.

NO.46 You are considering whether or not to implement bare metal or virtual machine shapes. Which TWO statements are true about bare metal and virtual machine (VM) database (DB) systems? (Choose all correct answers)

Both bare metal and vm DB systems support two-node Real Application Clusters (RAC) systems.

The Console, API, and Oracle Cloud Infrastructure CLI are options for managing bare metal DB systems.

Bare metal shapes determine the total raw storage allocated to bare metal DB systems.

Bare metal and VM DB can only have a single Database Home, and the single database will be the version of the Database Home.

NO.47 Your company’s security policy requires you to patch the database within a month of a relevant database patch being released by Oracle. Which method requires the least amount of down time?

Download the latest patch from MOS, back up your database, run a precheck, then apply the patch on the database home.

Own two Oracle Homes (OH193_A and OH193_B), each with a test database (193A and 193B respectively).

Back up your database, run a precheck, then apply the patch on the database home where the database resides.

Download the latest patch from MOS, back up your database, and use dbaasc1i to apply the patch on the database home.

Create a new database home, patch it to the version you want, and then move the database to the new home.

NO.48 In Exadata Cloud Service, you use Oracle Data Guard for disaster recovery. What is the minimum egress requirement needed to enable Data Guard between Exadata Cloud Services?

Tcp traffic only for port 1521 and port 22

Tcp traffic only for port 1521

Tcp traffic only for port 22

Open for all protocols

NO.49 Which set of data types is supported by the NoSQL Database Cloud Service tables?

XML, JSON, array

Iong, double, triple

enum, map, record

Boolean, date stamp, float