Free Oracle 1Z0-182 Exam Dumps Questions & Answers

Which three statements are true about the Oracle Database server during and immediately after SHUTDOWN TRANSACTIONAL?

• A.  Sessions remain connected even if they are not running a transaction.
• B.  New connection requests made to the database instance are refused.
• C.  Uncommitted transactions are allowed to continue to the next ROLLBACK.
• D.  Instance recovery occurs automatically during the shutdown.
• E.  Uncommitted transactions are allowed to continue to the next COMMIT.

Examine these commands:
[oracle@host01 ~]$ sqlplus u1/oracle
SQL> SELECT * FROM emp;
ENO ENAME DN
-------------------------
1 Alan 2
2 Ben 2
SQL> exit
[oracle@host01 ~]$ cat emp.dat
1, Alan, 2
3, Curl, 4
4, Bob, 4
[oracle@host01 ~]$ sqlldr u1/oracle TABLE=emp
Which two statements are true?

• A.  It appends data from EMP.DAT to EMP.
• B.  It generates a log that contains control file entries, which can be used with normal SQL*Loader operations.
• C.  It overwrites the data for Alan and adds data for Curl and Bob.
• D.  It overwrites all data in EMP with data from EMP.DAT.
• E.  It generates a SQL script that it uses to load data from EMP.DAT to EMP.

In one of your databases, you create a user, HR, and then execute this command: GRANT CREATE SESSION TO hr WITH ADMIN OPTION; Which three actions can HR perform?

• A.  Execute DDL statements in the HR schema.
• B.  Revoke the CREATE SESSION privilege from user HR.
• C.  Grant the CREATE SESSION privilege with ADMIN OPTION to other users.
• D.  Execute DML statements in the HR schema.
• E.  Revoke the CREATE SESSION privilege from other users.
• F.  Log in to the database instance.

Which statement is true about the PDB_DBA role granted to a local user during the creation of a new PDB?

• A.  The role has the privileges to create and manage users within the PDB.
• B.  No privileges are provided with the PDB_DBA role.
• C.  The role has the privileges to administer the PDB.
• D.  The role has the privileges to perform DDL operations on all local schema objects.

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.  Specify a path in the DATAFILE clause of the command specifying a location with at least 100 MB of available space.
• 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.  Add the AUTOEXTEND ON clause with NEXT set to 100M.
• E.  Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 MB of available space.