Real Cheap Oracle 1Z0-042 Test Questions Help You 100% Pass From Passleader (121-130)

QUESTION 121 Your tnsnames.ora file has the following entry for the service alias ORCL: ORCL =      ( DESCRIPTION =          (ADDRESS = (PROTOCOL = TCP)(HOST = 10.156.24.216)(PORT = 1521))              (CONNECT_DATA =                   (SERVER = DEDICATED)                   (SERVICE_NAME = orcl.oracle.com)          )       ) The TNSPING command executes successfully when tested with ORCL but…

Real Cheap Oracle 1Z0-042 Test Questions Help You 100% Pass From Passleader (111-120)

QUESTION 111 While running the Oracle Universal Installer on a Unix platform to install Oracle Database 10g software, you are prompted to run orainstRoot.sh script. What does this script accomplish? A.    It creates the pointer file. B.    It creates the base directory. C.    It creates the Inventory pointer file. D.    It creates the Oracle user…

Real Cheap Oracle 1Z0-042 Test Questions Help You 100% Pass From Passleader (101-110)

QUESTION 101 Your database is started by using the server parameter file (SPFILE). You issued this command to change the value of the LOG_BUFFER initialization parameter: ALTER SYSTEM SET LOG_BUFFER=24M SCOPE=BOTH; What would be the outcome of this command? A.    The command would return an error because LOG_BUFFER is a static parameter. B.    The parameter…

Real Cheap Oracle 1Z0-042 Test Questions Help You 100% Pass From Passleader (91-100)

QUESTION 91 You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables. While migrating the data, you want to have minimal impact…

Real Cheap Oracle 1Z0-042 Test Questions Help You 100% Pass From Passleader (81-90)

QUESTION 81 Your database is opened in NOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode. How would you do this? (Choose two.) A.    Execute the ALTER DATABASE ARCHIVELOG statement B.    Select ARCHIVELOG option in the database control and restart the database to apply the changes. C.    Shut down and start the instance,…

Real Cheap Oracle 1Z0-042 Test Questions Help You 100% Pass From Passleader (71-80)

QUESTION 71 You executed the following command to start the database: SQL> STARTUP ORACLE instance started. Total System Global Area  281018368 bytes Fixed Size   789000 bytes Variable Size   229635576 bytes Database Buffers  50331648 bytes Redo Buffers  262144 bytes ORA-00205: error in identifying controlfile, check alert log for more info Which view would you query at…