|
Home > Archive > Oracle certifications > December 2001 > DO you need ocp bibles?you will pass ocp once if you have my bibles(8i)
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
DO you need ocp bibles?you will pass ocp once if you have my bibles(8i)
|
|
| askey200 2001-12-20, 8:05 am |
| total(001,023,024,025,026) price is $200,one exam is $50!my e-mail:
ocp8i@fm365.com | |
| AlanSmith 2001-12-21, 6:14 pm |
| Your bibles are based on September'01 cheetsheets from www.cheet-sheets.com
true/false ?
if true.... why waste money ? I used 024 cheetsheet and failed
if false... based ON WHAT? did you use your little spy digital camera on the testing room, or what???!!! | |
| ocp1201 2001-12-21, 7:24 pm |
| $200 or $50 that's all BULLSH*T!!!
Is you guy have that kind of money to spare to to the bookstore or amazon.com and but yourself a good book (study guide) for OCP exams. you'll not only pass the exam you'll also get to learn the stuff for real.
Youll only be cheating yourself if you buy and use cheetsheets for the exam. cheetsheets or askey's bible wont help you pass or learn Oracle! and that's the bottom line! | |
|
| While,
if the person is using cheatsheets, and those stuffs, really cost so much, as he mention, is not worth buying at all. Coz, he only want to change the format of the questions, and tell you that he can help you pass. No point getting it, while, you can get it for free, from asking ppl around the board.
Since, this forum is talking abt certification. Cheating or studying those certifications are up to that person.
His or her career path, is all decided by him or her, by their employer.
How true are those guides, nobody knows, unless someone get the stuffs from the person, and verify it.
Anyway, hope that you all will do well for your certifications. Do have a nice day ahead.
See ya!!! | |
| askey200 2001-12-23, 12:11 am |
| my bibles are not based on September'01 cheetsheets from www.cheet-sheets.com .i dont know the site yet!i have got the prometric system from the testing room.dont believe me!hehe.so i can write the real questions.
now i give you 10 real questions of 024!but i deleted the answers!
1. What can you use the values in the GETS and GETMISSES columns of V$ROWCACHE to determine the hit ratio for?
A. library cache
B. dictionary cache
C. entire shared pool
D. large objects such as PL/SQL packages
2. Sometimes the LGWR process must wait because DBWn has not completed checkpointing a file. How do you identify the situation?
A. Check the V$SESSION_WAIT view for the "log buffer space" event.
B. Check the alert.log file for the message "CHECKPOINT NOT COMPLETE". (*)
C. Check the "redo buffer allocation retries" statistic in the V$SYSSTAT view.
D. Check the "log file switch (checkpoint complete)" event in the V$SYSSTAT view.
3. Which class of data describes to Oracle Expert how the database is used in daily operations?
A. Schema class
B. Workload Class
C. Instance Class
D. Environment Class
4. What should be two goals in tuning rollback segments? (Choose two.)
A. Transactions should never wait for access to rollback segments.
B. No transaction, however large or exceptional, should never run out of rollback space.
C. Rollback segments should be configured to extend continually during normal processing.
D. The ratio of waits to the rollback segment header blocks should be less than 5% of the sum of access.
5. What is the main reason to create a reverse key index on a column?
A. The column is populated using a sequence.
B. The column contains many different values.
C. The column is mainly used for value range scans.
D. The column implements an inverted list attribute.
6. What will this statement do?
CREATE TABLESPACE temp
DATAFILE 'C:\database\temp.dbf' SIZE 10m
temporary;
A. create a tablespace that will be dropped on instance shutdown
B. create a tablespace in which the user can create segments for usage during sorts
C. create a tablespace in which Oracle can create segments for usage during sorts
D. create a tablespace in which a user can create tables that will be automatically dropped after a week
7. Where can you find the nondefault parameters when the instance is started?
A. alert log
B. online redo log
C. archived redo log
D. SYSTEM user's trace file
8. You pinned an object in the shared pool using the DBMS_SHARED_POOL package. Which command could you use to unpin this object, assuming you are in a SQL*Plus session?
A. ALTER SYSTEM FLUSH SHARED_POOL;
B. EXECUTE dbms_shared_pool.unpin;
C. EXECUTE dbms_shared_pool.unkeep;
D. EXECUTE dbms_library_cache.unpin;
9. Which two statements about row migration are true? (Choose two.)
A. Row migration is caused by a PCTFREE value set too low.
B. Row migration can be resolved using the ANALYZE command.
C. Row migration can be reduced by choosing a larger block size.
D. Row migration means that row pieces are stored in different blocks.
E. Queries that use an index to select migrated rows perform additional I/O.
10. When tables are stored in locally managed tablespaces, where is extent allocation information stored?
A. memory
B. data dictionary
C. temporary tablespace
D. corresponding tablespace itself | |
| askey200 2001-12-28, 12:55 am |
| Part I
1. How do you decare a PL/SQL table of records to hold the rows selected from the EMP table?
A. DECLATE
Emp_table IS TABLE OF emp&ROWTYPE;
B. BEGIN
TYPE emp_table_type IS TABLE OF emp&ROWTYPE;
Emp_table emp_table_type;
C, DECLARE
TYPE emp_table_type IS TABLE OF emp&ROWTYPE;
INDEX BY WHOLE_NUMBER;
Emp_table emp_table_type;
D. DECLARE
TYPE emp_table_type IS TABLE OF emp&ROWTYPE;
INDEX BY BINARY_INTEGER;
Emp_table emp_table_type;
2.The view EMP_VIEW is created based on the EMP table as follows;
CREATE OR REPLACE VIEW emp_view
AS
SELECT deptno ,SUM(sal)TOT_SAL,COUNT(*) NUM_EMP
FROM emp
GROUP BY deptno;
What happens when the following command is issued?
UPDATE emp_view
SET tot_sal=20000
WHERE deptno=10;
A.The base table cannot be updated through this view.
B.The TOT_SAL column in the EMP table is updated to 20000 for department 10.
C.The TOT_SAL column in the EMP_VIEW view is updated to 20000 for department 10.
D.The SAL column in the EMP table is updated to 20000 for employees in department 10.
3.You have a view called SNN_SAL that is based on the EMPLOYEE table. The structure of the ANN_SAL view is:
Name Null? Type
______________________________
________________________
EPTNO NOT NULL NUMBER(4)
YEARLY_SAL NUMBER(9,2)
MONTHLY_SAL NUMBER(9,2)
Which statement retrieves data from the ANN_SAL view?
A.SELECT *
FROM ann_sal;
B.SELECT *
FROM EMPLOYEE;
C.SELECT *
FROM VIEW ann_sal;
D.SELECT *
FROM VIEW ann_sal BASEDON employee;
4.Click on the Exhibit button and examine the table instance chart for the patient table .
You create the patient_vu view based on id_number and last_name columns from the patient table.What is the best way to modify the view to contain only those patients born in 1997?
A.Replaced the view adding a WHERE clause.
B.Use the ALTER command to add a WHERE clause to verify thetime.
C.Drop the patient_vu,then create a new view with a WHERE clause.
D.Drop the patient_vu,then create a new view withe a HAVING clause.
5.In the declarative section of a PL/SQL block, you create but did not initialize a number variable.When the block executes, what will be initial value of the variable?
A.0
B.null(*)
C.it depend on the scale and precision of the variable.
D.The block will not execute because the variable was initialized.
6.Evaluate this PL/SQL block
DECLARE
v_result NUMBER(2)
BEGIN
DELETE
FROM employee
WHERE dept_id IN(10,20,30);
V_result:=SQL&ROWCOUNT;
COMMIT;
END
What will be the value of v_result if no rows are deleted?
A.zero (*)
B.one
C.true
D.null
E.false
7.Evaluate this PL/SQL block
BEGIN
FOR i IN 1..10 LOOP
IF i=4 OR i=6 THEN
NULL;
ELSE
INSERT INTO test(results)
VALUES (1);
END IF;
COMMIT;
END LOOP
ROLLBACK;
END;
How many values will be inserted into the TEST table?
A. 0
B. 4
C. 6
D. 8
E. 10
8.You need to create a PL/SQL program to insert record into the employee table.Which block of code successfully uses the INSERT command ?
A.DECLARE
V_hiredate DATE:=SYSDATE;
BEGIN
INSERT INTO emp(empno,ename,hiredate,deptn
o)
VALUES(empno_sequence,nextval
,'&name',v_hiredate,&deptno);
END (*)
B.DECLARE
V_hiredate DATE:=SYSDATE;
BEGIN
INSERT INTO emp(empno,ename,hiredate,deptn
o)
VALUES(empno_sequence,nextval
,'&name',v_hiredate,&deptno);
END
C.DECLARE
V_hiredate DATE:=SYSDATE;
BEGIN
INSERT INTO emp(empno,ename,hiredate)
VALUES(empno_sequence,nextval
,'&name',v_hiredate,&deptno);
END
D.DECLARE
V_hiredate DATE:=SYSDATE;
BEGIN
INSERT INTO emp(empno,ename,hiredate,deptn
o)
VALUES(empno_sequence,nextval
,'&name',v_hiredate,&deptno);
WHERE job='clerk';
END
9.Which two conditions in a PL/SQL block cause an exception to occur?(choose two)
A.The SELECT statement does not return a row .
B.The SELECT statement returns more than one row.
C.The SELECT statement contains a GROUP BY clause.
D.The SELECT statement does not have a WHERE clause.
E.The datatypes in the SELECT list are inconsistent with the datatypes in the INTO clause.
10.The EMPLOYEE table contains these columns;
LAST_NAME VARCHAR2(25)
FIRST_NAME VARCHAR2(25)
SALARY NUMBER(7,2)
You need to display the names of employees that earn more than the average salary of all
employees.Evaluate this SQL statement :
SELECT last_name,first_name
FROM employee
WHERE salary>AVG(salary);
Which change should you make to achieve the desired results?
A.Change the function in the WHERE clause.
B.Move the function to the SELECT clause and add a GROUP BY clause.
C.Use a subquery in the WHERE clause to commpare the average salary value.
D.Move the function the SELECT clause and add a GROUP BY clause and a HAVING clause. |
|
|
|
|