Which two are true about instance recovery for a database that is open in read write mode?(Choose two.) A. It is always performed when opening a database. B. The database opens after the roll forward phase of instance recovery has completed. C. It is guaranteed to complete within fast_start_mttr_target number of seconds. D. Only the CURRENT REDO log… Read More »
Which two statements are true about space-saving features in an Oracle Database? (Choose two.) A. A table that is truncated will always have its segment removed B. An index created with the UNUSABLE attribute has no segment C. If they exist for a session, Private Temporary Tables (PTTs) are always dropped at the next COMMIT OR ROLLBACK statement… Read More »
The ORCL database has RESUMABLE__TIMEOUT = 7200 and DEFERRED_SEGMENT_CREATION = FALSE User U1 has a 1 MB quota in tablespace DATA.U1 executes this command:SQL> CREATE TABLE t1 AS(SELECT object_name, sharing, createdFROM dba_objects);U1 complains that the command is taking too long to execute.In the alert log, the database administrator (DBA) finds this:2017-03-06T12:15:17.183438+05:30statement in resumable session ‘User U1(136), Session 1,… Read More »
Which three statements are true about dropping and unused columns in an Oracle database? (Choose three.) A. A DROP COLUMN command can be rolled back B. A primary key column referenced by another column as a foreign key can be dropped if using the CASCADE option. C. A column that is set to UNUSED still counts towards the… Read More »
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/[email protected]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… Read More »
Your database instance was shut down normally and then started in NOMOUNT state. You then execute this command:ALTER DATABASE MOUNT;Which two actions are performed? (Choose two.) A. The online redo logs are opened B. The online data files are opened C. The alert log records the execution details D. The Oracle background processes are started E. The initialization… Read More »
A database is configured to use automatic undo management with temporary undo enabled.An UPDATE is executed on a temporary table.Where is the UNDO stored? A. in the undo tablespace B. in the SYSAUX tablespace C. in the SGA D. in the PGA E. in the temporary tablespace Correct Answer: E http://www.dba-oracle.com/t_temp_undo_enabled.htm
Your database instance is started with a PFILE.Examine these parameters:You want to increase the size of the buffer cache.Free memory is available to increase the size of the buffer cache.You execute the command:SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;What is the outcome? A. The value is changed only in the PFILE and takes effect at the next instance startup B.… Read More »
Which two statements are true about space-saving features in an Oracle Database? (Choose two.) A. Private Temporary Tables (PTTS) store metadata in memory only B. An index that is altered to be UNUSABLE will retain its segment C. A table that is truncated will always have its segment removed D. If they exist for a session, Private Temporary… Read More »
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? A. Dynamic service registration cannot be used for this database instance B. The LREG process registers services dynamically with the LISTENER_1 listener C. LISTENER_1 must also be defined in the LISTENER.ORA file to… Read More »