Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

Company Name Starts with ...
#  A  B  C  D  E   F  G  H  I  J   K  L  M  N  O   P  Q  R  S  T   U  V  W  X  Y  Z

Techno Solutions SQL Server Interview Questions
Questions Answers Views Company eMail

1.Describe way(s) to tune the SQL table in order to optimize performance. 2. Explain SQL Injection and how can you prevent them?

1 3443

I have a website that allows customers to browse and place orders for certain products. I have 2 tables; Customers and Orders. The Customers table holds the customer records and the Orders table holds the orders placed by the customer. Both tables are tied based on the field Cust_ID. Example of the data is shown below: Cust_ID Cust_Name Cust_ID Product Amount Order_Date 1001 John Tan 1001 P-5211 $120.00 2/13/2006 1002 Michael Wong 1001 K-1428 $88.90 1/11/2006 1003 Mary Cheong 1003 C-0923 $82.50 1/27/2006 1004 Ahmad Suffian 1003 K-1428 $88.90 2/2/2006 Write a single SQL statement that extracts all purchase records with the following criteria: 1. Customer names starting with “M” only. 2. Orders placed within the current month only. 3. Amount does not exceed $100.00 The list must be sorted by order date with the latest order showing on top.

3 4063

Let’s say the table in the database is named as TBL_Register. The fields in this table include: 1. User_Name, 2. User_Telephone, 3. Register_Date The field Register_Date stores the current date and time of the registration. Write the SQL statement that inserts the data into the table.

2 3467

Post New Techno Solutions SQL Server Interview Questions






Un-Answered Questions

What does cp mean in unix?

205


What is primary key in ms access 2007?

183


Explain about version control?

271


What are mark complete and mark exception actions?

1


What is normalization? Explain its different types?

273






explain about externally initiated operations

285


selling price = shs. 200, variable overhead-selling per unit= shs 80, variable production cost per unit = shs 60, fixed selling cost = 2,840,000. the production capacity of the project is 200,000 units. required P/V ratio, BEP and margin of safety

1210


Please any one help me I preparing for the post of charge man in Indian ordinance factory please give me some guide line & book for this exam.my email. anoopkpandey16@gmail.com

2472


What is __ init __ method do in models?

62


When can infinite loop occur in a plugin. How do you avoid infinite loops in the plugin code?

153


Give two examples of a ‘collision-free’ protocol ?

1102


What are some of the roles of NABARD and IRDA?

325


What are arithmetic operators?

223


What happens if you add your just created object to a mutable array, and you release your object?

1


What is difference between unix timestamp and mysql timestamp?

241