SAP Oracle database placement test question papers - Set 2

SAP Oracle database placement test question papers - Set 2

1) What is the default LISTENER port number ?

A) 1527
B) 1547
C) 1572
D) 1599
View Answer / Hide Answer


2)In which transaction code can you delete and recreate index ?

A) SE11
B) SE13
C) DB21
D) DB24
View Answer / Hide Answer


3) Select the correct option with respect to database index processing type.

A) Create database index
B) Delete database index
C) Active and adjust database
D) All of the above
View Answer / Hide Answer


4) From which parameter you can see the buffer cache value ?

A) db_block_buffers
B) db_cache_advice
C) db_buffer_block
D) db_cache_size
View Answer / Hide Answer


5)We may require to upgrade operating system as a pre-requisite before start of oracle upgrade.

A) True
B) False
View Answer / Hide Answer


6)By default, where does the oracle stage directory exist?

A) /oracle/
B) /oracle/SID/102_64
C) /oracle/SID/
D) none of the above
View Answer / Hide Answer


7) After extracting ORACLE RDBMS software, the sub-directories database, client, clusterware, companion, gateways are created under which location ?

A)/oracle/
B)/oracle/stage/
C) /oracle/stage/102_64
D) /oracle/Inventory
View Answer / Hide Answer


8) What is the purpose of oracle Inventory directory ?

A) Maintains the inventory of all oracle software installed on the system
B) Maintains all the Mopatch and Opatch information installed on the system
C) Used for system startup and shutdown
D) None of the above
View Answer / Hide Answer


9) Path of oracle inventory is mentioned in which file ?

A) oraInst.loc
B) orainst.loc
C) oraSID.sap
D) orainst.lok
View Answer / Hide Answer


10) What is the purpose of executing pre-requisite script utlu102i.sql.?

A)Checks the database information about the current database.
B) Checks the redolog files in the current database whose size is less than 4mb
C) Checks the current database tablespace sizes
D) All of the above
View Answer / Hide Answer