CIST1220-Structured Query Language, SQL Server Express 2008

New

Long-Term Learning

Learn efficiently and remember over time.

Start Long-Term Learning

Get personalized study reminders at intervals optimized for better retention.
Track your progress on this set by creating a folder
Or add to an existing folder

Add this set to a folder

  • The process of determining the particular tables and columns that will comprise a database is known as____

    database design

    In the SELECT clause, you can use the ____ symbol to indicate that you want to include all columns.

    C) *

    In SQL, you use the ____ command to query a database.

    SELECT

    The ____ table indicates the number of copies of a particular book that are currently on hand at a particular branch of Henry Books.

    INVENTORY

    When a script file contains more than one command, each command must end with a _____.

    Semicolon

    The ____data type is use to store integers.

    INT

    You indicate the end of a command by typing a____

    Semicolon.

    A field is another term for a(n)____

    Column

    The ____ operator finds rows that do not contain null values in the specified column.

    IS NOT NULL

    The ____ wildcard symbol represents any individual character.

    Underscore ( _ )

    The basic form of the SQL SELECT command is _____

    SELECT-FROM-WHERE

    Each line in the Premiere Products order form contains a part number, the number of units of the ordered part, the quoted price, and ______

    Part description.

    Any column (or collection of columns) that determines another column is called a(n) ___

    Determinant.

    The ____ function determines the number of rows in a table.

    COUNT.

    You form compound conditions by connecting two or more simple conditions using the ____ operator.

    All of the above (AND,OR,NOT).

    ___ can occur then there is a column in a table that is dependent on only a portion of the primary key.

    Update anomalies.

    Preceding a condition by the ____ operator reverses the truth of the original condition.

    NOT

    The correct data type for the BALANCE column in the CUSTOMER table is ____

    DECIMAL.

    the ____ operator is inclusive meaning that a value equal to either value would be selected.

    BETWEEN.

    The ___ clause lets you group data on a particular column.

    GROUP BY.

    A(n) ____ is a characteristic of property of an entity.

    attribute.

    When you need to sort data on two columns, the less important column is called the ____ sort key.

    minor

    A ____ file is a text file with a .sql extension that contains SQL commands.

    script.

    A relation is in ____ if it does not contain any repeating groups.

    second normal form

    The ____ operator uses one or more wildcard characters to test for a pattern match.

    LIKE.

    A(n) ___ is the association between entities.

    relationship.

    Which of the following is the primary key of the ORDER_LINE (ORDER_NUM, PART_NUM, NUM_ORDERED, QUOTED_PRICE) table?

    ORDER_NUM ANDPART_NUM.

    Which of the following command changes the value in a column?

    UPDATE.

    In SQL for Orable and SQL Server, the ___ symbol is used as a wildcard to represent any collection of characters.

    %

    The ____ data type stores only the actual character string.

    VARCHAR.

    In relational database each ____ should be unique.

    All of the above. (row,record,tuple)

    Each book at Henry Books is uniquely identified with a(n) ____

    CODE.

    The REP table consists of the sales representatives number, last name, first name, address, total commission, and ___

    Commission rate.

    You can use the ____ operator followed by a collection a values to provide a concise way of phrasing certain conditions.

    IN

    The ___ command defines a table's structure by listing its columns, data types, and column lengths.

    CREATE TABLE.

    when you use the ____ function you can use the asterisk (*) to represent any column

    COUNT.

    Which of the following operators can be used for a column computation?

    Plus ( + )

    You use the ___ clause to list data in a specific order.

    ORDER BY.

    The___ clause is used to restrict the groups that will be included.

    HAVING.

    Which of the following is a valid name for a table?

    TBL_1

    The ___ field of the WROTE table of Henry Books indicates the order in which the authors of a particular are listed on the cover.

    SEQUENCE.

    Use the ____ date type for columns that contain letters and special characters and for columns that will not be use in calculations.

    CHAR.

    ____ is one of the categories of update anomalies.

    Inconsistent data.

    Each publisher has a ___ that uniquely identifies the publisher at Henry Books.

    code.

    The ____ function calculates a total of the values in a column.

    SUM.

    For any column whose data type is CHAR, values must be enclosed in _____

    single quotation marks.

    Which of the following tables relates books to authors?

    WROTE.

    To delete an entire table, use the ____ command and then re-create the table.

    DROP TABLE.

    To display all the rows and columns in a table, type the word SELECT, followed by (n)____, followed by the word FROM and then the name of the table containing the data you want to view.

    ASTERISK.

    The ____ operator specifies a range of values in a condition.

    BETWEEN.

    Please allow access to your computer’s microphone to use Voice Recording.

    Having trouble? Click here for help.

    We can’t access your microphone!

    Click the icon above to update your browser permissions above and try again

    Example:

    Reload the page to try again!

    Reload

    Press Cmd-0 to reset your zoom

    Press Ctrl-0 to reset your zoom

    It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

    Please upgrade Flash or install Chrome
    to use Voice Recording.

    For more help, see our troubleshooting page.

    Your microphone is muted

    For help fixing this issue, see this FAQ.

    Star this term

    You can study starred terms together

    NEW! Voice Recording

    This is a Plus feature