Wipro Training Materials
1)2nd Normal form
2)views
3)Initcap
4)Day,dd,mon,yyyy,hr:mmAM
5)Notnull?
6)composite key
7)select count(distinct dept_id)
8)select column1,column2 from group by......(the choice which doesn't have semicolon and table name)
9)view
10)having
11)null value
12)multicolumn
13)alter view
14)count(date) and min(date)
15)outerjoin
16)grant,revoke
17)values 3 or 5
18)set define...
19)intersect
20)from,where,group by, having, order by
21)100*90
22)referential integrity
23)city(lower_...).....where city='france'
******************************************************************************************************************************
RDBMS
1) Initcap function converts a first character of a string to uppercase
2) Object privileges can be granted to others using the SQL command GRANT AND REVOKE ( The choice is both a and b)
3) How long the variable remain …….
Ans : until the session completes
4) To_date
5) ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY (student_id)
6) Two statements are true about constraints
a) The primary key and the unique key conatraints create a unique index
b) The not null constraint ensures that null values are not permitted for the column
7) which of the following requires explicit commit -------- insert
8) Author name ='scott'
9) SET DEFINE is not a sql command
10) You cannot update a view with group functions
11) A single row subquery
12) Valid statements
a)min(start_date)
b)count(start_date)
13) logic functions---- and ,or,not
14) subquery ignores NULL value by default
15) SUM (used to calculate total of all salaries)
16) which one executes first ----- 100*19
17) column length --- 255 characters
18) shows error
19) COMPOSITE KEY (more than one attribute)
20) ALTER TABLE customers ADD CONSTRAINT cust_name_nn NOT NULL
21) create table package as (pack_id number(2))
22) where salary > 5000
23) null value by default
24) create, alter
25) where, groupby, having
26) third number default sysdate
27) delete
28) VIEWS provide table security by restricting access to ……….
29) UPDATE , DELETE
30) E-R model
31) Referential integrity
32) OR
33) on delete cascade
34) 3 or 5
35) equi join … d1.dept_no=e1.dept.no (the qn like this)
36) "Annual Salary"
37) reserved words cannot be used
38) AND – not a set operator
39) outer join – matching all records…..
****************************************************************************************************
1.serv 3,4---------------------dekstop ceo
2.false--------------------------System Transistion
3.serv 1------------------------------least resolution
4.offshore------------------chennai,us
5.white box-------------------internal logic
6.u,i,s------------------order of testing
7.all---------------------------outsuorced
8.black box------------------ other testing
9.manual-------------------------man
10.desktop mangmt---------------------not in AO
11.false---------------------------no testing serv 1 ticket
12.regression------------------ car mechanic
13.assemble----------- component function properly
14.fase-----------------service termination not a part of..
15.true------------------------PM is SM
16.scopecheck--------------------------verification
17.false---------------------------------------speed of market
18.AO----------------------------------defined deliverables
19.need not b created----------------test approach
20.ASS&prod test -----------------------------------difficult to differentiate
21.SM---------------------------------------------customer &unit
22.serv 1-------------------least
23.all------------------------------release
24.TL---------------------------program delay
25.analyse app.reqmt---------------------------a.reqmt are refined as same assys test plan is prepared
26.perform select plan dele--------------------------not true peer review
27.SM----------------------------client & strategic
28.performance mangt--------------------------SQA
29.serv 3or 4 ---------------------------junior staff
30.all----------------------------const factor AO
31.true------------------AO life diligence
32.SI--------------------run/maintan
33.helpdesk------------incidence ticket
34.serv 1-----------------ATM stopped
35.AO-----------------------------ongoing operation
36.ins,simul protype-------------------------not true abt validation
37.false---------------------------------------- AO cant AD
38.true----------------tru testing defects removal
39.ORT-----------overall productn config
40.CEO-----------------------when serv 1 ticket
****************************************************************************************8
Programming Techniques
{
int x=3;
if(x==2);
x=0;
if(x==3)
x++;
else
x+=2;
printf(x)
}
ans
2
int x=5,y= -10,b=2,a-=4,z;
z=x++ - --y*b/a;
printf(z);
ans
10
int x=3,counter=0;
while((x=1))
{
++counter;
x - -;
}
printf(counter);
ans
counter=2
some variable name best pracites
reg bottom up approach some check boxes
switch --- default needs break or not
short and long byes---- 2 and 4 bytes
some ques reg hungarian,camel casing
valid approach
*structured apprach
*top-down
*bottom-up
*conventional approach
***************************************************************************************
1)
# include<stdio.h>
void main()
{
int z,x=5,y=-10,a=4,b=2;
z=x++ - --y * b/a;
printf("%d",y);
}
Ans : 10
2)
# include<stdio.h>
void main()
{
int i=4, x=6;
double z;
z = x/i;
printf("%0.2f",z);
}
Ans : 1.00
3)
# include<stdio.h>
void main()
{
int x=3;
if(x==2)
x=0;
if(x==3)
x++;
else
x+=2;
printf("%d",x);
}
Ans : 4
4)
# include<stdio.h>
void main()
{
int a = 10,b;
b = a++ + ++a;
printf("%d %d %d %d",b,a++,a,++a);
}
Ans : 22 13 13 13
5)
# include<stdio.h>
void main()
{
int x = 0;
for ( ; ;)
{
if(x++ == 4)
break;
continue:
}
printf("x = %d",x);
}
Ans : x = 5
6)
# include<stdio.h>
void main()
{
int a = 10,b=5,x,y;
x = a>9;
y = a>3 & & b !=3;
printf("x = %d, y = %d",x,y);
}
Ans : Undefined symbol &(Error)
7)
# include<stdio.h>
void main()
{
float a = 2.3;
int b = 3;
a = b / 2 + b * 8 / b - b + a /3;
printf("%f"a);
}
Ans : 6.76
8)
# include<stdio.h>
long factorial(long l);
void main()
{
long l = factorial(4);
}
long factorial(long x)
{
?????
return x*factorial(x-1);
}
Ans : if(x<=1) return 1;
9)
# include<stdio.h>
void main()
{
int m=10,n=15,x;
x = ++m + n++;
printf("%d%d%d",x,m,n);
}
Ans: 26 11 16
10)
#include<stdio.h>
void main()
{
int i=0,j=0,table[3][3];
for(i;i<3;i++)
{
for(j;j<3;j++)
{
if(j==i)
table[i][j]=1;
else
table[i][j]=0;
}
}
}
The value of the table will be:
Ans : 1 0 0 0 1 0 0 0 1
**********************************************************************************
PT(answers only)
void main()
{
int z,x=5,y=10;
a=4,b=2;
z=x++- --y*b/a;
printf("%d",y);
}
ans=10
void main()
{
int i=4,x=6;
double z;
z=x/i;
printf("%0.2f",z);
}
ans=1.00
void amin()
{
int x=3;
if(x==2);
x=0;
if(x==3)
x++;
else
x+=2;
}
printf("%d",x);
ans:2
void main()
{
int a=10,6;
b-a++ + ++a;
printf("%d%d%d%d",b,a++,a,++a);
}
ans 22,13,13,13
void main()
{
int x=0;
for(;;)
{
if(x++==4)
break;
continue;
}
printf("x=%d",x);
}
ans x=5
void mani()
{
float a=2.3;int b=3;
a=b/2+b*8/b-b+a/3;
printf("%f",a);
}
ans: 6.76
void mani()
{
int a=10,b=5,x,y;
x=a>9;
y=a>3 &&b!=3;
printf("x=%d,y=%d",x,y);
}
undefined symbol &(error)
long factorial(long l)
void main()
{
long l=factorial(4);
}
long factorial(ong x)
{
????
return x*factorial(x-1);
}
ans if(x<=1)return 1;
void main()
{
int m=10,n=15,x;
x=++m + n++;
printf("%d%d%d",x,m,n);
}
ans 26,11,16
void main()
{
int i=10,j=0,table[3][3];
for(i;i<3;i++)
{
for(j;j<3;j++)
{
if(j==i)
table[i][j]=1;
else
table[i][j]=0;
}}}
ans 100
010
001
********************************************************************************
wat r d steps of software develomt?
Requirement,analysis,design,testing,deploy
where we use the decision flow tech approach?
structured programming
there is no need of braces in an if condn ven there r two or more stmts
which keyword is used to release the memory allocation malloc free();
what can we use instead of "int height of "
camel_underscore
"I was got my salary 50%96!" it is printed out by using which printf stmt
max-num 5------> ans preprocessor macro
in a c prgm Static could be usd once is a life of tat prgm ans true
wat is the mini stroage bytes for sign/long 2,4
the break stmt is necessary for default int switch case-----------> true
int a[8]={1,2,3,4}
wat is the outpt
ans depends upon the complier
which stmt is usd to get string from keyboard
ans gets()
14%-3 +2
-14%-3 -2
-14%3 -2
main()
{
char &str="hello";
char *pt=str;
char least=127;
....
}
ans 0
cahr *some fun()
{
cahr tem[]={'s','t','f'...}
...
}
ans garbage value
void main()
{
cahr a[]="12345\0";
....
}
ans here in 3 or 6
f0r(i=1;i<10;1++)
{
for(j=1;j<=10;j++)
{
..
..
}
ans 100 010 001
size of double ans 8bytes
int sum =0;
for(i=1i<=10;i++);
{
sum=sum+i;
}
retur sum;
}
ans i<=9 10
i<9 9
question related to count. ans 2
only one ternary operator ans true
print prime numbers betwn 2 to 10
(13/4 *3)%5+1
ans 5
c=getchar or c=getc(stdin)
z=1.00
static variable--->true
x=26,m=11,n=16
check order info()--> shud start wit caps
binary search
camel notation
fg
A&C
20bytes
uninitialised
realloc(ptr,10)
00131
algorithm
if any variable is used inside a for loop can v refer it outside d loop ans true
structured progrmmg
except conventional program alll ther options for design approach
one valid stmt
other elements in the array would br ans==0
one stmt is valid
write soub(d)
28
A followed by b,c
it will loop indefinitely
calloc
1--1 1--2
45
do while exectues once
001234
5
binary
testing
2)views
3)Initcap
4)Day,dd,mon,yyyy,hr:mmAM
5)Notnull?
6)composite key
7)select count(distinct dept_id)
8)select column1,column2 from group by......(the choice which doesn't have semicolon and table name)
9)view
10)having
11)null value
12)multicolumn
13)alter view
14)count(date) and min(date)
15)outerjoin
16)grant,revoke
17)values 3 or 5
18)set define...
19)intersect
20)from,where,group by, having, order by
21)100*90
22)referential integrity
23)city(lower_...).....where city='france'
******************************************************************************************************************************
RDBMS
1) Initcap function converts a first character of a string to uppercase
2) Object privileges can be granted to others using the SQL command GRANT AND REVOKE ( The choice is both a and b)
3) How long the variable remain …….
Ans : until the session completes
4) To_date
5) ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY (student_id)
6) Two statements are true about constraints
a) The primary key and the unique key conatraints create a unique index
b) The not null constraint ensures that null values are not permitted for the column
7) which of the following requires explicit commit -------- insert
8) Author name ='scott'
9) SET DEFINE is not a sql command
10) You cannot update a view with group functions
11) A single row subquery
12) Valid statements
a)min(start_date)
b)count(start_date)
13) logic functions---- and ,or,not
14) subquery ignores NULL value by default
15) SUM (used to calculate total of all salaries)
16) which one executes first ----- 100*19
17) column length --- 255 characters
18) shows error
19) COMPOSITE KEY (more than one attribute)
20) ALTER TABLE customers ADD CONSTRAINT cust_name_nn NOT NULL
21) create table package as (pack_id number(2))
22) where salary > 5000
23) null value by default
24) create, alter
25) where, groupby, having
26) third number default sysdate
27) delete
28) VIEWS provide table security by restricting access to ……….
29) UPDATE , DELETE
30) E-R model
31) Referential integrity
32) OR
33) on delete cascade
34) 3 or 5
35) equi join … d1.dept_no=e1.dept.no (the qn like this)
36) "Annual Salary"
37) reserved words cannot be used
38) AND – not a set operator
39) outer join – matching all records…..
****************************************************************************************************
1.serv 3,4---------------------dekstop ceo
2.false--------------------------System Transistion
3.serv 1------------------------------least resolution
4.offshore------------------chennai,us
5.white box-------------------internal logic
6.u,i,s------------------order of testing
7.all---------------------------outsuorced
8.black box------------------ other testing
9.manual-------------------------man
10.desktop mangmt---------------------not in AO
11.false---------------------------no testing serv 1 ticket
12.regression------------------ car mechanic
13.assemble----------- component function properly
14.fase-----------------service termination not a part of..
15.true------------------------PM is SM
16.scopecheck--------------------------verification
17.false---------------------------------------speed of market
18.AO----------------------------------defined deliverables
19.need not b created----------------test approach
20.ASS&prod test -----------------------------------difficult to differentiate
21.SM---------------------------------------------customer &unit
22.serv 1-------------------least
23.all------------------------------release
24.TL---------------------------program delay
25.analyse app.reqmt---------------------------a.reqmt are refined as same assys test plan is prepared
26.perform select plan dele--------------------------not true peer review
27.SM----------------------------client & strategic
28.performance mangt--------------------------SQA
29.serv 3or 4 ---------------------------junior staff
30.all----------------------------const factor AO
31.true------------------AO life diligence
32.SI--------------------run/maintan
33.helpdesk------------incidence ticket
34.serv 1-----------------ATM stopped
35.AO-----------------------------ongoing operation
36.ins,simul protype-------------------------not true abt validation
37.false---------------------------------------- AO cant AD
38.true----------------tru testing defects removal
39.ORT-----------overall productn config
40.CEO-----------------------when serv 1 ticket
****************************************************************************************8
Programming Techniques
{
int x=3;
if(x==2);
x=0;
if(x==3)
x++;
else
x+=2;
printf(x)
}
ans
2
int x=5,y= -10,b=2,a-=4,z;
z=x++ - --y*b/a;
printf(z);
ans
10
int x=3,counter=0;
while((x=1))
{
++counter;
x - -;
}
printf(counter);
ans
counter=2
some variable name best pracites
reg bottom up approach some check boxes
switch --- default needs break or not
short and long byes---- 2 and 4 bytes
some ques reg hungarian,camel casing
valid approach
*structured apprach
*top-down
*bottom-up
*conventional approach
***************************************************************************************
1)
# include<stdio.h>
void main()
{
int z,x=5,y=-10,a=4,b=2;
z=x++ - --y * b/a;
printf("%d",y);
}
Ans : 10
2)
# include<stdio.h>
void main()
{
int i=4, x=6;
double z;
z = x/i;
printf("%0.2f",z);
}
Ans : 1.00
3)
# include<stdio.h>
void main()
{
int x=3;
if(x==2)
x=0;
if(x==3)
x++;
else
x+=2;
printf("%d",x);
}
Ans : 4
4)
# include<stdio.h>
void main()
{
int a = 10,b;
b = a++ + ++a;
printf("%d %d %d %d",b,a++,a,++a);
}
Ans : 22 13 13 13
5)
# include<stdio.h>
void main()
{
int x = 0;
for ( ; ;)
{
if(x++ == 4)
break;
continue:
}
printf("x = %d",x);
}
Ans : x = 5
6)
# include<stdio.h>
void main()
{
int a = 10,b=5,x,y;
x = a>9;
y = a>3 & & b !=3;
printf("x = %d, y = %d",x,y);
}
Ans : Undefined symbol &(Error)
7)
# include<stdio.h>
void main()
{
float a = 2.3;
int b = 3;
a = b / 2 + b * 8 / b - b + a /3;
printf("%f"a);
}
Ans : 6.76
8)
# include<stdio.h>
long factorial(long l);
void main()
{
long l = factorial(4);
}
long factorial(long x)
{
?????
return x*factorial(x-1);
}
Ans : if(x<=1) return 1;
9)
# include<stdio.h>
void main()
{
int m=10,n=15,x;
x = ++m + n++;
printf("%d%d%d",x,m,n);
}
Ans: 26 11 16
10)
#include<stdio.h>
void main()
{
int i=0,j=0,table[3][3];
for(i;i<3;i++)
{
for(j;j<3;j++)
{
if(j==i)
table[i][j]=1;
else
table[i][j]=0;
}
}
}
The value of the table will be:
Ans : 1 0 0 0 1 0 0 0 1
**********************************************************************************
PT(answers only)
void main()
{
int z,x=5,y=10;
a=4,b=2;
z=x++- --y*b/a;
printf("%d",y);
}
ans=10
void main()
{
int i=4,x=6;
double z;
z=x/i;
printf("%0.2f",z);
}
ans=1.00
void amin()
{
int x=3;
if(x==2);
x=0;
if(x==3)
x++;
else
x+=2;
}
printf("%d",x);
ans:2
void main()
{
int a=10,6;
b-a++ + ++a;
printf("%d%d%d%d",b,a++,a,++a);
}
ans 22,13,13,13
void main()
{
int x=0;
for(;;)
{
if(x++==4)
break;
continue;
}
printf("x=%d",x);
}
ans x=5
void mani()
{
float a=2.3;int b=3;
a=b/2+b*8/b-b+a/3;
printf("%f",a);
}
ans: 6.76
void mani()
{
int a=10,b=5,x,y;
x=a>9;
y=a>3 &&b!=3;
printf("x=%d,y=%d",x,y);
}
undefined symbol &(error)
long factorial(long l)
void main()
{
long l=factorial(4);
}
long factorial(ong x)
{
????
return x*factorial(x-1);
}
ans if(x<=1)return 1;
void main()
{
int m=10,n=15,x;
x=++m + n++;
printf("%d%d%d",x,m,n);
}
ans 26,11,16
void main()
{
int i=10,j=0,table[3][3];
for(i;i<3;i++)
{
for(j;j<3;j++)
{
if(j==i)
table[i][j]=1;
else
table[i][j]=0;
}}}
ans 100
010
001
********************************************************************************
wat r d steps of software develomt?
Requirement,analysis,design,testing,deploy
where we use the decision flow tech approach?
structured programming
there is no need of braces in an if condn ven there r two or more stmts
which keyword is used to release the memory allocation malloc free();
what can we use instead of "int height of "
camel_underscore
"I was got my salary 50%96!" it is printed out by using which printf stmt
max-num 5------> ans preprocessor macro
in a c prgm Static could be usd once is a life of tat prgm ans true
wat is the mini stroage bytes for sign/long 2,4
the break stmt is necessary for default int switch case-----------> true
int a[8]={1,2,3,4}
wat is the outpt
ans depends upon the complier
which stmt is usd to get string from keyboard
ans gets()
14%-3 +2
-14%-3 -2
-14%3 -2
main()
{
char &str="hello";
char *pt=str;
char least=127;
....
}
ans 0
cahr *some fun()
{
cahr tem[]={'s','t','f'...}
...
}
ans garbage value
void main()
{
cahr a[]="12345\0";
....
}
ans here in 3 or 6
f0r(i=1;i<10;1++)
{
for(j=1;j<=10;j++)
{
..
..
}
ans 100 010 001
size of double ans 8bytes
int sum =0;
for(i=1i<=10;i++);
{
sum=sum+i;
}
retur sum;
}
ans i<=9 10
i<9 9
question related to count. ans 2
only one ternary operator ans true
print prime numbers betwn 2 to 10
(13/4 *3)%5+1
ans 5
c=getchar or c=getc(stdin)
z=1.00
static variable--->true
x=26,m=11,n=16
check order info()--> shud start wit caps
binary search
camel notation
fg
A&C
20bytes
uninitialised
realloc(ptr,10)
00131
algorithm
if any variable is used inside a for loop can v refer it outside d loop ans true
structured progrmmg
except conventional program alll ther options for design approach
one valid stmt
other elements in the array would br ans==0
one stmt is valid
write soub(d)
28
A followed by b,c
it will loop indefinitely
calloc
1--1 1--2
45
do while exectues once
001234
5
binary
testing
0 comments:
Post a Comment