SQL test 2

star goldstar goldstar goldstar goldstar greyFemaleMale
35 Questions - Developed by: Fahad Yusuf - Developed on: - 16.188 taken

  • 1
    SQL is a data sublanguage, not a complete programming language
  • 2
    When using SQL to create a table, a column is defined by declaring, in this order: data type, column name, and optional constraints.
  • 3
    When using SQL to create a table, specifying the NULL property for a column indicates that only null values may be stored in that column.
  • 4
    When using SQL to create a table, specifying a data type of Char(10) indicates a fixed length field of 10 characters.
  • 5
    For a column to be defined as the primary key using table constraints, the column must have been given the property NULL.
  • 6
    If you need to create a primary key that is a composite key using SQL, the key may be defined when the table is created using the CREATE TABLE statement.
  • 7
    Referential integrity constraints can be created using the ON DELETE phrase when the table is created using the CREATE TABLE statement.
  • 8
    Referential integrity constraints using the ON DELETE NO ACTION phrase may be explicitly stated when the table is created using the CREATE TABLE statement.
  • 9
    Data is added to a table using the SQL INSERT command.
  • 10
    The result for SELECT statements in SQL is a relation unless the result is a single number.
  • 11
    To force the DBMS to remove duplicate rows from the results of an SQL SELECT query, the keyword DISTINCT must be used.
  • 12
    In SQL, the WHERE clause is used to specify which columns will be included in the result.
  • 13
    In SQL, multiple conditions in the WHERE clause can be combined by using the SQL AND keyword.
  • 14
    In SQL, to refer to a range in a WHERE clause, use the WITHIN keyword.
  • 15
    In SQL, the NOT keyword can be combined with the IN keyword to form the NOT IN condition for selecting values.
  • 16
    In SQL, the LIKE keyword can be used to select on partial values.
  • 17
    In SQL, the LIKE keyword can be combined with the NOT keyword to form the NOT LIKE condition for selecting values.
  • 18
    In SQL, the IS NULL keyword can be used to select on records containing NULL values in a particular column.
  • 19
    In SQL, the order of the rows that result from a SELECT statement can be set using the SORT BY phrase.
  • 20
    The SUM built-in function in SQL is used to total the values in a numeric column.
  • 21
    The TOP built-in function in SQL is used to find the maximum value in a numeric column
  • 22
    Standard SQL does not allow built-in functions to be used in a WHERE clause.
  • 23
    The SQL GROUP BY keyword can be used to group rows by common values.
  • 24
    Built-in SQL functions cannot be applied to data combined using the GROUP BY keyword.
  • 25
    Data from a maximum of three tables can be combined through the use of subqueries in SQL.
  • 26
    A subquery is appropriate only if the final result contains only data from a single table.
  • 27
    The basic idea of a join is to combine the contents of two or more relations into a new relation.
  • 28
    Using standard SQL, unmatched rows will not appear in the result of a join.
  • 29
    Values of existing data can be changed using SQL through the CHANGE command.
  • 30
    The ON DELETE CASCADE referential integrity constraint does not apply when rows are deleted using the SQL DELETE command.
  • 31
    Microsoft Access SQL commands are run within the SQL View of a Query window.
  • 32
    Microsoft Access can run QBE queries, but not SQL queries.
  • 33
    To open a new Microsoft Access Query window, click the Query Design button on the Create command tab.
  • 34
    Microsoft Access SQL supports and will correctly implement the numeric data type with (m, n) notation.
  • 35
    In Microsoft Access, default values must be set as a field property while the table is in Design View.

Comments (0)

autorenew