(•̪●)==ε/̵͇̿​̿/’̿’̿ ̿ ̿̿ `(•.°)~

24 Questions | Total Attempts: 32

SettingsSettingsSettings
Please wait...
()==//   `(.)~

Questions and Answers
  • 1. 
  • 2. 
    What is the T-SQL statement for determining the SQL Server version that is running?
  • 3. 
    Default SQL Server and Named SQL Server are just some of the types of SQL Server instances?
    • A. 

      True

    • B. 

      False

  • 4. 
    Which of the following are valid SQL Server instance names?
    • A. 

      #AdventMoxyServer

    • B. 

      APX$tan

    • C. 

      MoxyANDapx

    • D. 

      @$$h0L3

  • 5. 
    What should be the collation settings when installing SQL Server if you are using APX/
    • A. 

      SQL_Latin1_General_CP1_CI_AS

    • B. 

      SQL_Latin1_PS1_CI_AS

    • C. 

      SQL_Latin1_General_CP1_CI

    • D. 

      SQL_Latin_General_CP1_CI_AS

  • 6. 
    _________________ is a collection of data files that can be managed as a set.
  • 7. 
    What can be recorded to the log to aid in recovery up to a certain point?
    • A. 

      Restore point

    • B. 

      Transaction log

    • C. 

      Transactions

    • D. 

      Checkpoint

  • 8. 
    The transaction log is a history of actions performed by an RDBMS to guarantee against crashes.
    • A. 

      True

    • B. 

      False

  • 9. 
    The SQL Server Service:
    • A. 

      Manages the data and related resources like index files

    • B. 

      Ensures data consistency and integrity

    • C. 

      Allows automation of some administrative tasks

    • D. 

      Enabled integration with Active Directories

  • 10. 
    What are the two levels at which SQL Server validates a user?
    • A. 

      Windows and SQL Authentication

    • B. 

      Windows and Mixed Mode

    • C. 

      Authentication and Permission

    • D. 

      None of the above

  • 11. 
    The following is an example of how to connect to the database using SQL Authentication:
    • A. 

      True

    • B. 

      False

  • 12. 
    The following is/are false in relation to SQL Tables:
    • A. 

      Tables that have index may not have a composite primary key

    • B. 

      Clustered Indexes provide an efficient way to access data from a table

    • C. 

      An index can contain more than one row

    • D. 

      A database consisting of a number of tables can have a number of clustered indexes.

  • 13. 
    This assigned to a column determines the type of information that can be stored in the column.
  • 14. 
    An _____________ is a numeric column that is generated automatically when a row is added to the table.
  • 15. 
    To logically group tables, users, views, sprocs, we often make use of ________________.
  • 16. 
    Which of the following is/are true?
    • A. 

      Decimal (x,y) may only contain an integer

    • B. 

      Datetime and smalltime represents date and time. Smalltime is precise to 1 second

    • C. 

      Int, SmallInt and TinyInt can be used to represent a half-share of stock or a par value of a corporate bond

    • D. 

      None of the above are true.

  • 17. 
    The contents of the president table.
  • 18. 
    All records where the president's last name is Adams.
  • 19. 
    Only the first name and last name of each president sorted by start date from latest to oldest.
  • 20. 
    Same as above, but only show president's last name with an end date after 12/31/2000
  • 21. 
    Show all records that have no end date.
  • 22. 
    Show all last names in the table with no duplicates.
  • 23. 
    A SQL server database will have at least two files:
    • A. 

      A primary data file and a backup file

    • B. 

      A primary data file and a log file

    • C. 

      A primary data file and a secondary data file

    • D. 

      A primary data file and an index file

Back to Top Back to top