SQL Server Practice Test 6

1. Which of the following option is used to find database objects by using filter criteria?

Advanced Object and filter Select dialog box

Advanced filter Select dialog box

Advanced find Select dialog box

Advanced Object Select dialog box

2. How many types of recovery model is provided by SQL Server?

3. Backup can occur while the database is in ___________ state.

Restoring

Offline

All of the mentioned

Online

4. Which of the following code will DROP an existing snapshot before creating new?

None of the mentioned

IF EXISTS(
    SELECT 
        * 
    FROM 
        sys.databases 
    WHERE 
        name = 'DatabaseA_Snapshot' 
    AND source_database_id IS NOT NULL
    )
BEGIN
    CREATE DATABASE [DatabaseA_Snapshot] 
    ON (NAME=DatabaseA, FileName='<whatever>') 
    AS SNAPSHOT OF [DatabaseA]
END

IF NOT EXISTS(
    SELECT 
        * 
    FROM 
        system.databases 
    WHERE 
        name = 'DatabaseA_Snapshot' 
    AND source_database_id IS NOT NULL
    )
BEGIN
    CREATE DATABASE [DatabaseA_Snapshot] 
    ON (NAME=DatabaseA, FileName='<whatever>') 
    AS SNAPSHOT OF [DatabaseA]
END

IF NOT EXISTS(
    SELECT 
        * 
    FROM 
        sys.databases 
    WHERE 
        name = 'DatabaseA_Snapshot' 
    AND source_database_id IS NOT NULL
    )
BEGIN
    CREATE DATABASE [DatabaseA_Snapshot] 
    ON (NAME=DatabaseA, FileName='<whatever>') 
    AS SNAPSHOT OF [DatabaseA]
END

5. Which of the following feature cannot be used in simple recovery mode?

All of the mentioned

Database mirroring

Media recovery without data loss

Log shipping

6. Which of the following command defragments clustered and secondary indexes of the specified table?

DBCC CHECKDB

DBCC CATALOG

DBCC INDEXDEFRAG

DBCC SHOWCONTIG

7. Point out the correct statement.

Recovery models are designed to control transaction log maintenance

Restore models are designed to control transaction log maintenance

Backup models are designed to control transaction log maintenance

None of the mentioned

8. Which of the following is the instance of SQL Server that is your production server in log shipping?

primary database

primary server

secondary database

secondary server

9. The __________ is an Access add-in program that provides data analysis tools for financial analysis.

All of the mentioned

Analysis ToolSQL

Analysis ToolPak

Analysis Tool

10. Point out the correct statement.

SSMS for Access converts Access database objects to SQL Server or SQL Azure database object

None of the mentioned

SSMA for Access converts Access database objects to SQL Server or SQL Azure database object

Use the CONVERSION page of the Project Settings dialog box to specify how much data appears on the Data tab