Crowdly

27017

3306

What concept in a relational database is analogous to a collection in MongoDB?

Row

Index

Table

Column

Which of the following is a primary key-like concept in MongoDB?

Shard

Index

ObjectId

Replica Set

Which NoSQL database is the best for storing JSON data?

Cassandra

All of the above

MongoDB

DynamoDB

Which of the following is the correct syntax for creating function/stored procedure in PostgreSQL?

CREATE PROC proc_name() AS && SELECT * FROM table_name;$$

CREATE FUNCTION func_name() RETURNS VOID AS  LANGUAGE plpgsql;

CREATE PROCEDURE proc_name AS SELECT * FROM table_name;

CREATE FUNCTION func_name() RETURNS VOID AS  LANGUAGE plpgsql;

What are System stored procedures?

Stored procedures run and used for managing administrative activities of SQL Server

Stored procedures that can return a single value or a set of rows

Stored procedures that can be written in any language supported by the .NET Framework

Stored procedures that allow you to loop through a SQL statement's result

What are the three main parts of a stored procedure?

Cursors

Execution

Outputs

Inputs

Triggers

Results

Match the commands for working with stored procedures in PostgreSQL with their descriptions:

Deletes an existing stored procedure.

Creates a new stored procedure or replaces an existing one.

Creates a new stored procedure.

Executes a stored procedure.

What happens during the execution phase of a stored procedure?

The stored procedure source code is compiled and optimized

The server processes the execution plan sequentially, dispatching each step to an appropriate internal manager process

The server saves the execution plan to disk for future use

The server resolves object references and creates a query tree

What happens during the "Compilation" step of executing a stored procedure?

The process of resolving object references the first time the procedure is executed

The process of recording the procedure's name and other information in the system catalog

The step where the procedure's source code is stored in syscomments for later use

The step where the query tree is constructed and passed to the query optimizer for compilation and optimization