SQL Interview Questions

Questions: 170

Comments: 868

SQL Tags

—

DBMS

Showing Questions 51-60 of 170 Questions

<< Previous 2 3 4 5 [6] 7 8 9 10 11 Next >>

Sponsored Links

SQL Interview Questions

Sorting Options :

How to compare the total salary of all employee with a individual employee salary for a particular department.

Read Answers (2) | Asked by : c.p.mohan

Answer Question Subscribe

How to select the recently UPDATED records from the table?

Latest Answer: There is no native methods to fetch recently updated records as the prime functionality for an RDBMS is to store records in best way that makes prefeching faster, so storage is not based on update order but other attributes that makes DBMS fast If ...

Read Answers (1) | Asked by : sat.inn

Answer Question Subscribe

How find to find column value without knowing table name

Latest Answer: you can use view "user_tab_columns". in this view you will get. In this you will get table_name, column_name, datatype and all things..select * from user_tab_columns; ...

Read Answers (1) | Asked by : ddkdhar

Answer Question Subscribe

How to add positive and negative numbers in a single column and output them to two different columns

Read Answers (3) | Asked by : srydhar

Answer Question Subscribe

There is a table Table_A contains 4 feilds col1, col2, col3, col4 having values a, b, c, d as values

There is a table Table_A contains 4 feilds col1, col2, col3, col4 having values a, b, c, d as values respectively. What will be the code if someone wants to update a with b, b with c, c with d and d with a?

Read Answers (1) | Asked by : sha_jit

Answer Question Subscribe

There are 10 rows in Table A and 0 Rows in table B. Select * from A,BHow many rows will be retrieved.

10 rows

Read Answers (7) | Asked by : Eshwar

Answer Question Subscribe

What is the Difference between stored procedures and external procedures?

Latest Answer: An external procedure is simply a program unit that is not written in Oracle’s SQL or PL/SQL and resides outside of the database. External procedures must be stored as shared libraries at the operating system level. In a Windows NT environment, ...

Read Answers (3) | Asked by : samanta

Answer Question Subscribe

You have EMP and dept table .how do you get the entire department and corresponding employee details

You have EMP and dept table .how do you get the entire department and corresponding employee details and the department which are not alloted it?what is referential integrity constraint?wat is triggers,stored procedures,stored functions explain with examples

Read Answers (2) | Asked by : umarajeswari

Answer Question Subscribe

I have a table with a column city. The values are “delhi” and “hyderabad”.

I have a table with a column city. The values are “delhi” and “hyderabad”. I need to update Hyderabad with delhi and delhi with Hyderabad. Define a query for that

Read Answers (4) | Asked by : surender reddy g

Answer Question Subscribe

How do you create our own schema? which privileges are required?

Latest Answer: Hi All,A Schema in oracle is a logical representation of all the Oracle objects owned by a user.To make my explanation simpe , let me give an example.Let's say you own a bike, a computer, mobile. Now all these articles owned by you collectively is called ...

Read Answers (2) | Asked by : arvi.sardar

Answer Question Subscribe

View page << Previous 2 3 4 5 [6] 7 8 9 10 11 Next >>

Go Top

#	User Name	Count
1	rampratap409	59
2	patilpravin_1981	26
3	g_sidhu	23
4	kowmudiswarna	13
5	ddkdhar	13
6	krishnaindia2007	12
7	globalanil18	10
8	nileshsingh	8
9	sbagai2001	8
10	dmadhusudhanarao	7

Get Latest Updates Via RSS Reader or by Email
Forum Discussion
Knowledge Base
Learning Series
Freelance Jobs
GeekInterview Blog
Testing Interview Questions
Oracle Interview Questions
Java Interview Questions
Latest Placement Papers
Free Training
Learn AJAX