ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
Categories  >>  Software  >>  Databases  >>  SQL PLSQL
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question 
Given two tables Student(SID, Name, Course) and Level(SID,
level) write the SQL statement to get the name and SID of
the student who are taking course = 3 and at freshman level.
 Question Submitted By :: Supreeth
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Given two tables Student(SID, Name, Course) and Level(SID, level) write the SQL statement to get the name and SID of the student who are taking course = 3 and at freshman level.
Answer
# 1		 
SELECT Student.name, Student.SID 
FROM Student, Level
WHERE Student.SID = Level.SID
AND Level.Level = "freshman"
AND Student.Course = 3;
 
Is This Answer Correct ?    0 Yes 1 No
Supreeth
 
  Re: Given two tables Student(SID, Name, Course) and Level(SID, level) write the SQL statement to get the name and SID of the student who are taking course = 3 and at freshman level.
Answer
# 2		 
select s.name,s.sid from student s,level l
where s.sid=l.sid
and s.course=3
and l.level='freshman'
 
Is This Answer Correct ?    1 Yes 0 No
Smriti
 
 
 
  Re: Given two tables Student(SID, Name, Course) and Level(SID, level) write the SQL statement to get the name and SID of the student who are taking course = 3 and at freshman level.
Answer
# 3		 
SELECT  S.Name,S.SID  
FROM    Student S, Level L 
WHERE   S.SID=L.SID
AND     L.level='freshman'
AND     S.Course=3
 
Is This Answer Correct ?    0 Yes 0 No
Guest
 
  Re: Given two tables Student(SID, Name, Course) and Level(SID, level) write the SQL statement to get the name and SID of the student who are taking course = 3 and at freshman level.
Answer
# 4		 
Select Name,SID from Student
where SID in(Select SID from level where level='freshman') 
and Course=3;
 
Is This Answer Correct ?    1 Yes 0 No
Vishu
 
  Re: Given two tables Student(SID, Name, Course) and Level(SID, level) write the SQL statement to get the name and SID of the student who are taking course = 3 and at freshman level.
Answer
# 5		 
SELECT  
 S.Name
,S.SID  
FROM Student S 
INNER JOIN Level L ON S.SID=L.SID
WHERE S.Course=3 AND L.level='freshman'
 
Is This Answer Correct ?    0 Yes 0 No
Ani
 

 
 
 
Other SQL PLSQL Interview Questions
 
  Question Asked @ Answers
 
Types of joins ? Digital-GlobalSoft3
how to find the second highest salary from emp table? Wipro24
What are the types of triggers ? TCS4
State the advatage and disadvantage of Cursor's?  2
How to call DDL statements from pl/sql?  3
hi..........i m Accenture employee...Accenture is an IT company having itz branches in India at Mumbai, Pune,Delhi, Hyderabad, Chennai and Bangalore....Presently there are openings here for SAP, Testing, Oracle,Java,.NET,MAinframe and Peoplesoft...... I am a software engineer working with Accenture,Mumbai....u can mail me in your resume..i`ll forward it to our HR team...my mail id: pankit.lodaya@accenture.com Wipro2
Can we use SQL%ISOPEN in implicit cursors? Does this attribute works properly in Implicit Curosors?  2
What is the difference between DELETE and TRUNCATE? Tech-Mahindra10
What are two virtual tables available during database trigger execution ?  2
Explain the usage of WHERE CURRENT OF clause in cursors ? Satyam2
Differentiate between %type and %rowtype attribute in Oracle PL/AQL programming ? PreVator3
What are the different types of PL/SQL program units that can be defined and stored in ORACLE database ?  1
what is mean by forward declaration and where we'll use it. TCS4
What is Overloading of procedures ?  1
declare l1 number := null; l2 number :=null; begin if l1=l2 then message('equal'); else if l1<>l2 then message('not equal'); else message('else'); end if; end if; end; What will be the output ? Oracle7
What is Overloading of procedures ?  3
What is differance unique key and primary key. EDS6
How One can easily select all even, odd, or Nth rows from a table using SQL queries?  3
What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ?  1
I have one table and column is c1 pk, c2 not null,c3 not null and 200 row in it and i add c4 column and value, how can is possible  7
 
For more SQL PLSQL Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us |   interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com