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 incorrect because it uses the wrong comparison operator for text matching.

The script is correct if there is an employee with the exact name 'Doe'.

The script is incorrect because it should use double quotes for string comparison.

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

SELECT DISTINCT column_name FROM table_name;

SELECT UNIQUE column_name FROM table_name;

SELECT DIFFERENT column_name FROM table_name;

SELECT UNIQUE_VALUES column_name FROM table_name;

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 if there is an employee with the exact name 'Doe'.

The script is incorrect because it should use double quotes for string comparison.

The script is incorrect because it should use the ILIKE operator for case-insensitive text matching.

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 all columns from the Employees table where the Salary is greater than 90000, showing the highest salaries first.

Display all columns from the Employees table where the Salary is greater than 90000, arranged in ascending order of Salary.

Display all columns from the Employees table where the Salary is greater than 90000, ordered by Name.

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 'Not Available' if Price is NULL, otherwise, display the actual Price.

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

Display OrderID, Product, Quantity, and Price columns from the Orders table, displaying 'Not Available' for all Price entries.

What is a schema in a database?

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

A logical container for database objects such as tables, views, and indexes.

A database template used for creating new databases.

A reserved space in memory for storing database metadata.

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

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

B:It will add a new column named "role" to the "users" table, setting its data type to VARCHAR and default value to 'user'.

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

D:It will create a new table named "role" and add it as a column in the "users" table with a default value 'user'.

What is a view in a database schema?

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

A predefined query stored in the database.

A collection of database objects.

An index used for quick data retrieval.

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

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

B:It will delete the table "products" if it exists in the database, otherwise, it will do nothing.

C:It will remove all data from the "products" table, leaving the table structure intact.

D:It will check if the "products" table exists, and if it does, it will remove all data from it.

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 descending order of Salary, showing the highest salaries first.

Display all columns from the Employees table in descending order of Salary, showing the lowest salaries first.

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

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

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

B:The script will succeed as it adds a new record with the specified ID and other values.

C:The script will fail because the price value should not have a decimal point.

D:The script will fail because the category ID 3 does not exist in the "categories" table.

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

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

B:The script is erroneous because the username value is missing a closing single quote.

C:The script is erroneous because it attempts to insert a record without specifying the values for the remaining columns.

D:The script is erroneous because it attempts to insert a record without providing values for all columns, specifically the "email" and "password" columns.

What information can you find in Data Dictionary Views?

B:Only information related to table structures

C:Only information related to user access

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

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

B:Define a table structure for storing category information, including id, name, and description fields.

C:Insert data into a table called "categories" with columns for id, name, and description.

D:Update the "categories" table by adding three new columns: id, name, and description.

What is a Data Dictionary View in a database?

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

B:It's a set of metadata that describes the structure of the database.

C:It's a set of tables containing user data in the database.

D:It's a set of views created by users to access database information.

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 only the Name and Position columns from the Employees table where the Position is either 'HR' or 'Sales, ordered by Name.

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

Display only the Position column from the Employees table where the Position is either 'HR' or 'Sales, ordered by Position.

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, showing the highest salaries first.

Display all columns from the Employees table where the Salary is between 50000 and 80000, showing the lowest salaries first.

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

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

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

B:Create an index named "idx_name" on the "products" table for the column "id."

C:Create an index named "idx_products" on the "name" table for the column "products."

D:Create an index named "idx_products" on the "categories" table for the column "name."

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

A: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.

B:It will create a table named "products" with three columns: "id", "name", and "price", where "id" is the primary key of type INT, "name" is a variable character string of maximum length 50 characters, and "price" is a decimal number with precision 10 and scale 2.

C:It will create a table named "products" with two columns: "name" and "price", and "id" will be automatically generated as the primary key.

D:It will create a table named "products" with two columns: "name" and "price", and "id" will be set as a foreign key referencing another table.

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

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

B:Adds a new column named "stock" to the "products" table with an initial value of 0 for all existing records.

C:Updates the "stock" column in the "products" table, setting its default value to 0.

D:Creates a new table named "stock" and adds it as a column in the "products" table.

What is a sequence in a database schema?

A:A way to generate unique numbers.

B:A set of related tables in a database.

C:A schema used for ordering database objects.

D:A data type for storing numerical values.

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

A:It will create an index named "id_username" on the "users" table for the column "username."

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

C:It will create a new table named "idx_username" and add it as a column in the "users" table, using the data from the "username" column.

D:It will create a new table named "users" with an index named "idx_username" on the "username" column.

Which of the following is not a type of Data Dictionary View in Oracle Database?

D:All of the above are types of Data Dictionary Views.

SQL Quiz

Authored by Bald Vertebrate

Physical Ed

12th Grade

Used 2+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

47 questions

Show all answers

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is an index in a database schema?

A:A way to find data in a database more quickly.

B:A unique identifier for each row in a table.

C:A security mechanism for restricting access to certain data.

D:A data structure that organizes and enhances the speed of data retrieval.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which SQL function is used to return the current date and time?

NOW()

GETDATE()

CURRENT_TIMESTAMP

DATE_FORMAT(NOW())

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which SQL keyword is used to filter the records?

WHERE

FIND

FILTER

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

ORDER BY

SORT

ARRANGE

GROUP BY

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

Ascending

Descending

Random

Unspecified

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the function used in SQL to convert a string to a number?

TO_NUMBER

CAST

CONVERT

PARSE

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

In SQL, which function is used to return a value if a condition is TRUE, and another value if it is FALSE?

CASE

SWITCH

WHEN

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

51 questions

UJIAN SEKOLAH BERBASIS KOMPUTER MAPEL PENJAS

Quiz

•

12th Grade

50 questions

podrurze

Quiz

•

11th - 12th Grade

47 questions

AHA Heartsaver Adult CPR/AED

Quiz

•

9th - 12th Grade

50 questions

SCUBA Open Water Test Practice

Quiz

•

5th Grade - University

50 questions

LATIHAN SOAL PJOK AKHIR SEMESTER

Quiz

•

6th Grade - University

50 questions

Sports Med - CQ2 - DP1 - Children & Young Athletes

Quiz

•

12th Grade

46 questions

6.3 - Components of Fitness Review

Quiz

•

11th - 12th Grade

45 questions

US BAHASA SUNDA KELAS IX

Quiz

•

9th - 12th Grade

Popular Resources on Wayground

15 questions

Grade 3 Simulation Assessment 1

Quiz

•

3rd Grade

22 questions

HCS Grade 4 Simulation Assessment_1 2526sy

Quiz

•

4th Grade

16 questions

Grade 3 Simulation Assessment 2

Quiz

•

3rd Grade

19 questions

HCS Grade 5 Simulation Assessment_1 2526sy

Quiz

•

5th Grade

17 questions

HCS Grade 4 Simulation Assessment_2 2526sy

Quiz

•

4th Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

24 questions

HCS Grade 5 Simulation Assessment_2 2526sy

Quiz

•

5th Grade

20 questions

Math Review

Quiz

•

3rd Grade

Discover more resources for Physical Ed

15 questions

2025 SOCCER QUIZ

Quiz

•

9th - 12th Grade

30 questions

Tobacco

Quiz

•

9th - 12th Grade

4 questions

The Brain & Addiction

Presentation

•

9th - 12th Grade

SQL Quiz

What is an index in a database schema?

Which SQL function is used to return the current date and time?

Which SQL keyword is used to filter the records?

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

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

What is the function used in SQL to convert a string to a number?

In SQL, which function is used to return a value if a condition is TRUE, and another value if it is FALSE?

Which SQL statement is used to create a new table in a database?

What is the SQL command to delete a table?

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

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Physical Ed