Search Header Logo

Final Quiz Async 3

Authored by Mark Gangan

Computers

University

Used 5+ times

Final Quiz Async 3
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

40 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the correct syntax for inserting a single row into a table named employees?

INSERT INTO employees (id, name, salary) VALUES (1, 'John', 50000);

INSERT employees VALUES (1, 'John', 50000);

ADD TO employees (id, name, salary) (1, 'John', 50000);

INSERT ROW employees (id, name, salary) (1, 'John', 50000);

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which keyword is used to insert multiple rows in a single INSERT statement?

MANY ROWS

BATCH INSERT

MULTIPLE VALUES

  1. Separate VALUES clauses with commas

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which SQL statement retrieves all columns from a table named customers?

SELECT ALL FROM customers;

SELECT * FROM customers;  

GET * FROM customers;

FETCH ALL customers;

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How do you select only the name and email columns from a table users?

SELECT name, email FROM users;  

SELECT (name, email) FROM users;

GET name AND email FROM users;

SELECT COLUMNS name, email FROM users;

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which clause filters records in a SELECT query?

FILTER BY

HAVING

WHERE

CONDITION

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the correct syntax to find employees with a salary greater than 50000?

SELECT * FROM employees WHERE salary > 50000;  

SELECT * FROM employees IF salary > 50000;

SELECT * FROM employees HAVING salary > 50000;

SELECT * FROM employees CHECK salary > 50000;

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

How do you retrieve records where age is greater than 30 and salary is less than 60000?

SELECT * FROM employees WHERE age > 30 OR salary < 60000;

SELECT * FROM employees WHERE age > 30 AND salary < 60000;  

SELECT * FROM employees WHERE age > 30, salary < 60000;

SELECT * FROM employees WHERE age > 30 && salary < 60000;

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?