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

50 questions

Sports Quiz

Quiz

•

KG - Professional Dev...

50 questions

L2 APF Mock 3

Quiz

•

12th Grade

44 questions

Fitness Fundamentals Review 6th

Quiz

•

8th - 12th Grade

45 questions

Soal Latihan PJOK Kelas 6 (02)

Quiz

•

6th Grade - University

50 questions

Physical Education Final Exam Review

Quiz

•

9th - 12th Grade

50 questions

Intro - Strand 3 - Transportation Systems

Quiz

•

10th Grade - University

47 questions

Verificación Final Repaso 1

Quiz

•

12th Grade - University

52 questions

Atletismo 2023

Quiz

•

9th - 12th Grade

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 Physical Ed

35 questions

Mental Health Review

Quiz

•

9th - 12th Grade

15 questions

Basketball quiz

Quiz

•

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