What is acid property in a database?

1043

what is a database lock ? : Sql dba

1186

Is primary key a clustered index?

984

What is the difference between stored procedure and view?

1028

What is bind variable in pl sql?

1069

How do I truncate a sql log file?

1092

what are date and time functions in mysql? : Sql dba

989

What is a scalar value in sql?

1087

what is cursor. write example of it. What are the attributes of cursor.

1409

what is isam? : Sql dba

1026

What are the different set operators available in sql?

1035

What are predefined functions in sql?

1060

What is the syntax and use of the coalesce function?

1181

What is time based sql injection?

983

Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

2122