R4R
Right Place For Right Person TM
 
R4R Sql SQl FAQs Sql Interview Questions and Answers

 


Totel:174 Click: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35

SQL Interview Questions And Answers

Page 1

Questions 1 I Have a table in which there is a chance of duplicate rows. Can you please tell me how to eliminate the dup;licate records?

Answer
Use primary key If column is like Id or no..Alternate way is you can apply unique constraint on column.. hope u hv cleared ur doubts

Answer
Deletion of duplicate records: delete from emp a where a.rowid > (select min(b.rowid) from emp b where a.rowid=b.rowid) or delete from table t1 where t1.rowid < (select max(t2.rowid) from table t2 where t2.<common column_name> = t1.<common column_name>)

Questions 2 What is use of 'in' command?

Answer
in command use suppose u want to choose department then you use in command ex=select ename,sal from emp where deptno in(10,20);

Questions 3 Class members
Questions 4 What is the Sql Wild card?

Answer
SQL Wild Card is the bassically use for the searchign opration similarily LIKE function.SQL wildcards can substitute for one or more characters when searching for data in a database. the following wildcards can be used: > % - A substitute for zero or more characters > _ - A substitute for exactly one character > [charlist] - Any single character in charlist > [^charlist] or [!charlist] - Any single character not in charlist

Answer
% -

Questions 5 Describe TO_DATE function?

Answer
The TO_DATE function using the values when we want to be show thw timestamp from a character string that has been interpreted using a character template.


Goto Page:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35

SQL Objective Questions And Answers

SQL Objective Questions And Answers

SQL Interview Questions And Answers

SQL Subjective Questions And Answers


R4R,SQL Objective, SQL Subjective, SQL Interview Questions And Answers,SQL,SQL Interview,SQL Questions ,SQL Answers

New Updates

R4R
R4R
R4R
R4R
R4R
R4R
R4R
R4R