Find the odd one out
from the following
A)AVERAGE
B)COUNT
C)GROUP_CONCAT()
D)SUM
What is the print
statement of plsql?
A)rdbms_output.put_line();
b)dbms_output.put_line();
C)dbms_output.put_line();
D)none of the above
which of the following commands used for renaming a file1 to file2 in a Unix system?
pickone option
a)my file1, file2
b)my file2, file1
C)cp file1, file2(rm file1)
D)cp file2, file1 (rm file1)
Which of the
following command is used for changing the case of first two lines of the
life"studentData" from lower to upper?
Pick one option
a)tr'[a-z]''[A-Z]'studentData|head-2
B)tr studentData head-2'[a-z]''[A-Z]'
c)tr head-2 studentData'[A-Z]''[a-z]'
d)head-2 studentData| tr'[a-z]''[A-Z]
DECLARE
v_delete NUMBER(2);
BEGIN
DELETE FROM
department WHERE dept_id IN (21,25,30);
v_delete :=
SQL%ROWCOUNT;
COMMIT;
END;
what will be the
value of v_delete if no rows are deleted?
A)false
B)true
c)null
ans: false
Paul is working with a cllient who is casual
while communicating with him through chat application.
the client sends him memes and other to build
better workplace relatioships
Select the best
option
A)paul can be task oriented and polite. He can avoid
reciprocating by sharing memes and forward through chat application
B)since the client is informal while communicating, paul
ccan also do the same
c)paul can tell the
client that what is doneso far is not right and that its not professsional to
do so
D) paul should take up this matter with the HR
Identify the command that will print the count of powerbanks which belongsto Mi brand
A)awk-F","{names[$2]++}END {print
names["Mi"]}'
B)awk-F","{if($2=="Mi"}count[$2]++}END
{print count}'
c)awk'BEGIN{FS=",";IGNORECASE=1}-{if($2=="mi")count++}END{print
count}'
D)awk'BEGIN{FS+","}{if$2=="Mi")count[$2]++} END{print $2}'
Consider a file team.txt
has the following contents
Bucks Milwaukee 60 22
0.732
Raptors Toronto 58 24
0.707
76ers Philadelphia 51
31 0.622
Celtics Boston 49 33
0.598
pacers Indiana 58 34
0.585
what will be the
output for the following
awk'/0.6/ { print $1
}' teams.txt
A)Ce|tics Pacers
B)Philadelphia
C)76ers
D)Bucks Raptors
0 Comments