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 Dumps
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…
Real Cheap Oracle 1Z0-042 Test Questions Help You 100% Pass From Passleader (61-70)
QUESTION 61 Examine the following commands executed in your database: SQL> ALTER SESSION RECYCLEBIN=ON; Session altered SQL> CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees; Table created. Further, you executed the following command to drop the table: SQL> DROP TABLE emp; Table dropped. What happens in this scenario? A. The table is moved…
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…
Real Cheap Oracle 1Z0-042 Test Questions Help You 100% Pass From Passleader (21-30)
QUESTION 21 Which is the correct description of the significance of the ORACLE_HOME environmental variable? A. It specifies the directory containing the Oracle software. B. It specifies the directory containing the Oracle-Managed Files. C. It specifies the directory for database files, if not specified explicitly. D. It specifies the base directory of Optimal Flexible Architecture…
Real Cheap Oracle 1Z0-042 Test Questions Help You 100% Pass From Passleader (11-20)
QUESTION 11 According to your backup strategy, you performed an incremental level 0 backup of your database. Which statement regarding this backup is true? A. The backup is similar to image copy. B. The backup contains all used data blocks. C. The backup contains only unused data blocks. D. The backup contains all data blocks…
Real Cheap Oracle 1Z0-042 Test Questions Help You 100% Pass From Passleader (1-10)
QUESTION 1 Which three pieces of information are considered while deciding the size of the undo tablespace in your database? (Choose three.) A. the size of an undo block B. the size of the redo log files C. undo blocks generated per second D. the size of the database buffer cache E. the value of…