5.3

Why is the process of generating backups such an important feature of an RDBMS?

A database can contain mission-critical data, which an organization may not be able to afford to lose.

Why might a database dump be a good option for backup/restore?

A database dump includes both the database data and the structure, so it could be restored whether the offending error was in the data or in the structure.

You've been tasked with changing the primary key in the Customer table from the CustID field to the AcctNum field. Which Data Definition Language (DDL) command can do that?

ALTER TABLE

What would the query select * from Customers where state = 'MN' return as an answer from a "Customer" table?

All of the fields from the answer table, but only for those rows where the state code is MN

You submitted the following SQL command for a "Customer" table: DELETE FROM CUSTOMER. What happened next?

All of the records from the "Customer" table were deleted.

In a database application, what is the difference between a form and a report?

Both display data, but a form can be used to update the contents of the database as well.

Adding a new relational database, table, or index is a function of which Data Definition Language (DDL) command?

CREATE

What is the difference between the DELETE and DROP commands in SQL?

DELETE deletes rows from a table, whereas DROP eliminates the entire table.

What is the term used for the file that includes a copy of the database along with the schema?

Database dump

Which type of constraint is added to a table for the purpose of establishing a relationship with another table?

Foreign key

Queries often retrieve data from multiple tables. If the same column name is used in two tables, how does SQL know which column to use?

In the SELECT statement, the column name is prefixed by the table name.

All of the records from the "Customer" table were deleted.

It comprises the group of SQL commands that can add to or modify the structure of a database.

Which is the best way to issue SQL commands to manipulate data in a relational database?

It depends on the user's level of SQL experience, overall purpose, and access permissions.

Which statement is NOT true regarding the SQL INSERT statement?

It is a data definition language statement.

What is the purpose of the SQL INSERT command?

It is used to add a new row to a table in a database.

Which of the following is the best example of a direct/manual database access method?

Log into phpMyAdmin and run SQL statements at the command prompt.

In a situation where a PC-based database and an application are both hosted on the same computer, what is the application architecture called?

One-tier

Who would typically use a query/report builder to access database data?

Power users and programmers

Using a programmatic database access method to interact with a relational database would require what type of commands?

SQL

In the event of an application failure, which application architecture model would be the most disruptive to users?

Standalone

Why is a client-server application considered a two-tier architecture?

The database runs on a database server, while the application is run on the client computer.

You've written an SQL query for an "Order" table: SELECT ProductName, Price from ProductMaster. Now your mentor asks you to add this line to your query: ORDER BY PRICE. How will that affect your query results?

The list of product names and prices will now be sorted by price.

You have been placed on a project to update the addresses of customers in a "Customer" table. Who can issue the SQL commands to give you permission to update the data in that table?

The owner of the "Customer" table

What is the SQL UPDATE command used for?

To change the value in one or more fields in a table

What is the purpose of the SQL DROP command?

To delete a table or an entire database

The use of a Graphical User Interface (GUI) to allow users to search and add records is an example of which type of database access method?

User interface/utility

Which statement is NOT true regarding SQL permissions?

Users can only be given permission to view data by the owner. Permission to update data is handled outside of SQL.