5.3 Summarize Methods used to interface with database's

Question 1

What is NOT true regarding SQL permissions?

Answer 1

The owner of a table can assign only the permission to view (not update) data in the table to other users.

Question 2

What is the purpose of the SQL INSERT command?

Answer 2

It adds a new row to a table in a database.

Question 3

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

Answer 3

One-tier
When the application, which includes reports, forms, queries, etc., is hosted on the same computer as the actual database, it’s called a standalone or one-tier database application architecture.

Question 4

What is NOT true regarding the SQL INSERT statement?

Answer 4

It is a data definition language statement. Data definition statements are SQL statements, such as CREATE DATABASE and CREATE TABLE, that define the structure of a database. The INSERT command adds rows of data into a table, not new objects into a database.

Question 5

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

Answer 5

SQL
When accessing a database via a programming language, database interaction is handled with SQL commands. SQL is the relational database access language. As such, many programming languages even include libraries that provide default code for database connection and queries.

Question 6

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

Answer 6

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

Question 7

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

Answer 7

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.

Question 8

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

Answer 8

Power users and programmers

Question 9

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?

Answer 9

The owner of the “Customer” table

Question 10

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

Answer 10

CREATE

Question 11

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

Answer 11

Foreign key
A relationship between two tables requires a common column between the two tables. A foreign key is added to a table for the purpose of being that common column that matches back to a primary key in another table.

Question 12

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

Answer 12

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

Question 13

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

Answer 13

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

Question 14

What is the SQL UPDATE command used for?

Answer 14

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

Question 15

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

Answer 15

Log into phpMyAdmin and run SQL statements at the command prompt.
Using an administrative tool to connect and sign directly into the RDBMS provides the greatest level of control over the database. It allows the SQL commands to interact directly with the database, without the use of any other form or application.

Question 16

What is NOT true regarding the SQL INSERT statement?

Answer 16

It is a data definition language statement.

Question 17

What is a true statement about Data Definition Language (DDL)?

Answer 17

It comprises SQL commands that can add to or modify the structure of a database.
Data Definition Language (DDL) includes commands that can manipulate the structure of a database, rather than the data inside the database. Examples include ALTER, CREATE, and DROP. Adding and deleting tables, changing column names and sizes, as well as adding indexing and permissions, are all functions of DDL.

Question 18

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?

Answer 18

In the SELECT statement, the column name is prefixed by the table name.
Adding the table name as a prefix (Customer.lastName) tells SQL to extract the lastName from a “Customer” table, even if the same field name appears in another table.

Question 19

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

Answer 19

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

Question 20

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

Answer 20

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