Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Interview Questions(Oracle9i DBA), help me

Interview Questions(Oracle9i DBA), help me

From: Raaj <erkraj_at_gmail.com>
Date: 3 Mar 2006 06:33:13 -0800
Message-ID: <1141396393.059303.129060@z34g2000cwc.googlegroups.com> 





    
  
  1.   Does windows NT support direct I/O?






Answer: Choose one of the answers that apply


    
  
  1.   No, only AIO
  
  2.   Yes, depending on hardware.
  
  3.   Yes.
  
  4.   No.

  
  5.   Can you take a coldbackup from solaris and use it on windows NT?






Answer: Choose one of the answers that apply


    
  
  1.   Yes.
  
  2.   Yes if RMAN backup performed from NT server.
  
  3.   Yes, after running RMAN convert.
  
  4.   No.

  
  5.   All of the following will alter the number of checkpoints that occur
in one hour on the database, except one. Which is it?






Answer: Choose one of the answers that apply


    
  
  1.   Decreasing tablespace size
  
  2.   Decreasing size of redo log members
  
  3.   Setting LOG_CHECKPOINT_INTERVAL greater than the size of the redo
log file
  
  4.   Setting LOG_CHECKPOINT_TIMEOUT to zero

  
  5.   The DBA is attempting to back up the Oracle database control file.
After
issuing the ALTER DATABASE BACKUP CONTROLFILE TO TRACE command, where
can the DBA find the backup control file creation materials Oracle
created for him or her ?






Answer: Choose one of the answers that apply


    
  
  1.   USER_DUMP_DEST

  
  2.   LOG_ARCHIVE_DEST

  
  3.   CORE_DUMP_DEST

  
  4.   BACKGROUND_DUMP_DEST


  
  5.   What is the most important action a DBA must perform after changing
the database from NOARCHIVELOG TO ARCHIVELOG?






Answer: Choose one of the answers that apply


    
  
  1.   Shutdown normal and restart the database
  
  2.   Perform a full logical database backup
  
  3.   Perform a full offline database backup
  
  4.   Manually switch the log files

  
  5.   Which of the following choices lists an ALTER USER option that can
be executed by the user herself or himself?






Answer: Choose one of the answers that apply


    
  
  1.   DEFAULT TABLESPACE

  
  2.   IDENTIFIED BY

  
  3.   TEMPORARY TABLESPACE

  
  4.   PROFILE


  
  5.   You need to view the initialization parameter settings for your
Oracle
database. Which of the following choices does not identify a method
you can use to obtain values set for your initialization parameters?






Answer: Choose one of the answers that apply


    
  
  1.   Issue SELECT * FROM DBA_PARAMETERS; from SQL*Plus
  
  2.   Issue SELECT * FROM V$PARAMETER; from SQL*Plus
  
  3.   Issue SHOW PARAMETERS from Server Manager
  
  4.   Use OEM Instance Manager

  
  5.   As a result of a media failure, the current online redo log group is
corrupted, the database crashes, as the current online group is
inaccessible. Which type of incomplete recovery are you most likely to
perform ?






Answer: Choose one of the answers that apply


    
  
  1.   Change-based
  
  2.   Time-based
  
  3.   Recovery using a backup control file
  
  4.   Cancel-based

  
  5.   User SNOW executes the following statement: SELECT * FROM EMP. This
statement executes successfully, and SNOW can see the output. Table
EMP is owned by user REED. What object would be required in order for
this scenario to happen ?






Answer: Choose one of the answers that apply


    
  
  1.   User SNOW would need the role to view table EMP.
  
  2.   User SNOW would need the privileges to view table EMP.
  
  3.   User SNOW would need a synonym for table EMP.
  
  4.   User SNOW would need the password for table EMP.


  
      
    
    1.   Which one of the following statements is true?


  
    





Answer: Choose one of the answers that apply


    
  
  1.   The request queue is common, and the response queue is different
for all the dispatchers.
  
  2.   The request queue and response queue are different for all the
dispatchers.
  
  3.   The request queue is different, and response queue is common for
all the dispatchers.
  
  4.   The request queue and response queue are common for all the
dispatchers.


  
      
    
    1.   What is the largest SGA size for 8.1.7.4 32 bit?


  
    





Answer: Choose one of the answers that apply


    
  
  1.   approximately 2GB
  
  2.   approximately 3.5GB
  
  3.   approximately 4GB
  
  4.   approximately 8GB
  
  5.   approximately 16GB


  
      
    
    1.   The DBA is about to perform some administrative tasks. Specifying
the
OPTIMAL parameter has which of the following appropriate uses?


  
    





Answer: Choose one of the answers that apply


    
  
  1.   Limiting concurrent users
  
  2.   Limiting concurrent transactions
  
  3.   Limiting growth of rollback segments
  
  4.   Limiting growth of tables



  
      
    
    1.   If the DBA wants to find information about how often transactions
are
wrapping transaction information between multiple rollback segment
extents, where would the DBA look to find that information?


  
    





Answer: Choose one of the answers that apply


    
  
  1.   DBA_ROLLBACK_SEGS

  
  2.   V$ROLLSTAT

  
  3.   V$ROLLNAME

  
  4.   DBA_SEGMENTS



  
      
    
    1.   You have 30 rollback segments in your database, for which
TRANSACTIONS_PER_ ROLLBACK_SEGMENT is set to 49 and
TRANSACTIONS is set to 1000. During periods of heavy usage, about how
many rollback segments will be actively used by Oracle?


  
    





Answer: Choose one of the answers that apply


    
  
  1.   50
  
  2.   60
  
  3.   20
  
  4.   30


  
      
    
    1.   The DBA has a table created with the following statement:
CREATE TABLE EMPL

(EMPID NUMBER(10),

LASTNAME VARCHAR2(40),

RESUME LONG RAW);

The DBA attempts to issue the following statement:
ALTER TABLE EMPL

ADD ( PERF_APPRAISE LONG);

What happens?


  
    





Answer: Choose one of the answers that apply


    
  
  1.   The statement succeeds.
  
  2.   The statement succeeds, but column is added as VARCHAR2.
  
  3.   The statement fails.
  
  4.   The statement adds a disabled constraint.


  
      
    
    1.   The primary key of the EMP table has three columns, EMPID,
LASTNAME,

and FIRSTNAME. You issue the following SELECT statement:
SELECT * FROM EMP WHERE LASTNAME = 'HARRIS' AND FIRSTNAME = 'BILLI'

AND EMPID = '5069493';

Where would you look to see if this query will use the index associated


  
    





with the primary key?



Answer: Choose one of the answers that apply


    
  
  1.   DBA_IND_COLUMNS

  
  2.   DBA_TAB_COLUMNS

  
  3.   DBA_INDEXES

  
  4.   DBA_CLU_COLUMNS



  
      
    
    1.   You are configuring your index to be stored in a tablespace. Which
of the
following storage parameters are not appropriate for indexes?


  
    





Answer: Choose one of the answers that apply


    
  
  1.   OPTIMAL

  
  2.   INITIAL

  
  3.   PCTINCREASE

  
  4.   NEXT



  
      
    
    1.   You need to set up auditing in an order entry and product shipment
application so that when the ORDER_STATUS column in the ORDERS
table changes to 'SHIPPED', a record is placed in a special table
associated
with a part of the application that gives sales representatives a daily
list
of customers to call on a follow-up to make sure the customer is
satisfied
with the order. Which of the following choices represents the best way
to perform this auditing?


  
    





Answer: Choose one of the answers that apply


    
  
  1.   Statement auditing
  
  2.   Object auditing
  
  3.   Audit by access
  
  4.   Value-based auditing


  
      
    
    1.   Information in the buffer cache is saved back to disk in each of
the
following situations except one. In which situation does this not
occur?


  
    





Answer: Choose one of the answers that apply


    
  
  1.   When a time-out occurs
  
  2.   When a log switch occurs
  
  3.   When the shared pool is flushed
  
  4.   When a checkpoint occurs

  
  5.   In order to allow remote administration of users and tablespaces on
an Oracle database, which of the following types of files must exist in
the database?






Answer: Choose one of the answers that apply


    
  
  1.   Password file
  
  2.   Initialization file
  
  3.   Datafile
  
  4.   Control file
  
  5.   Nothing, SYSDBA privileges are not required for these actions.

  
  6.   You are planning the storage requirements for your database. Which
of the following is an effect of maintaining a high PCTFREE for a
table?






Answer: Choose one of the answers that apply


    
  
  1.   Oracle will manage filling data blocks with new records more
actively.
  
  2.   Oracle will manage filling data blocks with new records less
actively.
  
  3.   Oracle will leave more space free in data blocks for existing
records.
  
  4.   Oracle will leave less space free in data blocks for existing
records.

  
  5.   You manage database access privileges with roles where possible.
You have granted the SELECT_MY_TABLE role to another role, called
EMP_DEVELOPER. To view information about other roles that may be
granted to EMP_DEVELOPER, which of the following dictionary views
are appropriate?






Answer: Choose one of the answers that apply


    
  
  1.   DBA_ROLE_PRIVS

  
  2.   DBA_TAB_PRIVS

  
  3.   USER_SYS_PRIVS

  
  4.   ROLE_ROLE_PRIVS


  
  5.   In order to set your SQL*Plus session so that your NLS_DATE_FORMAT
information is altered in a specific way every time you log into
Oracle,
what method would be used?






Answer: Choose one of the answers that apply


    
  
  1.   Setting preferences in the appropriate menu option
  
  2.   Creating an appropriate LOGIN.SQL file
  
  3.   Issuing the ALTER USER statement
  
  4.   Issuing the ALTER TABLE statement

  
  5.   You create a sequence with the following statement:
CREATE SEQUENCE MY_SEQ

START WITH 394

INCREMENT BY 12

NOMINVALUE

NOMAXVALUE

NOCACHE

NOCYCLE;

Two users have already issued SQL statements to obtain NEXTVAL, and
four more have issued SQL statements to obtain CURRVAL. If you issue a
SQL statement to obtain the NEXTVAL, what will Oracle return?






Answer: Choose one of the answers that apply


    
  
  1.   406  
  
  2.   418  
  
  3.   430  
  
  4.   442  
 





Thanks and Regards,


Raaj
Received on Fri Mar 03 2006 - 08:33:13 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US