Oracle 1Z0-1093-23 Online Practice Questions and Exam Preparation

Oracle 1Z0-1093-23 Online Questions & Answers

• Question 111:

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

  A. NOSQL_ROWS_READ, NOSQL_ROWS_DELETE
  B. NOSQL_TABLE_INSPECT, NOSQL_TABLE_UPDATE
  C. NOSQL_TABLE_DESTROY, NOSQL_TABLE_ALTER
  D. NOSQL_TABLE_WRITE, NOSQL_ROWS_INSERT
  A. NOSQL_ROWS_READ, NOSQL_ROWS_DELETE

• Question 112:

  What information is required to connect to the NoSQL Database Cloud Service?

  A. Tenancy ID, passphrase, handshake key
  B. User ID, tenancy ID, component ID
  C. Signing key fingerprint, API signing key, tenancy OCID
  D. API signing key, admin ID, user ID
  C. Signing key fingerprint, API signing key, tenancy OCID

• Question 113:

  You are designing an Exadata Database Service-based architecture for a customer who has a requirement that all maintenance, including database upgrades, be completed with as little downtime as possible. Which technology should be used?

  A. Application Continuity
  B. ASM instead of LVM
  C. RMAN
  D. Multitenant
  E. Active Data Guard
  E. Active Data Guard

• Question 114:

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

• Question 115:

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

  A. Run the precheck operation before you apply any update.
  B. Patch the DB System before updating a database for DB Systems with Grid Infrastructure/ASM storage management.
  C. Back up your databases before you apply any updates to your system.
  D. Ensure all servers and database instances are stopped before applying patch to your DB system to avoid data corruption.
  D. Ensure all servers and database instances are stopped before applying patch to your DB system to avoid data corruption.

• Question 116:

  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
  A. to set the row retention time

• Question 117:

  The /u02 directory containing Oracle Homes (OH) is 80% utilized and you need to free up space in it. You own two Oracle Homes OH193_A and OH193_B with test databases 193A and 193B, respectively. You decide to consolidate both

  databases into a single Oracle Home (OH193_A) to free up space.

  Which two actions must you perform? (Choose two.)

  A. Schedule a downtime window with the team using the 193B database.
  B. Copy the sqlnet.ora and spfile from OH193_B to OH193_A and restart PDBs.
  C. Create a new container database under OH193B and migrate the Pluggable Databases (PDBs) from 193B to 193A.
  D. Use the Move Database option from the console to relocate the database to the target Oracle Home.
  A. Schedule a downtime window with the team using the 193B database.
  D. Use the Move Database option from the console to relocate the database to the target Oracle Home.

• Question 118:

  You enable automatic backups on your Exadata Cloud@Customer.

  Which type of file is NOT backed up by default and is the customer's responsibility to back up?

  A. database archivelog files
  B. Transparent Data Encryption (TDE) keystore (wallet)
  C. server parameter file (SPfile)
  D. database control files
  B. Transparent Data Encryption (TDE) keystore (wallet)

• Question 119:

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

  A. After you have provisioned a VM DB system, you cannot increase or decrease block storage.
  B. If a VM DB system requires more block storage, you can increase the storage at any time without impacting the system.
  C. If you want to increase or decrease the storage, you must change the shape of the VM DB system.
  D. 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.
  B. If a VM DB system requires more block storage, you can increase the storage at any time without impacting the system.

• Question 120:

  You want to connect to your MySQL DB system's endpoint. You create an Oracle Linux computeinstance 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)

  A. Install the MySQL client on your local computer.
  B. Define a SQL Developer connection in your MySQL Database Service database system.
  C. Connect to your database system by using the MySQL client on the Linux compute instance.
  D. ssh into the compute instance from your local machine.
  C. Connect to your database system by using the MySQL client on the Linux compute instance.
  D. ssh into the compute instance from your local machine.