Tag: technology

Quizzes (307) Questions (36705)

Questions Related to technology

Multiple choice technology databases

Which of the following queries are correct to delete duplicate records in a table?

  1. SELECT * FROM table a WHERE ROWID < (SELECT MAX(ROWID) FROM table b WHERE a.col1 = b.col1);

  2. SELECT * FROM table a WHERE ROWID <= (SELECT MAX(ROWID) FROM table b WHERE a.col1 = b.col1);

  3. SELECT * FROM table a WHERE ROWID > (SELECT MIN(ROWID) FROM table b WHERE a.col1 = b.col1);

  4. SELECT * FROM table a WHERE ROWID >= (SELECT MIN(ROWID) FROM table b WHERE a.col1 = b.col1);
Reveal answer Fill a bubble to check yourself
A,C Correct answer
Full explanation
Multiple choice technology testing

Assume you are a test analyst working on Banking Project to upgrade an existing automated teller machine system to allow customers to obtain cash advances from supported credit cards. The requirments specification contains the following paragraph: "The system shall allow cash advaces of at least 500 dollers for all supported credit cards. The correct list of supported credit cards is American Express, Visa , Japan Credit Bank, Eurocard and Master Card." Which of the following statements are true?

  1. The paragraph is ambiguous in terms of supported cards.

  2. The paragraph indicates potential performance problems.

  3. The paragraph is unclear in terms of advance limits.

  4. The paragraph indicates potential usability problems.
Reveal answer Fill a bubble to check yourself
C Correct answer
Full explanation