1. The following is a valid SQL statement. SELECT e.employee_id, e.last_name, d.location_id, department_id FROM employees e JOIN departments d USING (department_id) ; True or False? Mark for Review (1… more →
ORACLE Academy © 2009Blogu' lu' Flory wrote 1 day ago: Ce artist a debutat în industria muzicală cu albumul “I Dreamed A Dream”? Susan Boyle Me … more →
Blogu' lu' Flory wrote 2 days ago: The Impossible Quiz 2 1. Up his sleevies 2. Paint 3. Earth (the rest are candy bars, remember) 4. Am … more →
Blogu' lu' Flory wrote 2 days ago: The Impossible Quiz 1 Question 1: Four Question 2: No, but a tin can Question 3: K.O Question 4: THE … more →
Alex wrote 2 days ago: 1. The following is a valid SQL statement. SELECT e.employee_id, e.last_name, d.location_id, departm … more →
Alex wrote 2 days ago: 1. A NATURAL JOIN is based on: Mark for Review (1) Points Columns with the same name and datatype (* … more →
Alex wrote 2 days ago: 1. Which select statement will return the last name and hire data of an employee and his/ her manage … more →
Alex wrote 2 days ago: 1. The following is a valid outer join statement: SELECT c.country_name, d.department_name FROM coun … more →
Alex wrote 2 days ago: 1. Which statement about joining tables with a non-equijoin is false? A WHERE clause must specify a … more →
Alex wrote 2 days ago: 1. If table A has 10 rows and table B has 5 rows, how many rows will be returned if you perform an e … more →
Alex wrote 2 days ago: 1. CASE and DECODE evaluate expressions in a similar way to IF-THEN-ELSE logic. However, DECODE is s … more →
Alex wrote 2 days ago: 1. Consider the following data in the Employees table: last_name commission_pct manager_id King null … more →
Alex wrote 2 days ago: 1. A table has the following definition: EMPLOYEES( EMPLOYEE_ID NUMBER(6) NOT NULL, LAST_NAME VARCHA … more →
Alex wrote 2 days ago: 1. Which query would return a whole number if the sysdate is 26-MAY-04? SELECT TRUNC(MONTHS_BETWEEN( … more →
Alex wrote 2 days ago: 1. What is the result of the following SQL Statement: SELECT ROUND(45.923,-1) FROM DUAL; 46 45.9 50 … more →
Blogu' lu' Flory wrote 2 days ago: Câţi copii are rapperul Lil Wayne? 2 Catastrofe: Cum se numeşte cargoul care s-a scufundat aproape d … more →
Blogu' lu' Flory wrote 3 days ago: Din ce trupă face parte Damon Albarn? Gorillaz Educaţie: În ce an a fost fondată Universitate … more →
Alex wrote 4 days ago: 1. Identify the output from the following SQL statement: SELECT RPAD(‘SQL’,6, ‘* … more →
Blogu' lu' Flory wrote 4 days ago: Compozitori români: În ce an devine Sabin Drăgoi membru corespondent al Academiei Române? R: 1955 … more →
Blogu' lu' Flory wrote 5 days ago: Câte miliarde de euro va trebui să plătească statul român băncilor în 2010? R: 12 miliarde Capitale: … more →