TCS IRA MOST IMPORTANT MCQS MUST LEARN

 

Which query returns all the employees who earn the minimum salary from the Employees Table?

 a. Select * from employees where sal=min (sal);

 b. Select * from employees where sal = (select sal fromemployees);

c. Select * from employees where sal = (select min (sal) fromemployees);

d. Select * from employees where sal = (select min (sal) from employees group by empno);

 

What will be the output of below command?

sort file1|uniq –u

 a. Command has syntax error.

 b. Finds the unique lines in the file and sort it.

 c. Sort the file named file1 and displays the duplicate lines in the file

d. Sort the file named file1 and displays the distinct lines in the file

Which of the following is not an inline element in html?

 

a. <a>

b. <br>
c. <img>

d. <hr>

 

An array can be declared in Javascript as;

 

a. var rating = ["Avg", "Medium", "High"];

b. var rating = {"Avg", "Medium", "High"};

c. var rating = <"Avg", "Medium", "High">;

d. None of options

What is the output of below python code?

 s='tcstcstcs qcityqcity'

 print(s[3:6])

 a. TCS TCS

b. CS

c. tcs

What is the output of the below query?

INSERT IGNORE INTO employee (employee_id,last_name, first_name,age) VALUES( 1234,'Ryan', 'Thomas',34);

a. The query is syntactically wrong

b. Query will insert the record in to employee table

c. Query will ignore if the record/tuple is already present in the table else it will insert the record .

d. None of the options

What is the syntax to combine the content of two files (file1, file2 ) into another

 file (newfilename)?

 

a. cat file1 file2 > newfilename

b. cat file1 file2 >> newfilename

c. cat file1 file2 < newfilename

d. cat file1 file2 << newfilename

 

What is the output of below code?

TCS = {‘1’ : 1, '2' : 2 }

theCopy = TCS

TCS['1'] = 5

sum = TCS['1'] + theCopy['1']

print(sum)

a. 9

b. 8

c. 7

d. 10

Robots can be used for building houses

pick one

true

false

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

 

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

 

 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

 

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 option

 

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

 

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