1)Robots can be used for building houses
Pick one
True
False
2)Advantages of public cloud services
A)scalabity
B)hardware on premise
C)inexpensive and easy to setup
D)no resources are wasted
E)option 1 3 4
3)SELECT *
FROM employee
where name LIKE '%S%';
what will the above command do ?
pick one option
A)Return records containing S in the same
B)Return records having name starting with s
C)returns records having name ending with s
D)none of the option
4)What will following query return?
SELECT*FROM Employee
WHERE MOD (Empid,2)<>0;
pick one option
A)Return all records with empid as even
B)Return all records with empid as odd
C)Return all even row records
D)Return all odd row records
5)SELECT *
FROM employee
WHERE name LIKE '%$%';
what will the above command do ?
pick one option
A)Returns records containing S in the name
B)Returns records having name starting with s
C)Return records having name ending with s
D)none of the options
6)Choose the correct option for the following code
awk'{print $ 1}' myfile
pick one option
A)it prints the first row details from myfile
B)it prints the first column details from myfile
C)it prints the whole contents from myfile
D)it prints contents other than first row from myfile
7)what will be returned by the attribute SQL%NOTFOUND?
PICK ONE OPTION
a)Returns the number of rows processed due to a DML statement
b)Returns TRUE if no rows were processed due to a DML statement
C)Returns FALSE if no rows were processed due to a DML statement
D)Returns TRUE if some rows were processed due to a DML statement
8)find the odd one out from the following
A)AVERAGE
B)COUNT
C)GROUP_CONCAT()
D)SUM
9)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
10) 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)
11)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]'
12)
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
13) 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
14)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}'
15)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