SKILL 2.3 QUIZ

/in /by

QUESTION 1

  1. ______________have the responsibility of configuring and managing each SQL Server instance to meet the needs and the SLA demands appropriate for the database and workloads planned for the instance.

    DBAs

    System administrators

    Network Analysts

    None of the above

5 points   

QUESTION 2

  1. Which of the following is a database file type?

    Primary Data

    Secondary Data

    Transaction Log

    All of the above

5 points   

QUESTION 3

  1. _____________are used to group data files together for multiple purposes.

    Folders

    Configuration files

    Filegroups

    None of the above

5 points   

QUESTION 4

  1. TempDB is used by SQL Server for:

    Temporary user objects

    Internal objects

    Row versions

    All of the above

5 points   

QUESTION 5

  1. ____________________is a template for all databases created on the SQL Server instance.

    Master

    Model

    msdb

    tempdb

5 points   

QUESTION 6

  1. _______________is a read-only database that resides in the mssqlsystemresource.mdf file, which contains copies of all system objects.

    Resource

    Distribution

    Model

    Master

5 points   

QUESTION 7

  1. A typical installation of a SQL Server instance will show the ____________common system databases.

    One

    Two

    Four

    Eight

5 points   

QUESTION 8

  1. _________________specifies whether the database is read-only.  When the value is true, users can only read data, they cannot modify data or database objects.

    Database Read-Only

    Restrict Access

    Page Verify

    Delayed Durability

5 points   

QUESTION 9

  1. This database configuration setting controls the locking and row versioning behavior of T-SQL statements via connections to SQL Server.

    Delayed Durability

    Is Read Committed Snapshot On

    Restrict Access

    None of the above

5 points   

QUESTION 10

  1. SQL Server files have two names: a logical and operating system file name.

     

     

"Get Help With Your Essay
. If you need assistance with writing your essay, our professional essay writing service is here to help!

Order Now