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

Yugma

• Aug 13th, 2006

Database is simply a collection of related data nothing else. It can be manual?or automatic both.DBMS is collection of application programs which enables a user to define, create and manipulate database.

ashutosh mishra

• Jun 7th, 2006

hiin simple way ,we can say that database is collection of data which can be easily manipulate and retrive.databse  is thing which can be store backendin database software.

Answer Question  Select Best Answer

Bilkis

• Aug 16th, 2006

No.

Answer Question  Select Best Answer

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

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

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

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

Vasanth Kumar

• Oct 6th, 2006

UNION - returns on Distinct rows/Slower in performanceUNION ALLL- Returns duplicate rows/Faster Performance

Sachin

• Aug 3rd, 2006

Union will remove the duplicate rows from the result set while Union all does'nt.

Answer Question  Select Best Answer

Jerrin

• Oct 19th, 2006

The Table is called a Heap....

Answer Question  Select Best Answer

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

aa

• Nov 28th, 2006

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

Answer Question  Select Best Answer

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

rajneeshbajwa

 Profile Answers by rajneeshbajwa Questions by rajneeshbajwa

• Dec 22nd, 2006

Hi Frienz...According to me WHERE and HAVING both are equally important..WHERE is used for condition on a single row and it comes before group by clause...whereas HAVING is used with GROUP BY alwayz.....

mamathi

• Oct 27th, 2006

we can use where clause for single function only. haveing clause we can use more then one function in a clause.exselect * from table namewhere salary > 10000;ex havingselect *from table namehaving sa...

Answer Question  Select Best Answer

Select emp_name, Dept_name from (Employee_table left outer join Dept_table on Employee_table.Dept_id = Dept_table.Dept_id)

Evghenii

• Jan 19th, 2007

Select A.ENAME as Employee, B.ENAME as Manager from EMP A, EMP B where A.MGR=B.EMPNO group by A.ENAME;

zero_cool

• Mar 6th, 2006

Select ename, dnumber from employee left outer join department; I think that would be enough without necessarily saying "where employee.dnumber = department.dnumber since we are using "LEFT OUTER JOIN" statement--zero cool--

Answer Question  Select Best Answer

Lakshaman

• Jan 24th, 2007

An exampleWe accept user and password and validate likeselect 1 from users where username = 'username' and password = 'pwd';What if username string is passed like [x' or 1=1; --]select 1 from users where username = 'x' or 1=1; --' and password = 'pwd';

sabithagopi

 Profile Answers by sabithagopi Questions by sabithagopi

• Jan 23rd, 2007

SQL Injection happens when a developer accepts user input that is directly placed into a SQL Statementand doesn't properly filter out dangerous characters. This can allow an attacker to not only stealdata from your database, but also modify and delete it.

Answer Question  Select Best Answer

IS NULL operator

burelamanohar

• Feb 6th, 2007

Null Operator

rajanipriya

 Profile Answers by rajanipriya Questions by rajanipriya

• May 8th, 2006

  select * from table1 where colunm1 IS NULL;This statement will suffice.

Answer Question  Select Best Answer

kaledhananjay

• Feb 6th, 2007

SELECT NVL(MAX(EMPNO)+1,0) FROM EMP;This select statement generates empno from 0...N.

kaledhananjay

• Feb 6th, 2007

Try this SELECT NVL(MAX(EMPNO)+1, 0) FROM EMP; It create empno from 0..N.

Answer Question  Select Best Answer

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

amy

• Mar 20th, 2007

Select e1.name, e2.name, e3.namefrom employee e1 left join employee e2 on e1.manager_id = e2.employee_idleft join employee e3 on e2.manager_id = e3.employee_id

biswa

• Jul 11th, 2006

 SELECT worker.ENAME || ' works for '  2  || manager.ENAME  3  FROM emp worker, emp manager  4  WHERE worker.mgr = manager.empno ;where emp is the tableEMPNO ENAME&n...

Answer Question  Select Best Answer

Sunil Langeh

 Profile Answers by Sunil Langeh Questions by Sunil Langeh

• Mar 22nd, 2007

Yes, to do so ,firstly we have to delete records from the child category/table

PRASHANTKULAT

 Profile Answers by PRASHANTKULAT Questions by PRASHANTKULAT

• Mar 7th, 2007

We can delete record from Parent table. But to do so We have to delete records from child tableTo do so You can write Trigger (Before delete trigger) on the Parent Table which will delete all the child records.

Answer Question  Select Best Answer