Answer / jerry joseph

1. identify and create optimal indexes for your tables

every table should have at least a clustered index

Indexes should be considered on all columns that are
frequently accessed by the WHERE, ORDER BY, GROUP BY, TOP,
and DISTINCT clauses

Static tables can be more heavily indexed that dynamic tables

2. An SQL Injection attack is a form of attack that comes
from user input that has not been checked to see that it is
valid. The objective is to fool the database system into
running malicious code that will reveal sensitive
information or otherwise compromise the server.

Example:
StrSQL = "SELECT * from Users WHERE username = '" +
txtUserName.Text + "' AND password = '" + txtPassword.Text +
"'";
if txtUserName is entered as "admin' OR 1 = 1;--" the query
becomes
"SELECT * from Users WHERE username = 'admin' OR 1 = 1;--'
AND password = '" + txtPassword.Text + "'"
user logs in as admin

Prevention :
Use Parameterized Queries or Stored Procedures to prevent
SQL Injection.

Why do we use non clustered index?

0 Answers  

---

Delete duplicate rows from a table without primary key by using a single query Table Employee empname salary A 200 B 300 A 200 C 400 D 500 D 500 Output should be A 200 B 300 C 400 D 500

14 Answers  

---

What is trigger explain with program?

0 Answers  

---

Explain different types of index?

0 Answers  

---

What are information schema views?

0 Answers  

---

What are page splits? : SQL Server Architecture

0 Answers  

---

Does full backup break log chain?

0 Answers  

---

Where to find ntwdblib.dll version 2000.80.194.0?

0 Answers  

---

What is de-normalization and when do you do it?

3 Answers  

---

Can you explain various data region available in ssrs with their use?

0 Answers  

---

Can we hide the definition of a stored procedure from a use?

0 Answers  

---

Give an example of why you would want to denormalize a database

0 Answers  

---