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

Which three statements are true about using SQL*Plus?

• A.It can run scripts passed to it by a shell script.
• B.It must be downloaded from the Oracle Technology Network (OTN).
• C.It can run Recovery Manager (RMAN) commands.
• D.It can run scripts entered at the SQL prompt.
• E.It has its own commands that are separate from any SQL statements.
• F.It has both command-line and graphical user interfaces (GUI).

Which three statements are true about Enterprise Manager Cloud Control?

• A.It provides management for Oracle middleware.
• B.It provides management for Oracle-engineered systems.
• C.It is integrated with My Oracle Support.
• D.It uses a web-based console built into the Oracle database using XML DB.
• E.It is available to manage a database only when that database is open.

What are the three components of Oracle Database Automatic Maintenance Tasks?

• A.A packaging system that allows you to combine all error and failure logs to share with Oracle Support.
• B.The maintenance windows managed by Oracle Database Scheduler, which are predefined time intervals permitting scheduled tasks.
• C.A set of tasks that are started automatically at regular intervals to perform maintenance operations on the database.
• D.A database alert log that stores details about major database operations and errors, which is used to manage cluster performance.
• E.Oracle Database Resource Manager, which enables you to manage and configure system resources used by the Automatic Maintenance Tasks.
• F.A diagnostic system that collects database error logs and details about database failures that can be found to diagnose complete file.

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

You execute this command: CREATE SMALLFILE TABLESPACE sales DATAFILE '/u01/app/oracle/sales01.dbf' SIZE 5G SEGMENT SPACE MANAGEMENT AUTO; Which two statements are true about the SALES tablespace?

• A.Free space is managed using freelists.
• B.It must be smaller than the smallest BIGFILE tablespace.
• C.It is a locally managed tablespace.
• D.Any data files added to the tablespace must have a size of 5 gigabytes.
• E.It uses the database default block size.