Online Access Free 1Z1-182 Exam Questions

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

In the SPFILE of a single instance database, LOCAL_LISTENER is set to LISTENER_1. The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains: LISTENER_1 = (ADDRESS = (PROTOCOL = TCP)(HOST = host1.abc.com)(PORT = 1521)). Which statement is true?

• A.There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database in LISTENERS.
• B.Dynamic service registration cannot be used for this database instance.
• C.LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration.
• D.The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration.
• E.The LREG process registers services dynamically with the LISTENER_1 listener.

Which two statements are true about undo segments and the use of undo by transactions in an Oracle database instance?

• A.A single transaction may use multiple undo segments simultaneously.
• B.Undo segments can be stored in the SYSTEM tablespace.
• C.Undo segments can be stored in the SYSAUX tablespace.
• D.Undo segments can wrap around to the first extent when a transaction fills the last extent of the undo segment.
• E.Undo segments can extend when a transaction fills the last extent of the undo segment.

In one of your databases, the user HR has the password HRMGR. You want to connect to a database instance whose listener listens on port 1531 by using this statement: CONNECT HR/HRMGR@orcl. No name server is used. Which statement is true about ORCL?

• A.It must resolve to a valid connect descriptor in the client's tnsnames.ora file.
• B.It must be the name of the server running the database to whose instance HR wishes to connect.
• C.It must be the name of the database to whose instance HR wishes to connect.
• D.It must be the value of the SERVICE_NAMES parameter on the client side.
• E.It must resolve to a valid connect descriptor in the server's tnsnames.ora file.

Which three relationships between instances and Oracle databases are possible without using Multi-tenant?

• A.One instance on one server that has no database mounted.
• B.One instance on one server mounting and opening one database.
• C.One instance on one server mounting multiple databases.
• D.One instance on one server mounting and opening multiple databases.
• E.Two or more instances on separate servers all mounting and opening the same database.