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

  • 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 #11
Which three statements regarding the server parameter file (SPFILE) are true? (Choose three.)
  1. A
    An SPFILE is a binary file.
  2. B
    An SPFILE cannot reside on a client.
  3. C
    An SPFILE cannot contain static parameters.
  4. D
    An SPFILE can store changes persistently across instance restarts.
  5. E
    An SPFILE can be read by the database server, but it is not written to by the server.
  6. F
    An SPFILE must be created manually, before creating a database, even if you use the Database Configuration Assistant (DBCA) to create the database.

Correct Answer:
ABD

Question #12
Your test database is configured to run in NOARCHIVELOG mode. One of the data files in the USERS tablespace is lost due to a media failure. You notice that all the online redo logs have been overwritten since the last backup.
What would you do to recover the data file?
  1. A
    Take the USERS tablespace offline and re-create the lost data file.
  2. B
    Shut down the instance, restore the data file from the last consistent backup and restart the database instance.
  3. C
    Shut down the instance, restores all the database files from the last consistent backup and restart the database instance.
  4. D
    Take the USERS tablespace offline, restore all the data files of the USERS tablespace from the last consistent backup and make the tablespace online.

Correct Answer:
C

Question #13
Examine the command:
SQL>DBMS_STATS.SET_TABLE_PREFS('SH','CUSTOMERS','PUBLISH','false');
Which statement describes the effect of the above command?
  1. A
    Automatic statistics collection is stopped for the CUSTOMERS table
  2. B
    Statistics for the CUSTOMERS table are locked and cannot be overwritten
  3. C
    Existing statistics for the CUSTOMERS table become unusable for the query optimizer
  4. D
    Subsequently, statistics gathered on the CUSTOMERS table are stored as pending statistics

Correct Answer:
D

Question #14
The instance abnormally terminates because of a power outage.
Which statement is true about redo log files during instance recovery?
  1. A
    Inactive and current redo log files are required to accomplish recovery.
  2. B
    Online and archived redo files are required to accomplish instance recovery.
  3. C
    All redo log entries after the last checkpoint are applied from redo log files to data files.
  4. D
    All redo log entries recorded in the current log file until the checkpoint position are applied to data files.

Correct Answer:
C

Question #15
Examine the command:
SQL>ALTER USR skd ACCOUNT LOCK;
Which two statements are true after the command is executed? (Choose two.)
  1. A
    The SKD user cannot log in to the database instance
  2. B
    The objects owned by the SKD user are not accessible to any user
  3. C
    The other users can access the objects owned by the SKD user, on which they have access
  4. D
    The password for the SKD user expires and the user is forced to change the password at the next log in

Correct Answer:
AC

Previous Questions Next Questions

All Pages