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

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

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

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

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

Gopi

• Apr 8th, 2006

Subtype Relation

sujatha

• Jan 21st, 2006

Arc Relation

Answer Question  Select Best Answer

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

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

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

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

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

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

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

gemini burj

 Profile Answers by gemini burj Questions by gemini burj

• Nov 18th, 2007

 the translate function replaces a sequence of characters in a string with another set of characters. However, it replaces a single character at a time. For example, it will replace the 1st chara...

Answer Question  Select Best Answer

what is the difference between the null in C and one in SQL?

Sudhir Sorout

 Profile Answers by Sudhir Sorout Questions by Sudhir Sorout

• Feb 4th, 2008

Null is a special marker used to indicate that a data value is unknown in the sql. But in case of ‘C’ A "null statement" is a statement containing only a semicolon; it can appear...

Answer Question  Select Best Answer

This is one of the questions I have on my interview exam. It is a take home exam and I have not learned SQL but the employers want to know my know my skills to find answers using any means possible. Question: Review the following SQL code and give a brief explanation SELECT 'AD', B.AccountID,'Change' FROM (SELECT DISTINCT A.sAMAccountName As AccountID from (select AG.sAMAccountName...

ajith007

 Profile Answers by ajith007 Questions by ajith007

• Dec 6th, 2007

Use of distinct, not in keywords make this code altogether complicated. But what I discern from this code 'catch' lies in FULL OUTER JOIN since it retreives all the data including your null values.The union here returns the cross product of query mentioned that includes your null values.

Answer Question  Select Best Answer

What is water mark apporach in SQL?

godsrikanth

 Profile Answers by godsrikanth Questions by godsrikanth

• Dec 3rd, 2009

A High Water Mark is when a database (or database table) has reached its maximum capacity, for example, the EMPLOYEE table including current and past employees, could have 1000 rows. That would be its...

Answer Question  Select Best Answer

What is pivotal query?

mv_sivavardhan

 Profile Answers by mv_sivavardhan Questions by mv_sivavardhan

• Aug 6th, 2008

Pivot is a keyword using which the values in vertical rows can be displayed as horizontal columnsEx: If there is a table with all dates of month from 1st to 30th and values against each date...

Answer Question  Select Best Answer

what are the differences among these table level lock modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE MODE ?

Pintu_unix

 Profile Answers by Pintu_unix Questions by Pintu_unix

• Jul 20th, 2008

SHARE UPDATE EXCLUSIVE  This mode protects a table against concurrent schema changes and VACUUM runs. Acquired by VACUUM (without FULL), ANALYZE, and CREATE INDEX CONCURRENTLYEXCLUSIVE This ...

Answer Question  Select Best Answer