1Z0-1093-23 Online Practice Questions and Answers

What is the NoSQLHandle interface NOT used for?

A. to set the row retention time

B. to gets rows from a table

C. to get dynamic information on a table

D. to access multiple tables

In which case can you fast provision a virtual machine (VM) database (DB) systems, using Logical Volume Manager (LVM) for storage management?

A. Oracle Database versions 18c and greater

B. Oracle Database versions 12.2 and greater

C. Oracle Databases that could use Automatic Storage Management (ASM)

D. any currently supported release of the Oracle Database

Which statement is true about MySQL Database Service?

A. It is a public cloud service built on MySQL Community Edition.

B. Its users are responsible for database and operating system patching tasks.

C. It is a fully managed Oracle Cloud Infrastructure (OCI) native service.

D. It supports MySQL Enterprise Edition version 5.7 with InnoDB Storage Engine.

What three capabilities does the database fleet summary provide? (Choose three.)

A. View database log entries.

B. View the current database resource usage.

C. View the status of the databases.

D. Migrate databases to OCI.

E. Compare database performance metrics over time.

F. Execute a DDL command on the databases.

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

A. Use the reinstate command to return a failed database to the standby role after correcting the cause of failure.

B. Write on both primary and standby databases because DB system standby databases in Oracle Cloud Infrastructure Database are logical standbys.

C. Terminate a primary database in the DB system.

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

E. Failover the standby database to the primary role if the primary database becomes unavailable.

When you created your development database on Exadata Cloud@Customer, you selected "None" for backup location. You now need to enable Automatic backups on the development database with a retention period of 60 days.

Which action should you perform?

A. Change the database backup location to a local storage and set the retention period to 60 days.

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

C. Change the database backup location to an NFS backup location and set the retention period to 60 days.

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

To which two files used in local installations of MySQL Server are MySQL configurations analogous? (Choose two.)

A. my.ini

B. my.cnf

C. mylogin.cnf

D. mysqld-auto.cnf

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

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

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

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

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

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

Which is NOT a prerequisite forpatching Grid Infrastructure or database homes when using the console?

A. The /u01 directory on the database host file system has at least 15 GB of free space for the execution of Patching processes.

B. Oracle Clusterware is down on the VM cluster.

C. Therequired patch is available on the Control Plane server.

D. All database compute nodes of the VM cluster are up and running.

In a two-node Real Applications Clusterenvironment, the Internet and VCN Resolver are supported for DNS in the DB system. Which TWO tasks are required for the network setup? (Choose all correct answers)

A. After the VCN is created, modify the DNS settings to use DNS Hostnames.

B. when creatingthe database, specify a value in the Hostname Prefix.

C. Select "Use DNS Hostnames in this VCN" as the VCN is being created.

D. Select the hostname field for a DNS label when the subnet is being created.