Which of the following is true about the SQL AS clause?

The AS clause in SQL is used to change the column name in the output or assign a name to a derived column.

The SQL AS clause can only be used with the JOIN clause.

The AS clause in SQL is used to defines a search condition.

Which statement is true regarding routines and triggers?

Both consist of procedural code.

Both are stored in the database.

Both have to be called to operate.

Which of the following is the correct order of a SQL statement?

SELECT, WHERE, GROUP BY, HAVING

SELECT, GROUP BY, WHERE, HAVING

SELECT, HAVING, WHERE, GROUP BY

SELECT, WHERE, HAVING, GROUP BY

Each answer below shows example data from a table. Which answer is an example of the inconsistent values problem?

Three rows have the values Brown Small Chair, Small Chair Brown, and Small Brown Chair in the same column.

Three columns have the values 534-2435, 534-7867, and 546-2356 in the same row.

One row has the value "He is interested in a Silver Porsche from the years 1978-1988" in a column.

Three rows have the values Brown, NULL, and Blue in the same column.

Find the cities name with the condition and temperature from table 'whether' where condition = sunny or cloudy but temperature >= 60.

SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' OR condition = 'cloudy' AND temperature >= 60

SELECT city, temperature, condition FROM weather WHERE condition = 'cloudy' AND condition = 'sunny' OR temperature >= 60

SELECT city, temperature, condition FROM weather WHERE condition = 'cloudy' OR condition = 'sunny' OR temperature >= 60

SELECT city, temperature, condition FROM weather WHERE condition = 'sunny' AND condition = 'cloudy' AND temperature >= 60

Which statement is used to get all data from the student table whose name starts with p?

SELECT * FROM student WHERE name LIKE 'p%';

SELECT * FROM student WHERE name LIKE '%p%';

SELECT * FROM student WHERE name LIKE '_p%';

SELECT * FROM student WHERE name LIKE '%p';

If any other columns are written along with COUNT in a SELECT statement, then

Those columns need to be a part of group by clause

Those columns need to be a part of having clause

Those columns need to be a part of where clause

Those columns need not to be a part of any other clauses

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

Which of the following is true about a surrogate key?

It is a synthetic key with no business meaning.

It is a primary key with a real-world meaning.

It is a key used for referencing other keys in the same table.

It is never used in relationships.

Books (BookID, Title, Author, YearPublished) Query: SELECT Author, COUNT(*) FROM Books GROUP BY Author HAVING COUNT(*) > 1; What does the query do?

Selects authors who have published more than one book.

Selects authors and the total number of books they have published, including those with only one book.

Selects authors who have published at least two books.

Selects authors and their book counts, including those with no books published.

Employees (EmployeeID, Name, DepartmentID, Salary) Departments (DepartmentID, DepartmentName) Query: SELECT d.DepartmentName, AVG(e.Salary) AS AverageSalary FROM Employees e JOIN Departments d ON e.DepartmentID = d.DepartmentID GROUP BY d.DepartmentName HAVING AVG(e.Salary) > 60000; What does the query do?

Selects department names with an average salary greater than 60,000.

Selects department names and average salaries for all departments.

Selects department names where the average salary is exactly 60,000.

Selects department names with an average salary less than 60,000.

Students (StudentID, Name, MajorID) Alumni (AlumniID, Name, MajorID) Query : SELECT Name FROM Students EXCEPT SELECT Name FROM Alumni; What does the query do?

Selects names of current students who are not alumni.

Selects names of alumni who are not current students.

Selects names of all students and alumni.

Selects names of students and alumni, but only unique entries.

Orders (OrderID, CustomerID, OrderDate) Returns (ReturnID, CustomerID, ReturnDate) Query : SELECT CustomerID FROM Orders WHERE CustomerID NOT IN (SELECT CustomerID FROM Returns); What does the query do?

Selects customer IDs who have never returned an order.

Selects customer IDs who have returned at least one order.

Selects all customer IDs from orders.

Selects customer IDs who have placed orders and returned them.

Orders (OrderID, CustomerID, OrderDate, TotalAmount) Customers (CustomerID, CustomerName, City) Query : SELECT City, COUNT(*) AS NumberOfOrders FROM Orders o JOIN Customers c ON o.CustomerID = c.CustomerID WHERE TotalAmount > (SELECT AVG(TotalAmount) FROM Orders) GROUP BY City HAVING COUNT(*) > 5; What does the query do?

Selects cities with more than 5 orders where the total amount is above the average order amount.

Selects all cities and their order counts regardless of the total amount.

Selects cities with exactly 5 orders where the total amount is above the average.

Selects cities with orders below the average total amount.

Employees (EmployeeID, EmployeeName, DepartmentID, Salary) Departments (DepartmentID, DepartmentName, Location) Projects (ProjectID, ProjectName, EmployeeID, Budget) Query : SELECT e.EmployeeName FROM Employees e WHERE e.Salary < ANY ( SELECT p.Budget FROM Projects p WHERE p.EmployeeID IS NOT NULL ); What does the above SQL query return?

Names of employees who earn less than at least one project budget in the database, possibly including projects they do not work on.

Names of employees whose salaries are lower than at least one project budget assigned to any employee.

Names of employees whose salaries are lower than the lowest budget of projects being worked on by any employee.

Names of employees who earn less than the average budget of all projects but more than none.

Query Quest - External

Quiz

•

others

•

Practice Problem

•

Hard

Poovitha S

FREE Resource

27 questions

Show all answers

1.

OPEN ENDED QUESTION

1 min • Ungraded

TEAM NAME

Evaluate responses using AI:

OFF

2.

OPEN ENDED QUESTION

30 sec • Ungraded

GM ID

Evaluate responses using AI:

OFF

3.

OPEN ENDED QUESTION

30 sec • Ungraded

COLLEGE NAME

Evaluate responses using AI:

OFF

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is not a valid SQL type?

FLOAT

NUMERIC

DECIMAL

CHARACTER

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following are TCL commands?

COMMIT and ROLLBACK

UPDATE and TRUNCATE

SELECT and INSERT

GRANT and REVOKE

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

SQL Views are also known as

Simple tables

Virtual tables

Complex tables

Actual Tables

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which datatype can store unstructured data in a column?

CHAR

RAW

NUMERIC

VARCHAR

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

25 questions

Professional Educator 4E Chapter 13 Quiz Game

Quiz

•

KG - University

26 questions

Year 10 March Quiz

Quiz

•

9th Grade - University

32 questions

Test 3 Cells and Organelles

Quiz

•

KG - University

31 questions

Study Guide: I Survived The Sinking of the Titanic, 1912

Quiz

•

5th Grade

22 questions

Unit 2 Quiz

Quiz

•

KG - University

22 questions

Eco - Chapter 1 - What is Economics?

Quiz

•

KG - University

24 questions

Popular Music of the 1910s Test

Quiz

•

KG - University

25 questions

Earth Science Midterm part 1

Quiz

•

KG - 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 others

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