DBMS Enhancement Quiz

How to Create a Database.

• ALTER DATABASE myDB READ ONLY = 1;

• CREATE DATABASE myDB READ ONLY = 0;

• CREATE DATABASE myDB;

• DROP DATABASE myDB;

How to set a Database as Read Only, type:

• ALTER DATABASE myDB READ ONLY = 1;

• ALTER DATABASE myDB READ ONLY = 0;

• CREATE DATABASE myDB;

• DROP DATABASE myDB;

How to delete a Database.

• ALTER DATABASE myDB READ ONLY = 1;

• ALTER DATABASE myDB READ ONLY = 0;

• DEL DATABASE myDB;

• DROP DATABASE myDB;

How to create a table with employees data tuples in Database.

• CREATE TABLE employees (

  employee_id,

  first_name,

  last_name,

  hourly_pay,

  hire_date

  );

• ALTER TABLE CREATE TABLE employees (

  employee_id,

  first_name,

  last_name,

  hourly_pay,

  hire_date

  );

• DROP TABLE employees (

  employee_id,

  first_name,

  last_name,

  hourly_pay,

  hire_date

  );

• UPDATE TABLE employees (

  employee_id,

  first_name,

  last_name,

  hourly_pay,

  hire_date

  );

How to rename a table from employees to workers.

• RENAME TABLE employees TO workers;

• ALTER TABLE employees TO workers;

• UPDATE TABLE employees TO workers;

• SELECT TABLE employees TO FROM workers;

How to add columns in the employees table with phone number with correct data type.

• INSERT TABLE employees

  ADD phone_number DECIMALS(15);

• UPDATE TABLE employees

  ADD phone_number VARCHAR(15);

• ALTER TABLE employees

  ADD phone_number INT(15);

• ALTER TABLE employees

  ADD phone_number VARCHAR(15);

How to rename column name in the employees table with phone number to email.

• MODIFY TABLE employees

  RENAME COLUMN phone_number to email;

• UPDATE TABLE employees

  RENAME COLUMN phone_number to email;

• ALTER TABLE employees

  RENAME COLUMN phone_number to email;

• ALTER TABLE employees

  INSERT phone_number to email;

How to change the data type of email in the employees table.

• MODIFY TABLE employees

  MODIFY COLUMN email VARCHAR(100);

• ALTER TABLE employees

  MODIFY COLUMN email VARCHAR(100);

• UPDATE TABLE employees

  MODIFY COLUMN email VARCHAR(100);

• ALTER TABLE employees

  MODIFY COLUMN email INT(100);

Find all the data from employees hire date less than or equal to 2023-01-03

• SELECT *

  FROM employees

  WHERE hire_date < “2023-01-03”;

• SELECT *

  FROM employees

  WHERE hire_date = “2023-01-03”;

• SELECT *

  FROM employees

  WHERE hire_date >= “2023-01-03”;

• SELECT *

  FROM employees

  WHERE hire_date <= “2023-01-03”;

Find all the data from the employee Spongebob.

• SELECT *

  FROM employees

  WHERE first_name ALL “Spongebob”;

• SELECT *

  FROM employees

  WHERE first_name IN “Spongebob”;

• SELECT *

  FROM employees

  WHERE first_name = “Spongebob”;

• SELECT *

  FROM employees

  WHERE first_name => “Spongebob”;