Databases - Upwork

Question: What will be the output of the following SQL query? SET SHOWPLAN_TEXT ON GO SELECT * FROM abcsite.abctable GO
A
It will show the query plan and the estimated cost of running

B
It will show all the rows of the "abctable" table

C
It will show all the rows of the "abctable" table and the table structure

D
It will show the identities and Constraints applied on this table

Note: Not available
1. Report
Question: __________ is a container that holds tables, views, procedures, functions and so on.
A
Instance

B
Cluster

C
Metadata

D
Schema

E
None of these

Note: Not available
1. Report
Question: What exactly is a Super key?
A
A Super key is a column or a set of columns that uniquely identifies rows in a table

B
A Super key checks the number of columns in a table which have non-null values

C
A Super key is used to match columns in other tables

D
A Super key checks the number of rows in a table which have non-null values

Note: Not available
1. Report
Question: Which one of the following statements is correct?
A
You can create DDL triggers

B
You can create DML triggers

C
Both are correct

D
Neither is correct

Note: Not available
1. Report
Question: Starting from the slowest, arrange the following operators in the order in which they produce results in "SQL WHERE" query. 1. >, >=, <, <= 2. <> 3. = 4. LIKE
A
1,4,3,2

B
4,1,2,3

C
3,2,1,4

D
2,4,1,3

Note: Not available
1. Report
Question: Why are Joins generally better than the Correlated sub-query?
A
The Correlated sub-query scans the whole table

B
Joins pick up the rows according to the condition of the queries

C
The Correlated sub-query creates a nested loop

D
The Correlated sub-query makes the statement complex

Note: Not available
1. Report
Question: Consider the following table "Students": Students - - - - - - Name Hobbies John Driving Miller Fishing David Writing Robert Singing What will be the output of the following query? Select Substring(Hobbies,3) From students Where name= "john"
A
Dri

B
ivi

C
iving

D
ving

E
It will give an error

Note: Not available
1. Report
Question: What exactly is the Full-Text Catalog?
A
The Full-Text catalog is an index for searching specific keywords

B
The Full-Text catalog is a file which contains full-text indexes

C
The Full-Text catalog is basically an inbuilt function for checking the validation of a text

D
The Full-Text catalog is a system trigger for checking text validation

Note: Not available
1. Report
Question: The commands GRANT and REVOKE are examples of :
A
DDL (Data Definition Language)

B
DML (Data Manipulation Language)

C
TCL (Transaction Control Language)

D
DCL (Data Control Language)

Note: Not available
1. Report
Question: We are creating Stored Procedure in Database and using "sp_" prefix in its name. Which of the following statements is correct in accordance with the performance of the Stored Procedure execution?
A
The prefix will speed up the execution as it is in cache and will always get executed with high priority

B
The prefix will slow down the execution as the prefix is reserved for system stored procedures

C
The performance will not be affected as "sp_" is just a prefix for a stored procedure

D
The prefix will speed up the execution as prefix "sp_" is used for stored procedures by default

Note: Not available
1. Report

First Prev 63 64 65 66 67 Next Last

Question: What will be the output of the following SQL query? SET SHOWPLAN_TEXT ON GO SELECT * FROM abcsite.abctable GO

Question: __________ is a container that holds tables, views, procedures, functions and so on.

Question: What exactly is a Super key?

Question: Which one of the following statements is correct?

Question: Starting from the slowest, arrange the following operators in the order in which they produce results in "SQL WHERE" query. 1. >, >=, <, <= 2. <> 3. = 4. LIKE

Question: Why are Joins generally better than the Correlated sub-query?

Question: Consider the following table "Students": Students - - - - - - Name Hobbies John Driving Miller Fishing David Writing Robert Singing What will be the output of the following query? Select Substring(Hobbies,3) From students Where name= "john"

Question: What exactly is the Full-Text Catalog?

Question: The commands GRANT and REVOKE are examples of :

Question: We are creating Stored Procedure in Database and using "sp_" prefix in its name. Which of the following statements is correct in accordance with the performance of the Stored Procedure execution?