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 4070I 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 5171Let’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 4314Post New Techno Solutions SQL Server Interview Questions
- Techno Solutions ASP.NET Interview Questions (3) Techno Solutions SQL Server Interview Questions (3)
- Techno Solutions Struts Interview Questions (1)
- Techno Solutions SAP Basis Interview Questions (1)
- Techno Solutions SAP FI-CO (Financial Accounting & Controlling) Interview Questions (1)
- Techno Solutions Civil Engineering Interview Questions (1)
- Techno Solutions Electrical Engineering Interview Questions (1)
- Techno Solutions USA AllOther Visa Interview Questions (1)
Explain some essential objects in abap dictionary?
Where would you research a prospect before you reach out? : insurance cold calling
What is private blockchain? Give examples?
What are checklists? Give an example from the delivered checklists. How will you create a checklist of your own? Explain by giving an example?
How many functions are there in ms excel?
What is the job of the network layer under the osi reference model?
What is the Major Difference Between the Memorandum of Association and the Articles of Association?
What is cumulative condition record?
What is the difference between reactjs and angularjs?
Xmlserializer is throwing a generic "there was an error reflecting myclass" error. How do I find out what the problem is?
Write a program to show the process of spawning a child process
What is redis python?
What is log viewer?
What do you mean by employee subgroup?
Pick up a coin C1 given C1+C2 with probability of trials p (h1) =.7, p (h2) =.6 and doing 10 trials. And what is the probability that the given coin you picked is C1 given you have 7 heads and 3 tails?
