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

  • 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 #21
View the Exhibit and examine the privileges granted to the MGR_ROLE role.
The user SKD has been granted the CONNECT and RESOURCE roles only. The database administrator (DBA) grants MGR_ROLE to the user SKD by executing the command:
SQL> GRANT MGR_ROLE TO SKD WITH ADMIN OPTION;
Which statement is true about the user SKD after he/she is granted this role?
Exhibit:

  1. A
    The user SKD can grant only the MGR_ROLE role to other users, but not the privileges in it
  2. B
    The user SKD can revoke the MGR_ROLE only from the users for whom he/she is the grantor
  3. C
    The user SKD can grant the privileges in the MGR_ROLE role to other users but not with ADMIN OPTION
  4. D
    The user SKD can grant the privileges in the MGR_ROLE role to other users, but cannot revoke privileges from them

Correct Answer:
A

Question #22
After performing a clean shut down of the database instance for maintenance, you mount the database and then execute a command to open the database:
SQL> ALTER DATABASE OPEN;
Which two statements are true? (Choose two.)
  1. A
    The online redo log files and online data files are opened.
  2. B
    All the online data files headers are checked for consistency.
  3. C
    Instance recovery is performed before opening the database.
  4. D
    The path and existence of all the log file members are checked.

Correct Answer:
AB

Question #23
Examine the command that is used to create a table:

Which two statements are true about the effect of the above command? (Choose two.)
  1. A
    A CHECK constraint is created on the OID column.
  2. B
    A NOT NULL constraint is created on the OID column.
  3. C
    The ORDERS table is the only object created in the USERS tablespace.
  4. D
    The ORDERS table and a unique index are created in the USERS tablespace.
  5. E
    The ORDERS table is created in the USERS tablespace and a unique index is created on the OID column in the SYSTEM tablespace.

Correct Answer:
BD

Question #24
Which two statements are true about Shared SQL Area and Private SQL Area? (Choose two.)
  1. A
    Shared SQL Area will be allocated in the shared pool.
  2. B
    Shared SQL Area will be allocated when a session starts.
  3. C
    Shared SQL Area will be allocated in the large pool always.
  4. D
    The whole of Private SQL Area will be allocated in the Program Global Area (PGA) always.
  5. E
    Shared SQL Area and Private SQL Area will be allocated in the PGA or large pool.
  6. F
    The number of Private SQL Area allocations is dependent on the OPEN_CURSORS parameter.

Correct Answer:
AF

Question #25
Which three statements are correct about temporary tables? (Choose three.)
  1. A
    Indexes and views can be created on temporary tables
  2. B
    Both the data and structure of temporary tables can be exported
  3. C
    Temporary tables are always created in a user's temporary tablespace
  4. D
    The data inserted into a temporary table in a session is available to other sessions
  5. E
    Data Manipulation Language (DML) locks are never acquired on the data of temporary tables

Correct Answer:
ACE

Previous Questions Next Questions

All Pages