SQL Interview Questions

Mar 06 2005
08:10 PM

4232
Views

1
Ans

What is the advantage of specifying WITH GRANT OPTION in the GRANT command?

SQL Interview Questions

The privilege receiver can further grant the privileges he/she has obtained from the owner to any other user.

sahu
Profile Answers by sahu Questions by sahu

Jan 27th, 2006

Ans:From above Commentyes, we can give privilege receiver can further grant the privileges he/she has obtained from the owner to any other user.

Answer Question Select Best Answer
Mar 06 2005
08:10 PM

5112
Views

1
Ans

What command is used to get back the privileges offered by the GRANT command?

SQL Interview Questions

REVOKE

Hemangi

Oct 15th, 2005

RRVOKE

Answer Question Select Best Answer
Mar 06 2005
08:10 PM

5677
Views

1
Ans

Which system tables contain information on privileges granted and privileges obtained?

SQL Interview Questions

USER_TAB_PRIVS_MADE, USER_TAB_PRIVS_RECD

sahu
Profile Answers by sahu Questions by sahu

Jan 27th, 2006

Ans:yes,USER_TAB_PRIVS_MADE, USER_TAB_PRIVS_RECDsystem tables contain information on privileges granted and privileges obtained

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

2453
Views

1
Ans

Void main(){struct a{char ch[10];char *str;};struct a s1={"Hyderabad","Bangalore"};printf("n%c%c",s1.ch[0],*s1.str);printf("n%s%s",s1.ch,s1.str);getch();}

SQL Interview Questions

HB, HyderabadBangalore

lakshminarsu

Apr 13th, 2006

output of the above program:nHBnHyderabadBangalore

Answer Question Select Best Answer
Aug 28 2005
09:38 PM

3193
Views

1
Ans

What is the output of the programvoid main(){struct a{int i;char *st1;};typedef struct a ST;ST *str1;str1=(ST*)malloc(100);str1->i=100;strcpy(str1->st1,"Welcome to Oracle");printf(" %d%sn",str1->i,str1->st1);getch();}A. core dumpB. will not compileC. 100,Welcome to OracleD. None of these

SQL Interview Questions

C

Johon

Aug 28th, 2005

A. The strcpy() will seg fault as there's no allocated memory for the destination string.

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

2275
Views

1
Ans

A function without any return type declares returnA. IntegerB. FloatC. VoidD. Syntax Error

SQL Interview Questions

A

vijji

Jul 20th, 2006

A function cannot retyrn a value without declaring return statement so it gives syntax error

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

2816
Views

1
Ans

What is the output of the program?#include<stdio.h>#include<conio.h>void main(){char *st1[3]= {"Hello","World","Oracle"};*st1=st1[2];st1[1]=*st1;free(st1[0]);free(st1[1]);clrscr();printf("%s %s %s",st1,st1[1],st1[2]);getch();}A. Garbage Garbage OracleB. Oracle Oracle OracleC. Hello World OracleD. Core Dump cannot print after freeing the memory

SQL Interview Questions

D

vikas

Sep 11th, 2006

it ll display a blank screen. u can figure it out if u look at the code :char *st1[3]= {"Hello","World","Oracle ;// here st1[0] points to Hello, st1[1] points to World and so on !!*st1=st1[...

Answer Question Select Best Answer
Sep 03 2005
11:50 AM

2368
Views

1
Ans

Is there any query which is use to find the case sensitivity in each records in database through visual basic?

SQL Interview Questions

samiksc
Profile Answers by samiksc Questions by samiksc

Jan 19th, 2006

For case sensitive string comparison in SQL one has to use substring() and ascii() functions in the following way.Get first character of both strings using substring function as substring(str1, 1, 1)F...

Answer Question Select Best Answer
Feb 07 2006
10:14 AM

5666
Views

1
Ans

How to store directory structure in a database?

sumith

SQL Interview Questions

Mainak Aich

Mar 28th, 2006

We can do it by the following command:create or replace directory as 'c:\tmp'

Answer Question Select Best Answer
Feb 24 2006
09:59 AM

5942
Views

1
Ans

Why do i get "Invalid Cursor State" errors when I insert/update/delete data with execute Query()?

sudha

SQL Interview Questions

narasimha_82
Profile Answers by narasimha_82 Questions by narasimha_82

Feb 28th, 2006

HI SudhaIF u get this error, then there is a problem with the Java program, U may open the cursor with the Readonly mode.Change the Resultset type then you will get it.This is not problem with the OracleNarasimha Rao

Answer Question Select Best Answer
May 02 2006
07:16 AM

2466
Views

1
Ans

If Delete Any Table In Back-End Then. What Are The Triggers will Fire Automatically(Those Triggers Are Back-End Triggers Only)?

Patan Muzeebkhan

SQL Interview Questions

Alex T

May 4th, 2006

Oracle has Schema triggers (CREATE OR REPLACE TRIGGER ... ON SCHEMA ... that will file on DDL commands. You can do things like CREATE OR REPLACE TRIGGER save_our_dbBEFORE DROP OR TRUNCATEON SCHEMAto stop/log attempts to drop a table

Answer Question Select Best Answer
May 10 2006
03:32 PM

3733
Views

1
Ans

How can i hide a particular table name of our schema.

Nitin Bhargava

SQL Interview Questions

rajaram

May 21st, 2006

you can hide the table name by creating synonyms.e.g) you can create a synonym y for table xcreate synonym y for x;

Answer Question Select Best Answer
Aug 03 2006
11:25 AM

2072
Views

1
Ans

Using corelated subquery: Inner query results in more than one row/value, then can this values be concatenated as one so that it comes along with outer result test/row as one value.

chiru

SQL Interview Questions

Bilkis

Aug 16th, 2006

No.

Answer Question Select Best Answer
Oct 17 2006
03:16 PM

2923
Views

1
Ans

What is a table called, if it does not have neither Cluster nor Non-cluster Index?

bsush
Profile Answers by bsush Questions by bsush

SQL Interview Questions

Jerrin

Oct 19th, 2006

The Table is called a Heap....

Answer Question Select Best Answer
Apr 18 2007
10:00 AM

5462
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

5057
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

2488
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

5288
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

Login

What is the advantage of specifying WITH GRANT OPTION in the GRANT command?

What command is used to get back the privileges offered by the GRANT command?

Hemangi

Which system tables contain information on privileges granted and privileges obtained?

Void main(){struct a{char ch[10];char *str;};struct a s1={"Hyderabad","Bangalore"};printf("n%c%c",s1.ch[0],*s1.str);printf("n%s%s",s1.ch,s1.str);getch();}

lakshminarsu

What is the output of the programvoid main(){struct a{int i;char *st1;};typedef struct a ST;ST *str1;str1=(ST*)malloc(100);str1->i=100;strcpy(str1->st1,"Welcome to Oracle");printf(" %d%sn",str1->i,str1->st1);getch();}A. core dumpB. will not compileC. 100,Welcome to OracleD. None of these

Johon

A function without any return type declares returnA. IntegerB. FloatC. VoidD. Syntax Error

vijji

vikas

Is there any query which is use to find the case sensitivity in each records in database through visual basic?

How to store directory structure in a database?

Mainak Aich

Why do i get "Invalid Cursor State" errors when I insert/update/delete data with execute Query()?

If Delete Any Table In Back-End Then. What Are The Triggers will Fire Automatically(Those Triggers Are Back-End Triggers Only)?

Alex T

How can i hide a particular table name of our schema.

rajaram

Using corelated subquery: Inner query results in more than one row/value, then can this values be concatenated as one so that it comes along with outer result test/row as one value.

Bilkis

What is a table called, if it does not have neither Cluster nor Non-cluster Index?

Jerrin

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;}

Latest News

It looks like you are using an AD Blocker!

Void main(){struct a{char ch[10];char str;};struct a s1={"Hyderabad","Bangalore"};printf("n%c%c",s1.ch[0],s1.str);printf("n%s%s",s1.ch,s1.str);getch();}

What is the output of the programvoid main(){struct a{int i;char st1;};typedef struct a ST;ST str1;str1=(ST*)malloc(100);str1->i=100;strcpy(str1->st1,"Welcome to Oracle");printf(" %d%sn",str1->i,str1->st1);getch();}A. core dumpB. will not compileC. 100,Welcome to OracleD. None of these