You have a table with a string column. A lot of data is duplicated. Need to optimize a stored procedure for performance with the following criteria
+ stored procedure takes a string parameter as input
+ stored procedure must be optimized for all input params
+ only one SELECT statement uses the string input parameter

You want to store amount of money with decimal precision 5 digits (like 10.35762). What column type sholud you use ?

Update statement should be terminated when encounters a shared lock, what is the best solution?

You have to validate an email address using regular expressions and some sophisticated logic, What is the best solution?

You have two different application sessions. What solution should you implement to share transactions and lock between them to avoid any conflicts

You have to protect yourself against SQL injections what should you do:

You have a table named SALES with the following columns:

SalesmanID | ProductsSold
1 | 2000
2 | 4000
3 | 5000
4 | 5000
5 | 6000
6 | 6000
7 | 9000
8 | 9000

You have to chose a query that will select all SalesmanIDs that have sold an amount of products within the 3 top ProductsSold values.

You have a stored procedure that uses a SELECT statement to retrieve a sample data set from a table. It has been determined that the query is taking too long to return data.

Given that some inconsistent data can be allowed to appear. What type of isolation should be used for the query to return results fast?

You have a table named Sales that has the following three columns: Duty, Freight, and Customs.

You need to add new column to table which would show Sales+Freight+Customs.

Which option should you chose to implement?

You have to design a new database, the tables in the database should be replicated to three offices and the database tables should have the following requirements :

+ a unique row should be identified among all the rows
+ the row should be unique among the entire organization.

What option should you use?