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

Correct Answer: Sparse matrix, Index generation

Correct Answer: HotFix

Correct 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

Correct 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

Correct 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

Correct 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

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

Correct 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

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

Correct 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