1Z0-182.pdf
Q: 1
Which two statements are true about views used for viewing tablespace and datafile information?
Options
Q: 2
Examine this command: ALTER DATABASE MOVE DATAFILE '/u01/sales01.dbf' TO '/u02/sales02.dbf';
Which two statements are true?
Options
Q: 3
Which three statements are true about roles?
Options
Q: 4
Which two statements are true regarding Oracle database space management within blocks
managed by Automatic Segment Space Management (ASSM)?
Options
Q: 5
Which three statements are true about the Oracle Database server during and immediately after
SHUTDOWN TRANSACTIONAL?
Options
Q: 6
Which two tasks can you perform using DBCA for databases?
Options
Q: 7
Which three are benefits of using temp UNDO when performing DML on global temporary tables?
Options
Q: 8
Your database instance is started with an SPFILE. A PFILE is also available. You execute this command:
ALTER SYSTEM SET DB_CACHE_SIZE=100K; Where does the value change?
Options
Q: 9
Which two statements are true about User Authentication in an Oracle Database?
Options
Q: 10
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?
Options
Question 1 of 10
