[IT认证]OCP考试真题042.pdf

Oracle_RealExamQuestions.Com_1Z0-042_v2011-11-08_185q_By-linkon Number: 1Z0-042 Passing Score: 800 Time Limit: 120 min File Version: 2011-11-08 Exam : Oracle_RealExamQuestions.Com_1Z0-042 Ver :2011-11-08 Question : 185 This product will provide you questions and answers carefully compiled and written by our experts. Try to understand the concepts behind the questions instead of cramming the questions good luck By-linkon Exam A QUESTION 1 You have a text file that maintains information on thousands of items. The end-user application requires the transfer of that information into a table in the database. What would you use to achieve this task? (Choose two.) A. Data Pump B. SQL*Loader C. External table D. Oracle Text E. Oracle Import Answer: BC Section: (none) Explanation/Reference: for detail more please visit powered by By = Teguh Triharto CEO Teguh Triharto Corporation QUESTION 2 Which step do you need to perform to enable a user with the SYSDBA privilege to log in as SYSDBA in iSQL*Plus? A. The user must be granted the database administrator (DBA) privilege. B. Set up a user in the Oracle Application Server Containers for J2EE (OC4J) user manager, and grant the webDba C. The user must be listed in the password file for t e authentication. D. No special setup is needed for the user to connect as SYSDBA in iSQL*Plus. Answer: B Section: (none) Explanation/Reference: for detail more please visit powered by By = Teguh Triharto CEO Teguh Triharto Corporation QUESTION 3 You specified extent management as local for a tablespace. How will it affect space management in the tablespace? A. The tablespace will be system managed and the users cannot specify the extent size. B. Free extents will be managed by the data dictionary tables. C. All the extents will be of the sam