wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

DBMS 1

Total questions: 10

Worksheet time: 5mins

Name
Class
Date
1.

SELECT (a)   , location_id

FROM departments;

2.

SQL (a)   are not case-sensitive.

3.

(a)   cannot be abbreviated or split across lines

4.

SELECT last_name, salary, (a)  

FROM employees;

5.

SELECT last_name "Name" , salary*12 "_____ _____"

FROM employees;

(a)  

6.

SELECT (a)   AS "Employees"

FROM employees;

7.

SELECT last_name ||' (a)   '||job_id

AS "Employee Details"

FROM employees;

8.

SELECT (a)   department_id

FROM employees;

9.

(a)   employees

10.

SELECT *|{[DISTINCT] column|expression [alias],...}

FROM table;


what statement is that?

(a)