In an SQL query, which SQL keyword is used to link two conditions that both must be true for the rows to be selected?

When using the traditional set operators in a SELECT statement, tables must be union compatible and each corresponding column must have the same _____.

In an SQL query, which SQL keyword is used to state the condition that specifies which rows are to be selected?

Given a table with the structure: EMPLOYEE (EmpNo, Name, Salary, HireDate), which of the following is not a valid SQL command?

When one SQL query is embedded in another SQL query, this is referred to as a ________.

Based on the tables below, which of the following commands would return only the name of the sales representative and the name of the customer for each customer that has a balance greater than 400?GENERAL SALES DATABASE:SALESREP SalesRepNo RepName HireDate 654 Jones 01/02/2005 734 Smith 02/03/2007 345 Chen 01/25/2018 434 Johnson 11/23/2004 CUSTOMER CustNo CustName Balance SalesRepNo 9870 Winston 500 345 8590 Gonzales 350 434 7840 Harris 800 654 4870 Miles 100 345  

In an SQL query, which of the following symbols is used by ANSI-92 SQL (as opposed to the ANSI-89 used in MS Access) to represent a single unspecified character?

While a database analyst or administrator would primarily interact with a database through , in general users access to a database is mediated through .

SQL is a full, imperative programming language, like Python.

Referencing the photomicrographs on page 154 of the textbook, figure 5.27, labeled Photomicrographs showing serial sections of intestinal glands of colon Serial sections of the intestinal glands of a colon are illustrated using two different staining techniques. What is the stain used and the magnification in photo a? What is the stain used and the magnification in photo b? What structure is revealed in photo b that was not visible in photo a? Name the cell, the structure revealed and its appearance with stain b. What staining characteristic and/or reaction occurs with this stain (figure b) that is not possible with the stain used in photo a?