Tag: technology

UNION only selects distinct values, UNION ALL selects all values (excluding ?duplicates)?

UNION ALL only selects distinct values, UNION selects all values (including ?duplicates)?

UNION only selects distinct values, UNION ALL selects all values (including ?duplicates)?

UNION ALL only selects distinct values, UNION selects all values (excluding ?duplicates)?

10

1

5

50

WHERE

HAVING

HAVING BY

ORDER BY

Delete

Truncate

Insert

Update

Increase the performance during SELECT operation

Degrade the performance during INSERT operation?

Degrade the performance during the UPDATE or DELETE operation

All of the above

Natural Key

Domain Key

Candidate Key

All of the Above

Open the Visual Basic Upgrade Wizard, get a cup of coffee and watch it run.

Assess the VB 6 application; find out what controls it uses, what projects are in there and so on.

Cancel all social plans for the next couple months and start rewriting the app in .NET.

Schedule meetings with end users to see what features they want to add to the app.

DHTML pages

ActiveX documents

OLE controls

ADO to ADO via Interop

True

False

Yes, in all cases.

Yes, in some cases.

No, not at all.

Don't Know