-
What is the output of the program?#include<stdio.h>#include<conio.h>#define sqr(a) a*avoid main(){int a=10,b=1,c;c=sqr(10+1);printf("Sqr Root of (10+1)is %d", c);getch();}A. 121B. 21C. 13D. Syntax Error
B
Bhoomika sharma
- Dec 16th, 2008
Actually, you can see:sqr(a) is defined as:a*a;=> sqr(10+1)=10+1*10+1=> 10+10+1=>21is the right answer.
-
What is the output of the program?#include<stdio.h>#include<conio.h>void main(){int i=1*4/3-27%3^2+100*0.5-(4>3?1:2);clrscr();printf("%d",i);getch();}A. 49B. compile errorC. 51D. 48
B
surender
- Jun 11th, 2007
49
-
-
How to test the complex view using manually testing?
Sudhir Sorout
- Feb 4th, 2008
We can update a view using instead of trigger..... see example on url..http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.sqls.doc/sqls365.htm
gemini burj
- Nov 18th, 2007
Complex view means that no DML statement could be executed for this view, to test it you may descrive or select the columns from the views.
-
What is the advantage to use trigger in your PL?
bhagya
- Feb 10th, 2012
1.Auditing the tables
2.Online transaction
3.Securing from another table
4.Automatic calculations
5.Replicate the tableschennoju
- Aug 3rd, 2006
The main advantages of the triggers are* To Audit the table* To check the complex conditions which are not possible by the constraints.
-
-
What are the advantages and disadvantages of primary key and foreign key in SQL?
qptopm
- Sep 9th, 2016
Foreign keys are both a method of ensuring data integrity and a manifestation of the relationship between tables. It is also known as referential integrity. Foreign Key is a field in database table...
shivkumarojha
- Sep 6th, 2006
Disadvantages:On primary key index will be created so during updation of table index need to be adjusted accordingly. this process makes the updation slower.
-
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.
-
SenatorSID Name Year Service Party CID1 Jerry 5 Rep 22 Mary 2 Dem 33 Barry 12 Dem 1CountyCID Name Democrats Republicans1 Evergreen 75,000 70,0002 Marsh 12,000 25,0003 Hilltop 9,500 8,000A) List each county in alphabetical order with the senator that serves the county
anugrah17
- Jan 9th, 2008
above solution is also correct, but a join is always better :)--------------------------------------------------------------------------SELECT Country.Name AS Country, Senator....
rajakumar_na
- Nov 22nd, 2007
Try this,SELECT c.name county, s.name senatorFROM county c, senator sWHERE s.cid = c.cidORDERY BY county; Result;COUNTY &nbs...
-
SQL Time Functions
How to calculate the time variation between two different time sessions?
Sudhir Sorout
- Feb 4th, 2008
Select t1- t2 from dualwhere t1 and t2 are dates then this query will return no of day not hrs.Sudhir Sorout
gbansal4
- Dec 15th, 2007
Select t1 - t2 from dualwhere t1 & t2 are dates. It will give output in hours.
-
Changing column name
How we can change the name of the column for a existing table?
ushalakshmi
- Apr 16th, 2008
The Column Can be changed by using the following commandsp_rename 'Tablename.OldColumnname', 'new columnname', 'COLUMN&#...
ravinder.pathania
- Feb 5th, 2008
The coloumn name can be changed by issuing the following commandalter table rename column to The feature is available after oracle 9i version
-
How to execute a sql*plus script from pl/sql block.
My script contains sql plus set commands. how to execute that script in a pl/sql block i.e. either anonymous ,procedure or function or trigger
hemant.agarwal03
- Mar 17th, 2008
First you need to save your file in .sql format, suppose you create set.sql and saved it on c: drive then follow below command.SQL> @C:SET.SQL and press ENTERyour script has been executed. :-)
Susil Kumar
- Feb 20th, 2008
Let me reframe the question as follows: How to execute pl/sql block in sql*plus environment?If I am on the right path, I'll be able to give th...
-
Inner Join Problem
Why IN query not worked in inner join?
sbsm_07
- Apr 29th, 2010
When we querying with in clause multiple records in resultset. inner join compare with one record only
krishna9231
- Jul 7th, 2008
Inner Join is nothing but self join. In self join the system wil take one record from tabel (i.e. first objective) and compare with the same table but objective is different.so at a time your comparin...
-
Pairwise and Non-Pairwise Comparisons
Explain the difference between pairwise and non-pairwise comparisons in multiple column sub-queries.
pravintule
- May 28th, 2010
In pairwise comparison the attributes included in where clause predicate are compered in same predicate and only single predicte is evaluated.where as in non-pairwise comparison the attributes are com...
yogesh.raut
- Mar 13th, 2010
Pairwise means we can put two checks at a time using subquery using ' in ' condition.. Non pairwise mean seprately we have to specifiy subquery for both conditons using equality operator.
-
User-defined Data Type
Write an SQL statement to create user-defined data types?
jpundalik
- Dec 29th, 2009
Below is the syntax can be used for creating user defined data type in Oraclecreate or replace type type_name as object(add fields and types..)Example:create or replace type address as object(addr1 varchar2(100),City varchar2(30),phone varchar2(15));
-
LOB Segment
What do you mean by LOB segment? Explain LOB segment
smonroy
- Sep 27th, 2011
You are talking about oracle, LOB is simply a pointer. It points to an index.
-
What are steps to follow for query tuning ?
robindas
- Jan 11th, 2013
Few steps for query tuning. 1) Check for if any sub query or exists or not exists is there if yes then try to change it in the joins 2) Try to check the way joins had been written try to put it in f...
samareshoracle
- Aug 4th, 2012
Following a Tuning Methodology Objectives:: Determine performance problems Manage performance Describe tuning methodologies Identify goals for tuning Describe automatic SQL tunin...
-
How to get number of days using SQL ?
I have table .. like
EMPNO Ename DOB
------------------------------------
1 you 1-jan-2011
2 Me 28-jan-2011
tel me the query for no.of days different from.. two dates of column DOB.?
Thanks in advance.
Sateeshkirathakudu
- Dec 13th, 2011
Select date1-date2 from tablename;
If the above value is negative it means date 1 is older than date 2 -
Corelated query
What is difference b/w coreleated subquery and nested subquery?
-
DML operations on base tables using a simple view
Can we make DML operations on base tables using a simple view?Can we insert or update or delete rows to the base tables using a view?
lviswanath
- Jul 22nd, 2013
Of course we can do anything i.e. updating/deleting/inserting on a base table underlying a simple view, until unless its covering NOT NULL columns of the table in the query of the simple View.
SQL Interview Questions
Ans