Software Applications Programming Errors and solutions.

1. Which of the following queries can you use to search for employees with the pattern 'A_B' in their names? A. SELECT last_name FROM employees WHERE last_name LIKE '%A\_B%' ESCAPE '\\'; B. SELECT last_name FROM employees WHERE last_name LIKE '%A_B%' ESCAPE; C. SELECT last_name FROM employees WHERE last_name LIKE 'A_B%' ESCAPE '%'; D. SELECT last_name FROM employees WHERE last_name LIKE '%A\_B%' ESCAPE '\'; 2. The number of records in a table emp is given by statement A. Select total(*) from emp; B. Select count(*) from emp; C. Select sum(*) from emp; D. Select total from emp; 3. Write a query to Display the Name and studentid of all Students of branch CSE and ECE in alphabetical order by name. 4. Can you use the SQL JOIN and SQL HAVING clauses in one SQL statement? A .Yes. B . No. C . It depends. D . Don't know 5. # Which four are valid Oracle constraint types? A....

Prerequisites for Microsoft Visual Studio 2010 Express installation Architectures x86, x64  Supported Operating Systems Windows XP (x86) with Service Pack 3 Windows Vista (x86 & x64) with Service Pack 2 Windows 7 (x86 and x64) Windows Server 2003 (x86 & x64) with Service Pack 2 - all editions Users must install MSXML6 if it is not already present. Windows Server 2003 R2 (x86 and x64) - all editions Windows Server 2008 (x86 and x64) with Service Pack 2 - all editions Windows Server 2008 R2 (x64) - all editions Hardware Requirements GHz or faster processor 1024 MB RAM (1.5 GB if running on a virtual machine) 3 GB of available hard-disk space 5400 RPM hard-disk drive DirectX 9-capable video card running at 1024 x 768 or higher display resolution DVD-ROM drive