1). Which of the following memory areas are allocated in a SQL Server 2014 insta

Question

1). Which of the following memory areas are allocated in a SQL Server 2014 instance (engine)?

A. Buffer cache

B. Shared pool

C. Memory pool area

D. code area

2). Terry wants to change the default value of a basic or advance instance configuration, what is the command syntax? (assume: CCCE or common criteria compliance enabled)

A. exec sp_configure ‘common criteria compliance enabled’, 3 go

Reconfigure with override go

B. exec sp_configure ‘common criteria compliance enabled’, 3 go and reboot the node

C. exec sp_configure ‘common criteria compliance enabled’, 0 go

D. exec sp_configure ‘common criteria compliance enabled’, 3 go and cycle SQL Server

3). How does SQL Server determines the recovery time of a particular database?

A. SQL Server determines the time automatically based on the changes taking place in the database

B. the amount of writes to the sytem

C. No_wait parameter, which requires a restart of the instance

D. Based on the amount of LSN numbers being generated

Explanation / Answer

1. Buffer cache:- In buffer cache, SQL server stores data which has been loaded from the disk and return trips to the disk which is not necessary.

2. exec sp_configure ‘common criteria compliance enabled’, 3 go

Reconfigure with override go

Command syntax:-

3. SQL Server determines the time automatically based on the changes taking place in the database. It is because this allows us to recover our database at a point in time right before a transaction occured.

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.