SQL Tables

  1. Tables are...
    Database objects that contain all the data in a database.
  2. The number of tabls in a database is limited by...
    The number of objects allowed in a database (2,147,483,647)
  3. A standarad user defined table can have up to how many columns?
    1,024
  4. The number of rows in the able is limited only by...
    The storage capacity of the server.
  5. Give two examples of constraints you can create on a column.
    Disallow values or provide a default value if one is not specified. You can also assign a key constraint on the table that enforces uniqueness or defines a relationship between tables.
  6. The data in the table can be compressed either by....
    Row or page.
  7. Data compression allows...
    More rows to be stored on a page.
  8. What is the purpose of a Partitioned Table?
    Partitioned tables are tables whose data is horizontally divided into units which may be spread across more than one filegroup in a database. Partitioning makes large tables or indexes more manageable by letting you access or manage subsets of data quickly and efficiently, while maintaining the integrity of the overall collection.
  9. How many partitions does SQL Server 2012 support by default?
    Up to 15,000 partitions
  10. What is the purpose of a Local Temporary Table and how does it differ from a Global Temporary Table?
    Local temporary tables have a single number sign (#) as the first character of their names; they are visible only to the current connection for the user, and they are deleted when the user disconnects from the instance of SQL Server.
  11. What is the purpose of a Global Temporary Table and how does it differ from a Local Temporary Table?
    Global temporary tables have two number signs (##) as the first characters of their names; they are visible to any user after they are created, and they are deleted when all users referencing the table disconnect from the instance of SQL Server.
  12. What is the purpose of a System Table?
    This is where SQL Server stores the data that defines the configuration of the server and all its tables. Users cannot directly query or update the system tables. The information in the system tables is made available through the system views.
Author
impalu
ID
255710
Card Set
SQL Tables
Description
:)
Updated