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

Oracle 1z0-034 Exam Practice Questions (P. 2)

  • Full Access (148 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 #6
Examine the following RMAN command:
RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON; RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which perquisite must be met before accomplishing the backup?
  1. A
    Provide a password for the encryption.
  2. B
    Set up an Oracle wallet for the encryption.
  3. C
    No setup is required as it is a default encryption method.
  4. D
    Both Oracle wallet and password must be set up for the encryption.

Correct Answer:
B
http://download.oracle.com/docs/cd/B28359_01/backup.111/b28270/rcmconfa.htm

Question #7
Examine these Data Pump commands to import objects to non-existent users hr1 and oe1.

S expdp system/manager -

Schemas =hr,oe -
directory =EXP_ DIR
include = table
$ impdp system/manager

Schemas = hr1,oe1 -

Directory = EXP_DIR -

Dumpfile = export.dat -

Remap_schema =hr:hr1,oe :oe1 -
What would be achieved by running the above commands?
  1. A
    expdp will fail because no path has been defined for the dumpfile.
  2. B
    expdp will succeed but Impdp will fail because users do not exist.
  3. C
    impdp will create two users called hrl and oe1 and import all objects to the new schemas
  4. D
    impdp will create two users called hrl and oe1 and import tables owned by hr and oe schemas to hr1 and oe1 schemas, respectively.

Correct Answer:
B

Question #8
The database is configured in ARCHIEVELOG mode and regular complete database backups are taken. The loss of which two types of files may require a recovery with the RESETLOGS option?
  1. A
    Control files
  2. B
    Password file
  3. C
    Inactive online redo log file
  4. D
    Archived log files required to perform recovery
  5. E
    Newly created tablespace which is not backed up

Correct Answer:
AD
The RESETLOGS options is required in:
1. Imcomplete Recovery
2. Change of control file
So that, the control file and archived redo logs are required.

Question #9
User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash back the transactions?
  1. A
    ALTER DATABASE FLASHBACK ON;
  2. B
    GRANT SELECT ANY TRANSACTION TO scott;
  3. C
    GRANT EXECUTE ON dbms_flashback TO scott;
  4. D
    ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
  5. E
    ALTER TABLESPACE undots1 RETENTION GUARANTEE;
  6. F
    ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;

Correct Answer:
BCDF

Question #10
The DB_BLOCK_CHECKING parameter is set to FULL.
What checks occur each time the DBWnprocess(es) writes?
  1. A
    The Oracle database will check all data blocks by going through the data on each block, making sure the data is self-consistent.
  2. B
    The DBWn and the direct loader will calculate a checksum and store it in the cache header of every data block when writing it to disk.
  3. C
    The Oracle database will check data blocks belonging to the SYSTEM tablespace only, by going through the data on each block, making sure the data is self- consistent.
  4. D
    The Oracle database will check data blocks belonging to the SYSAUX tablespace only, by going through the data on each block, making sure the data is self- consistent.
  5. E
    The Oracle database will check data blocks in the SYSTEM and SYSAUX tablespaces only, by going through the data on each block, making sure the data is

Correct Answer:
A

Previous Questions Next Questions

All Pages