-
What is the output of the programvoid main(){int i,j,k,n=5;clrscr();for(i=5;i>0;i--){j=1<i;k=n&j;k==0?printf("0"):printf("1");}getch();}A. 00011B. 11110C. 11001D. 11100
B
Bhoomika sharma
- Dec 16th, 2008
Although we may think that the code contains errors but its logical approach,We have a for-loop in which i is initialized to 5. The value of j =1 if 1<i i.e. it is valid for i=5,4,3,2 and the truth...
aniljoo
- Feb 12th, 2007
Answer should be 11110
-
What do you mean by Meta data ?
Bhoomika sharma
- Dec 16th, 2008
Meta Data provides a context for data. It is used to faciliate the understanding,characteristics, and management usage of data. E.g. we have as:metadata for :Book: author,publisher,ISBN,and number or ...
bind mama
- Feb 5th, 2007
Data about data is called Meta data.
-
How can we delete a check constraint in a table
-
_______data type is used to store binary data such as graphics, sound, etcSQL uses ____________ clause to impose an order on the result of a query _________ function determines the number of rows or column values.The limit that determines the sphere of influence and control over a system is called_______________ is a graphic technique that can be used by analyst to represent the inputs and outputs.
-
What is the parameter substitution symbol used with INSERT INTO command?
&
Anuradha
- Oct 13th, 2005
Ans :insert into .Because & is used for substitution variables . And INSERT INTO command is certainly not used before a substitution variable.
-
How to copy SQL table?
malapati
- Oct 9th, 2008
To copy a table along with records create table as select *from ;if we want to copy only structure create table < new tablename> select *from where ;
ravi
- Jun 12th, 2006
Yes , we can copy the table structure. create table as select * from where 1=2;
-
How to find out the database name from SQL*PLUS command prompt?
-
How do you delete duplicate row from oracle table that does not have any primary key field?
raji_4u
- Sep 19th, 2008
Consider a table has two columns and no primary keyemp---------------------empno ename---------------------1 AA2 BB3 CC1 DD --> not duplicate3 ...
Lavanya Chowdary
- May 6th, 2007
We can use RowID if you are not having any primary key for column.
-
How to tune the following sql in order that the performance improve the query is SELECT DISTINCTA.BUSINESS_UNIT,A.CUST_ID,A.ASOF_DTFROM PS_ITEM_ACTIVITY A WHERE A.BUSINESS_UNIT = '1100G'AND A.ITEM LIKE 'OA%' AND A.PO_LINE = 0AND A.ENTRY_REASON 'CLEAR'AND A.ASOF_DT > '01-JAN-1900'AND A.USER1 = ' 'UNIONSELECT DISTINCTA.BUSINESS_UNIT,A.CUST_ID,A.ASOF_DTFROM PS_PENDING_ITEM A WHERE A.BUSINESS_UNIT = '1100G'AND A.ITEM LIKE 'OA%' AND A.PO_LINE = 0AND A.ENTRY_REASON 'CLEAR'AND A.ASOF_DT > '01-JAN-1900'AND A.USER1 = ' 'AND A.POSTED_FLAG = 'N'AND ERROR_FLAG = ' '
raji_4u
- Sep 19th, 2008
Remove union and place union allMake sure the where conditions is in order of1. =2. >3. 4. like.
Make sure that the condition that returns least records comes first.zskhan
- Oct 12th, 2006
Remove DISTINCT from both queries.Since UNION is being used, we are going to get distinct rows anyway and queries with distinct are quite expensive.
-
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;}
6
-
Pivotal query
What is pivotal query?
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...
-
How can you create a column to be auto generated when creating a table ? is it possoble ?
mv_sivavardhan
- Aug 6th, 2008
There are two ways to auto generate the values of a column in a table1) Default value: we can set a default value to column definition2) Identity value: we can set an identity value with initial value and increment value to column definition.
-
Table Level Lock Modes
what are the differences among these table level lock modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE MODE ?
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 ...
-
Which clause you use to exclude the rows before grouping them?A. Group ByB. HavingC. WhereD. Minus
krishnaveni_g
- Jul 17th, 2008
Where clause is the correct answer. Order of execution iswheregroup byhaving
-
What is the difficult SQL query you used in last job. Explain the scenario
seemu123
- Jul 1st, 2008
You can use like thisSelect top 10 customer from Databasename..TablenameunionSelect top 10 customer from Databasename..TablenameunionSelect top 10 customer from Databasename..Tablenameex:Select top 10...
kashyap_aseem
- Feb 14th, 2008
One which i faced but till yet couldnt solved was like i am having 50 db's, each db's having 100 customersi wanted top 10 customer for each 50 db's according to their salary in oraclethough it sounds easy but according to my knowledge its not so
-
Main(int argc,int *argv[]){int i;for(i=1;i<argc; i++)printf("n%s%s",argv[i],(i<argc-1)?"":"");return 0;getch();}
I work for oracle
chaitanya_chitrala
- Jun 25th, 2008
As the value in argc is 4 ,the value till 2 char is printed from the input string therefore the output is :I Work
Amee Thaker
- Sep 5th, 2007
It will print all the parameters passed.
-
while this query dint work :
"select * from (select rownum,a.* from emp a) where rownum=70;"
2. as i've read that rownum can work only for < and <= but not for = or > or >=, then why the query worked for rnum=70">1. Why is it so that the given query worked :"select * from (select rownum rnum,a.* from emp a) where rnum=70; "while this query dint work :"select * from (select rownum,a.* from emp a) where rownum=70;"2. as i've read that rownum can work only for < and or >=, then why the query worked for rnum=70
krishnaindia2007
- Jun 21st, 2008
ROWNUM returns a number indicating the order in which the row was retrieved from the table, but this is not always the order in which a row is displayed. If you directly user rownum in the outer query it considers the rownum of outer query not that of inner query.
Lavanya Chowdary
- May 6th, 2007
It will work for = operator But it will work for the first row in the table pls check that
-
It is also mentioned that column aliases cannot be used in the WHERE clause, then how did this query worked :"select * from (select rownum rnum,a.* from testsal a) where rnum=3;".
Praveen Vaddadi
- Mar 7th, 2008
Lets examing the query as:select * from (select rownum rnum,a.* from testsal a) b where b.rnum=3;".The subquery here is used as another table for the main query and only its structure will b...
-
What de-normalization and when do you do it?
sweetytrivedi
- Jun 18th, 2008
Denormalization is the process of attempting to optimize the performance of a DB by adding redundant data or by grouping data. The recommendation is always to use this for teh logical design
hari prasad
- Mar 19th, 2007
When its a large data base and our main constraint is the cost(time) than we concentrates on fast retriving .so we go for denormalization instade of joing(complex relation calculcus) too many table and be in much complexicity with hign normalization.
-
How many columns are retrieved from this query:SELECT address1 || ',' ||address2 ||',' ||address2 "Address" FROM = employee;A. 3B. 2C. 1D. 0
JohnCenzer
- Nov 30th, 2006
I think there is some confusion between "retrieve" and "return".The query retreives 2 columns from the table - address1 and address2, and returns 1 column "Address"
Jim Abraham
- May 27th, 2006
All the addressed rows in the select statement are concatenated and renamed as "Addresss". So only 1 column will be reflected in the result.So answer is C
SQL Interview Questions
Ans