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

Quiz

•

Physical Ed

•

12th Grade

•

Practice Problem

•

Medium

Bald Vertebrate

Used 2+ times

FREE Resource

SWITCH

WHEN

Create a free account and access millions of resources

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

By signing up, you agree to our Terms of Service & Privacy Policy

Already have an account?

Similar Resources on Wayground

50 questions

Mapel PJOK Kls (10)

Quiz

•

10th Grade - University

45 questions

PTN Section 6 Review

Quiz

•

12th Grade

47 questions

Exercise Physiology Quiz pt 2

Quiz

•

12th Grade

42 questions

Health & Skill Related Components

Quiz

•

6th - 12th Grade

50 questions

BAB 4 TEKS ULASAN

Quiz

•

8th Grade - University

50 questions

Nutrition Quiz Prep

Quiz

•

9th - 12th Grade

50 questions

Fitness fun

Quiz

•

9th - 12th Grade

44 questions

Q3 MAPEH 9 QUARTER EXAM REVIEWER

Quiz

•

9th Grade - University

Popular Resources on Wayground

10 questions

Honoring the Significance of Veterans Day

Interactive video

•

6th - 10th Grade

9 questions

FOREST Community of Caring

Lesson

•

1st - 5th Grade

10 questions

Exploring Veterans Day: Facts and Celebrations for Kids

Interactive video

•

6th - 10th Grade

19 questions

Veterans Day

Quiz

•

5th Grade

14 questions

General Technology Use Quiz

Quiz

•

8th Grade

25 questions

Multiplication Facts

Quiz

•

5th Grade

15 questions

Circuits, Light Energy, and Forces

Quiz

•

5th Grade

19 questions

Thanksgiving Trivia

Quiz

•

6th Grade

Discover more resources for Physical Ed

29 questions

Alcohol

Quiz

•

9th - 12th Grade

30 questions

Ch 12 Review - Driving in Adverse Conditions

Quiz

•

9th - 12th Grade

5 questions

Muscular System

Lesson

•

9th - 12th Grade

SQL Quiz

47 questions

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

Create a free account and access millions of resources

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Physical Ed