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 server’s tnsnames.ora file B. It must resolve to… Read More »
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 »
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 »
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 »
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 »
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 »
Given:Which two lines of code when inserted in line 1 correctly modifies instance variables? (Choose two.) A. setGCount(g); B. setCCount(c) = cCount; C. tCount = tCount; D. aCount = a; E. cCount = setCCount(c); Correct Answer: C,D
Given:Which two methods facilitate valid ways to read instance fields? (Choose two.) A. getTCount B. getACount C. getGCount D. getCCount E. getTotalCount Correct Answer: D,E
Which two are true about instance recovery for a database that is open in read write mode?(Choose two.) A. Only the CURRENT REDO log group is required to perform instance recovery. B. The database opens after the roll forward phase of instance recovery has completed. C. It always occurs during instance startup performed immediately after a SHUTDOWN ABORT.… Read More »