Home      Tests New!      Polls      Discussion Forums     Take a Quiz     Make a Quiz     Login     Contact QuizMoz         Find a quiz.   Example: Harry Potter Quiz Create your own Poll Create a Test Make a Trivia Quiz Make a Quiz about Yourself Make Free Personality Test Recommend QuizMoz   Personal Injury Law Quizzes   Hottest Quizzes Free IQ Test   Michael Jackson Quiz   English Language Test   Does He Love You Quiz   Business Phone Etiquette Quiz   Impossible Quiz   Personality Quiz   Free Quizzes   India Quiz   ICC World Cup Quiz   Kya Mast Hai Life Quiz   General Knowledge Questions   Are you in Love Quiz   Skeletal System Quiz   Love Personality Quiz   General Knowledge Test         Home > Quizzes and Fun Tests > Oracle OCP Practice Tests > Oracle OCP Practice Test - Oracle 9i OCP Fundamentals Practice Questions   Hottest Quizzes Free IQ Test  Oracle OCP Practice Test - Oracle 9i OCP Fundamentals Practice Questions Welcome to the QuizMoz Oracle OCP Practice Test - Oracle 9i OCP Fundamentals Practice Questions. QuizMoz offers one of the Internet's largest collection of quizzes for you to tease your brain and pit your wits against the experienced QuizMoz quiz masters. Go ahead and find out what you know about yourself and the world around you. Best of luck!!  Oracle OCP Practice Test - Oracle 9i OCP Fundamentals Practice Questions Facts  Average Score for this quiz: 47%  No of times this quiz has been taken: 7  No of people passing this quiz: 4  No of people failing this quiz: 3  Maximum score for this quiz: 67% Coverage : Managing Tables Managing Data Managing Database Maintaing Data Integrity Managing Indexes Globalization Support Auditing Managing Indexes Managing Privileges Managing Password File Managing Password Security and Resources Managing Roles Managing Users  Oracle OCP Practice Test - Oracle 9i OCP Fundamentals Practice Questions Discussion Forum 1.  The following command was issued: SQL>TRUNCATE TABLE departments; Which statements are true regarding the command? a. All extents are released b. All rows of the table are deleted c. Any associated indexes are truncated d. No undo data is generated for the table's rows e. The number of extents allocated to the DEPARTMENTS table are reduced to the original setting for MINEXTENTS Please provide appropriate updations Ques The following command was issued:<br><br>SQL>TRUNCATE TABLE departments;<br><br>Which statements are true regarding the command? a. b. c. d. e. Please describe the changes made by you 2.  The ITEM table has a constant transaction load 24 hours a day, so down time is not allowed. The indexes become fragmented. Which statement will hold true in such a situation? a. The index needs to be dropped, and then re-created b. The resolution of index fragmentation depends on the type of index c. The index can be rebuilt while users continue working on the table d. The index can be rebuilt, but users will not have access to the index during this time Please provide appropriate updations Ques The ITEM table has a constant transaction load 24 hours a day, so down time is not allowed. The indexes become fragmented. Which statement will hold true in such a situation? a. b. c. d. Please describe the changes made by you 3.  Which table type should be used to provide fast key-based access to table data for queries involving exact matches and range searches? a. Regular table b. Clustered table c. Partitioned table d. Index-organized table Please provide appropriate updations Ques Which table type should be used to provide fast key-based access to table data for queries involving exact matches and range searches? a. b. c. d. Please describe the changes made by you 4.  The value of the OS_AUTHENT_PREFIX initialization parameter was set to OPS$ and created a user account by issuing this SQL statement: CREATE USER OPS$KING IDENTIFIED EXTERNALLY; Which statements are true? a. Oracle server assigns the DEFAULT profile to the user b. The PASSWORD EXPIRE clause was specified for an external user account c. The user does not require CREATE SESSION system privilege to connect to the database d. If the DBA_USERS data dictionary view is queried, the USERNAME column will contain the value KING e. The user account is maintained by Oracle, but password administration and user authentication are performed by the operating system or a network service Please provide appropriate updations Ques The value of the OS_AUTHENT_PREFIX initialization parameter was set to OPS$ and created a user account by issuing this SQL statement: <br><br>CREATE USER OPS$KING <br>IDENTIFIED EXTERNALLY; <br><br>Which statements are true? a. b. c. d. e. Please describe the changes made by you 5.  Which file is a part of the Oracle database? a. Control file b. Password file c. Parameter files d. Archived log files Please provide appropriate updations Ques Which file is a part of the Oracle database? a. b. c. d. Please describe the changes made by you 6.  A 10 GB index is to be created on the ITEM table. The index should be spread across many tablespaces, decreasing contention for index lookup, and increasing scalability and manageability. Which index would be best for this table? a. Bitmap b. Unique c. Partitioned d. Reverse key e. Single column Please provide appropriate updations Ques A 10 GB index is to be created on the ITEM table. The index should be spread across many tablespaces, decreasing contention for index lookup, and increasing scalability and manageability.<br>Which index would be best for this table? a. b. c. d. e. Please describe the changes made by you 7.  Which command can be used to display the date and time in the form 17:45:01 JUL-12-2000 using the default US7ASCII character set? a. ALTER SYSTEM SET NLS_DATE_FORMAT='HH24:MI:SS MON-DD-YYYY'; b. ALTER SESSION SET DATE_FORMAT='HH24:MI:SS MON-DD-YYYY'; c. ALTER SESSION SET NLS_DATE_FORMAT='HH24:MI:SS MON-DD-YYYY'; d. ALTER SYSTEM SET NLS_DATE_FORMAT='HH:MI:SS MON-DD-YYYY'; Please provide appropriate updations Ques Which command can be used to display the date and time in the form<br>17:45:01 JUL-12-2000 using the default US7ASCII character set? a. b. c. d. Please describe the changes made by you 8.  An index needs to be created on the EMP_ID column of the EMPLOYEE table which satisfies the following conditions: 1. The index will be called EMP_PK. 2. The index should be sorted in ascending order. 3. The index should be created in the INDEX01 tablespace, which is a dictionary managed tablespace. 4. All extents of the index should be 1 MB in size. 5. The index should be unique. 6. No redo information should be generated when the index is created. 7. 20% of each data block should be left free for future index entries. Which command creates the index and meets all the requirements? a. CREATE UNIQUE INDEX emp_pk ON Employee(Emp_id) TABLESPACE index0l PCTFREE 20 STORAGE (INITIAL lm NEXT lm PCTINCREASE 0); b. CREATE UNIQUE INDEX emp_pk ON employee(emp_id) TABLESPACE index0l PCTFREE 20 STORAGE (INITIAL 1m NEXT 1m PCTINCREASE 0) NOLOGGING; c. CREATE UNIQUE INDEX emp_pk ON Employee(emp_id) TABLESPACE index0l PCTUSED 80 STORAGE (INITIAL lm NEXT lm PCTINCREASE 0) NOLOGGING; d. CREATE UNIQUE INDEX emp_pk ON employee(emp_id) TABLESPACE index0l PCTUSED 80 STORAGE (INITIAL lm NEXT lm PCTINCREASE 0); Please provide appropriate updations Ques An index needs to be created on the EMP_ID column of the EMPLOYEE table which satisfies the following conditions:<br>1. The index will be called EMP_PK.<br>2. The index should be sorted in ascending order.<br>3. The index should be created in the INDEX01 tablespace, which is a dictionary managed tablespace.<br>4. All extents of the index should be 1 MB in size.<br>5. The index should be unique.<br>6. No redo information should be generated when the index is created.<br>7. 20% of each data block should be left free for future index entries.<br><br>Which command creates the index and meets all the requirements? a. b. c. d. Please describe the changes made by you 9.  The current password file allows for five entries. New DBAs have been hired and five more entries need to be added to the file, for a total of ten. How can the allowed number of entries be increased in the password file? a. Manually edit the password file and add the new entries b. Alter the current password file and resize if to be larger c. Add the new entries; the password file will automatically grow d. Drop the current password file, recreate it with the appropriate number of entries and add everyone again Please provide appropriate updations Ques The current password file allows for five entries. New DBAs have been hired and five more entries need to be added to the file, for a total of ten. How can the allowed number of entries be increased in the password file? a. b. c. d. Please describe the changes made by you 10.  Evaluate the following SQL command: GRANT REFERENCES (employee_id), UPDATE (employee_id, salary, commission_pct) ON hr.employees TO MARY; Which statements correctly describe what user MARY can or cannot do? a. CANNOT create a table with a constraint b. Can create a table with a constraint that references HR.EMPLOYEES c. Can update values of the EMPLOYEE_ID, SALARY, and COMMISSION_PCT columns d. Can insert values of the EMPLOYEE_ID, SALARY, and COMMISSION_PCT columns e. CANNOT insert values of the EMPLOYEE_ID, SALARY, and COMMISSION_PCT columns f. CANNOT update values of the EMPLOYEE_ID, SALARY, and COMMISSION_PCT columns Please provide appropriate updations Ques Evaluate the following SQL command:<br><br>GRANT REFERENCES (employee_id),<br>UPDATE (employee_id, salary, commission_pct)<br>ON hr.employees<br>TO MARY;<br><br>Which statements correctly describe what user MARY can or cannot do? a. b. c. d. e. f. Please describe the changes made by you 11.  Five roles were created using the statements shown: CREATE ROLE payMANAGER; CREATE ROLE oeclerk IDENTIFIED BY salary; CREATE ROLE hr_manager IDENTIFIED EXTERNALLY; CREATE ROLE genuser IDENTIFIED GLOBALLY; CREATE ROLE dev IDENTIFIED USING dev_test; Which statement indicates that a user must be authorized to use the role by the enterprise directory service before the role is enabled? a. CREATE ROLE payclerk; b. CREATE ROLE genuser IDENTIFIED GLOBALLY; c. CREATE ROLE oeclerk IDENTIFIED BY salary; d. CREATE ROLE dev IDENTIFIED USING dev_test; e. CREATE ROLE hr_manager IDENTIFIED EXTERNALLY; Please provide appropriate updations Ques Five roles were created using the statements shown:<br><br>CREATE ROLE payMANAGER;<br>CREATE ROLE oeclerk IDENTIFIED BY salary;<br>CREATE ROLE hr_manager IDENTIFIED EXTERNALLY;<br>CREATE ROLE genuser IDENTIFIED GLOBALLY;<br>CREATE ROLE dev IDENTIFIED USING dev_test;<br><br>Which statement indicates that a user must be authorized to use the role by the enterprise directory service before the role is enabled? a. b. c. d. e. Please describe the changes made by you 12.  SMITH is logged on to a client. He does not have a secure connection from the client to the host where his Oracle database is running. Which authentication mechanism allows him to connect to the database using the SYSDBA privilege? a. Control file authentication b. Password file authentication c. Data dictionary authentication d. Operating system authentication Please provide appropriate updations Ques SMITH is logged on to a client. He does not have a secure connection from the client to the host where his Oracle database is running. Which authentication mechanism allows him to connect to the database using the SYSDBA privilege? a. b. c. d. Please describe the changes made by you Think you know more about this quiz!   Please enter your Name and what you would like to tell everyone about Oracle OCP Practice Test - Oracle 9i OCP Fundamentals Practice Questions  Name: Think you know more about Oracle OCP Practice Test - Oracle 9i OCP Fundamentals Practice Questions and would like others to know too? Whether its a great fact, a joke, a personal experience or an interesting anecdote, please share it with all the human beings on planet earth. Your contribution will help keep QuizMoz a free site for all.    (Optional)  (average submission size - 5 to 10 lines) Oracle OCP Practice Test - Oracle 9i OCP Fundamentals Practice Questions Discussion Forum Know the Latest News about Oracle OCP Practice Test - Oracle 9i OCP Fundamentals Practice Questions! What others think about Oracle OCP Practice Test - Oracle 9i OCP Fundamentals Practice Questions By: Tom on 11/21/2009    I want more quiz questions By: Reema on 11/20/2009    Great Quiz! The quizmaster laid out this quiz so that even beginners could learn more By: Sridhar on 11/19/2009    Its a really good way to brush up things and informative also. By: Personality Quiz Man on 11/18/2009    I love quizzes. Personality Quizzes are my favorite. By: Aumkar on 11/17/2009    It was enjoyable. By: Laura on 11/16/2009    I appreciate the time and effort that the quiz maker put into the quiz By: Tommy on 11/15/2009    Great site. Good learning and fun. By: Lil Wayne Fan on 11/14/2009    Give me more quiz questions about LilWayne By: Kath on 11/13/2009    It's a really good quiz. By: Teena on 11/12/2009    I love this quiz Website. This is the best free quiz site. By: Shannon on 11/11/2009    I have never seen such an excellent quiz website before this. By: Quiz Game Player on 11/10/2009    One day I will crack all the Impossible quizzes in the world By: Free quiz seeker on 11/9/2009    I am searching for an impossible quiz By: QuizMoz Fan on 11/8/2009    I love all the QuizMoz quizzes. The general knowledge quiz is my favorite By: Samantha on 11/7/2009    This is so cool. Even though I really did not know some of the questions, it was still fun! By: Penny on 11/6/2009    NICE WEBSITE, great quiz! By: Haris on 11/5/2009    These quizzes will increase my vocab skill.Frequently i Have used this website to check my vocab strength. By: Tracy on 11/4/2009    Great test. A nice way to gauge one's knowledge By: quiz girl on 11/3/2009    hey folks! i like the amazing quizzes on quizmoz. it increases your general knowledge By: Bobby Kalsi on 11/2/2009    Try to make it easier to search for a QUIZ Category.. (It should be easier to seach for a quiz category...)   Hottest Quizzes Free IQ Test   Christmas Quiz   Christmas Quizzes   Kids General Knowledge Quiz   2009 General Knowledge Quiz   2010 General Knowledge Test   Science Quiz for Kids   Medical Terminology Quiz   Career Quiz for Kids   General Knowledge Science Test   Harry Potter Quiz   IQ Tests   Cricket Quiz   Am I Pregnant Quiz   Dating Etiquette Quiz   Email Etiquette Quiz   Home     About Us      Advertise     Terms of Service     Privacy Policy     Contact QuizMoz    FAQ     SiteMap Copyright © 2007.www.quizmoz.com. All rights are reserved.