Your database instance is currently configured to support 1,500 connections. The Web applicationthat uses the database allows a large number of users to work with the database simultaneously. Someusers of the Web application do not interact with the server all the time. You want to increase the scalability by configuring the database instance to handle more connections. Asa DBA, which configuration would you set to support more than 1,500 connections at a time()
You are managing an Oracle Database 11g instance with ASM storage. The ASM instance is down. To know the details of the disks in the DATA disk group , you issued the following ASMCMD command: ASMCMD> lsdsk -I -d DATA Which statement is true regarding the outcome of this command?()
You are working on a test database where instance recovery takes a considerable amount of time.How can reduce the recovery time?()
You are working on a test database where instance recovery takes a considerable amount of time. How can reduce the recovery time?()
Which background process of a database instance,using Automatic Storage Management (ASM), connects as a foreground process into the ASM instance?()
You used the IMMEDIATE option to shut down your database instance. Consider the steps that mayoccur when a database instance is started and database is opened: 1:SGA is allocated. 2:Control file is read. 3:Redo log files are opened. 4:Instance recovery is started. 5:Background processes are started. 6:Data file headers are checked for consistency. 7:Server parameter file or the initialization parameter file is read. Which option has the correct order in which these steps occur()
Which initialization parameter in an ASM instance specifies the disk groups to be automatically mounted at instance startup?()
Your company has a server that runs an instance of Actrve Directory Lightweight Directory Service (AD LDS) You need to create new organizational units in the AD LDS application directory partition What should you do()
After performing a clean shut down of the database instance for maintenance, you mount thedatabase and then execute a command to open the database: SQL> ALTER DATABASE OPEN; Which two statements are true()
Examine the parameters for your database instance: Which three statements are true about the process of automatic optimization by using cardinality feedback?()