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 »
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 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 be the value of the SERVICE_NAMES parameter on the client side B. It must be… 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. cCount = setCCount(c); B. tCount = tCount; C. setGCount(g); D. setCCount(c) = cCount; E. aCount = a; Correct Answer: B,E
Given:Which two lines of code when inserted in line 1 correctly modifies instance variables? (Choose two.) A. aCount = a; B. cCount = setCCount(c); C. tCount = tCount; D. setCCount(c) = cCount; E. setGCount(g); Correct Answer: A,C
Given:Which two methods facilitate valid ways to read instance fields? (Choose two.) A. getGCount B. getTCount C. getCCount D. getTotalCount E. getACount Correct Answer: C,D
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. LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration B. Dynamic service registration cannot be used for this database instance C. The LREG process registers services dynamically… 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 »