GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

SQL Interview Questions


SQL Interview Questions

Questions: 170
Comments: 908
 SQL Tags
 Showing Questions 1-10 of 170 Questions
[1] 2 3 4 5 6 7 8 9 10 Next >>
 Sponsored Links

 
 SQL Interview Questions
Sorting Options :  

Does View occupy memory? If we delete the base table of existing view, What happens? 
Latest Answer: View just stores the query defination and not the data. if base table or any one table involed with view is dropped we will get this error in 10gORA-04063: view "SCOTT.VEMP" has errors  where vemp is view name ...
Read Answers (5) | Asked by : manu4sql

Where clause restricts rows, what does having clause restricts ?1. only group results.2. rows results.3. both rows and groups result. 
Latest Answer: Hi there,The WHERE clause restricts which rows are returned,while the HAVING clause operates  on groups of rows.HAVING is always used with GROUP BY and it must have a function in it and it restrictsThe rule says:- If a condition refers to an aggregate ...

Latest Answer: The columns which are mentioned in group by clause should also be mentioned in select statement except for aggrerations. ...
Read Answers (7) | Asked by : radha11

There is a table having the following columns :-student id marks1 marks2 maxmarks1 10 20 202 25 30 303 30 10  
Latest Answer: update tablenameset Maxmarks = case when mark1> mark2 then mark1 else mark2 end  ...

Have 2 table Emp1 (Column Name: Ename), 2nd table Emp2 (Column Name: First and Column Name: LastTable Name :Emp1ENameHunt, MichaelGraham, SmithNelson, Ryan Table Name: Emp2First LastMichael HuntSmith GrahamRyan NelsonNeed 
Latest Answer: insert into emp2(first,last) (select substr(ename,1,instr(ename,',')-1),substr(ename,instr(ename,',')+1) from emp1) ...
Read Answers (6) | Asked by : ssq1999

what is difference between nested query,sub query and nested query? explain clearly with an example? 
Latest Answer: query inside the query is nested query. it is also called as sub query. Correlated subquery runs once for each row selected by the outer query. It contains a reference to a value from the row selected by the outer query. Nested subquery runs only ...

How can I select column values from a table without knowing the column name ?Suppose , select employee_id from employees , now I don't know the column name and I want to select the column.Please let 
Latest Answer: If you do not know the column name you want to select from the table, I would simply suggest you that, follow this command: SELECT * FROM table_name here * let you choose all the column name from the respective table. ...

Latest Answer: We cannot insert, update, delete record in dual table.Dual means dummy. In the dual table only one column is present. ...
Read Answers (5) | Asked by : ashish88

WE using Last_value()analytical function but the result do not match according to me? 
View Question | Asked by : ashish88

How and in what way REPLACE is different from TRANSLATE? 
Latest Answer: Translate check and replace character by character in the string like this example- SELECT TRANSLATE('AGDFADCDA ANLKAKE ABZUYA','AG','ZY') FROM DUAL; here in all three words ('AGDFADCDA ANLKAKE ABZUYA') the character ‘A’ , ‘G’ and ‘AG’ ...

View page [1] 2 3 4 5 6 7 8 9 10 Next >>

Ask A Question
Go Top
 Sponsored Links

 
Ask Question
You must login to Ask Question or Register your free account

Category:

 
Question Title:


Question in Detail:

Add this to my Subscribed Questions (?)
Send me email when new answer is posted (?)

 
Subscribe
Get Latest Updates Via RSS Reader or by Email
 Forum Discussion Subscribe to Forum Discussions Via E-Mail Latest Forum Discussions Subscribers
 Knowledge Base Subscribe to Knowledge Base Series Via E-Mail Knowledge Base Subscribers
 Learning Series Subscribe to GeekInterview Learning Series Via EMail Learning Series Subscribers
 Freelance Jobs Subscribe to GeekInterview Freelance Jobs Via EMail Latest Freelance Jobs Subscribers
 GeekInterview Blog Subscribe to GeekInterview Blog Via EMail GeekInterview Blog Subscribers
 Testing Interview Questions Subscribe to Testing Interview Questions Via EMail Testing Interview Questions Subscribers
 Oracle Interview Questions Subscribe to Oracle Interview Questions Via EMail Oracle Interview Questions Subscribers
 Java Interview Questions Subscribe to Java Interview Questions Via EMail Java Interview Questions Subscribers
 Latest Placement Papers Subscribe to Latest Placement Papers Placement Papers Subscribers
 Free Training Subscribe to Free Training Via EMail Free Training Subscribers
 Learn AJAX Subscribe to AJAXwith.com Via EMail AJAXwith Subscribers
Sponsored Links

 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape