BENGKEL SQL : SLOT 2

1. What is a data type in SQL?

• a. A method for storing data in a table

• b. A method for sorting data in a table

• c. A type of database schema

• d. A method for securing data in a table

2. What is a string in SQL?

• a. A sequence of floating-point numbers

• b. A sequence of characters

• c. A sequence of Booleans

• d. A sequence of integers

3. Which integer data type can store numbers ranging from less than negative two billion to more than positive two billion?

• SMALLINT

• BIGINT

• INT

• TINYINT

4. What is a schema in SQL?

• a. A method for storing data

• b. A type of data

• c. A blueprint of a database

• d. A type of database

5. Which of the following is a reason for using data types in SQL?

• a. To make the data more difficult to understand

• b. To make the data more difficult to access

• c. To make the data harder to manipulate

• d. To make the data take up less storage space

6. What is the correct syntax for creating a table named "employees" with columns "employee_id" (integer), "name" (string), "age" (integer), and "salary" (float)?

• a. CREATE TABLE employees (employee_id INT, name VARCHAR(255), age INT, salary NUMERIC(10,2));

• b. CREATE TABLE employees (employee_id INT, name VARCHAR, age INT, salary FLOAT);

• c. CREATE TABLE employees (employee_id INTEGER, name STRING, age INTEGER, salary FLOAT);

• d. CREATE TABLE employees (employee_id INT, name TEXT, age INT, salary REAL);

7. Which SQL keyword is used to retrieve unique values from a table?

• a. SELECT UNIQUE VALUES

• b. SELECT UNIQUE ROWS

• c. SELECT UNIQUE

• d. SELECT DISTINCT

3. Which SQL command is used to retrieve data from a database?

• a. DELETE

• b. SELECT

• c. UPDATE

• d. INSERT

9. Which of the following statements retrieves all columns and rows from a table called "students"?

• a. DISPLAY ALL FROM students;

• b. SELECT ALL FROM students;

• c. SELECT * FROM students;

• d. RETRIEVE * FROM students;

10. What is the difference between a view and a table in SQL?

• a. A view is a temporary table, while a table is a permanent storage of data.

• b. A view is a table that only contains selected columns from another table

• c. A view is a table that is used for joining data from multiple tables.

• d. A view is a table that is used for back up purpose only.