פתרונות SQL Server

הפתרונות הבאים תקפים לפלטפורמת מיקרוסופט, לפתרונות עבור פלטפורמת אורקל לחץ כאן.

1.
DESC employees  

2.  
SELECT  *
FROM   employees 

3.
FROM employees 
SELECT last_name , first_name 

שגיאה

.4
SELECT department_name , department_id , manager_id AS "MNG"
FROM  departments 

.5
SELECT department_name , department_name 
FROM   departments 

תקין

.6
SeleCT        last_NAME , fiRST_NamE , FROM Employees

שגיאה - פסיק מיותר

.7
SELECT employee_id , first_name , last_name , phone_number , department_id 
FROM   employees 

.8
SELECT first_name , last_name , hire_date , salary , 
       salary * 12 AS "ANNUAL_SAL"
FROM employees 

9.
B
.10
SELECT first_name + ' ' +last_name AS "FULL_NAME" , 
       phone_number + ' - ' + email AS "CONTACT_DETAILS"
FROM employees 

.11
SELECT DISTINCT manager_id 
FROM employees 

.12
SELECT last_name + ' ' + job_id AS "EMPLOYEE_AND_TITLE"
FROM employees 

.13
-- In MSSQL, in order to concatenate string with date / number, everything must be converted into string.
-- One way to preform this conversion is using the CAST function.
SELECT first_name AS "FN" , last_name AS "LN" , salary AS "SAL" , 
       'HD : '+ CAST(hire_date AS VARCHAR) AS "HD"
FROM employees 

14.
SELECT DISTINCT salary 
FROM employees

15.
SELECT DISTINCT department_id , job_id  
FROM employees

פתרונות Oracle

1.
DESC employees  

2.  
SELECT  *
FROM   employees 

3.
FROM employees 
SELECT last_name , first_name 

שגיאה

.4
SELECT department_name , department_id , manager_id AS "MNG"
FROM  departments 

.5
SELECT department_name , department_name 
FROM   departments 

תקין

.6
SeleCT        last_NAME , fiRST_NamE , FROM Employees

שגיאה - פסיק מיותר

.7
SELECT employee_id , first_name , last_name , phone_number , department_id 
FROM   employees 

.8
SELECT first_name , last_name , hire_date , salary , 
       salary * 12 AS "ANNUAL_SAL"
FROM employees 

9.
אף אחת מהתשובות אינה נכונה - ה

.10
SELECT first_name || ' ' || last_name AS "FULL_NAME" , 
       phone_number || ' - ' || email AS "CONTACT_DETAILS"
FROM employees 

.11
SELECT DISTINCT manager_id 
FROM employees 

.12
SELECT last_name || ' ' || job_id AS "EMPLOYEE_AND_TITLE"
FROM employees 

.13
SELECT first_name AS "FN" , last_name AS "LN" , salary AS "SAL" , 
       'HD : '|| hire_date AS "HD"
FROM employees 

14.
SELECT DISTINCT salary 
FROM employees

15.
SELECT DISTINCT department_id , job_id  
FROM employees