1Z0-042 무료 덤프문제 온라인 액세스

Which three statements are true about the stages of database startup? (Choose three.)

• A.Data files and online redo log files are checked for consistency while opening the database.
• B.Control files are read at the OPEN stage for the location of data files.
• C.Data files and redo log files are made available to users at the OPEN stage.
• D.Control files are required to bring the database to the NOMOUNT stage.
• E.Data files and redo log files can be renamed at the MOUNT stage.

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

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

You specified segment space management as automatic for a tablespace. What effect would this have on space management?

• A.The segment would be managed by bitmaps.
• B.Extents would be managed by the freelists.
• C.The segment would be managed by the freelists.
• D.Free space would be managed by the data dictionary.

Which three pieces of information are to be mandatorily provided while creating a new listener using Enterprise Manager Database Control? (Choose three.)

• A.the server name where the listener runs
• B.the port used by the listener
• C.the log file and trace file destination for the listener
• D.the protocol used by the listener
• E.the database services to be registered with the listener

A user complains that he gets the following error message repeatedly after executing some
SQL statements. The error message forces the user to log off from and log on to the database to continue his work.
ORA-02392: exceeded session limit on CPU usage, you are being logged off
Which action would you take to increase the session limit on CPU usage?

• A.Modify the system privileges assigned to the users.
• B.Modify the value for the RESOURCE_LIMIT parameter in the parameter file.
• C.Modify the object privileges assigned to the user.
• D.Modify the roles assigned to the users.
• E.Modify the profile assigned to the user.