SQL Interview Questions

Apr 18 2007
10:00 AM

5460
Views

2
Ans

How do find that your global temporary table is defined with "on commit preserve rows" or "on commit delete rows"?

RenukaRajput
Profile Answers by RenukaRajput Questions by RenukaRajput

SQL Interview Questions

meenakvasulochanan
Profile Answers by meenakvasulochanan Questions by meenakvasulochanan

Aug 17th, 2007

The column "duration" in all_tables will tell us whether the temporary table is defined with "on commit preserve row" or "on commit delete rows"The values :SYS$TRANSACTIO...

Answer Question Select Best Answer
Apr 12 2007
08:33 PM

5056
Views

2
Ans

How do you declare a variable with BLOB as datatype? How can you use BLOB data type? What size can be given to its variable?

madhug56
Profile Answers by madhug56 Questions by madhug56

SQL Interview Questions

intelmental4
Profile Answers by intelmental4 Questions by intelmental4

Jul 23rd, 2007

BLOB is Binary Large ObjectWhen you declare any variable as image, text, ntext ... they would be BLOB data typesText = 2^31-1text = 2^30-1ntext = 2^31-1-Each text, ntext, image colum can in a table ca...

Answer Question Select Best Answer
Apr 03 2007
08:39 PM

2487
Views

2
Ans

What is Partitioning in SQL ?

qababu
Profile Answers by qababu Questions by qababu

SQL Interview Questions

venkat82.k
Profile Answers by venkat82.k Questions by venkat82.k

Mar 19th, 2008

Hi guys partitionings nothing but a huge table is divided into some meaningfull parts to do manipulations ,for easy maintainwe divide partitions while creating tables.mainly 3 types of par...

Answer Question Select Best Answer
Mar 24 2007
09:21 AM

4391
Views

2
Ans

What is difference between EXIT and QUIT ?

jahid

SQL Interview Questions

Nikhil_4_Oracle

Mar 26th, 2007

Both are same....-Nikhil

Answer Question Select Best Answer
Mar 23 2007
05:58 AM

2064
Views

2
Ans

Create Sequence using alter command

Sandeep

SQL Interview Questions

How to Create Sequence and insert data using Alter command to a new column?

callmesomu

Apr 17th, 2007

ALTER SEQUENCE SEQUENCE_NAMEINCREMENT BY 10

Answer Question Select Best Answer
Jun 19 2005
11:51 AM

5287
Views

2
Ans

Void main(){int i,j,k;for(i=0;i<3;i++)k=sum(i,i);printf("n%d",k);getch();}sum(s,t){static int m;m+=s+t;return m;}

SQL Interview Questions

6

ganeshkumar.mit
Profile Answers by ganeshkumar.mit Questions by ganeshkumar.mit

Sep 13th, 2008

M = 1 + 1 + 2 + 2final answer is 6

Answer Question Select Best Answer
Jun 19 2005
11:51 AM

3753
Views

2
Ans

Which of the storage class(es) becomes the global variables for the entire programA. ExternB. StaticC. AutoD. Register

SQL Interview Questions

A

swetha

Aug 16th, 2007

The answer is A. Extern

robin singh

Jun 11th, 2006

A: extern becoz v can access it any where

Answer Question Select Best Answer
Jun 19 2005
11:51 AM

2300
Views

2
Ans

Which of the following storage class(es) became the global variable for the entire programA. ExternB. StaticC. AutoD. Register

SQL Interview Questions

A

aniljoo

Feb 12th, 2007

Static storage class in c is considered as global variable that comes into existence from start to end of the program

Answer Question Select Best Answer
Jun 19 2005
11:51 AM

2924
Views

2
Ans

Which of the following is not true in case of command line arguments?A. The argc parameter is used to hold the number of arguments in the command line and is an integerB. The argv parameter is a pointer to an array of a character pointer and each one points to command line argumentsC. The argv[1] always point to program nameD. None of above

SQL Interview Questions

C

Bhoomika sharma
Profile Answers by Bhoomika sharma Questions by Bhoomika sharma

Dec 16th, 2008

Yes, the argc[] parameter contains an integer i.e. used to hold the number of argumnets in the command line.char*argv[] is used as a pointer to an array of a character pointer and points to the comman...

Answer Question Select Best Answer
Jun 19 2005
11:51 AM

5316
Views

2
Ans

What is the output of the program?#include<stdio.h>#include<conio.h>void main(){int i,j=20;clrscr();for(i=1;i<3;i++){printf("%d,",i);continue;printf("%d",j);break;}getch();}A. 1,20B. 1,20,1,20C. 1,2D. 1,2,20,20

SQL Interview Questions

C

vikas

Sep 11th, 2006

it ll display "1,2,"... none of the options say that (make a note of comma).. or giving it the benifit of doubt.. c is the answer.i guess the logic is pretty simple.. after calling the 1st printf(), the current iteration of loop is skipped because of "continue"... so 2nd printf() is never called.

amol

Jul 26th, 2006

ans is1,2

Answer Question Select Best Answer
Aug 11 2005
10:22 AM

3164
Views

2
Ans

What will be the output of the fallowing SELECT statement?SELECT count(*)FROM empWhere exist (select 'X' From deptwhere dept_name ='Stores' and dept.dept_id=emp.dept_id)A. select total number of employees belonging to department " stores "B. select all employees belonging to department "X"C. select all employees belonging to department "stores"D. select total number of employees belonging to department "X"

SQL Interview Questions

NAGA

Aug 29th, 2006

This will not give any outputThis will throw a error missing expression

krishna

Aug 11th, 2005

A. It selects the total no of emplyoyees in stores

Answer Question Select Best Answer
Jun 19 2005
11:51 AM

3467
Views

2
Ans

An item could be either a component or spare." How can you represent this scenario in an E-R?A. Subtype RelationB. Arc RelationC. Recursive RelationD. Many to Many Relation

SQL Interview Questions

Gopi

Apr 8th, 2006

Subtype Relation

sujatha

Jan 21st, 2006

Arc Relation

Answer Question Select Best Answer
Sep 01 2005
10:45 AM

8417
Views

2
Ans

What is the difference between Single row sub-Query and Scalar sub-Query?

SQL Interview Questions

B.Vijay Karthik

Sep 1st, 2005

Single row subqueries returns only one row of results.A single row sub query uses a single row operator; the common operator is the equality operator(=). A Scalar subquery returns exactly one col...

SACHIN

Aug 12th, 2005

SINGLE ROW SUBQUERY RETURNS A VALUE WHICH IS USED BY WHERE CLAUSE , WHEREAS SCALAR SUBQUERY IS A SELECT STATEMENT USED IN COLUMN LIST CAN BE THOUGHT OF AS AN INLINE FUNCTION IN SELECT COLUMN LIST

Answer Question Select Best Answer
Sep 16 2005
10:56 PM

2843
Views

2
Ans

Cursor Syntax brief history?

Beena
Profile Answers by Beena Questions by Beena

SQL Interview Questions

prabakaran

Sep 18th, 2005

To retrieve data with SQL one row at a time you need to use cursor processing.Not all relational databases support this, but many do.Here I show this in Oracle with PL/SQL, which is Procedural Languag...

Prabakaran

Sep 17th, 2005

To retrieve data with SQL one row at a time you need to use cursor processing. Not all relational databases support this, but many do.Here I show this in Oracle with PL/SQL, which is Procedural Langua...

Answer Question Select Best Answer
Apr 24 2006
11:24 AM

2936
Views

2
Ans

What is cluster.cluster index and non cluster index?

uma soni

SQL Interview Questions

vvijaychandra
Profile Answers by vvijaychandra Questions by vvijaychandra

Jul 4th, 2006

Clustered Index:- A Clustered index is a special type of index that reorders the way records in the table are physically stored. Therefore table may have only one clustered index.Non-Clustered Index:-...

zanhsieh
Profile Answers by zanhsieh Questions by zanhsieh

Apr 24th, 2006

The difference is that, Clustered index is unique for any given table and we can have only one clustered index on a table. The leaf level of a clustered index is the actual data and the data is resort...

Answer Question Select Best Answer
Jun 22 2006
07:55 AM

2917
Views

2
Ans

What is materialized View?

dvaidyanathan
Profile Answers by dvaidyanathan Questions by dvaidyanathan

SQL Interview Questions

thumatinagaraju
Profile Answers by thumatinagaraju Questions by thumatinagaraju

Oct 23rd, 2006

A materilized view can contain group function or some operators and it having some information . and it's useful in datawarehousing..

vvijaychandra
Profile Answers by vvijaychandra Questions by vvijaychandra

Jul 4th, 2006

A materialized view is a database object that contains the results of a query. They are local copies of data located remotely or used to create summary tables based on aggregation of a tables data. Materialized views which store data based on the remote tables are also know as snapshots.

Answer Question Select Best Answer
Sep 06 2006
09:29 AM

2095
Views

2
Ans

What is the queary for Non equal joints ,self joints?

kumar

SQL Interview Questions

shivkumarojha
Profile Answers by shivkumarojha Questions by shivkumarojha

Sep 6th, 2006

Self Join-The SELF JOIN is used to join a table to itself, as if the table were two tables, temporarily renaming at least one table in the SQL statement. The syntax is as follows:SELECT A.LAST_NAME, B...

shivkumarojha
Profile Answers by shivkumarojha Questions by shivkumarojha

Sep 6th, 2006

NonEquiJoin-NON-EQUIJOIN joins two or more tables based on a specified column value not equaling a specified column value in another table. The syntax for the NON-EQUIJOIN isSELECT EMPLOYEE_TBL.EMP_ID...

Answer Question Select Best Answer
Nov 03 2006
10:53 AM

1814
Views

2
Ans

What is the basic difference in MySQL & Stored SQL?

mohammad ali

SQL Interview Questions

aa

Nov 28th, 2006

Stored procedure is a set of precompiled, preoptimized sql queries that is executed faster.

Answer Question Select Best Answer
Nov 07 2006
01:03 PM

7634
Views

2
Ans

What is oracle hint? how do we use hints in SQL for the optimization of the query?

sree

SQL Interview Questions

John Thomas Ambadan

Dec 5th, 2006

Hint are used to alter execution plans of SQL statements. by using hints you will be able to choose the execution plans.for eg. in a SELECT statement your will be able to specify whether an index is t...

Answer Question Select Best Answer
Sep 07 2007
08:10 AM

4480
Views

2
Ans

What is pipeline function? How it is used?

tc

SQL Interview Questions

gemini burj
Profile Answers by gemini burj Questions by gemini burj

Nov 18th, 2007

Pipelined functions are useful if there is a need for a data source other than a table in a select statementFor more details, following link is available.http://www.adp-gmbh.ch/ora/plsql/pipeline.html

Answer Question Select Best Answer

Login

How do find that your global temporary table is defined with "on commit preserve rows" or "on commit delete rows"?

How do you declare a variable with BLOB as datatype? How can you use BLOB data type? What size can be given to its variable?

What is Partitioning in SQL ?

What is difference between EXIT and QUIT ?

Nikhil_4_Oracle

Create Sequence using alter command

callmesomu

Void main(){int i,j,k;for(i=0;i<3;i++)k=sum(i,i);printf("n%d",k);getch();}sum(s,t){static int m;m+=s+t;return m;}

Which of the storage class(es) becomes the global variables for the entire programA. ExternB. StaticC. AutoD. Register

swetha

robin singh

Which of the following storage class(es) became the global variable for the entire programA. ExternB. StaticC. AutoD. Register

aniljoo

What is the output of the program?#include<stdio.h>#include<conio.h>void main(){int i,j=20;clrscr();for(i=1;i<3;i++){printf("%d,",i);continue;printf("%d",j);break;}getch();}A. 1,20B. 1,20,1,20C. 1,2D. 1,2,20,20

vikas

amol

NAGA

krishna

An item could be either a component or spare." How can you represent this scenario in an E-R?A. Subtype RelationB. Arc RelationC. Recursive RelationD. Many to Many Relation

Gopi

sujatha

What is the difference between Single row sub-Query and Scalar sub-Query?

B.Vijay Karthik

SACHIN

Cursor Syntax brief history?

prabakaran

Prabakaran

What is cluster.cluster index and non cluster index?

What is materialized View?

What is the queary for Non equal joints ,self joints?

What is the basic difference in MySQL & Stored SQL?

aa

What is oracle hint? how do we use hints in SQL for the optimization of the query?

John Thomas Ambadan

What is pipeline function? How it is used?

Latest News

It looks like you are using an AD Blocker!