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 Create a Survey Now you can Read Books Online Free at ReadCentral.com     Love Compatibility Test   English Language Test   Does He Love You Quiz   Business Phone Etiquette Quiz   Impossible Quiz   Personality Quiz   Free Quizzes   Harry Potter Quizzes   Keira Knightley Quiz   Rage Against The Machines Quiz   FIFA World Cup   Are you in Love Quiz   Skeletal System Quiz   Love Personality Quiz   Harry Potter Personality Quizzes         Home > Quizzes and Fun Tests > Oracle OCP Practice Tests > Oracle OCP Practice Test - Oracle 9i OCP Fundamental II    Oracle OCP Practice Test - Oracle 9i OCP Fundamental II Welcome to the QuizMoz Oracle OCP Practice Test - Oracle 9i OCP Fundamental II. 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!! 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 Fundamental II Discussion Forum 1.  Oracle9i introduces some enhancements for index-organized tables, which increase their availability. Which statements are true regarding the online functionality available with index-organized tables? a. The primary key index of an IOT CANNOT be coalesced b. When IOTs are rebuilt, the OVERFLOW segment must be manually rebuilt c. IOTs can be rebuilt using the ALTER TABLE... MOVE statement d. Only primary indexes on IOTs can be rebuilt online e. Secondary indexes on IOTs can be rebuilt online Please provide appropriate updations Ques Oracle9i introduces some enhancements for index-organized tables, which increase their availability. <br>Which statements are true regarding the online functionality available with index-organized tables? a. b. c. d. e. Your Name Please describe the changes made by you Please provide appropriate updations Your Name Please comment why is this inappropriate. 2.  Which type of index does this syntax create? CREATE INDEX emp_last_name_idx ON emp(last_name) PCTFREE 30 STORAGE(INITIAL 200K NEXT 200K PCTINCREASE 0 MAXEXTENTS 50) TABLESPACE indx; a. Bitmap b. B-Tree c. Partitioned d. Reverse key Please provide appropriate updations Ques Which type of index does this syntax create?<br><br>CREATE INDEX emp_last_name_idx ON emp(last_name) PCTFREE 30<br>STORAGE(INITIAL 200K NEXT 200K<br>PCTINCREASE 0 MAXEXTENTS 50) TABLESPACE indx;<br> a. b. c. d. Your Name Please describe the changes made by you Please provide appropriate updations Your Name Please comment why is this inappropriate. 3.  Two columns need to be dropped from a table. Which sequence of SQL statements should be used to drop the columns and limit the number of times the rows are updated? a. ALTER TABLE emp DROP COLUMN comments DROP COLUMN email; b. ALTER TABLE emp DROP COLUMN comments; ALTER TABLE emp DROP COLUMN email; c. ALTER TABLE emp SET UNUSED COLUMN comments; ALTER TABLE emp DROP UNUSED COLUMNS; ALTER TABLE emp SET UNUSED COLUMN email; ALTER TABLE emp DROP UNUSED COLUMNS; d. ALTER TABLE emp SET UNUSED COLUMN comments; ALTER TABLE emp SET UNUSED COLUMN email; ALTER TABLE emp DROP UNUSED COLUMNS; Please provide appropriate updations Ques Two columns need to be dropped from a table. Which sequence of SQL statements should be used to drop the columns and limit the number of times the rows are updated? a. b. c. d. Your Name Please describe the changes made by you Please provide appropriate updations Your Name Please comment why is this inappropriate. 4.  Which of the following statements are true? a. MOUNT mounts the database for certain DBA activities but does not provide user access to the database b. The NOMOUNT command creates only the Data Buffer but does not provide access to the database c. The OPEN command enables users to access the database d. The STARTUP command starts an instance Please provide appropriate updations Ques Which of the following statements are true? a. b. c. d. Your Name Please describe the changes made by you Please provide appropriate updations Your Name Please comment why is this inappropriate. 5.  Which statement is true when considering the number of indexes to be created on a table? a. Every column that is updated requires an index b. Every column that is queried is a candidate for an index c. Columns that are part of a WHERE clause are candidates for an index d. On a table used in a Data Warehouse application there should be no indexes e. All of the above Please provide appropriate updations Ques Which statement is true when considering the number of indexes to be created on a table? a. b. c. d. e. Your Name Please describe the changes made by you Please provide appropriate updations Your Name Please comment why is this inappropriate. 6.  Which type of segment is used to improve the performance of a query? a. Index b. Table c. Temporary d. Boot strap Please provide appropriate updations Ques Which type of segment is used to improve the performance of a query? a. b. c. d. Your Name Please describe the changes made by you Please provide appropriate updations Your Name Please comment why is this inappropriate. 7.  A database is currently configured with the database character set to WEBIS08859P1 and national character set to AL16UTF16. Business requirements dictate the need to expand language requirements beyond the current character set, for Asian and additional Western European languages, in the form of customer names and addresses. Which solution saves space storing Asian characters and maintains consistent character manipulation performance? a. Use SQL CHAR data types and change the database character set to UTF8 b. Use SQL NCHAR data types and change the national character set to UTF8 c. Use SQL CHAR data types and change the database character set to AL32UTF8 d. Use SQL NCHAR data types and keep the national character set to AL16UTF16 Please provide appropriate updations Ques A database is currently configured with the database character set to WEBIS08859P1 and national character set to AL16UTF16.<br>Business requirements dictate the need to expand language requirements beyond the current character set, for Asian and additional Western European languages, in the form of customer names and addresses.<br>Which solution saves space storing Asian characters and maintains consistent character manipulation performance? a. b. c. d. Your Name Please describe the changes made by you Please provide appropriate updations Your Name Please comment why is this inappropriate. 8.  Which of the following groups allows its members to connect to a 9i database using the SYSDBA privilege? a. OSDBA b. 9iDBA   c. OSADM d. OSOPER e. None of the above Please provide appropriate updations Ques Which of the following groups allows its members to connect to a 9i database using the SYSDBA privilege? a. b. c. d. e. Your Name Please describe the changes made by you Please provide appropriate updations Your Name Please comment why is this inappropriate. 9.  Which privilege is required to create a database? a. DBA b. SYSDBA c. SYSOPER d. RESOURCE Please provide appropriate updations Ques Which privilege is required to create a database? a. b. c. d. Your Name Please describe the changes made by you Please provide appropriate updations Your Name Please comment why is this inappropriate. 10.  Which of the following statements are true regarding the data dictionary views with prefix USER_? a. The column OWNER is implied to be the current user b. A user needs the SELECT ANY TABLE system privilege to query these views c. The definitions of these views are stored in the user's default tablespace d. These views return information about all objects to which the user has access e. A user who has the CREATE PUBLIC SYNONYM system Please provide appropriate updations Ques Which of the following statements are true regarding the data dictionary views with prefix USER_? a. b. c. d. e. Your Name Please describe the changes made by you Please provide appropriate updations Your Name Please comment why is this inappropriate. 11.  How is the HR_PAY role enabled? a. SET ROLE hr_pay; b. CREATE ROLE hr_pay; c. ENABLE ROLE hr_pay; d. SET ENABLE ROLE hr_pay; Please provide appropriate updations Ques How is the HR_PAY role enabled? a. b. c. d. Your Name Please describe the changes made by you Please provide appropriate updations Your Name Please comment why is this inappropriate. 12.  As SYSDBA TOM created the PAYCLERK role and granted the role to JOHN. JOHN in turn attempts to modify the authentication method of the PAYCLERK role from SALARY to NOT IDENTIFIED, but when doing so he receives the insufficient privilege error shown below. SQL> connect JOHN/crusader Connected. SQL> alter role payclerk not identified; alter role payclerk not identified * ERROR at line 1: ORA-01031: insufficient privileges Which privilege does JOHN require to modify the authentication method of the PAYCLERK role? a. ALTER ANY ROLE b. MANAGE ANY ROLE c. UPDATE ANY ROLE d. MODIFY ANY ROLE Please provide appropriate updations Ques As SYSDBA TOM created the PAYCLERK role and granted the role to JOHN. JOHN in turn attempts to modify the authentication method of the PAYCLERK role from SALARY to NOT IDENTIFIED, but when doing so he receives the insufficient privilege error shown below.<br><br>SQL> connect JOHN/crusader<br>Connected.<br>SQL> alter role payclerk not identified;<br>alter role payclerk not identified<br>*<br>ERROR at line 1:<br>ORA-01031: insufficient privileges<br><br>Which privilege does JOHN require to modify the authentication method of the PAYCLERK role? a. b. c. d. Your Name Please describe the changes made by you Please provide appropriate updations Your Name Please comment why is this inappropriate. 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 Fundamental II  Name: Think you know more about Oracle OCP Practice Test - Oracle 9i OCP Fundamental II 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 Fundamental II Discussion Forum Know the Latest News about Oracle OCP Practice Test - Oracle 9i OCP Fundamental II! What others think about Oracle OCP Practice Test - Oracle 9i OCP Fundamental II By: maya on Aug 2, 2009    Save mother earth with your humanity ! By: S. Manzoor on Jun 19, 2009    Good practise who are planing to take the certificaton exams By: mily on Jun 15, 2009    u get 2 know 'bout ur level when u test urself. By: Harinder Singh on Apr 15, 2009    was a good Experience taking this test By: satish l on Jan 27, 2009    excellent By: Sharad on Oct 23, 2008    Good questions. Quizzes for this month are sponsored by www.ExpertRating.com     Big Brother   FIFA   Soccer WAGs Quizzes   NBA 2010 Quiz   Science Quiz for Kids   Medical Terminology Quiz   Career Quiz for Kids   Home And Away Quiz   Harry Potter Quiz   Harry Potter and the Deathly Hallows   US History 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.