IF-THEN-ELSE can only be used in functions, whereas IF-THEN can be used anywhere.

The IF-THEN-ELSE statement includes an alternative action for when the condition is false, while IF-THEN does not.

IF-THEN-ELSE is used only for loops, while IF-THEN is for conditional statements.

IF-THEN-ELSE requires a boolean expression, while IF-THEN does not.

ELSIF allows for multiple conditional checks in PL/SQL control structures.

ELSIF is used to terminate a PL/SQL block.

ELSIF can only be used once in a control structure.

ELSIF is a synonym for the IF statement.

A CASE statement is used to create tables in PL/SQL.

A CASE statement is a method for defining variables in PL/SQL.

A CASE statement is a control structure for conditional logic in PL/SQL, used to evaluate conditions and return values based on the first true condition.

A CASE statement is a type of loop structure in PL/SQL.

Stored procedures are temporary PL/SQL blocks created using the CREATE TEMPORARY statement.

Stored procedures are created using the INSERT PROCEDURE statement.

Stored procedures are named PL/SQL blocks stored in the database, created using the CREATE PROCEDURE statement.

Stored procedures are only used for data retrieval and cannot modify data.

Triggers can only be executed manually by users.

Triggers are a type of data type in PL/SQL.

Triggers are only used for logging purposes.

Triggers in PL/SQL are procedures that automatically execute in response to specific events on a table, serving purposes like enforcing rules and maintaining data integrity.

A function can only be called once; a procedure can be called multiple times.

A procedure always returns a value; a function does not.

A function is used for data manipulation; a procedure is used for data retrieval.

A function returns a value; a procedure does not.

CREATE OR REPLACE PACKAGE package_name AS procedure_name; END package_name; CREATE OR REPLACE PACKAGE BODY package_name AS procedure_name IS BEGIN -- implementation END procedure_name; END package_name;

CREATE PACKAGE BODY package_name; procedure_name IS BEGIN END;

CREATE OR REPLACE PACKAGE package_name; procedure_name; END package_name;

CREATE PACKAGE package_name AS procedure_name; END;

Cursors are used to store static data in PL/SQL.

Cursors are used in PL/SQL to manage and process query results row by row.

Cursors are a type of variable used for error handling in PL/SQL.

Cursors are used to define the structure of a database table in PL/SQL.

Exception handling in PL/SQL blocks is managed using the 'EXCEPTION' section to catch and handle runtime errors.

PL/SQL blocks do not support exception handling; all errors must be resolved manually.

Exception handling in PL/SQL blocks is done using the 'BEGIN' section to initiate processes.

The 'CATCH' section is used in PL/SQL for exception handling instead of 'EXCEPTION'.

NoSQL databases are only used for structured data and require complex queries.

A NoSQL database is a non-relational database that differs from SQL databases by allowing flexible data models and handling unstructured data, while SQL databases use structured schemas and relational data.

SQL databases are designed to handle unstructured data and provide flexible data models.

A NoSQL database is a type of SQL database that uses fixed schemas.

Create, Retrieve, Modify, and Erase

Construct, Read, Alter, and Delete

CRUD operations in NoSQL databases are Create, Read, Update, and Delete.

Create, Read, Write, and Remove

Advantages of NoSQL databases include flexibility in data models, horizontal scalability, lower latency, and support for various data types.

Higher costs for scaling infrastructure

Strict adherence to a fixed schema

Increased complexity in data management

Perform a write operation to read data.

Access the data directly from the server's file system.

Use a SQL query to fetch data from the database.

Use the database's query method to retrieve data from a specified collection or table.

The 'RETURN' statement is used to pass control back to the calling environment and can return a value from the function.

The 'RETURN' statement is used to exit a function without returning a value.

The 'RETURN' statement is optional in PL/SQL functions.

The 'RETURN' statement is used to define the output parameters of a function.