Databases Reference
In-Depth Information
2.
You need to design SELECT statements to retrieve data from database
tables in a Microsoft SQL Server database. When would you use an
asterisk in the SELECT clause? When is the FROM clause required?
When is the WHERE clause required? When are neither FROM nor
WHERE needed with the SELECT statement?
3.
You are designing a database application that will be used to enter,
retrieve, and update data in the database. You want to minimize the
user's understanding of table structure, including column names and data
types. In addition, many operations require calculations based on dates
stored in database tables and the number of months or days between
selected dates. Should you rely on interactive or embedded SQL? Why?
When performing calculations, how can you ensure that operators are
processed in the order you want? In this specific example, why should
you choose a DBMS that extends the basic SQL language standard as
your database platform?
