Display the output based on the scripts provided: SELECT * FROM Employees WHERE Salary > 90000;

Display all columns from the Employees table where the Salary is greater than 90000.

Display only the Salary column from the Employees table where the Salary is greater than 90000.

Display all columns from the Employees table where the Salary is exactly 90000.

Display an error message because the WHERE clause syntax is incorrect.

Display the output based on the scripts provided: SELECT Name, Position FROM Employees WHERE Position = 'HR' OR Position = 'Sales';

Display only the Name and Position columns from the Employees table where the Position is either 'HR' or 'Sales'.

Display all columns from the Employees table where the Position is either 'HR' or 'Sales'.

Display an error message because the OR operator cannot be used in the WHERE clause.

Display all columns from the Employees table where the Position is 'HR' and 'Sales'.

Display the output based on the scripts provided: SELECT * FROM Employees ORDER BY Salary DESC;

Display all columns from the Employees table in descending order of Salary.

Display all columns from the Employees table in ascending order of Salary.

Display an error message because the ORDER BY clause cannot be used with SELECT *.

Display all columns from the Employees table where the Salary is greater than or equal to 0.

Display the output based on the scripts provided: SELECT * FROM Employees WHERE Salary BETWEEN 50000 AND 80000 ORDER BY Salary ASC;

Display all columns from the Employees table where the Salary is between 50000 and 80000 in ascending order of Salary.

Display all columns from the Employees table where the Salary is between 50000 and 80000 in descending order of Salary.

Display an error message because the ORDER BY clause cannot be used with the BETWEEN operator.

Display all columns from the Employees table where the Salary is greater than or equal to 50000 and less than or equal to 80000 in ascending order of Salary.

Review the script. Determine whether or not it is erroneous or not. The goal of the script is to display all rows with Name having ‘Doe” in it: SELECT * FROM Employees WHERE Name = ‘Doe’;

The script is incorrect because it should use the LIKE operator for partial text matching.

The script is correct and will display all rows where the Name column exactly matches 'Doe'.

The script is incorrect because it uses the wrong comparison operator for text matching.

The script is incorrect because it should use the CONTAINS operator for text matching.

Display the output based on the scripts provided: SELECT OrderID, Product, Quantity, COALESCE(CAST(Price AS VARCHAR), 'Not Available') AS Price FROM Orders;

Display OrderID, Product, Quantity, and Price columns from the Orders table, converting Price to VARCHAR and displaying 'Not Available' if Price is NULL.

Display OrderID, Product, Quantity, and Price columns from the Orders table, converting Price to VARCHAR and displaying 'Available' if Price is NULL.

Display OrderID, Product, Quantity, and Price columns from the Orders table, converting Price to VARCHAR and displaying NULL if Price is NULL.

Display OrderID, Product, Quantity, and Price columns from the Orders table, converting Price to VARCHAR and displaying 0 if Price is NULL.

Review the script. Determine whether or not it is erroneous or not. The goal of the script is to display all rows with Name having ‘Doe” in it: SELECT * FROM Employees WHERE Name = ‘Doe’;

The script is incorrect because it uses the wrong comparison operator for text matching.

The script is correct and will display all rows where the Name column exactly matches 'Doe'.

The script is incorrect because it should use the LIKE operator for partial text matching.

The script is incorrect because it should use the CONTAINS operator for text matching.

Explain what will happen when the script below is ran: CREATE TABLE products ( id INT PRIMARY KEY, name VARCHAR(50), price DECIMAL(10, 2) );

It will create a table named "products" with three columns: "id" of type INT as the primary key, "name" of type VARCHAR with a maximum length of 50 characters, and "price" of type DECIMAL with precision 10 and scale 2.

It will create a table named "products" with two columns: "name" of type VARCHAR with a maximum length of 50 characters, and "price" of type DECIMAL with precision 10 and scale 2, but it will not create the "id" column because it is missing the data type for the "id" column.

It will generate a syntax error because the data type for the "id" column is not specified.

It will create a table named "products" with two columns: "id" of type INT as the primary key, and "price" of type DECIMAL with precision 10 and scale 2, but it will not create the "name" column because it is missing from the script.

Explain what will happen when this script is ran: ALTER TABLE users ADD COLUMN role VARCHAR(20) DEFAULT 'user';

It will modify the existing "users" table by adding a new column named "role" of type VARCHAR with a default value of 'user'.

It will create a new table called "users" with a column named "role" of type VARCHAR with a default value of 'user'.

It will delete the "users" table and create a new table with a column named "role" of type VARCHAR and a default value of 'user'.

It will rename the "users" table to "role" and set its column type to VARCHAR with a default value of 'user'.

Explain what will happen when this script is ran: DROP TABLE IF EXISTS products;

It will drop the table "products" if it exists in the database, without checking for any dependencies.

It will create a new table named "products" if it doesn't already exist in the database.

It will display an error message because the syntax is incorrect.

It will alter the table "products" by adding a new column named "IF EXISTS."

Explain what will happen when this script is ran: CREATE INDEX idx_username ON users (username);

It will create an index named "idx_username" on the "users" table for the column "username."

It will drop the index "idx_username" if it already exists on the "users" table.

It will display an error message because the syntax is incorrect.

It will update the "users" table by adding a new column named "idx_username."

Review the script. Determine whether or not it is erroneous or not. The goal of the script is to add new a record in the table: INSERT INTO users (id, username, email, password) VALUES (1, 'john_doe', ' john.doe@example.com ', 'password123');

The script is erroneous because it attempts to insert a record with an existing ID value (1).

The script is erroneous because it includes the column names in the VALUES clause, which is not allowed in SQL syntax.

The script is correct and will add a new record with the specified values into the "users" table.

The script is erroneous because it contains a password value that is not hashed, which is a security concern.

What is a schema in a database?

A collection of database objects, including tables, views, indexes, and synonyms.

A data structure to store data.

What is a view in a database schema?

A virtual table based on the result-set of an SQL statement.

A physical table stored in a database.

What is an index in a database schema?

A way to find data in a database more quickly.

A method to sort data in a database.

What is a sequence in a database schema?

A way to generate unique numbers.

A set of numbers or characters in a specific order.

CREATE TABLE categories ( id INT PRIMARY KEY, name VARCHAR(50), description TEXT );

Create a new table named "categories" with three columns: id, name, and description.

Drop the table "categories" if it already exists in the database.

Insert a new record into the "categories" table.

Update the "categories" table by adding a new column named "id."

Explain what will happen when the script below is ran: ALTER TABLE products ADD COLUMN stock INT DEFAULT 0;

Add a new column named "stock" to the "products" table with a default value of 0.

Create a new table named "products" with four columns: id, name, price, category_id.

Insert three records into the "products" table with specified values.

Update the "products" table by changing the data type of the "stock" column to INT.

Explain what will happen when the script below is ran: DROP TABLE IF EXISTS categories;

Drop the table "categories" if it exists in the database.

Create a new table named "categories" if it doesn't already exist.

Display an error message because the syntax is incorrect.

Add a new column named "IF EXISTS" to the "categories" table.

Explain what will happen when the script below is ran: CREATE INDEX idx_name ON products (name);

Create an index named "idx_name" on the "products" table for the column "name."

Drop the index "idx_name" if it already exists on the "products" table.

Display an error message because the syntax is incorrect.

Update the "products" table by adding a new column named "idx_name."

Review the script. Determine whether or not it is erroneous or not. The goal of the script is to add new a record in the table: INSERT INTO products (id, name, price, category_id) VALUES (4, ‘Headphones’, 100.00, 3);

The script will fail because the ID 4 already exists in the "products" table.

The script is correct and will successfully add a new record to the "products" table.

The script will fail because the name "Headphones" already exists in the "products" table.

The script will fail because the category_id 3 does not exist in the "products" table.

What is a Data Dictionary View in a database?

It's a set of read-only tables that provide information about the database.

It's a graphical representation of data.

It's a set of commands to manage databases.

What information can you find in Data Dictionary Views?

Names of all tables in the database

Names of all users in the database

Information about space usage, integrity constraints, and privileges

Q3-CPO PT

Authored by Fernando Enad

Computers

12th Grade

Used 3+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

48 questions

Show all answers

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which SQL keyword is used to filter the records?

SORT BY

WHERE

ORDER BY

GROUP BY

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the SQL keyword used to sort the results in ascending or descending order?

SORT

ORDER

ORDER BY

GROUP BY

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which SQL keyword is used to return records where column values fall within a specified range?

WHERE

BETWEEN

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the default sorting order of the "ORDER BY" clause in SQL?

Descending

Ascending

Random

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In SQL, how do you select only distinct (different) values from a column?

SELECT DIFFERENT column_name FROM table_name;

SELECT DISTINCT column_name FROM table_name;

SELECT UNIQUE column_name FROM table_name;

SELECT column_name FROM table_name DISTINCT;

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which SQL operator is used to filter the records to include only those where the column value matches one of several specified values?

BETWEEN

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What SQL keyword is used to sort multiple columns?

SORT BY

ORDER BY

GROUP BY

ARRANGE BY

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

50 questions

MIDTERM EXAM OP1

Quiz

•

12th Grade

43 questions

Introduction to IB Digital Society

Quiz

•

11th - 12th Grade

50 questions

ULANGAN HARIAN TEKNIK PENGOLAHAN AUDIO DAN VIDEO

Quiz

•

1st - 12th Grade

47 questions

IT Fundamentals Chapter 6

Quiz

•

8th - 12th Grade

51 questions

Testout IT Fundamentals Chapter 3

Quiz

•

11th - 12th Grade

48 questions

STARTER - 1D Array Test

Quiz

•

9th - 12th Grade

45 questions

SOAL PSAJ 2024 - KOMPETENSI KEAHLIAN TKJ

Quiz

•

12th Grade

45 questions

LATIHAN SOAL PSTS INFORMATIKA KELAS 7 GNP

Quiz

•

9th - 12th Grade

Popular Resources on Wayground

7 questions

History of Valentine's Day

Interactive video

•

4th Grade

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

15 questions

Valentine's Day Trivia

Quiz

•

3rd Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

Discover more resources for Computers

18 questions

Valentines Day Trivia

Quiz

•

3rd Grade - University

20 questions

-AR -ER -IR present tense

Quiz

•

10th - 12th Grade

21 questions

Presidents Day Trivia

Quiz

•

6th - 12th Grade

10 questions

Valentine's Day: History and Modern Celebration

Interactive video

•

9th - 12th Grade

11 questions

Valentine's Day Trivia

Quiz

•

8th - 12th Grade

10 questions

Factor Quadratic Expressions with Various Coefficients

Quiz

•

9th - 12th Grade

18 questions

Success Strategies

Quiz

•

9th - 12th Grade

10 questions

Valentine's Day Trivia

Quiz

•

9th - 12th Grade

Q3-CPO PT

Which SQL keyword is used to filter the records?

What is the SQL keyword used to sort the results in ascending or descending order?

Which SQL keyword is used to return records where column values fall within a specified range?

What is the default sorting order of the "ORDER BY" clause in SQL?

In SQL, how do you select only distinct (different) values from a column?

Which SQL operator is used to filter the records to include only those where the column value matches one of several specified values?

What SQL keyword is used to sort multiple columns?

Display the output based on the scripts provided: SELECT FROM Employees WHERE Salary > 90000;*

Display the output based on the scripts provided: SELECT Name, Position FROM Employees WHERE Position = 'HR' OR Position = 'Sales';

Display the output based on the scripts provided: SELECT FROM Employees ORDER BY Salary DESC;*

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Computers