If you have done your homework about this organization, now is the time to use that knowledge. Remember, even as a recruited candidate, some facilities will want to understand why you would select them. If you are a recruited candidate, remind them that you were not looking when you were contacted, but that the challenge sounded intriguing and that a solid opportunity for career advancement is important to you.

Select datediff('2008-09-07','2006-10-02');

CUSTOMER Union Select 'EAST', CUSTOMER From CUST_DTLS Where REGION = 'E' Order By CUSTOMER

The above is

a) Not an error

b) Error - the string in single quotes 'NORTH' and 'SOUTH'

c) Error - the string should be in double quotes

d) Error - ORDER BY clause

Defines the queries for the finder and select methods of an entity bean having container-managed persistence. A subset of

SQL92, EJB QL has extensions that allow navigation over the relationships defined in an entity bean's abstract schema.

The XML file that contains one or more asant targets. A target is a set of tasks you want to be executed. When starting

asant, you can select which targets you want to have executed. When no target is given, the project's default target is

executed.

The generic syntax for GRANT is as following
GRANT [rights] on [database] TO [username@hostname] IDENTIFIED BY [password]
Now rights can be:
a) ALL privilages
b) Combination of CREATE, DROP, SELECT, INSERT, UPDATE and DELETE etc.
We can grant rights on all databse by usingh *.* or some specific database by database.*

SELECT CURDATE();
SELECT CURRENT_DATE();
SELECT CURTIME();
SELECT CURRENT_TIME();

The recovery model is a database property. It defines the method you wish to use when recovering your database; depending on the mode you select, different amounts of information will be preserved for each backup. Simple recovery: This option restores a database to its state at the time of its most recent backup. Any changes made after the last full or differential backup are lost (no transaction log backups are made). Full recovery: This option restores a database to its state at the point of failure. Bulk-logged recovery: This option enables bulk-logged operations, which means that certain database operations, such as SELECT INTO operations or BCP/Bulk Copy, will be logged minimally or not at all. The risk of data loss is higher than with the full-recovery model, as bulk-logged recovery does not provide point-in-time recovery

You can create a Windows NT ERD using the Repair Disk program (RDISK.EXE). To do so, select the Run option from the Start menu, enter the CMD command in the Run dialog box, and then type RDISK at the command prompt.

Windows 3.x must be upgraded to Windows 95 or 98 first, and then to Windows 2000 Professional. For more information, see the section "Upgrading to Windows 2000." 12. A, C, D. To upgrade a system to Windows 2000 from a previous operating system using a CDROM  installation, you can: 1) boot the system to the existing operating system, insert the Windows 2000 Professional distribution CD in the CDROM drive, and click on Install Windows; 2) Start Setup through the Run command (In Windows 9x and NT 4.0, click Start and select the Run option from the menu. In Windows 3.x and NT 3.51, click File and then select the Run option from that menu.). At the prompt, enter the location on the Windows 2000 start file (Winnt.exe or Winnt32.exe) on the distribution (that is, d:\i386\Winnt32.exe). In the case of Windows 3.x, the Winnt.exe option should be used.