How do I count records in sql?
write a query find which rows of a table is updated on 2 days before?
What is the difference between sql/pl-sql/embeded sql?
what are different types of keys in sql?
Is primary key clustered or nonclustered?
what is text? : Sql dba
What is normalisation in sql?
If you want a column to be part of the result set, after which SQL keyword does it belong? 1. SELECT 2. FROM 3. WHERE 4. GROUP BY 5. HAVING
10 Answers HCL, TCS,
What are the possible values for the boolean data field?
is it necessary to write group by and order by clause together
Is left join inner or outer by default?
How can one get sql*loader to commit only at the end of the load file? : aql loader
What is the difference between UNIQUE CONSTRAINT and PRIMARY KEY? 1. There is no difference. 2. A PRIMARY KEY cannot be declared on multiple columns. 3. A UNIQUE CONSTRAINT cannot be declared on multiple columns. 4. A table can have multiple PRIMARY KEYS but only one UNIQUE CONSTRAINT. 5. A table can have multiple UNIQUE CONSTRAINTs but only one PRIMARY KEY.