| 1. | Which of the following data types stores data outside the Oracle database? |
| a. | | UROWID |
| b. | | BFILE |
| c. | | BLOB |
| d. | | NCLOB |
| e. | | EXTERNAL
|
|
|
|
|
|
|
| 2. | Which of the following operations cannot be performed using the ALTER TABLE statement? |
| a. | | Rename Table |
| b. | | Rename Column |
| c. | | Drop Column |
| d. | | Drop NOT NULL Constraint
|
|
|
|
|
|
|
| 3. | Which of the following are DML statements? |
| a. | | COMMIT |
| b. | | MERGE |
| c. | | UPDATE |
| d. | | DELETE |
| e. | | CREATE |
| f. | | DROP
|
|
|
|
|
|
|
| 4. | Which of the following constraints can be defined only at the column level? |
| a. | | UNIQUE |
| b. | | NOT NULL |
| c. | | CHECK |
| d. | | PRIMARY KEY |
| e. | | FOREIGN KEY |
| f. | | All of the above
|
|
|
|
|
|
|
| 5. | Which of the following views should a user query to display the columns associated with the constraints on a table owned by the user? |
| a. | | USER_CONSTRAINTS |
| b. | | USER_OBJECTS |
| c. | | ALL_CONSTRAINTS |
| d. | | USER_CONS_COLUMNS |
| e. | | USER_COLUMNS
|
|
|
|
|
|
|
| 6. | Which of the following statements complete a transaction? |
| a. | | DELETE employees; |
| b. | | DESCRIBE employees; |
| c. | | ROLLBACK TO SAVEPOINT C; |
| d. | | GRANT SELECT ON employees TO SCOTT; |
| e. | | ALTER TABLE employees SET UNUSED COLUMN sal;
|
|
|
|
|
|
|
| 7. | Evaluate the following statement:
SELECT *
FROM USER_CONS_COLUMNS;
Logged on as user MILLER, which task can be accomplished using this statement? |
| a. | | Count the number of UNIQUE constraints in the schema |
| b. | | Display the columns associated with the constraints on the tables MILLER owns |
| c. | | Determine the type of constraint on the DEPT_ID column of the DEPARTMENT table in the user Chan schema |
| d. | | Display the names of the constraints on the tables MILLER can access |
| e. | | None of the above
|
|
|
|
|
|
|
| 8. | Evaluate the following statement:
TRUNCATE TABLE item;
Which of the following statements about the TRUNCATE TABLE statement are true? |
| a. | | The result of this statement can be reversed by issuing a ROLLBACK |
| b. | | This statement will retain the structure of the ITEM table |
| c. | | This statement will permanently remove all the rows from the ITEM table |
| d. | | This statement will produce the same result as the 'DELETE item' statement |
| e. | | Only the owner of the ITEM table can issue this statement successfully
|
|
|
|
|
|
|
| 9. | What would happen if an index was created on all six columns in the STUDENT table? |
| a. | | All queries with a WHERE clause would be slower |
| b. | | The speed of updates would be increased |
| c. | | The delete operations on the table would be slower |
| d. | | All the SELECT statements issued on the table would be faster
|
|
|
|
|
|
|
| 10. | The ACCOUNT table contains the following columns:
ACCOUNT_ID NUMBER(12) NOT NULL, Primary Key
CREDIT_LIMIT NUMBER(7) NOT NULL
PREV_BALANCE NUMBER(7,2)
NEW_PURCHASES NUMBER(7,2)
PAYMENTS NUMBER(7,2)
FINANCE_CHARGE NUMBER(7,2)
A view definition was created based on the ACCOUNT table. This view allows users to insert and update records that can be queried using the view. Which statement was used to create this view? |
| a. | | CREATE VIEW acct_v
AS SELECT DISTINCT credit_limit
FROM account
WHERE finance_charge > 75.00; |
| b. | | CREATE VIEW acct_v
AS SELECT account_id, prev_balance, new_purchases, payments
FROM account; |
| c. | | CREATE VIEW accts_v
AS SELECT *
FROM account
WHERE payments IS NULL
AND finance_charge IS NOT NULL
WITH CHECK OPTION; |
| d. | | CREATE VIEW acct_v
AS SELECT account_id, AVG(finance_charge) "Avg. Finance Chrg."
FROM account
GROUP BY finance_charge
WITH CHECK OPTION;
|
|
|
|
|
|
|
| 11. | Access was granted to the ITEM table by its owner. Which data dictionary view should be queried to review comments on the ITEM table? |
| a. | | ALL_TAB_COMMENTS |
| b. | | ALL_USER_COMMENTS |
| c. | | USER_TAB_COMMENTS |
| d. | | USER_TABLE_COMMENTS
|
|
|
|
|
|
|
| 12. | Which statement should be used to remove the EMPLOYEE_ID_PK PRIMARY KEY constraint and all depending constraints from the EMPLOYEE table? |
| a. | | MODIFY TABLE employee
DROP CONSTRAINT employee_id_pk CASCADE; |
| b. | | ALTER TABLE employee
DELETE PRIMARY KEY CASCADE; |
| c. | | ALTER TABLE employee
DROP PRIMARY KEY CASCADE; |
| d. | | ALTER TABLE employee
DROP PRIMARY KEY CASCADE;
|
|
|
|
|
|
|
What others think about Oracle OCP Practice Test - Oracle 9i SQL OCP |
| By: Penny on 11/21/2009 |
| | NICE WEBSITE, great quiz! |
|
 |
| By: Sridhar on 11/20/2009 |
| | Its a really good way to brush up things and informative also. |
|
|
| By: Aumkar on 11/19/2009 |
|
|
| By: Hannah on 11/18/2009 |
| | Enjoyed it, and learned a lot about general knowledge |
|
|
| By: Lil Wayne Fan on 11/17/2009 |
| | Give me more quiz questions about LilWayne |
|
| By: Roger on 11/16/2009 |
| | I love Quiz Games. QuizMoz is an excellent Quiz site |
|
|
| By: Tallitha on 11/15/2009 |
|
|
| By: Roger on 11/14/2009 |
| | I love Quiz Games. QuizMoz is an excellent Quiz site |
|
|
| By: Teena on 11/13/2009 |
| | I love this quiz Website. This is the best free quiz site. |
|
|
| By: Haris on 11/12/2009 |
| | These quizzes will increase my vocab skill.Frequently i Have used this website to check my vocab strength. |
|
|
| By: Tommy on 11/11/2009 |
| | Great site. Good learning and fun. |
|
|
| By: Laura on 11/10/2009 |
| | I appreciate the time and effort that the quiz maker put into the quiz |
|
|
| By: Hot girl on 11/9/2009 |
| | I love answering Quiz Questions |
|
|
| By: Nancy on 11/8/2009 |
| | I would like to see a complete page of horror movie quizzes for the horror genre fans! |
|
|
| By: Dave on 11/7/2009 |
| | I really enjoyed this quiz. I will take a lot of information away with me. Great quiz |
|
|
| By: general knowledge seeker on 11/6/2009 |
| | i love to take tests and quizzes. quizzes are my life. general knowledge questions are good for everyone |
|
|
| By: quiz girl on 11/5/2009 |
| | hey folks! i like the amazing quizzes on quizmoz. it increases your general knowledge
|
|
|
| By: Samantha on 11/4/2009 |
| | This is so cool. Even though I really did not know some of the questions, it was still fun! |
|
|
| By: Reema on 11/3/2009 |
| | Great Quiz! The quizmaster laid out this quiz so that even beginners could learn more |
|
|
| By: Teresa on 11/2/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. |
|
|
