SQL Questions

Q:

How would apply date range filter?

Answer

One can use simple conditions like >= and <=, or use between/and but the trick here is to know your exact data type.


 


- Sometimes date fields contain time and that is where the query can go wrong so it is recommended to use some date related functions to remove the time issue. In SQL Server common function for accomplishing the task datediff () function.


- Interviewees also have to be aware of different time zones and server time zone.


-To increase query performance you may still want to use between however you should be aware of proper format you should use if not it might misbehave during filtering.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL - Technology

1 5124
Q:

Which TCP/IP port does SQL Server run on? How can it be changed?

Answer

SQL Server runs on port 1433. It can be changed from the Network Utility TCP/IP properties.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL - Technology

1 4756
Q:

What are the properties and different Types of Sub-Queries?

Answer

Properties of Sub-Query


- A sub-query must be enclosed in the parenthesis.


- A sub-query must be put in the right hand of the comparison operator, and


- A sub-query cannot contain an ORDER-BY clause.


- A query can contain more than one sub-query.


Types of Sub-Query


- Single-row sub-query, where the sub-query returns only one row.


- Multiple-row sub-query, where the sub-query returns multiple rows,. and


- Multiple column sub-query, where the sub-query returns multiple columns

Report Error

View answer Workspace Report Error Discuss

Subject: SQL - Technology

1 4626
Q:

The SQL SELECT statement is capable of

A) Projection B) Selection
C) Protection & Security D) Both A & B
 
Answer & Explanation Answer: D) Both A & B

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: SQL - Technology
Exam Prep: AIEEE , Bank Exams , CAT
Job Role: Analyst , Bank Clerk , Bank PO

1 4582
Q:

How can you generate debugging output from PL/SQL?

Answer

Use the DBMS_OUTPUT package. Another possible method is to use the SHOW ERROR command.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL - Technology

0 4574
Q:

Which one of the following sorts rows in SQL?

A) ORDER BY B) GROUP BY
C) SORT BY D) ALIGN BY
 
Answer & Explanation Answer: A) ORDER BY

Explanation:
Report Error

View Answer Report Error Discuss

2 4423
Q:

What is the difference between JOIN and UNION?

Answer

SQL JOIN allows access to records of other table based on the given conditions between two tables.


Ex: If we are provided with the department ID of each employee, then we can use the department ID of the employee table to merge with the department ID of the department table to access department names.


UNION operation allows addition of 2 similar data sets to create a resulting set that contains all the data from the source data sets.


Ex: If we are provided with 2 employee tables of the same structure, we can UNION them to create a singular result that will contain all employee from both the table.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL - Technology

1 4176
Q:

State one similarity and difference between WHERE Clause and HAVING Clause?

Answer

Similarity: Both WHERE and HAVING Clause filters out records based on one or more conditions.


Difference: WHERE Clause can only be applied to a static non-aggregated column whereas HAVING is needed for aggregated columns.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL - Technology

1 3946