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.