Online Access Free 1Z0-042 Practice Test

Which is the memory area that is created when a dedicated server process is started, and contains data and control information for that server process?

• A.PGA
• B.Streams Pool
• C.Shared Pool
• D.SGA

You specified extent management as local for a tablespace. How will it affect space management in the tablespace?

• A.The tablespace will be system managed and the users cannot specify the extent size.
• B.All the extents will be of the same size.
• C.Bitmap will be used to record free and allocated extents.
• D.Free extents will be managed by the data dictionary tables.

Which two statements are true about the primary key constraint in a table? (Choose two.)

• A.The non-deferrable primary key constraint creates an unique index on the primary key column if it is not already indexed.
• B.The primary key constraint can be referred by only one foreign key constraint.
• C.It is not possible to disable the primary key constraint.
• D.The primary key constraint can be imposed by combining more than one column.
• E.It is possible to have more than one primary key constraint in a single table.

The junior DBA in your organization has accidentally deleted the alert log file. What will you do to create new alert log file?

• A.No action required.The file would be created automatically by the instance.
• B.Create the new text file file as ALERT.LOG.
• C.You have to recover the alert log file from the valid backup.
• D.Change the value for the BACKGROUND_DUMP_DEST parameter.

You define an alert to be raised when the USERS tablespace usage has reached 80% of the total space. Which area would you refer to, in order to confirm that the alert has been raised due the event?

• A.the alert.log file
• B.the Database Control performance page
• C.the DBA_ALERTS view
• D.the Database Control Maintenance page
• E.the Database Control Home page