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…
1Z0-042 sample questions
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 (51-60)
QUESTION 51 In your database server, the parameter PLSQL_OPTIMIZE_LEVEL has been set to 2. What would this setting achieve? A. It degrades the run time and compiler performance. B. It provides better run time and compiler performance. C. It provides better optimization of the statement during parse time. D. It forces the rule based optimizer…
Real Cheap Oracle 1Z0-042 Test Questions Help You 100% Pass From Passleader (41-50)
QUESTION 41 After being hired as a database administrator, you find that there is only one database that is functional and that is being accessed by the applications. You want to create a replica of the database, to be used for testing purposes. What is the best method to create the replica? A. create a…