Q: How would apply date range filter?

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

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

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

Question 1

How to use Amazon SQS?

Accepted Answer

Amazon SQS is a message passing mechanism that is used for communication between different connectors that are connected with each other It also acts as a communicator between various components of Amazon It keeps all the different functional components together This functionality helps different components to be loosely coupled, and provide an architecture that is more failure resilient system

Question 2

What is the use of multi-threaded fetching in Amazon S3?

Accepted Answer

- Multi-threading fetching in Amazon S3 is used to fetch the objects concurrently using the multiple threads and map the task so that fetching can be made simpler - It is not a good practice to increase the threading for a particular object as every node on the server has some bandwidth constraints - It provides user the ease with which they can upload the files and upload the threads in parallel - It provides high speed of data transfer and easy maintenance of the sever as well

Question 3

What do you understand by MapReduce?

Accepted Answer

MapReduce is a software framework that was created by Google It`s prime focus was to aid in distributed computing, specifically large sets of data on a group of many computers The frameworks took its inspiration from the map and reduce functions from functional programming

Question 4

How is mapreduce related to cloud computing?

Accepted Answer

The mapreduce framework contains most of the key architecture principles of cloud computing such as: - Scale: The framework is able to expand itself in direct proportion to the number of machines available - Reliable: The framework is able to compensate for a lost node and restart the task on a different node - Affordable: A user can start small and over time can add more hardware

Question 5

________ intended to address issues such as bugs and errors within existing software.

Accepted Answer

HotFix

Question 6

List out few of the applications that make use of Multilinked Structures?

Accepted Answer

Sparse matrix, Index generation

Question 7

Classify the Hashing Functions based on the various methods by which the key value is found.

Accepted Answer

Direct method, Subtraction method, Modulo-Division method, Digit-Extraction method, Mid-Square method, Folding method, Pseudo-random method

Question 8

What is a spanning Tree?

Accepted Answer

A spanning tree is a tree associated with a network All the nodes of the graph appear on the tree once A minimum spanning tree is a spanning tree organized so that the total edge weight between nodes is minimized

Question 9

How will you find the 3rd max salary in the employment table?

Accepted Answer

SELECT DISTINCT(salary) FROM emp as e1 WHERE (3) = (SELECT COUNT(DISTINCT(salary)) FROM emp as e2 WHERE e1salary <= e2salary)

Question 10

How would apply date range filter?

Accepted 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

Question 11

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

Accepted Answer

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

Question 12

Define a temp table.

Accepted Answer

In a nutshell, a temp table is a temporary storage structure It means you can use a temp table to store data temporarily so you can manipulate and change it before it reaches its destination format In table_usergender column change ‘male to female’ and ‘female to male’ in one SQL statement UPDATE table_user SET gender = CASE gender WHEN ‘male’ THEN ‘female’ WHEN ‘female’ THEN ‘male’ ELSE gender END

Question 13

What is the difference between JOIN and UNION?

Accepted 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

Question 14

What type of Joins have you used?

Accepted Answer

The knowledge of Joins is a MUST for every interviewee Most SQL programmers have used inner join and outer join[left/right]; but the catch point here is to also mention cross join and self-join

Question 15

What are user defined data-types and when do you use them?

Accepted Answer

User defined data-types in SQL is an extension to the base SQL server data-types by provision of a descriptive name We use them to format the database and segregate specific repetitions of rows and columns in the database

Question 16

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

Accepted 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

Question 17

What is Catalog Views?

Accepted Answer

Catalog views return information that is used by the SQL Server Database Engine Catalog Views are the most general interface to the catalog metadata and provide the most efficient way to obtain, transform, and present customized forms of this information All user- available catalog metadata is exposed through catalog views

Question 18

We can modify an existing Company from

Accepted Answer

Company Info > Alter

Question 19

A database is used to

Accepted Answer

A database is used to store, modify, extract and to search for the data within it.

Question 20

SQL views can be used to hide?

Accepted Answer

In SQL, a SQL view is a virtual table based on the result-set of an SQL statement. A view contains rows and columns, just like a real table. SQL views can be used to hide rows and columns and complicated SQL syntax. The fields in a view are fields from one or more real tables in the database.

Technology Questions