Which of the following is true about query design?

A. the LIKE operator enhances performance
B. it's best to use relative names when referring to database objects
C. sorting should be done by the SQL server, not the client application
D. subqueries can degrade performance


Answer: D

Computer Science & Information Technology

You might also like to view...

Tap or click the 'Default Sensitivity level' arrow to display a list of ____________________.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

Analysis and Design Questions

What will be an ideal response?

Computer Science & Information Technology

A feature in Word with which you can see suggestions from LinkedIn to help you update your resume.

What will be an ideal response?

Computer Science & Information Technology

Many object-oriented programming languages have built-in ____________________ that contain ready-to-use, predefined classes for common tasks, such as creating a form.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology