Question # 1 Which three statements are true about the tools used to configure Oracle Net Services? (Choose three.)
The Oracle Net Configuration Assistant is only used when running the Oracle installer
Oracle Net Manager can be used to centrally configure listeners on any database server target
The lsnrctl utility requires a listener.ora file to exist before it is started
Oracle Net Manager can be used to locally configure naming methods on a database server
Enterprise Manager Cloud Control can be used to centrally configure listeners on any managed database server
Click for Answer
Oracle Net Manager can be used to centrally configure listeners on any database server target
Oracle Net Manager can be used to locally configure naming methods on a database server
Enterprise Manager Cloud Control can be used to centrally configure listeners on any managed database server
Question # 2 In your data center, Oracle Managed Files (OMF) is used for all databases. All tablespaces are smallfile tablespaces. SALES_Q1 is a permanent user-defined tablespace in the SALES database. Examine this command which is about to be issued by a DBA logged in to the SALES database: ALTER TABLESPACE sales_q1 ADD DATAFILE; Which are two actions, either one of which you could take to ensure that the command executes successfully? (Choose two.)
Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify with at least 50 Mb of available space.
Specify a path in the DATAFILE clause of the command specifying a location with at least 100M of available space.
Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 Mb of available space.
Add the AUTOEXTEND ON clause with NEXT set to 100M.
Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 Mb of available space.
Click for Answer
Specify a path in the DATAFILE clause of the command specifying a location with at least 100M of available space.
Add the AUTOEXTEND ON clause with NEXT set to 100M.
Question # 3 In which three situations does a new transaction always start? (Choose three.)
when issuing a SELECT FOR UPDATE statement after a CREATE TABLE AS SELECT statement was issued in the same session
when issuing a TRUNCATE statement after a SELECT statement was issued in the same session
when issuing a CREATE TABLE statement after a SELECT statement was issued in the same session
when issuing the first Data Manipulation Language (DML) statement after a COMMIT OR ROLLBACK statement was issued in the same session
when issuing a CREATE INDEX statement after a CREATE TABLE statement completed successfully in the same session
Click for Answer
when issuing a SELECT FOR UPDATE statement after a CREATE TABLE AS SELECT statement was issued in the same session
when issuing the first Data Manipulation Language (DML) statement after a COMMIT OR ROLLBACK statement was issued in the same session
Question # 4 Which three are types of segments in an Oracle Database? (Choose three.)
undo
index
stored procedures
sequences
tables
Click for Answer
Question # 5 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: Which statement is true?
Dynamic service registration cannot be used for this database instance
The LREG process registers services dynamically with the LISTENER_1 listener
LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration
There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database instances
The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration
Click for Answer
LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration
How to Pass Oracle 1Z0-082 Exam?
1
Buy Dumps
Get the most accurate Oracle prep with our exam-focused 1Z0-082 dumps. Real questions and verified answers – the ultimate tool for passing on your first try.
2
Preparation
Prep for the Oracle Database 19c exam from the comfort of your home. Download our 1Z0-082 practice questions and start studying today!
3
Success
Don't be surprised on exam day! Our accurate Oracle Database Administration I practice questions match the real exam format. Prepare at home and walk into your exam with ease.