Online Access Free 1Z1-182 Practice Test

You have connected to the CDB root as a common user with the CREATE PLUGGABLE DATABASE system privilege and issued the following command: SQL> CREATE PLUGGABLE DATABASE pdb1 ADMIN USER admin1 IDENTIFIED BY p1 ROLES = (CONNECT) FILE_NAME_CONVERT = ('PDB$SEEDdir', 'PDB1dir'); Which three are results of the CREATE command?

• A.It creates a new local user ADMIN with restricted privileges.
• B.It creates tablespaces to store metadata.
• C.It creates a new local user ADMIN with SYSDBA privileges.
• D.The PDB must be opened Read Only to complete the integration of the PDB into the CDB.
• E.After the PDB is created, it is automatically opened Read/Write.
• F.It creates new default schemas for the PDB.

Examine this command: SQL> ALTER TABLE ORDERS SHRINK SPACE COMPACT; Which two statements are true?

• A.Queries and DML statements are allowed on ORDERS while the SHRINK is executing.
• B.The SHRINK operation causes rows to be moved to empty space starting from the beginning of the ORDERS segment.
• C.Only queries are allowed on ORDERS while SHRINK is executing.
• D.The SHRINK operation causes rows to be moved to empty space starting toward the end of the ORDERS segment.
• E.Dependent indexes become UNUSABLE.
• F.The high-water mark (HWM) of ORDERS is adjusted.

Which three tasks are part of the predefined Automated Maintenance Tasks?

• A.Automatic error and failure log collection tasks.
• B.Automatic Optimizer Statistics Collection.
• C.Automatic notification tasks.
• D.Automatic Backups of the database system files.
• E.Automatic SQL Plan Management advisor tasks.
• F.Automatic segment and segment statistics advisor tasks.

Which two tasks can you perform using DBCA for databases?

• A.Enable flashback database for an existing database.
• B.Configure a nonstandard block size for a new database.
• C.Register a new database with an available Enterprise Manager Management server.
• D.Change the standard block size of an existing database.
• E.Configure incremental backups for a new database.

Examine this command: ALTER DATABASE MOVE DATAFILE '/u01/sales01.dbf' TO '/u02/sales02.dbf'; Which two statements are true?

• A.Tables with one or more extents in this data file may be queried during the execution of this command.
• B.DML may be performed on tables with one or more extents in this data file during the execution of this command.
• C.Compressed objects in sales01.dbf will be uncompressed in sales02.dbf after the move.
• D.The "TO" clause containing the new file name must be specified even if Oracle Managed Files (OMF) is used.
• E.It overwrites any existing file with the name sales02.dbf in /u02 by default.