Prepared Quizzes, How Would You Answer that Question? 2

5 01 2011

January 5, 2011

(Back to the Previous Post in the Series) (Forward to the Next Post in the Series)

Since the readers of this blog produced fantastic answers for the previous multi-part quiz, I thought that it might be an interesting challenge to try another quiz.  The questions from this quiz seems to be aimed at OCP (over-clocked personality, obviously checking performance, old cat people, and maybe a few Oracle Certified Professionals) types of people, or maybe I misunderstood.  Try to answer a couple of the questions from this quiz (with justifications of course), and we will compare notes.  My answers do not match, so I failed this quiz also.

OCP Type Questions:

  1. B
  2. D
  3. A
  4. D
  5. A
  6. (1) A
  7. (2) D
  8. (3) B
  9. (4) A
  10. (1) C
  11. (2) D
  12. (3) C
  13. (4) D
  14. (5) B



4 responses

6 01 2011
Dom Brooks

In general, I like the explanations on this one which mostly seem akin to “A is correct because it is false but B is incorrect because it is true.”

I know the quiz to a certain extent mirrors the trends of the OCP exams themselves – but it all implies that if you master OEM, you master the database.

6 01 2011
Radoslav Golian

Pager alert? I have seen
A – how big is the tablespace?, how are the data growing?, is it automatically extended? may be a problem or may be not..
B – an ancient myth.. Ratios are usually useless, there are only few which may be useful..
65% may be OK for some systems..
C- This may be a problem, but I think it is unusual to use dictionary maneged tablespaces nowadays or to use it and to have a table with so many extents
D – I don’t know what is redo log filesystem.. Redo logs are fixed size. If “redo log filesystem” includes archive redo logs destination then this may be correct
So I would choose anything else but not B 🙂

2. OEM console, is it that java application used on 9i? Because I can’t find “event manager” in current OEM, but I’m not a DBA, so maybe I’m blind 🙂

3. I don’t know, I don’t use it..

A – ok, crontab can be used for job scheduling, but dbms_job is in the database for ages (I only worked with >=8i versions of Oracle).
I would choose probably this.. You can schedule jobs using OEM, but are still using dbms_job or newer dbms_scheduler, and this is also possible without OEM..
B – similar to A, you can send emails without OEM using utl_smtp or utl_mail.
C – I don’t know what schema manager is, I’ve never use it..
D – “Using SQL*Plus to start and stop the database. This is because SQL*Plus cannot issue “startup” or “shutdown” commands”
What? In which version was it not possible?

sqlplus sys/******@maja as sysdba

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  235999648 bytes
Fixed Size                   450976 bytes
Variable Size             201326592 bytes
Database Buffers           33554432 bytes
Redo Buffers                 667648 bytes
Database mounted.
Database opened.

A-maybe ok
B- yes, we can display indexes
C-same as B
D-depends on what maintenance task is.. we could have some task on OS level..
I would choose A, D

6. this is very inaccurate question.. what if os_authent_prefix is not ops$, ops$user could be a valid user with db password auth.
A – what if server = client? and you can also have remote authentication enabled (remote_os_authent), so this is not accurate..
B – i don’t know, i’m only 27…
C – maybe yes, if remote_os_authent is enabled and it’s correctly setup
D – not true, 1. it can by set in spfile.. 2. is parameter can be null (in oracle empty string is null)
in fact oracle strongly recommends it to set to null
I would choose D.
I not sure but I think all could be correct some with remote auth enabled and some with os_auth_prefix set to “”…

8. with remote_os_authent=false you disable remote OS auth (which is disabled by default), not os authent.
No answer is correct, I think

maybe i’ll add some others 🙂

6 01 2011
Radoslav Golian

I wanted to write I have seen pages only in movies 🙂 There are not used in europe 🙂
one more:
A. I don’t think it’s correct..
what if I set user_processes to 0?

8 01 2011
Charles Hooper

As of right now, slightly less than 50 people have attempted the OCP test.

Dom, thanks for the comment. Some of the questions in that quiz seemed to be a little open-ended with no real correct answer. Something like this:
Which of the following does not belong with the others:
A. Apple
B. Horse
C. Cow
D. Rattlesnake

Radoslav, nice attempt at the questions. I have not spent quite enough time yet looking at the questions to answer as completely as you did.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: