Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home Oracle 1z0-160

Oracle 1z0-160 Exam Practice Questions (P. 3)

  • Full Access (70 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #11
You are working on a DBaaS database instance.
Identify the location for the associated database files for your instance.
  1. A
    The installer sets the database file locations during installation by configuring the data file storage options.
  2. B
    The DBaaS database instance data files are stored at: : Oracle product software; the entire bits Compute Cloud storage volume /u01 : Oracle Database data storage; the entire data Compute Cloud storage volume /u02 : Database backup storage; the entire fra Compute Cloud storage volume /u03 : Database redo logs; the entire redo Compute Cloud storage volume /u04
  3. C
    All DBaaS database files are stored at /u01/app/oracle/oradata.
  4. D
    The database file locations are read from utldbfiles.ora and users can update this file to set their own locations.

Correct Answer:
B
Compute Cloud Service Storage Volumes
When a Database Cloud Service database deployment is created at the Oracle
Database Cloud Service service level, the following storage volumes are created.

References: Using Oracle Database Cloud Service (February 2017), page A-9 http://docs.oracle.com/cloud/latest/dbcs_dbaas/CSDBI/CSDBI.pdf

Question #12
You want to perform database recovery with the most recent backup.
Which command would you execute?
  1. A
    dbaascli rec –args –latest
  2. B
    dbaascli orec –args -latest
  3. C
    dbaascli rec –args -last
  4. D
    dbaascli orec –args -last

Correct Answer:
B
orec latest command restores the most recent backup and performs complete recovery. dbaascli
References:
https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/dbaascli.html

Question #13
You are migrating an Oracle Database 11.2.0.4 on-premise database to an Oracle Database Cloud Service (Database as a Service) that provides a pre-created
Oracle Database 12.1.0.2 database.
What four migration methods can be used?
  1. A
    conventional export/import
  2. B
    Transportable Tablespace (TTS) with RMAN conversion
  3. C
    Transportable Tablespace (TTS) by using Oracle Data Pump
  4. D
    SQL *Loader
  5. E
    RMAN image restore
  6. F
    Data Pump Transportable Database (TDB) export/import

Correct Answer:
BCDF
You load data into an Oracle database on Oracle Database Cloud Service using the same tools you would use for an Oracle database on another system.
* (D) Using SQL*Loader to Load Data into the Database
* Using Oracle Data Pump Import to Load Data into the Database
* (BC) Using Transportable Tablespaces to Load Data into the Database
There are two ways to transport a tablespace:
Manually, involving issuing commands to SQL*Plus, RMAN, and Data Pump.
Using the Transport Tablespaces Wizard in Enterprise Manager
* Using Pluggable Databases (PDBs) to Load Data into the Database
* Using Oracle Public Cloud Data Transfer Services to Move Large Data Sets
* (F) Full transportable export/import, is available to make migration to Oracle Database 12c faster, easier, and more efficient than ever before. Full transportable export is available starting with Oracle Database 11g Release 2 (11.2.0.3).
References:
https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/load-data-db.html https://docs.oracle.com/cd/B28359_01/server.111/b28310/tspaces013.htm#ADMIN11395 http://www.oracle.com/technetwork/database/enterprise-edition/full-transportable-wp-12c-1973971.pdf

Question #14
You created a Database as a Service (DBaaS) instance. This action also created a virtual machine and configured it for the DBaaS instance. It also created two user accounts. One of the users is oracle.
What three functions can the oracle user perform?
  1. A
    Grant privileges and roles to database users.
  2. B
    Create database users.
  3. C
    Back up and recover databases.
  4. D
    Create tablespaces.
  5. E
    Reboot a VM.
  6. F
    Use the sudo command to perform root user access operations.

Correct Answer:
ABC
oracle is the Oracle Database administrator account you use to access the system and perform non-root database administration tasks. A home directory, /home/ oracle, is created for this user. This user cannot use the sudo command to perform operations that require root-user access. Additionally, by default you cannot connect as this user to the compute node using SSH. You can add the public key to the users $HOME/.ssh/authorized_keys file to grant persistent SSH access, or you can connect as the opc user and then use the sudo -s command to start a root-user command shell, followed by an su - oracle command to switch to the oracle user.
Incorrect Answers:
F: root is the root administrator for the system. You do not have direct access to this account. To perform operations that require root-user access, use the sudo command as the opc, not the oracle, user.
References:
https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/linux-user-accounts-rac.html http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/dbaas/obe_dbaas_administering_your_database_cloud_service/ obe_dbaas_administering_your_database_cloud_service.html

Question #15
Where is the Oracle Database Cloud software for monitoring and backup installed?
  1. A
    The Oracle Database Cloud software is located in the Database Automatic Diagnostic Repository (ADR).
  2. B
    The installation is done at /var/opt/oracle/dbaascli and /var/opt/oracle/bkup_api.
  3. C
    The location must be set during installation as user-defined locations for the installation to start.
  4. D
    The location is based on Oracle Flex Architecture, which is similar to non-DBaaS systems.

Correct Answer:
B
When a database deployment is created using the Oracle Database Cloud Service service level, software is installed in the following locations.
* bkup_api utility /var/opt/oracle/bkup_api
* dbaascli utility /var/opt/oracle/dbaascli
* Oracle REST Data Services /u01/app/oracle/product/apex_listener
* Oracle Database
$ORACLE_HOME:
✑ Oracle Database 12c: /u01/app/oracle/product/12.1.0/dbhome_1
✑ Oracle Database 11g: /u01/app/oracle/product/11.2.0/dbhome_1
Note: Using the dbaascli utility, you can perform operations like:
✑ Changing the password of the SYS user
✑ Checking the status of the Oracle Data Guard configuration
✑ Switchover and failover in an Oracle Data Guard configuration
✑ Patching the database deployment
✑ Database recovery
✑ Rotating the master encryption key
References: Using Oracle Database Cloud Service (February 2017), A-4 https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/using-oracle-database-cloud-service.pdf

Previous Questions Next Questions

All Pages