Oracle Base Database Services 2023 Professional v1.0 (1z0-1093-23)

Page:    1 / 4   
Total 55 questions

Which users created on Database Servers can be used for both Oracle database and host management of your Exadata Database Service?

  • A. root, opc, oracle, and grid users
  • B. root, opc, oracle, grid, and cloud users
  • C. opc, oracle, and grid users
  • D. root, oracle, and grid users


Answer : C

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


Answer : B

In addition to Automatic backups of your Oracle database, you want to take On-Demand backups of the database on Exadata Database Service on Dedicated Infrastructure in the public cloud.
How can you do this?

  • A. Use the Create Backup button in the backup section of the Database Details page to take an On-Demand backup.
  • B. Connect to Exadata Database Service as oracle user first and then take an On-Demand backup.
  • C. Disable Automatic backup and then take an On-Demand backup.
  • D. On-Demand backups are not allowed on Exadata Database Service because they use Automatic backups.


Answer : A

Which two statements are true when enabling Data Guard on Exadata Database Service? (Choose two.)

  • A. You should use similar configurations for your Primary and Standby databases to ensure you meet the same performance service level after a role transition.
  • B. You can enable Data Guard to support your Standby or Disaster Recovery (DR) needs with a single API call or mouse click in the UI using cloud automation.
  • C. You can use Active Data Guard, which extends Oracle Data Guard capabilities by providing read/write functionality on the Standby or Disaster Recovery system.
  • D. You must configure Data Guard manually to create the Standby or DR instance for your Primary Exadata Database.
  • E. You cannot edit your configuration to change between synchronous or asynchronous transport of data to the DR site, after enabling Data Guard.


Answer : AB

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.


Answer : AD

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


Answer : E

Which method must you use to patch databases on Exadata Database Service with the least amount of downtime?

  • A. Conduct in place patching of the database Home.
  • B. Leverage Patchmgr to execute patching the database Home.
  • C. Create a Data Guard standby and execute standby first patching.
  • D. Leverage Opatch to execute patching the database Home.
  • E. Move the database to a new Home with the desired patch level.


Answer : E

You used the "Stop" option from the Console of an Exadata Database Service virtual machine within a VM cluster.
Which two statements are true? (Choose two.)

  • A. Billing for the CPU stops but billing for the Exadata Infrastructure continues.
  • B. The stopped VM is not available to any other database deployment.
  • C. All the VMs in the cluster are stopped.
  • D. All the databases in the VM cluster are stopped.
  • E. Billing for the OCPU and Infrastructure are stopped until the VM restarts.


Answer : AB

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.


Answer : C

Which three are prerequisites for using the MySQL Database Service? (Choose three.)

  • A. You must create a compartment to store your resources.
  • B. You must create a tenancy and be able to sign in to it.
  • C. You or your group must be granted the policies described in Mandatory Policies.
  • D. You must download the latest MySQL version from https://edelivery.oracle.com/.
  • E. You must install the downloaded MySQL version onto Oracle Cloud Infrastructure.


Answer : ABC

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

  • A. structured data
  • B. semi-structured data
  • C. unstructured data
  • D. free-structured data


Answer : D

Which statement is FALSE about updating your Virtual Machine DB System database?

  • A. Updating the DB system updates the Grid Infrastructure for two-node RAC DB Systems with Automatic Storage Management (ASM) storage management software.
  • B. Ensuring /u01 has 15 GB of free space.
  • C. Updating the DB System also updates the operating system.
  • D. Updating the DB System does NOT update the operating system.


Answer : D

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.


Answer : D

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

  • A. The Service Gateway with a private subnet can be used to access Object Storage.
  • B. The Service Gateway can connect to services in the same region of its VCN.
  • C. The Service Gateway can connect to services in other regions outside of the VCN.
  • D. The Service Gateway can be used to connect to the Internet.
  • E. The Service Gateway with a public subnet can be used to access Object Storage.


Answer : AB

Which two steps must be taken before installing a management agent for the Oracle Cloud Infrastructure (OCI) Database Management Service? (Choose two.)

  • A. Create or copy an Agent Install Key.
  • B. Create or copy an Agent OCID.
  • C. Patch the database to be managed.
  • D. Confirm the OS and networking requirements.
  • E. Install TLS 1.3 on the database system.


Answer : AD

Page:    1 / 4   
Total 55 questions