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

ALTER TABLE employees MODIFY COLUMN email VARCHAR(100);

MODIFY 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 = “Spongebob”;

SELECT * FROM employees WHERE first_name ALL “Spongebob”;

SELECT * FROM employees WHERE first_name IN “Spongebob”;

SELECT * FROM employees WHERE first_name => “Spongebob”;

Find all the data from employees hourly pay greater or equal to 15.

SELECT * FROM employees WHERE hourly_pay = 15;

SELECT * FROM employees WHERE hourly_pay <= 15;

SELECT * FROM employees WHERE hourly_pay >= 15;

SELECT * FROM employees WHERE hourly_pay > 15;

Find the employees that do not have the hire date.

SELECT * FROM employees WHERE hire_date IS NULL;

SELECT * FROM employees WHERE hire_date IS MISSING;

SELECT * FROM employees WHERE hire_date IS NO DATA;

SELECT * FROM employees WHERE hire_date IS 0 ;

How to change the position of email column from the employees table.

ALTER TABLE employees MODIFY email VARCHAR(100) AFTER last_name;

ALTER TABLE employees MODIFY email VARCHAR(100) FIRST;

ALTER TABLE employees MODIFY email VARCHAR(100) LAST;

ALTER TABLE employees MODIFY email VARCHAR(100) AFTER first _name ;

How to delete a row from a table.

DELETE FROM employees; WHERE employee_id = 6;

DROP FROM employees; WHERE employee_id = 6;

DROP ROW FROM employees; WHERE employee_id = 6;

How to delete email column from the employees table.

ALTER TABLE employees DROP COLUMN email;

UPDATE TABLE employees DROP COLUMN email;

MODIFY TABLE employees DROP COLUMN email;

INSERT TABLE employees DROP COLUMN email;

How to insert row from the employees table.

INSERT INTO employees VALUES ();

INSERT INTO employees VALUES (), (), (), ();

MODIFY TABLE INTO employees VALUES ();

UPDATE INTO employees VALUES ();

How to insert specific data in employees table.

INSERT INTO employees (employee_id, first_name, last_name) VALUES (6, “Sheldon”, “Plankton”),

UPDATE INTO employees (employee_id, first_name, last_name) VALUES (6, “Sheldon”, “Plankton”),

INSERT INTO employees (employee_id, last_name) VALUES (6, “Sheldon”, “Plankton”),

INSERT INTO employees (employee_id ) VALUES (6, “Sheldon”, “Plankton”),

What does the ALTER TABLE clause do?

The SQL ALTER TABLE clause modifies a table definition by altering, adding, or deleting table columns and/or constraints

The SQL ALTER TABLE clause is used to insert data into database table

THE SQL ALTER TABLE deletes data from database table

The SQL ALTER TABLE clause is used to delete a database table

Match the following SQL term with a description - FROM

The field and order used to sort the results

Write the CORRECT relational algebra expression base on this schema: Manager(managerId, managerName, age, address, workExperience, salary). Show the name of all managers and ID whose experience is more than 5.

π managerID, managerName (σ workExprience > 5) (MANAGER)

π managerID, managerName ( σ workExprience = 5) (MANAGER)

σ managerID, managerName (π workExprience > 5) (MANAGER)

σ managerID, managerName (π workExprience = 5) (MANAGER)

π ID, Name (σ Exprience > 5) (MANAGER)

Based on the following schema List names of sailors who are over 21 years old. Schema: Sailors (sid, name, rating, age); Boats (bid, name, color) ; Reserves (sid, bid, day)

πname ( σage>21 (Sailors)) U πname (Sailors)

What is meant by the term union compatibility?

When two or more tables share the same number of columns and when they share the same domains

When two or more tables share the same number of columns

When two or more tables have the same degree

When two or more tables share the same (or compatible) domains

What will the following relational algebra statement do?σ release_year>1997 AND genre=’sci-fi'(Movies)

Select tuples from the movies table where the release year was greater than 1997 and the genre is sci-fi.

Join tuples from the movies table where the release year was greater than 1997 and the genre is sci-fi.

Select tuples from the release year table where the genre is sci-fi.

Join tuples from the release year table where the genre is sci-fi.

In SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" starts with an "a"?

SELECT * FROM Persons WHERE FirstName LIKE 'a%'

SELECT * FROM Persons WHERE FirstName LIKE '%a'

SELECT * FROM Persons WHERE FirstName='a'

SELECT * FROM Persons WHERE FirstName='%a%'

How can you change "Gonzales" into "Casimina" in the "LastName" column in the Persons table?

UPDATE Persons SET LastName='Casimina' WHERE LastName='Gonzales'

MODIFY Persons SET LastName='Casimina' WHERE LastName='Gonzales'

UPDATE Persons SET LastName='Gonzales' INTO LastName='Casimina'

MODIFY Persons SET LastName='Gonzales' INTO LastName='Casimina'

With SQL, how can you insert a new record into the "Persons" table?

INSERT VALUES ('Jimmy', 'Jackson') INTO Persons

INSERT ('Jimmy', 'Jackson') INTO Persons

INSERT INTO ('Jimmy', 'Jackson') INTO Persons

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?

SELECT * FROM Persons WHERE Firstname = 'Peter'

SELECT * FROM Persons WHERE Firstname <>'Peter'

SELECT * FROM Persons WHERE Firstname LIKE 'Peter'

SELECT [all] FROM Persons WHERE Firstname ='Peter'

What is wrong with the following code: SELECT * FROM movies WHERE genre = comedy AND year < 2016 ORDER BY year DESC;

Comedy should have single quotes around it

DBMS Enhancement Quiz

Authored by Agnes Gonzales

Other

University

Used 3+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

33 questions

Show all answers

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

How to Create a Database.

ALTER DATABASE myDB READ ONLY = 1;

CREATE DATABASE myDB READ ONLY = 0;

CREATE DATABASE myDB;

DROP DATABASE myDB;

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

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;

MULTIPLE CHOICE QUESTION

1 min • 1 pt

How to delete a Database.

ALTER DATABASE myDB READ ONLY = 1;

ALTER DATABASE myDB READ ONLY = 0;

DEL DATABASE myDB;

DROP DATABASE myDB;

MULTIPLE CHOICE QUESTION

1 min • 1 pt

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

);

MULTIPLE CHOICE QUESTION

1 min • 1 pt

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;

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

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);

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

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;

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

30 questions

candy

Quiz

•

KG - Professional Dev...

32 questions

Understanding Strings and Arrays

Quiz

•

University

30 questions

Movies

Quiz

•

10th Grade - Professi...

35 questions

SEM I Unit 3 Post test

Quiz

•

9th Grade - University

30 questions

BASIC CONFIG,SWITH & BRIDGE MIKROTIK

Quiz

•

University

28 questions

LIS ELEC 02 WEEK 14

Quiz

•

University

30 questions

Spowiedź

Quiz

•

1st Grade - University

28 questions

Front Office Management

Quiz

•

University

Popular Resources on Wayground

10 questions

5.P.1.3 Distance/Time Graphs

Quiz

•

5th Grade

10 questions

Fire Drill

Quiz

•

2nd - 5th Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

15 questions

Hargrett House Quiz: Community & Service

Quiz

•

5th Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

20 questions

Inferences

Quiz

•

4th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

Discover more resources for Other

18 questions

Informative or Argumentative essay

Quiz

•

5th Grade - University

20 questions

Disney Trivia

Quiz

•

University

20 questions

8.II_Review_TEACHER

Quiz

•

University

39 questions

Unit 7 Key Terms

Quiz

•

11th Grade - University

20 questions

Subject verb agreement practice

Quiz

•

University

20 questions

Quadrilaterals

Quiz

•

KG - University

5 questions

Examining Theme

Interactive video

•

4th Grade - University

25 questions

WWI, Great Depression, WWII

Quiz

•

KG - University