You have a table with a string column
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
What column type sholud you use ?
You want to store amount of money with decimal precision 5 digits (like 10.35762). What column type sholud you use ?
what is the best solution to terminate the update statement when encounters a shared lock?
Update statement should be terminated when encounters a shared lock, what is the best solution?
What is the best solution to validate an email address using regular expressions and some sophisticated logic?
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 loc
You have two different application sessions. What solution should you implement to share transactions and lock between them to avoid any conflicts
what should you do to protect yourself against SQL injections?
You have to protect yourself against SQL injections what should you do:
You have a table named SALES with the following columns:
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.
What type of isolation should be used for the query to return results fast?
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?
Which option should you chose to implement?
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?
What option should you use to design a new database?
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?