Free Oracle 1Z1-052 Exam Dumps Questions & Answers

Note the functionalities of various background processes:
1 : Perform recovery at instance startup.
2 : Free the resources used by a user process when it fails.
3 : Cleanup the database buffer cache when a process fails.
4 : Dynamically register database services with listeners.
5 : Monitor sessions for idle session timeout.
6 : Cleanup unused temporary segments.
7 : Record the checkpoint information in control file.
Which option has the correct functionalities listed for a background process?

• A.Checkpoint (CKPT): 1, 2, 5
• B.Database Writer (DBWR): 1, 3, 4
• C.Process Monitor (PMON): 4, 6, 7
• D.System Monitor (SMON): 1, 6

Identify the two situations in which the alert log file is updated with details. (Choose two.)

• A.Inserting a value in a table returns "ORA-00001: unique constraint (SYS.PK_TECHP) violated."
• B.Creating a table returns "ORA-00955: name is already used by an existing object'
• C.Rebuilding an index using ALTER INDEX ... REBUILD fails with an error "ORA-01578:
  ORACLE data block corrupted (file # 14, block @ 50)."
• D.Rebuilding an index using ALTER INDEX .... REBUILD fails with an error "ORA-01578:
  ORACLE data block corrupted (file #14, block #50)."
• E.Running a query on a table returns "ORA-600: Internal Error"
• F.Inserting a value in a table returns "ORA-01722: Invalid Number"

Which statement is true about loading data using the conventional path of SQL*Loader?

• A.No exclusive locks are acquired when the conventional path loads are performed
• B.INSERT triggers are disabled before the conventional path load and reenabled at the end of the load
• C.Only PRIMARY KEY, UNIQUE KEY and NOT NULL constraints are checked
• D.Redo is not generated while performing conventional path loads
• E.Instead of performing transactions, SQL*Loader directly writes data blocks to the data files

Which two are true about space management in tablespaces? (Choose two.)

• A.Free lists are used for managing free space for segments in locally managed tablespaces
• B.Extent allocation must be specified as automatic for automatic segment space management (ASSM) tablespaces
• C.Locally managed tablespaces have either ASSM or manual segment space management (MSSM), and all the segments in these tablespaces are managed one way or the other
• D.Locally managed tablespaces track adjacent free space automatically by using bitmaps
• E.ASSM tablespaces prevent row chaining

The user HR owns the EMP table. The user HR grants privileges to the user SCOTT by using this command:

Which statement is true after HR issues the REVOKE command?

• A.The command fails because HR cannot revoke the privileges from JIM.
• B.The command succeeds and only HR has the privilege to perform the SELECT, INSERT, and UPDATE operations on the EMP table.
• C.The command succeeds and privileges are revoked from JIM.
• D.The command fails because SCOTT still has privileges.