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

Oracle 1z0-052 Exam Practice Questions (P. 4)

  • Full Access (284 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 #16
For which database operation would you need the database to be in the MOUNT state?
  1. A
    Renaming the control files
  2. B
    Re-creating the control files
  3. C
    Dropping a user in your database
  4. D
    Dropping a tablespace in your database
  5. E
    Configuring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG modes

Correct Answer:
E

Question #17
The job to gather optimizer statistics for objects runs as part of the automatic maintenance window in your database instance. At a certain point of time, the maintenance window closes before the statistics are gathered for all objects.
Which statement is true in this scenario?
  1. A
    The statistics collection continues until all objects are processed.
  2. B
    The job is terminated and the statistics collected are restored to a time before the job started.
  3. C
    This produces an error and the statistics collected are locked until the next time that the maintenance window is opened.
  4. D
    The job is terminated and the statistics for the remaining objects are collected the next time that the maintenance window is opened.

Correct Answer:
D

Question #18
You want to move all objects of the APPS user in the test database to the DB_USR schema of the production database. Which option of IMPDP would you use to accomplish this task?
  1. A
    FULL
  2. B
    SCHEMAS
  3. C
    TRANSFORM
  4. D
    REMAP_SCHEMA
  5. E
    REMAP_TABLESPACE

Correct Answer:
D

Question #19
You executed the following command to create a password file in the database server:
$ orapwd file = orapworcl entries = 5 ignorecase=N
Which statement describes the purpose of the above password file?
  1. A
    It records usernames and passwords of users when granted the DBA role
  2. B
    It contains usernames and passwords of users for whom auditing is enabled
  3. C
    It is used by Oracle to authenticate users for remote database administrator
  4. D
    It records usernames and passwords of all users when they are added to OSDBA or OSOPER operating groups

Correct Answer:
C

Question #20
SQL> CREATE BIGFILE TABLESPACE MRKT
2 DATAFILE '/u01/app/oracle/oradata/orcl/mrkt.dbf' size 10M LOGGING
3 EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
Tablespace created.
SQL> ALTER DATABASE DEFAULT TABLESPACE MRKT;
Database altered.
Which two statements are true regarding the MRKT tablespace? (Choose two.)
  1. A
    No more data files can be added to the tablespace.
  2. B
    Segment space is managed by free lists in the tablespace.
  3. C
    A user created without being assigned a default tablespace uses this tablespace.
  4. D
    The tablespace can be dropped with the current setting with segments present in it.

Correct Answer:
AC

Previous Questions Next Questions

All Pages