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

What elements of globalization can be explicitly defined using the NLS_LANG environment variable? (Choose all that apply.)

• A.NLS_LANGUAGE
• B.NLS_CALENDAR
• C.NLS_SORT
• D.NLS_TERRITORY
• E.NLS_CHARACTERSET

View the Exhibit to examine the parameter values. You are planning to set the value for the MEMORY_TARGET parameter of your database instance.
What value would you assign?
Exhibit:

• A.90 MB
• B.272 MB
• C.362 MB
• D.1440 MB

When a job exceeds the date specified in its END_DATE attribute, which of the following will happen? (Choose all that apply.)

• A.The job will only be disabled if the value of the AUTO_DROP attribute is FALSE.
• B.The job will be dropped automatically if the value of the AUTO_DROP attribute is TRUE.
• C.The STATE column of the job table will be set to COMPLETED for the job.
• D.All objects referenced by the job will be dropped if the value of the AUTO_DROP attribute is TRUE and the value of the CASCADE attribute is TRUE.
• E.The STATE attribute of the job will be set to COMPLETED if the value of the AUTO_DROP attribute is FALSE.

You want to enable resumable space allocation at the instance level.
Which two actions would enable resumable space allocation at the instance level? (Choose two.)

• A.issuing the ALTER SYSTEM ENABLE RESUMABLE; statement
• B.issuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=<nonzero value>; statement
• C.issuing the ALTER SESSION ENABLE RESUMABLE; statement
• D.modifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero value

Examine the output of the query that you executed to list the objects in the recycle bin:

You verified that no table named SALES_TAB exists in the schema. Then you executed the following command to purge the objects in the recycle bin:
SQL> PURGE TABLE sales_tab;
What would be the outcome of this command?

• A.Only the table with the latest DROPSCN is purged
• B.All three tables in the recycle bin are purged
• C.Only the table with the oldest DROPSCN is purged
• D.The command returns an error because multiple entries with the same name exist in the recycle bin