Rows in a Query

If you had two tables, each with 3 items: Table_Mike: ITEM: Bread Milk Eggs Table_Kristy: ITEM: Cereal Butter Eggs And performed a UNION, how many rows would the resulting query have?

Question 2

If you have TABLE A with these columns (I put the data type in parenthesis, they are not actually part of the table name): LAST_NAME(TEXT), FIRST_NAME(TEXT), MIDDLE_NAME(TEXT), DATE_OF_BIRTH(DATE), and TABLE B with these columns: LAST_NAME(TEXT), FIRST_NAME(TEXT), MIDDLE_NAME(TEXT), DATE_O ...continues

Data over Network

Should you allow data to be sent over the network unencrypted if it's stored in your database in encrypted form? Why? Please explain Why or why not?

Query Question - View

What is a view? What does it have to do with querying? Why would you use a view?

Encrypted Database - Index

Why is it (more or less) impossible to make use of an index if you want to have an encrypted database?

Databases - Index Tables

If you were to index the tables 1000_ROWS and 2000_ROWS and then run query1, would the table 20CHAR_TABLE be created faster than if the tables were not indexed (try it out)? Why?

SQL query for Access

Using the week 2 attachment database attached here with this posting, I need to come up with the proper SQL to answer these six questions which are within the word document: I suppose each of the visuals is the actual answer and I need the SQL for each?

Microsoft Excel Functions

For the data attached is it possible to make excel highlight (Yellow) rows of results that are over 500. I would like this to happen every time I enter a value > 500. I would also like a count at the top of the spreadsheet to display the number of times this happens for a Pre-op and an Operational.

Questions 1-7 answers provided need SQL's for each.

With the file attached please answer in SQL form the following. Thanks... 1. Which employees (by name) have degrees? (the "answer" is Smith, Johnson and Williams) SELECT at least the employee first and last names - SELECT other columns you think would be meaningful. HINT: do a JOIN between the employees and degrees t ...continues

Create a query that would convert the order year into a decade and count the orders

Using the database attached to Lecture 2, let's say you are interested (let's say as the business owner) to see how old the books are that people order (going by their publication date). First, you'd need to create a query that would convert the order year into a decade and count the orders: SELECT books.title, CInt ...continues