-
-
-
if we truncate a table which consists of 100 rows then how many rows get updated?
prititripathi
- Oct 7th, 2011
Truncate teablename
used to delete the table
it will not update any row of the tablepravesh28
- Dec 28th, 2010
100turncate coomand delete all the row without deleting the colomn so 100 row updated......
-
-
What is the result of the fallowing code?PieceInsert into table A value(a1):CREATE TABLE B AS SELECT * FROM A;ROLLBACK;A. Table B gets created with the row inserted in the first statement.B. Table B is not createdC. Table B gets created, but no row gets inserted into Table AD. Rollback throws up an exception.
Guest
- Jan 4th, 2007
hian empty table table (B) will be created there is a mistake un the first statementno need to commit a Create instruction, so the rollback will have no effectgood luck
-
What is the o/p of the following C-program?Main(){Char str[7]="strings";Printf("%s",str);}
bhavya
- Sep 20th, 2014
But when str[6]="string"; //6 characters
it printed string and not any absurd value....
then why only in case of str[7]="strings";//7 characters
it prints absurd value at the end??? -
There are two numbers in the ratio 8:9. if the smaller of the two numbers is increased by 12 and the larger number is reduced by 19 thee the ratio of the two numbers is 5:9.Find the larger number?
karthisiva
- Dec 21st, 2010
(8/9)x*12/19=5/9,sollution multiply 8 with 9 and 9 with 5,so we get 72-45, and same for 12 and 19,we get 27x=108-95,x=13/27,x=1/2.1,largest number =9*1/2.1therfore the largest number is 4.5.
ksrikant
- Dec 19th, 2010
X:y=8:9 this means x is smaller than y(as x = (8/9)y). According to condition x+12/y-19 =5:99x+108 = 5y-95but 9x=8yso, 8y+108 = 5y-953y = -203y= -203/3, which is the larger number.
-
-
-
There are two square rooms. Both are of same height. The second room is 5m longer than the first room. The rate for papering the walls is 10 paisa per square meter. The total cost for papering the rooms is Rs 60 and Rs 80. What is the height of the rooms?
skumar06cs
- Jul 22nd, 2010
4xh*10=60----14(x+5)h*10=80------2After solving it we get 0.1m....Thanks frnds..
-
Which of the following statements is not true about views?A. You can create an index on viewsB. Views do not have permanent dataC. Views can be based on one or more tablesD. Views can be dropped without dropping tables
-
can you create a table by using pl/sql?if u so justify your answer;
-
-
In a 60 liters of mixture of spirit and water is 7 %. In order to make water 19%, how much water should be added?
opsmca
- Sep 6th, 2010
60*7/100=4.2 liter water right now therenow we assume we consider p liter water to make it 19%so(60+p)*19/100=p+4.2so p=8.8
-
What is the output of the following C program?Main(){Printf("%c","abcdefgh"[4]);}
maddy27
- Apr 2nd, 2010
The answer is "e" because the value "abcdefgh" will get one index for each letter as:a=0b=1c=2d=3e=4f=5g=6h=7And since %c is written in question der4 only one letter will be our answer... and is "e" coz its index is 4.
Raja
- Feb 12th, 2007
E
-
-
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
-
Demoralization is done toA. Check for Data IntegrityB. Reduce Data RedundancyC. Introduce Security CheckD. Increase Query performance
sweety
- Aug 23rd, 2014
Denormalization is done to increase query performance and
normalization is done to reduce data redundancy -
What is the o/p of the following C-program?Main(){Char *str[] = { "Frogs"," do", "not", "die", "they", "croak!");Printf("%d %d",sizeof(str),sizeof(str[0]));}
adeshgupta
- Oct 15th, 2009
24,4(in unix)sizeof(str[0])= storage address=inteter=4bytes;same as sizeof(str)= storage address of 6 =6*4bytes;
-
A stamp collector arranges his stamps during his free time. When he arranges his stamps in pairs, there is one stamp left. It is the same when he arranges the stamps in groups of 3, 4, 5 and 6. Now, how many stamps will he be left with when he arranges them in groups of 8?
skumar06cs
- Jul 22nd, 2010
First take the LCM of given No. and then add remainder that will give the required no. = 61so, divide by 8 get remainder as 5 ans...
Partha006
- Jun 30th, 2006
Total stamps are the l.c.m of 3,4,5,6 i.e 60 and 1 is the remainder in all the cases.. so the toal stamp is 60+1=61 now deviding 61 with 8 leaves the remainder 5so if he want to make it a group of 8 he ll be having 5 stamps left
