Tag: technology

Questions Related to technology

Which SQL statement is used to delete data from a database?

  1. DELETE

  2. COLLAPSE

  3. REMOVE

  4. ERASE


Correct Option: A
  1. EXTRACT FirstName FROM Persons

  2. SELECT FirstName FROM Persons

  3. SELECT Persons.FirstName

  4. SELECT * FROM Persons


Correct Option: B
  1. SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'

  2. SELECT FirstName='Peter', LastName='Jackson' FROM Persons

  3. SELECT * FROM Persons WHERE FirstName<>'Peter' AND LastName<>'Jackson'

  4. SELECT * FROM Persons WHERE FirstName='Jackson' AND LastName='Peter'


Correct Option: A
  1. SELECT * FROM Persons WHERE LastName>'Hansen' AND LastName

  2. SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'

  3. SELECT LastName>'Hansen' AND LastName

  4. SELECT LastName<>'Hansen' AND LastName<>'Pettersen' FROM Persons


Correct Option: B
Explanation:

To solve this question, the user needs to know the syntax for the SELECT statement in SQL and how to use the WHERE clause to filter records based on a specific condition. The user must also understand the BETWEEN operator in SQL that is used to select values within a range.

Now, let's go through each option and explain why it is right or wrong:

A. SELECT * FROM Persons WHERE LastName>'Hansen' AND LastName'Hansen' AND LastName'Hansen' AND LastName<>'Pettersen' FROM Persons This option is incorrect. The query selects all the records except the records with the last name "Hansen" and "Pettersen" from the "Persons" table, which is not what we want. We need to select records with last name between (and including) "Hansen" and "Pettersen".

The Answer is: B

  1. rabbit

  2. penguin

  3. canary bird

  4. turtle


Correct Option: B

Who is the main Linux supplier?

  1. Mandriva

  2. Red Hat

  3. Blue Cap

  4. SUSE


Correct Option: B

For Microsoft - Word Under Linux, which one is equivalent?

  1. OpenOffice

  2. TypeAway

  3. Lotus smart Note

  4. One note


Correct Option: A

Who created Linux in the first place?

  1. Bill Gates, at Microsoft research

  2. Lawrence Ian Nash, from MIT (US)

  3. Lynette Ulrich, at the University of Bonn (Germany)

  4. Linus Torvalds, at the University of Helsinki (Finland)


Correct Option: D

Between 1998 and 2000, the number of registered Linux users grew by 300%

  1. True

  2. False


Correct Option: B
  1. Use descriptive programming.

  2. Use QTP record option.

  3. Use virtual objects

  4. None of above


Correct Option: C