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?

You have to store windows media file (WMV) that has size greater that 2GB in the database.

What datatype should you chose?

You have two offices, one in NY and one in Tokyo. The Main database is located in the NY office.

You must permit the Tokyo sales manager to produce local reports in order to reduce WAN traffic. Which option will best work?

There’re two stored procedures in the database. The stored procedures are respectively named AlterSelling and GetSelling. Every day the two procedures are executed very often. The AlterSelling stored procedure updates a table named SellingOrders by using a transaction. From the SellingOrders table, data is retrieved and aggregated by the GetSelling stored procedure for a sales trend analysis report. When users run the sales trend analysis report, they have to wait for a long time. So what should you do to make sure that sales trend analysis report runs as quickly as possible?