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 Fondamentaux
[20 Questions]
  Question 1 How many columns are presented after executing this query: SELECT address1||','||address2||','||address2 "Adress" FROM employee;
 A.
1
 B.
2
 C.
3
 D.
0
 E.
4
  Question 2 Which of the following can be a valid column name?
 A.
Column
 B.
1966_Invoices
 C.
Catch_#22
 D.
#Invoices
 E.
None of the above
  Question 3 Which command will delete all data from a table and will not write to the rollback segment?
 A.
DROP
 B.
DELETE
 C.
CASCADE
 D.
TRUNCATE
  Question 4 Which character function can be used to return a specified portion of a character string?
 A.
INSTR
 B.
SUBSTRING
 C.
SUBSTR
 D.
POS
  Question 5 The primary key on table EMP is the EMPNO column. Which of the following statements will not use the associated index on EMPNO?
 A.
select * from EMP where nvl(EMPNO, '00000') = '59384';
 B.
select * from EMP where EMPNO = '59384';
 C.
select EMPNO, LASTNAME from EMP where EMPNO = '59384';
 D.
select 1 from EMP where EMPNO = '59834';
  Question 6 Which character is used to continue a statement in SQL*Plus?
 A.
*
 B.
/
 C.
-
 D.
@
 E.
=
  Question 7 Assuming today is Monday, 10 July 2000, what is returned by this statement: SELECT to_char(NEXT_DAY(sysdate, 'MONDAY'), 'DD-MON-RR') FROM dual;
 A.
03-juil-00
 B.
10-juil-00
 C.
12-juil-00
 D.
11-juil-00
 E.
17-juil-00
 F.
09-juil-00
  Question 8 To produce a meaningful result set without any cartesian products, what is the minimum number of conditions that should appear in the WHERE clause of a four-table join?
 A.
8
 B.
2
 C.
3
 D.
4
 E.
5
 F.
There is no such criteria
  Question 9 Which of the following SQL functions can operate on any datatype?
 A.
TO_CHAR
 B.
LOWER
 C.
LPAD
 D.
MAX
 E.
CEIL
  Question 10 Which Oracle access method is the fastest way for Oracle to retrieve a single row?
 A.
Primary key access
 B.
Access via unique index
 C.
Table access by ROWID
 D.
Full table scan
   
( 1 2 ) / 2
 
  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