Sample Questions of 1Z0-1093-23 Dumps With 100% Exam Passing Guarantee [Q32-Q49]

QUESTION 32
Which two use cases can be used by the Oracle database with Object Storage in Oracle Cloud Infrastructure (OCI)? (Choose two.)

Database data files

Database backups

Database log files

Database binaries

QUESTION 33
Which tool can be used to monitor a storage server in Exadata Database Service?

dbaascli

exacli

OCI CLI

ocpucli

QUESTION 34
While configuring a Virtual Machines (VM) database (DB) system, the next step after selecting a shape for the DB system is to select storage options and configuration.
Which two configurations should you select and use? (Choose two.)

Use Automatic Storage Management (ASM) for the storage management software of single and two-node VM deployments.

Use Object Storage buckets for DATA, redo logs, and archive logs.

Use Logical Volume Manager (LVM) for the storage management of single-node VM deployments.

Configure storage to assign 40% to DATA and the rest to redo logs and archive logs.

The two configurations that you should select and use while configuring a Virtual Machines (VM) database (DB) system are:
* Use Automatic Storage Management (ASM) for the storage management software of single and two-node VM deployments1. ASM is a feature of Oracle Database that provides a volume manager and a file system for Oracle data files, control files, and log files2. ASM simplifies the administration of Oracle Database files by managing the disk space allocation and optimizing the I/O performance2. ASM is the recommended storage management software for Oracle Database on Oracle Cloud Infrastructure1.
* Use Logical Volume Manager (LVM) for the storage management of single-node VM deployments1. LVM is a tool that allows you to create, resize, and delete logical volumes on your disks3. LVM provides more flexibility and control over your storage configuration than using raw partitions3. LVM is the default storage management software for single-node VM deployments on Oracle Cloud Infrastructure1.
The configurations that you should not select or use are:
* Use Object Storage buckets for DATA, redo logs, and archive logs. Object Storage is a service that provides scalable and durable storage for unstructured data such as images, videos, or backups4. Object Storage is not suitable for storing Oracle Database files that require high performance and low latency4.
Object Storage is mainly used for backup and recovery purposes for Oracle Database on Oracle Cloud Infrastructure.
* Configure storage to assign 40% to DATA and the rest to redo logs and archive logs. This is not a recommended configuration because it does not take into account the actual storage requirements and performance characteristics of your database workload1. You should plan your storage capacity and performance based on the size, growth rate, and I/O patterns of your data, log, and tempdb files1. You should also use separate disks or disk groups for each file type to avoid contention and optimize I/O throughput1.
References:
* Storage Configuration for Virtual Machine DB Systems
* Overview of Automatic Storage Management (ASM)
* Logical Volume Manager Administration
* Overview of Object Storage
* [Backing Up a Database to Object Storage by Using RMAN]

QUESTION 35
Which two statements are true about using a Service Gateway? (Choose two.)

The Service Gateway with a private subnet can be used to access Object Storage.

The Service Gateway can connect to services in the same region of its VCN.

The Service Gateway can connect to services in other regions outside of the VCN.

The Service Gateway can be used to connect to the Internet.

The Service Gateway with a public subnet can be used to access Object Storage.

QUESTION 36
What statement is FALSE regarding the differences between the Exadata Cloud@Customer X8M and X8 Infrastructure?

X8M uses Persistent Memory (PMEM).

X8M has more total OCPUs available than an equivalent X8 configuration.

Both X8M and X8 Exadata System models use InfiniBand for their internal network fabric.

X8 uses InfiniBand for its internal network fabric whereas X8M uses RoCE.

QUESTION 37
After you have provisioned a virtual machine (VM) database (DB) system, what action can you take to meet changes in block storage requirements?

After you have provisioned a VM DB system, you cannot increase or decrease block storage.

If a VM DB system requires more block storage, you can increase the storage at any time without impacting the system.

If you want to increase or decrease the storage, you must change the shape of the VM DB system.

If a VM DB system has different requirements for block storage, you can increase or decrease the storage at any time without impacting the system.

QUESTION 38
You use the Oracle Cloud Infrastructure console to create a MySQL DB system. You give it the name “mysql” and set the administrator username to “mysql.sys.” You give it a data storage size of 50 GB and set the host name to “mysql-host.” You do not specify a Maintenance Window start day and time.
Which action causes an error?

Storage size is too small.

Username “mysql.sys” is reserved.

Host name should contain only letters.

Maintenance Window start time is required.

QUESTION 39
What permissions do you need to perform actions on a NoSQL table?

NOSQL_ROWS_READ, NOSQL_ROWS_DELETE

NOSQL_TABLE_INSPECT, NOSQL_TABLE_UPDATE

NOSQL_TABLE_DESTROY, NOSQL_TABLE_ALTER

NOSQL_TABLE_WRITE, NOSQL_ROWS_INSERT

QUESTION 40
Your MySQL Database Service system is automatically backed up between midnight and 1 AM.
What must you do to change the starting time to 4 AM?

Select Backup Window from the Edit MySQL DB System Details page and set the start time to 4 AM.

Use the mysqlbackup command to establish a 4 AM backup start time.

Update the Oracle Cloud Infrastructure (QCI) MySQL DB System Details page to specify the 4 AM backup window start time.

Edit the OCI MySQL DB System Details to set the Enable Automatic Backups time to 4 AM.

QUESTION 41
After you have provisioned a virtual machine (VM) database (DB) system, what action can you take to meet changes in block storage requirements?

After you have provisioned a VM DB system, you cannot increase or decrease block storage.

If a VM DB system requires more block storage, you can increase the storage at any time without impacting the system.

If you want to increase or decrease the storage, you must change the shape of the VM DB system.

If a VM DB system has different requirements for block storage, you can increase or decrease the storage at any time without impacting the system.

QUESTION 42
NoSQL Database Cloud Service supports all three types of big data.
Which is NOT considered big data?

structured data

semi-structured data

unstructured data

free-structured data

QUESTION 43
Which characteristic is NOT a factor that impacts the capacity units for provisioning a NoSQL Database Cloud Service table?

Record size

Durability level

Data model

Query pattern

QUESTION 44
Which is NOT an Oracle best practice for updating Virtual Machine DB System databases?

Run the grecheck operation before you apply any update.

Patch the DB System before updating a database for DB Systems with Grid Infrastructure/ASM storage management.

Back up your databases before you apply any updates to your system.

Ensure all servers and database instances are stopped before applying patch to your DB system to avoid data corruption.

QUESTION 45
Which is NOT an Oracle best practice for updating Virtual Machine DB System databases?

Run the grecheck operation before you apply any update.

Patch the DB System before updating a database for DB Systems with Grid Infrastructure/ASM storage management.

Back up your databases before you apply any updates to your system.

Ensure all servers and database instances are stopped before applying patch to your DB system to avoid data corruption.

QUESTION 46
Which two external databases can be monitored by the Oracle Cloud Infrastructure (OCI) Database Management Service? (Choose two.)

Oracle 18c Database deployed on Oracle Exadata Cloud@Customer

Oracle Autonomous Database 19c deployed on an OCI Tenant

Oracle 12cR1 Database deployed on an Oracle Exadata Database Machine

Oracle 11gR2 Database deployed on an Oracle Private Cloud

QUESTION 47
NoSQL Database Cloud Service supports all three types of big data.
Which is NOT considered big data?

structured data

semi-structured data

unstructured data

free-structured data

QUESTION 48
How many IPs are required for the Backup Subnet supporting an Exadata Database Service with six Database Compute Servers?

12

9

16

24

QUESTION 49
Which two statements are true about Oracle Cloud Infrastructure (OCI) Management Interfaces? (Choose two.)

Terraform is an OCI Management interface that allows for programmatic access via https for secure application integration.

OCI CLI and dbcli (database CLI) are command-line interfaces that can be used with virtual machine DB systems.

OCI CLI and VMCLI are command-line interfaces that can be used with virtual machine DB systems.
VMCLI is a command-line interface that is available only on virtual machine DB systems and must be run on the host.

dbcli is available only on virtual machine DB systems and must be run on the host.

Virtual Machine DB Systems cannot be managed from the Web Console and must use the provided Cloud REST APIs.