SQL query to find all the cities whose humidity is 95.

SELECT city FROM weather WHERE humidity = 95

SELECT city WHERE humidity = 95

SELECT humidity = 89 FROM weather

Which of the following statement is true? DELETE does not free the space containing the table and TRUNCATE free the space containing the table Both DELETE and TRUNCATE free the space containing the table Both DELETE and TRUNCATE does not free the space containing the table DELETE free the space containing the table and TRUNCATE does not free the space containing the table

Both DELETE and TRUNCATE free the space containing the table

DELETE does not free the space containing the table and TRUNCATE free the space containing the table

Both DELETE and TRUNCATE does not free the space containing the table

DELETE free the space containing the table and TRUNCATE does not free the space containing the table

A database contains a table named employees with columns employee_id, employee_name, and salary. A user initiates a transaction to increase the salary of all employees by 10%. Which SQL statement should be used to update the salary within the transaction?

UPDATE employees SET salary = salary * 1.10;

MODIFY employees SET salary = salary * 1.10;

ALTER employees SET salary = salary * 1.10;

CHANGE employees SET salary = salary * 1.10;

A database contains a table named customers with columns customer_id, customer_name, and total_purchase. A user initiates a transaction to increase the total purchase amount by 5% for a specific customer with customer_id = 105. Which SQL statement should be used to perform this update within the transaction?

UPDATE customers SET total_purchase = total_purchase * 1.05 WHERE customer_id = 105;

MODIFY customers SET total_purchase = total_purchase * 1.05 WHERE customer_id = 105;

ALTER customers SET total_purchase = total_purchase * 1.05 WHERE customer_id = 105;

CHANGE customers SET total_purchase = total_purchase * 1.05 WHERE customer_id = 105;

With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"?

SELECT * FROM Persons ORDER BY FirstName DESC

SELECT * FROM Persons SORT BY 'FirstName' DESC

SELECT * FROM Persons ORDER FirstName DESC

SELECT * FROM Persons SORT 'FirstName' DESC

Find all the cities with temperature, condition and humidity whose humidity is in the range of 63 to 79.

SELECT * FROM weather WHERE humidity BETWEEN 63 AND 79

SELECT * FROM weather WHERE humidity IN (63 to 79)

SELECT * FROM weather WHERE humidity NOT IN (63 AND 79)

SELECT * FROM weather WHERE humidity NOT BETWEEN 63 AND 79

A database contains a table named orders with columns order_id, customer_id, and total_amount. A user initiates a transaction to delete all orders with a total amount less than $50. Which SQL statement should be used to delete these records within the transaction?

DELETE FROM orders WHERE total_amount

REMOVE FROM orders WHERE total_amount

DELETE * FROM orders WHERE total_amount

DROP FROM orders WHERE total_amount

How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?

UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'

UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen'

MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen'

MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen'

A database contains a table named customers with columns customer_id, customer_name, and total_purchase. A user initiates a transaction to increase the total purchase amount by 5% for a specific customer with customer_id = 105. Which SQL statement should be used to perform this update within the transaction?

UPDATE customers SET total_purchase = total_purchase * 1.05 WHERE customer_id = 105;

MODIFY customers SET total_purchase = total_purchase * 1.05 WHERE customer_id = 105;

ALTER customers SET total_purchase = total_purchase * 1.05 WHERE customer_id = 105;

CHANGE customers SET total_purchase = total_purchase * 1.05 WHERE customer_id = 105;

A database contains a table named students with columns student_id, student_name, and enrollment_date. A user initiates a transaction to retrieve the count of students enrolled after a specific date. Which SQL statement should be used to perform this retrieval within the transaction?

SELECT COUNT(student_id) FROM students WHERE enrollment_date > '2023-01-01';

COUNT students WHERE enrollment_date > '2023-01-01';

GET COUNT(student_id) FROM students WHERE enrollment_date > '2023-01-01';

RETRIEVE COUNT(student_id) FROM students WHERE enrollment_date > '2023-01-01';

A user initiates a transaction to retrieve the highest salary from a table named employees. Which SQL statement should be used to perform this retrieval within the transaction?

SELECT MAX(salary) FROM employees;

GET MAX(salary) FROM employees;

SEARCH MAX(salary) WITHIN employees;

A database contains a table named products with columns product_id, product_name, and quantity_in_stock. A user initiates a transaction to update the quantity in stock for a specific product with product_id = 201 to 50. Which SQL statement should be used to perform this update within the transaction?

UPDATE products SET quantity_in_stock = 50 WHERE product_id = 201;

CHANGE products SET quantity_in_stock = 50 WHERE product_id = 201;

MODIFY products SET quantity_in_stock = 50 WHERE product_id = 201;

ALTER products SET quantity_in_stock = 50 WHERE product_id = 201;

A user initiates a transaction to retrieve the distinct categories of products from a table named products. Which SQL statement should be used to perform this retrieval within the transaction?

SELECT DISTINCT category FROM products;

GET DISTINCT category FROM products;

SEARCH DISTINCT category IN products;

FIND DISTINCT category IN products;

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

SELECT * FROM Persons WHERE FirstName LIKE '%a'

SELECT * FROM Persons WHERE FirstName='a'

SELECT * FROM Persons WHERE FirstName LIKE 'a%'

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

Database and SQL Quiz

Authored by Varsha Thakur

Computers

University

Used 4+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

39 questions

Show all answers

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Consider the following schema - STUDENTS (student_code, first_name, last_name, email, phone_no, date_of_birth, honours_subject, percentage_of_marks); Which of the following query would display all the students whose first name starts with the character â€˜Aâ€™?

select first_name from students where first_name like â€˜A%â€™;

select first_name from students where first_name like â€˜%Aâ€™;

select first_name from students where first_name like â€˜%A%â€™;

select first_name from students where first_name like â€˜Aâ€™;

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

You have a relation called "Employees" that contains information about employees, including their salaries. You want to find the average salary of all employees. Which relational algebra operation would you use?

SELECT

PROJECT

AGGREGATE

JOIN

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

With SQL, how can you return the number of not null records in the "Persons" table?

SELECT COUNT() FROM Persons

SELECT COLUMNS() FROM Persons

SELECT COLUMNS(*) FROM Persons

SELECT COUNT(*) FROM Persons

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

You have a "Products" relation that contains information about products, including their prices. You want to find the products with a price greater than $100. What relational algebra operation would you use?

SELECT

PROJECT

JOIN

DIFFERENCE

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

SQL query to find the temperature in increasing order of all cities.

SELECT city FROM weather ORDER BY temperature

SELECT city, temperature FROM weather

SELECT city, temperature FROM weather ORDER BY temperature

SELECT city, temperature FROM weather ORDER BY city

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

In a database, you have a "Sales" relation that contains information about sales transactions, including the salesperson's name. You want to find the distinct names of salespeople who made sales. What relational algebra operation would you use?

SELECT

PROJECT

UNION

DISTINCT

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

You have a "Students" relation that contains information about students, including their ages. You want to find the average age of all students. Which relational algebra operation would you use?

SELECT

PROJECT

AGGREGATE

JOIN

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

40 questions

Grade 6-Sistem Komputer

Quiz

•

6th Grade - University

43 questions

Data Structure and Algorithm

Quiz

•

University

36 questions

Тест 1. 4 неделя (10 минут)

Quiz

•

University

36 questions

MOC 20345 Test

Quiz

•

University

40 questions

UTS TLM APK KOMPUTER

Quiz

•

University

40 questions

SIMULASI DIGITAL - X

Quiz

•

KG - Professional Dev...

40 questions

PTS ASJ XII TKJ 2022/2023

Quiz

•

University

44 questions

Round 1 Code2duo

Quiz

•

University

Popular Resources on Wayground

15 questions

Fractions on a Number Line

Quiz

•

3rd Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

20 questions

Figurative Language Review

Quiz

•

6th Grade

Discover more resources for Computers

30 questions

Quiz 1 Review

Quiz

•

University

Database and SQL Quiz

Consider the following schema - STUDENTS (student_code, first_name, last_name, email, phone_no, date_of_birth, honours_subject, percentage_of_marks); Which of the following query would display all the students whose first name starts with the character â€˜Aâ€™?

You have a relation called "Employees" that contains information about employees, including their salaries. You want to find the average salary of all employees. Which relational algebra operation would you use?

With SQL, how can you return the number of not null records in the "Persons" table?

You have a "Products" relation that contains information about products, including their prices. You want to find the products with a price greater than $100. What relational algebra operation would you use?

SQL query to find the temperature in increasing order of all cities.

In a database, you have a "Sales" relation that contains information about sales transactions, including the salesperson's name. You want to find the distinct names of salespeople who made sales. What relational algebra operation would you use?

You have a "Students" relation that contains information about students, including their ages. You want to find the average age of all students. Which relational algebra operation would you use?

You have two relations, "Employees" and "Departments." The "Employees" relation contains employee information, and the "Departments" relation contains department information. You want to find all employees in the "HR" department. What relational algebra operation would you use?

SQL query to find all the cities whose humidity is 95.

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers