Recherche 
 
Plan du site Accueil Nous contacter Plan du site
   
  Jeudi 09 Septembre 2010
   
 
  Oracle
 
J2EE
 
SAP
 
HP
 
Autres Thèmes
 
Certifications
 
Séminaires IT
 
Calendriers
 
Approche pédagogique
 
Packages , Forfaits , Cours du soir
 
Centre de Test Pearson Vue
  

Evénements
Actualités
Nouveautés
Offres promotionnelles
  
 
  
       
     
 
Cursus Administration Base de données
[32 Questions]
  Question 1 The finest level of logical database space is called:
 A.
SEGMENTS
 B.
EXTENTS
 C.
DATA BLOCKS
 D.
TABLESPACE
  Question 2 Which component of an instance holds session variables and arrays when you are NOT running in MTS mode?
 A.
SGA
 B.
SQL Area
 C.
Library Cache
 D.
PGA
 E.
Shared Pool
  Question 3 Which Oracle background process is responsible for coalescing free space?
 A.
PMON
 B.
SMON
 C.
ARCH
 D.
LGWR
  Question 4 The CKPT process is optional; which process assumes these duties if CKPT is not active?
 A.
PMON
 B.
SMON
 C.
ARCH
 D.
LGWR
  Question 5 The DBWR process is NOT responsible for:
 A.
Defers writes for I/O optimization
 B.
Uses a LRU algorithm to keep most recently used blocks in memory
 C.
Writes to database redo log files as people COMMIT data
 D.
Writes all changed (i.e. dirty) buffers to datafiles
  Question 6 Which statement about the LGWR is false?
 A.
There is only one redo log writer per instance
 B.
A commit confirmation may be issued before a transaction has been recorded in the redo log file
 C.
During long transactions Oracle can flush data to the redo logs before it is committed.
 D.
An Oracle instance cannot survive without a redo log writer
  Question 7 The storage parmeters for a given table are: INITIAL=100, NEXT=100, MINEXTENTS=2, MAXEXTENTS=10, PCTINCREASE=20. If the first 3 extents are filled, what will the size of the FOURTH extent be?
 A.
120
 B.
140
 C.
144
 D.
240
 E.
400
  Question 8 Assume the database administrator wanted to limit the amount of idle time that any one user could have during a given session. Which of the following would be used to enforce such a limit?
 A.
audit
 B.
quota
 C.
limit
 D.
profile
  Question 9 Discarding redo logs is done with which of the following statements?
 A.
alter database archivelog;
 B.
alter database open resetlogs;
 C.
alter database mount exclusive;
 D.
alter system archive log all;
  Question 10 The DBA is creating a new user. Which of the following is NOT defined at user creation?
 A.
default tablespace
 B.
profile
 C.
idle_time
 D.
default role
   
( 1 2 3 4 ) / 4
 
  Espace client
 
Login
Password
 
   
  • Mot de passe oublié ?
• Vous n'avez pas de compte ?
 
 
  Téléchargement
 
 
• Plaquette
• Catalogues
• Livres blancs
   
 
 
Pré-requis en ligne
  Pour évaluer vos
connaissances avant
de vous inscrire à un
cours.
 
 
Formations du mois
  • Comptabilité financière et reporting

• Introduction aux solutions SAP

• Les fondamentaux du SAP Web AS

• Oracle Database 10g: Administration Workshop I Release 2

• Oracle Database 10g: SQL and PL/SQL Fundamentals

• Oracle Database 10g: Administration Workshop II Release 2

• Oracle Database 10g: Performance Tuning

 
 
Evénements du mois
 

Aucun événement pour ce mois.
 
  © 2008 OMNIACADEMY