Tag: technology

Questions Related to technology

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

technology databases

  1. DELETE

  2. COLLAPSE

  3. REMOVE

  4. ERASE

Show answer
Correct Option: A

With SQL, how do you select a column named "FirstName" from a table named "Persons"?
technology databases

  1. EXTRACT FirstName FROM Persons

  2. SELECT FirstName FROM Persons

  3. SELECT Persons.FirstName

  4. SELECT * FROM Persons

Show answer
Correct Option: B

With SQL, how do you select all the records from a table named "Persons" where the "FirstName" is "Peter" and the "LastName" is "Jackson"?

technology databases

  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'

Show answer
Correct Option: A

With SQL, how do you select all the records from a table named "Persons" where the "LastName" is alphabetically between (and including) "Hansen" and "Pettersen"?
technology databases

  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

Show answer
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

What is the official Linux mascot?
technology operating systems

  1. rabbit

  2. penguin

  3. canary bird

  4. turtle

Show answer
Correct Option: B

Who is the main Linux supplier?

technology operating systems

  1. Mandriva

  2. Red Hat

  3. Blue Cap

  4. SUSE

Show answer
Correct Option: B

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

  1. OpenOffice

  2. TypeAway

  3. Lotus smart Note

  4. One note

Show answer
Correct Option: A

Who created Linux in the first place?

technology operating systems

  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)

Show answer
Correct Option: D

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

  1. True

  2. False

Show answer
Correct Option: B

Your application contains objects that behave like standard objects but are not recognized by QuickTest. How you will handle them?
technology testing

  1. Use descriptive programming.

  2. Use QTP record option.

  3. Use virtual objects

  4. None of above

Show answer
Correct Option: C