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

Which three statements are true about roles?

• A.Roles may be granted to other roles.
• B.Object privileges may not be granted to roles.
• C.The SET ROLE statement can enable one or more roles for a session.
• D.All roles granted to a user are set on default when the user logs in.
• E.The SET ROLE statement can disable one or more roles for a session.
• F.Roles must be password protected.

Your data center uses Oracle Managed Files (OMF) for all databases. All tablespaces are smallfile tablespaces. SALES_Q1 is a permanent user-defined tablespace in the SALES database. The following command is about to be issued by a DBA logged in to the SALES database: ALTER TABLESPACE sales_q1 ADD DATAFILE; Which two actions independently ensure that the command executes successfully?

• A.Add the AUTOEXTEND ON clause with NEXT set to 100M.
• B.Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 MB of available space.
• C.Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 MB of available space.
• D.Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 MB of available space.
• E.Specify a path in the DATAFILE clause of the command specifying a location with at least 100 MB of available space.

Which of the following ALTER SYSTEM statements can be run from within a pluggable database (PDB)?

• A.ALTER SYSTEM FLUSH BUFFER_CACHE
• B.ALTER SYSTEM ENABLE / DISABLE RESTRICTED SESSION
• C.ALTER SYSTEM CHECKPOINT
• D.ALTER SYSTEM SWITCH LOGFILE

Which resource plan is used to manage the resources for the predefined maintenance window?

• A.The predefined maintenance window starts automatically with 20% of the system resources ...
• B.The resources used by the predefined maintenance window can only be adjusted if you create a new resource plan in Resource Manager ...
• C.By default, all predefined maintenance windows use the DEFAULT_MAINTENANCE_PLANresource plan, and automated maintenance tasks run under subplan called ORA$AUTOTASK.
• D.The SYS_GROUP consumer resource group policies define the resources assigned ...

Which two statements describe how Optimizer Statistics are collected?

• A.Optimizer Statistics are collected in real-time as data is inserted, deleted, or updated.
• B.Optimizer Statistics are collected automatically by Automatic Workload Repository (AWR) Snapshot.
• C.Optimizer Statistics are collected by the Statistics Advisor.
• D.Optimizer Statistics are collected automatically by an automatic maintenance job that runsduring predefined maintenance windows.
• E.Optimizer Statistics can be manually collected at multiple levels using DBMS_STATS.GATHER_*_STATS PL/SQL procedures.