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 »
Which three are types of segments in an Oracle Database? (Choose three.) A. undo B. index C. stored procedures D. sequences E. tables F. clusters Correct Answer: B,E,F Explanation/Reference: http://www.adp-gmbh.ch/ora/concepts/segments.html
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 »
Which three statements are true about table data storage in an Oracle Database? (Choose three.) A. Data block headers contain their own Data Block Address (DBA) B. A table row piece can be chained across several database blocks C. Multiple row pieces from the same row may be stored in different database blocks D. Multiple row pieces from… 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 PGA C. in the SYSAUX tablespace D. in the SGA E. in the temporary tablespace Correct Answer: A
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. 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 »
Which three are types of segments in an Oracle Database? (Choose three.) A. undo B. index C. stored procedures D. sequences E. tables F. clusters Correct Answer: B,E,F Reference:http://www.adp-gmbh.ch/ora/concepts/segments.html