-
Import & Export Through OEM & SQL
Can any one guide me how can i import and export schema using SQL and OEM
luzaolai
- Apr 27th, 2009
In db2 three different format (ixf,del,asc) to export data:Export to tablename.ixf of ixf select * from tablename. When do import we can define if the original data should be kept or cleaned. Insert ...
-
What operator tests column for the absence of data?
IS NULL operator
burelamanohar
- Feb 6th, 2007
Null Operator
-
Which command executes the contents of a specified file?
START <filename> or @<filename>
-
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.
-
What are the privileges that can be granted on a table by a user to others?
Insert, update, delete, select, references, index, execute, alter, all
carlc40
- Apr 22nd, 2010
Oracle perspective -It depends on whether the user owns the table and if that user has the ADMIN privilege to grant privileges to others.?
rajanipriya
- May 8th, 2006
Alter, delete, index, insert, references, select, update. are the table(object)priviliges that can be granted by a user to others.
-
What is the output of the program?void main(){fork();printf(" Hello World");getch();}A. Hello WorldB. Hello World Hello WorldC. Error MessageD. None of these
B
LakshumaiahGoud
- Oct 3rd, 2010
it will print two times.if n fork calls then no.of processes will be 2^n
Bhoomika sharma
- Dec 16th, 2008
The answer is B as:the fork() calls the function i.e.it makes a copy of the parent process in the form of a child process. Thus,the two calls will be made to the function and as a result HEllo World is printed as twice and thus the answer.
-
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.
SQL Interview Questions
Ans