Q&A Hero

Design

Q: An ad-hoc query is ________. A) a question about the data that requires a program to be written B) a question that can be answered from the database using SQL C) a question that can be answered only by combining several SQL queries D) never useful in Business Intelligence scenarios
Q: A database extracted from the operational database for BI purposes typically ________. A) is an exact copy of the operational database B) contains only the metadata from the operational database C) combines all the data from the operational database into one large table D) contains just part of the operational database
Q: The INTERSECT of two relations A and B consists of all rows that are in relation B but are not in relation A.
Q: The UNION of two relations A and B consists of all rows that are either in relation A or in relation B or both.
Q: Outer joins can be either up joins or down joins.
Q: Joins that show the matching rows from the joined tables plus unmatched rows from one other table in their results are called outer joins.
Q: Joins that show only matching rows from the joined tables in their results are called inner joins.
Q: The SQL syntax JOIN . . . ON can be used as an alternate way of writing an SQL join statement.
Q: While many subqueries can be alternatively written as joins, correlated subqueries do work that cannot be duplicated as a join.
Q: Every subquery can be alternatively expressed by a join.
Q: In an SQL query, a join operation is achieved by specifying the equality of the respective column names as a condition in the WHERE clause.
Q: The names of tables to be joined in an SQL query are listed in the FROM clause.
Q: Two or more tables are joined by giving the table names in the WHERE clause and specifying the equality of the respective column names as a condition in the GROUP BY clause.
Q: When people use the term join they normally mean an equijoin.
Q: An alternative to combining tables by a subquery is to use a join.
Q: Only two tables can be queried by using a subquery.
Q: A nested SELECT statement (one that appears within the WHERE clause of another SQL statement) is called a subquery and must be enclosed in parentheses.
Q: A SELECT statement used in a WHERE clause is called a subquery.
Q: A WHERE clause can contain another SELECT statement enclosed in parentheses.
Q: The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column.
Q: Arithmetic in SQL statements is limited to the operations provided by the built-in functions.
Q: The clause SELECT COUNT (*) results in a table with a single row and a single column.
Q: The built-in function SUM can be used with any column.
Q: The SQL built-in function COUNT computes the number of rows in a query.
Q: The SQL built-in function MIN obtains the smallest value in a numeric column.
Q: The SQL built-in function MOST obtains the largest value in a numeric column.
Q: The SQL built-in function AVG computes the average of values in numeric columns.
Q: The SQL built-in function ADDUP totals values in numeric columns.
Q: The Microsoft Access wildcard character "_" (underscore) indicates a single, unspecified character in a specific location in a Microsoft Access SQL query.
Q: The Microsoft Access wildcard character "*" (asterisk) indicates a sequence of one or more unspecified characters in a Microsoft Access SQL query.
Q: The SQL wildcard character "#" indicates a single, unspecified character in a specific location in an SQL query.
Q: The SQL wildcard character "%" represents a series of one or more unspecified characters.
Q: The SQL keyword LIKE is used in SQL expressions to select partial string values.
Q: The condition in WHERE clauses can refer to a set of values by using the IN operator.
Q: To refer to a set of values in a condition, the values are placed inside parentheses ( ) and separated by commas.
Q: To exclude one or more values using a condition, the SQL OUT keyword must be used.
Q: To refer to a set of values needed for a condition, use the SQL IN operator.
Q: When two conditions must both be true for the rows to be selected, the conditions are separated by the SQL AND keyword.
Q: A WHERE clause can contain only one condition.
Q: Columns can be sorted in descending sequence by using the SQL DESC keyword.
Q: To sort the rows of the result table, the ORDER BY clause is specified.
Q: Sorting is specified by the use of the SORT BY phrase.
Q: The rows of the result table can be sorted by the values in one or more columns.
Q: The WHERE clause contains the condition that specifies which columns are to be selected.
Q: An asterisk (*) following the SELECT verb means that all columns are to be displayed.
Q: To have SQL automatically eliminate duplicate rows from a result, use the keyword DISTINCT with the FROM keyword.
Q: The result of an SQL SELECT operation can contain duplicate rows.
Q: The SQL WHERE clause contains the condition that specifies which rows are to be selected.
Q: To obtain all columns, use an asterisk (*) wildcard character instead of listing all the column names.
Q: To remove duplicate rows from the result of a query, specify the SQL DISTINCT keyword.
Q: The columns to be obtained by an SQL command are listed after the FROM keyword.
Q: SQL statements end with a colon.
Q: SQL can only query a single table.
Q: The SQL keyword FROM is used to specify the table to be used.
Q: The SQL keyword WHERE is used to specify the table(s) that contain(s) the data to be retrieved.
Q: The SQL keyword SELECT is used to specify the columns to be listed in the query results.
Q: SQL, although very popular, has never become a national standard.
Q: SQL commands can be embedded in application programs.
Q: In addition to being a data sublanguage, SQL is also a programming language, like Java or C#.
Q: SQL is not a complete programming language. Rather it is a data sublanguage.
Q: SQL was developed by IBM in the late 1970s.
Q: The American National Standards Institute (ANSI) maintains the standards for SQL.
Q: SQL is only a data manipulation language (DML).
Q: SQL includes a data definition language, a data manipulation language, and SQL/Persistent stored modules.
Q: SQL stands for Standard Query Language.
Q: An ad-hoc SQL query is typically written within an application program.
Q: Business Intelligence (BI) systems typically store their data in data warehouses.
Q: Databases record data in such a way that they can produce information.
Q: Data is recorded facts and figures; information is knowledge derived from data.
Q: A database shows data in tables and the relationships among the rows in those tables.
Q: In every database, not just the databases discussed in this book, table names are capitalized.
Q: Like a database table, a spreadsheet has rows and columns.
Q: In a database, each table stores data about a different type of thing.
Q: The purpose of a database is to help people keep track of things.
Q: Briefly describe the history of database processing.
Q: What are the three types of database design situations?
Q: What are referential integrity constraints? Give an example.
Q: Briefly describe the function of the DBMS in a database system.
Q: What is metadata and how does it relate to the definition of a database?
Q: Why do we say a database is self-describing and why is this an advantage?
1 2 3 … 68

Subjects

Accounting Anthropology Archaeology Art History Banking Biology & Life Science Business Business Communication Business Development Business Ethics Business Law Chemistry Communication Computer Science Counseling Criminal Law Curriculum & Instruction Design Earth Science Economic Education Engineering Finance History & Theory Humanities Human Resource International Business Investments & Securities Journalism Law Management Marketing Medicine Medicine & Health Science Nursing Philosophy Physic Psychology Real Estate Science Social Science Sociology Special Education Speech Visual Arts