Quiz DBMS
Petunjuk: 
Kerjakan soal-soal berikut ini dengan urut dan jelas! 
1.  Tentukan apakah perintah-perintah SQL berikut dapat dieksekusi/dijalankan ! Jika tidak dapat
dieksekusi/dijalankan, berikan alasannya ! 
a.  SELECT first_name or last_name 
FROM employees; 
Jawaban :  Incorrect syntax near the keyword 'or'.
b.  SELECT first_name, last_name 
FROM employees 
WHERE last_name LIKE = "S%"; 
Jawaban : Line 3: Incorrect syntax near '='.
c.  SELECT employee_id or salary 
FROM employees 
WHERE between  5000 and 12000; 
Jawaban : Incorrect syntax near the keyword 'or'.
d.  SELECT FROM employees; 
Jawaban : Incorrect syntax near the keyword 'FROM'.
e.  SELECT salary, 2*salary 
 FROM employees;
Jawaban :  correct, The command(s) completed successfully.