최신 1Z0-182 무료덤프 - Oracle Database 23ai Administration Associate

A. Execute DDL statements in the HR schema.

B. Log in to the database instance.

C. Revoke the CREATE SESSION privilege from user HR.

D. Execute DML statements in the HR schema.

E. Revoke the CREATE SESSION privilege from other users.

F. Grant the CREATE SESSION privilege with ADMIN OPTION to other users.

A. Data files are closed normally.

B. Subsequent instance startup performs instance recovery.

C. A checkpoint is written.

D. Uncommitted transactions are not rolled back by the shutdown.

E. Subsequent instance startup performs media recovery.

A. Unexpired UNDO is always retained.

B. UNDO_RETENTION specifies how long all types of UNDO are retained.

C. UNDO_RETENTION specifies for how long Oracle attempts to keep unexpired UNDO.

D. Active UNDO is always retained.

E. UNDO_RETENTION specifies for how long Oracle attempts to keep expired and unconsumed UNDO.

A. It skips only indexes that exist in both ORCL:SH and TESTDB:HR.

B. It skips all indexes of ORCL:SH and in both ORCL:SH and TESTDB:HR.

C. It skips only tables that exist in ORCL:SH and ORCL:OE.

D. It drops and re-creates indexes that exist in both ORCL:SH and TESTDB:HR.

E. It drops and re-creates tables that exist in both ORCL:SH and TESTDB:HR.

A. It frees unused temporary segments.

B. It frees resources held by abnormally terminated processes.

C. It rolls back transactions when a process fails.

D. It registers database services with all local and remote listeners known to the database instance.

E. It records checkpoint information in the control file.

A. Writing dirty database block images from the buffer cache.

B. Writing redo to log files.

C. Registering services with Oracle Net listeners.

D. Creating dedicated server connections.

E. Reading database blocks into the buffer cache.

F. Reading database blocks into the buffer cache.

A. DML may be performed on tables with one or more extents in this data file during the execution of this command.

B. The "TO" clause containing the new file name must be specified even if Oracle Managed Files (OMF) is used.

C. Tables with one or more extents in this data file may be queried during the execution of this command.

D. It overwrites any existing file with the name sales02.dbf in /u02 by default.

E. Compressed objects in sales01.dbf will be uncompressed in sales02.dbf after the move.

A. The resources used by the predefined maintenance window can only be adjusted if you create a new resource plan in Resource Manager ...

B. The SYS_GROUP consumer resource group policies define the resources assigned ...

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 predefined maintenance window starts automatically with 20% of the system resources ...

A. ALTER SYSTEM FLUSH BUFFER_CACHE

B. ALTER SYSTEM ENABLE / DISABLE RESTRICTED SESSION

C. ALTER SYSTEM SWITCH LOGFILE

D. ALTER SYSTEM CHECKPOINT

A. FGA policies by default can be created by a schema owner on an object in their schema.

B. FGA policies can be created by a user having the AUDIT_ADMIN privilege.

C. FGA policies can be created by a user having EXECUTE privilege on the DBMS_FGA package.

D. FGA policies can be created by a user having granted the CREATE_FGA_POLICY role.

E. FGA policies can only be created by a user with SYSDBA privilege.