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 Quiz   Hottest Quizzes Free IQ Test  Oracle OCP Practice Test - Oracle 9i OCP Fundamentals Quiz Welcome to the QuizMoz Oracle OCP Practice Test - Oracle 9i OCP Fundamentals Quiz. 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 Quiz Facts  Average Score for this quiz: 28%  No of times this quiz has been taken: 7  No of people passing this quiz: 2  No of people failing this quiz: 5  Maximum score for this quiz: 58% 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 Discussion Forum 1.  A partitioned table named ITEM is maintained. The following statement was issued: ALTER TABLE ITEM DROP PARTITION p1 UPDATE GLOBAL INDEXES PARALLEL (DEGREE 3); Which statement represents the result of including the UPDATE GLOBAL INDEXES clause? a. After the P1 partition is dropped, all global B-tree and function-based indexes are automatically rebuilt b. After the P1 partition is dropped, all global indexes that were marked UNUSABLE will be automatically rebuilt c. All global indexes on the ITEM table remain intact throughout the DDL operation d. Other DML statements can continue to use the any global B-tree indexes without interruption Please provide appropriate updations Ques A partitioned table named ITEM is maintained. The following statement was issued:<br><br>ALTER TABLE ITEM<br>DROP PARTITION p1<br>UPDATE GLOBAL INDEXES<br>PARALLEL (DEGREE 3);<br><br>Which statement represents the result of including the UPDATE GLOBAL INDEXES clause? a. b. c. d. Please describe the changes made by you 2.  Which constraint state prevents the entry of new data that violates the constraint, but allows invalid data to exist in the table? a. ENABLE VALIDATE b. DISABLE VALIDATE c. ENABLE NOVALIDATE d. DISABLE NOVALIDATE Please provide appropriate updations Ques Which constraint state prevents the entry of new data that violates the constraint, but allows invalid data to exist in the table? a. b. c. d. Please describe the changes made by you 3.  For which constraints are indexes created when the constraint is added? a. Check b. Unique c. Not null d. Primary key e. Foreign key Please provide appropriate updations Ques For which constraints are indexes created when the constraint is added? a. b. c. d. e. Please describe the changes made by you 4.  MILLER is an administrator who has FULL DBA privileges. When he attempts to drop the DEFAULT profile as shown below, he receives the error message shown. Which option best explains this error? SQL> drop profile SYS.DEFAULT; drop profile SYS.DEFAULT * ERROR at line 1: ORA-00950: invalid DROP option a. The DEFAULT profile cannot be dropped b. MILLER requires the DROP PROFILE privilege c. Profiles created by SYS cannot be dropped d. The CASCADE option was not used in the DROP PROFILE command Please provide appropriate updations Ques MILLER is an administrator who has FULL DBA privileges. When he attempts to drop the DEFAULT profile as shown below, he receives the error message shown. Which option best explains this error?<br><br>SQL> drop profile SYS.DEFAULT;<br>drop profile SYS.DEFAULT<br>*<br>ERROR at line 1:<br>ORA-00950: invalid DROP option a. b. c. d. Please describe the changes made by you 5.  A new user, Smith, has just joined the organization. Smith needs to be created as a valid user in the database. The following requirements have to be met: 1. An externally authentic user is to be created. 2. The user must have CONNECT and RESOURCE privileges. 3. The user must NOT have DROP TABLE and CREATE USER privileges. 4. A quota of 100 MB has to be set on the default tablespace and 500 K on the temporary tablespace. 5. The user should be assigned to the DATA_TS default tablespace. Which statement should be used to create the user? a. CREATE USER Smith IDENTIFIED EXTERNALLY DEFAULT TABLESPACE data_ts QUOTA 100M ON data_ts QUOTA 500K ON temp_ts TEMPORARY TABLESPACE temp_ts; REVOKE DROP_TABLE, CREATE_USER from Smith; b. CREATE USER Smith IDENTIFIED EXTERNALLY DEFAULT TABLESPACE data_ts QUOTA 500K ON temp_ts QUOTA 100M ON data_ts TEMPORARY TABLESPACE temp_ts; GRANT connect, resource TO Smith c. CREATE USER Smith IDENTIFIED EXTERNALLY DEFAULT TABLESPACE data_ts QUOTA 100M ON data_ts QUOTA 500K ON temp_ts TEMPORARY TABLESPACE temp_ts; GRANT connect TO Smith d. CREATE USER Smith INDENTIFIED GLOBALLY AS '' DEFAULT TABLESPACE data_ts QUOTA 500K ON temp_ts QUOTA 100M ON data_ts TEMPORARY TABLESPACE temp_ts; GRANT connect, resource TO Smith; REVOKE DROP_TABLE, CREATE_USER from Smith; Please provide appropriate updations Ques A new user, Smith, has just joined the organization. Smith needs to be created as a valid user in the database. The following requirements have to be met:<br><br>1. An externally authentic user is to be created.<br>2. The user must have CONNECT and RESOURCE privileges.<br>3. The user must NOT have DROP TABLE and CREATE USER privileges.<br>4. A quota of 100 MB has to be set on the default tablespace and 500 K on the temporary tablespace.<br>5. The user should be assigned to the DATA_TS default tablespace.<br><br>Which statement should be used to create the user? a. b. c. d. Please describe the changes made by you 6.  Which statement is true with respect to enabling the constraints? a. ENABLE NOVALIDATE is the default when a constraint is enabled b. Enabling a constraint NOVALIDATE places a lock on the table c. Enabling a UNIQUE constraint to VALIDATE does not check for constraint violation if the constraint is deferrable d. A constraint that is currently disabled can be enabled in one of two ways: ENABLE NOVALIDATE or ENABLE VALIDATE Please provide appropriate updations Ques Which statement is true with respect to enabling the constraints? a. b. c. d. Please describe the changes made by you 7.  User Smith created indexes on some tables owned by user John. The following needs to be displayed: index names index types Which data dictionary view(s) should be queried? a. DBA_INDEXES only b. DBA_IND_COLUMNS only c. DBA_INDEXES and DBA_USERS d. DBA_IND COLUMNS and DBA_USERS Please provide appropriate updations Ques User Smith created indexes on some tables owned by user John. The following needs to be displayed:<br>index names<br>index types<br>Which data dictionary view(s) should be queried? a. b. c. d. Please describe the changes made by you 8.  Which statements are true about rebuilding an index? a. The resulting index may contain deleted entries b. A new index is built using an existing index as the data source c. Queries cannot use the existing index while the new index is being built d. During a rebuild, sufficient space is needed to accommodate both the old and the new index in their respective tablespaces Please provide appropriate updations Ques Which statements are true about rebuilding an index? a. b. c. d. Please describe the changes made by you 9.  A company hired ALLEN, a DBA who will be working from home. Allen needs to have the ability to start the database remotely. A password file was created for the database and REMOTE_LOGIN_PASSWORDFILE = EXCLUSIVE was set in the parameter file. Which command adds Allen to the password file, allowing him remote DBA access? a. GRANT DBA TO ALLEN; b. GRANT SYSDBA TO ALLEN; c. GRANT RESOURCE TO ALLEN; d. orapwd file=orapwdSTUD user=ALLEN password=DBA Please provide appropriate updations Ques A company hired ALLEN, a DBA who will be working from home. Allen needs to have the ability to start the database remotely.<br>A password file was created for the database and REMOTE_LOGIN_PASSWORDFILE = EXCLUSIVE was set in the parameter file. Which command adds Allen to the password file, allowing him remote DBA access? a. b. c. d. Please describe the changes made by you 10.  Which utility provides the ability to assess the impact of the conversion of a database to a different character set? a. Locale Builder b. Database Workspaces c. User-Defined Events d. Character Set Scanner Please provide appropriate updations Ques Which utility provides the ability to assess the impact of the conversion of a database to a different character set? a. b. c. d. Please describe the changes made by you 11.  When is the use of fine-grained auditing beneficial? a. Unaudited access should be allowed to the CONTACT_ ADDRESS column of the CUSTOMER table from within the organization, but any access to the CONTACT_ADDRESS column occurring via the Internet should be tracked b. The Human Resources Administrator should be alerted every time someone accesses an executive's salary in the EMPLOYEE table c. Comparison between the before and after values of each update of the PRICE column of the PRODUCT table should be facilitated d. All users who updated the CUSTOMER table on a specific date should be identifiable e. All accesses of the EMPLOYEE table should be tracked f. All of the above Please provide appropriate updations Ques When is the use of fine-grained auditing beneficial? a. b. c. d. e. f. Please describe the changes made by you 12.  Which password management feature ensures that a user cannot reuse a password for a specified time interval? a. Account Locking b. Password History c. Password Verification d. Password Expiration and Aging Please provide appropriate updations Ques Which password management feature ensures that a user cannot reuse a password for a specified time interval? 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  Name: Think you know more about Oracle OCP Practice Test - Oracle 9i OCP Fundamentals 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 Discussion Forum Know the Latest News about Oracle OCP Practice Test - Oracle 9i OCP Fundamentals! What others think about Oracle OCP Practice Test - Oracle 9i OCP Fundamentals By: Tom on 11/21/2009    I want more quiz questions By: Tallitha on 11/20/2009    This quiz is amazing By: general knowledge seeker on 11/19/2009    i love to take tests and quizzes. quizzes are my life. general knowledge questions are good for everyone By: Penny on 11/18/2009    NICE WEBSITE, great quiz! By: Alice on 11/17/2009    Its a very good Quiz. It rocks my socks!!!!! By: Tracy on 11/16/2009    Great test. A nice way to gauge one's knowledge By: Teresa on 11/15/2009    I took the quiz. It let me know that I failed. But I wasn't able to see what the correct answers. It would be great to see what the answers are so I can learn. By: Erin on 11/14/2009    it was a fun and interseting quiz! By: Teena on 11/13/2009    I love this quiz Website. This is the best free quiz site. By: Roger on 11/12/2009    I love Quiz Games. QuizMoz is an excellent Quiz site By: Kath on 11/11/2009    It's a really good quiz. By: Lil Wayne Fan on 11/10/2009    Give me more quiz questions about LilWayne By: Hannah on 11/9/2009    Enjoyed it, and learned a lot about general knowledge By: Aumkar on 11/8/2009    It was enjoyable. By: Bobby Kalsi on 11/7/2009    Try to make it easier to search for a QUIZ Category.. (It should be easier to seach for a quiz category...) By: Personality Quiz Man on 11/6/2009    I love quizzes. Personality Quizzes are my favorite. By: Roger on 11/5/2009    I love Quiz Games. QuizMoz is an excellent Quiz site By: Shannon on 11/4/2009    I have never seen such an excellent quiz website before this. By: Tommy on 11/3/2009    Great site. Good learning and fun. By: Kayla on 11/2/2009    I think this is a great quiz full of knowlodge and information.   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.