Home      Tests New!      Polls      Take a Quiz     Make a Quiz     Login     Contact QuizMoz Go to Home Page  
   
  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









 

Featured Quizzes
 Love Compatibility Test
 English Language Test
 Does He Love You Quiz
 Business Phone Etiquette Quiz
 Impossible Quiz
 Personality Quiz
 CAT Preparation Mock Test
 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

 Follow QuizMoz on Twitter  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
  • 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
    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
    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;
    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
    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
    6. Which type of segment is used to improve the performance of a query?
    a.Index
    b.Table
    c.Temporary
    d.Boot strap
    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
    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
    9. Which privilege is required to create a database?
    a.DBA
    b.SYSDBA
    c.SYSOPER
    d.RESOURCE
    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
    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;
    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
    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)


    Know the Latest News about Oracle OCP Practice Test - Oracle 9i OCP Fundamental II!

    Follow QuizMoz on Twitter


    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


     

    Most Popular Quizzes
     Be A MakeUp Artist Course
     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.