A) Pessimistic and optimistic concurrency B) Table-level and row-level locking C) Exclusive and shared locking D) Latch and spinlock control
A) Priority queue access to tables B) Exclusive access to the data C) Shared access with other users D) Read-only access to the data
A) Multiple users can read data simultaneously B) They are only applied to index leaves C) They prevent all other reads D) They allow exclusive locks to be acquired
A) The end-user client B) The database administrator C) The SQL Server optimizer D) The Lock Manager
A) It cannot be used on indexes B) It automatically reduces performance C) It blocks all other users D) It requires more resources
A) Latches and spinlocks B) Version IDs and metadata C) Transactions and rollbacks D) Shared locks and exclusive locks
A) It pauses all threads until the deadlock clears B) It kills one of the threads and rolls back the transaction C) It restarts the entire database instance D) It forces all threads to use optimistic concurrency
A) The Lock Manager B) The Worker Thread Monitor C) The Tempdb system D) The Latch Controller
A) The index leaf nodes B) The main data table C) Tempdb D) The transaction log
A) By the system timestamp only B) By the user who initiated the update C) By the row's physical memory address D) By the ID of the transaction that created the version
A) They are immediately blocked B) They are rejected with an error C) They are moved to a waiting queue until the transaction ends D) They are executed on the older version of the row
A) Latches are less resource intensive than locks B) Locks are used for DMVs while latches are used for tables C) Locks are more lightweight than latches D) Latches are more robust than locks
A) Only if they are using optimistic concurrency B) Only if the database is read-only C) Yes D) No, only one client at a time
A) Database level only B) Pages only C) Entire index or index leaves D) Rows only
A) SQL Server 6.5 B) SQL Server 2000 C) SQL Server 2005 D) SQL Server 7.0
A) SQL Server 7.0 B) SQL Server 2000 C) SQL Server 2008 D) SQL Server 2005
A) SQL Server Compact Edition B) SQL Server 2008 R2 Datacenter C) SQL Server 2005 Express Edition D) SQL Server 2000 Personal Edition
A) Mobile Edition B) Standard Proxy C) Desktop Engine D) Web Server Edition
A) Web admin tool B) Database engine capabilities C) Microsoft Access compatibility D) A GUI
A) Windows CE Edition B) Datacenter Edition C) Personal Edition D) Desktop Engine
A) 10 GB limit B) No size limit C) 4 GB limit D) 1 GB limit
A) Standard management tools B) Transactional replication C) Full-Text Search D) SQL connectivity
A) 512 B) 256 C) 64 D) 128
A) SQL Server 2005 Express Edition B) SQL Server Compact 3.5 C) SQL Server 2005 Mobile Edition D) SQL Server 2000 Personal Edition
A) SQL Server Compact 3.5 B) SQL Server 2008 R2 C) SQL Server 2005 Compact Edition D) Windows CE Edition
A) Microsoft B) IBM C) Sybase Inc. D) Oracle
A) SMTP B) FTP C) UDP only D) TCP/IP
A) Read80Trace B) SQLXML C) PSSDIAG D) Best Practices Analyzer
A) Service Pack 4 B) Service Pack 1 C) Service Pack 3 D) Service Pack 2
A) 1985 B) 1993 C) 1989 D) 1995
A) Linux support B) OS/2 support C) Columnar in-memory storage (xVelocity) D) Big Data Clusters
A) NT-OS B) Big Data C) Shiloh D) xVelocity
A) x86 B) PowerPC C) ARM D) x64
A) November 18, 2025 B) January 1, 2025 C) December 25, 2025 D) November 30, 2024
A) 12 terabytes B) 524 petabytes C) 640 petabytes D) 100 terabytes
A) 524 gigabytes B) 1 terabyte C) 12 terabytes D) 640 terabytes
A) 1024 B) 12 C) 524 D) 640
A) Hot-add memory B) SQL cluster management C) Stand-alone services D) Core database engine
A) SQL Server Management Studio Basic B) Hot-add memory C) Power Pivot D) Parallel indexes
A) 50 GB B) 4 GB C) 10 GB D) 1 TB
A) 50 GB B) 1 GB C) 10 GB D) 4 GB
A) Embedded architecture B) Single-threaded processing C) Client-server architecture D) Massively parallel processing (MPP)
A) 2020 B) Early 2016 C) 2005 D) 2012
A) 180 days B) 90 days C) 365 days D) 30 days
A) SSEE B) Compact Edition C) LocalDB D) Fast Track
A) Mobile device users B) Application developers C) Database administrators D) Cloud architects
A) Allocation unit B) Extent C) Partition D) Page
A) 16 KB B) 4 KB C) 8 KB D) 2 KB
A) .ldf B) .db C) .mdf D) .ndf
A) .mdf B) .ldf C) .ndf D) .log
A) 4 B) 16 C) 32 D) 8
A) System Statistics Tables B) Dynamic Management Views C) Performance Monitors D) Virtual Data Objects
A) B-tree B) Heap C) Clustered index D) Partition
A) 128 bytes B) 8 bytes C) 96 bytes D) 64 bytes
A) binary B) Float C) Integer D) Varchar
A) Transaction heap B) Buffer cache C) Disk storage D) System log
A) Sequential I/O B) Networked I/O C) Synchronous I/O D) Asynchronous I/O
A) A checksum B) An encryption key C) A time stamp D) A user ID
A) PL/SQL B) T-SQL C) PostgreSQL D) MySQL
A) Query plan B) Stored procedure C) Data retrieval D) SQL dialect
A) Database administrator B) Network interface C) Client application D) Query processor
A) Data serialization B) Index restructuring C) Schema mapping D) Query optimization
A) Industry standard compliance B) Cloud compatibility C) Performance benchmarks D) Legacy
A) Low selectivity B) High system load C) Complex joins D) Large table size
A) Transact-SQL B) Template-SQL C) Transfer-SQL D) Table-SQL
A) ADO.NET B) CLR Host C) SQLOS D) Windows OS
A) Via system-defined stored procedures B) Via direct memory manipulation C) Via external PowerShell scripts D) Via GUI configuration files
A) T-SQL exclusively B) Native C++ only C) Assembly code only D) Any managed .NET language
A) System stored procedures B) External XML schemas C) Managed code (UDTs) D) SQLOS assemblies
A) Automatic memory garbage collection B) Context connections C) Direct hardware communication D) GUI development tools
A) Writing SQL code documentation B) Installing third-party software C) Modifying Windows registry keys D) Scheduling maintenance plans
A) Backup, copy, restore & check B) User password recovery C) Graphics rendering D) Table deletion and indexing
A) scikit-learn B) pandas C) revoscalepy D) numpy
A) Contract B) Route C) Queue D) Message type
A) Contract B) Message type C) Service program D) Route
A) As flat text files B) As encrypted objects C) As virtual memory buffers D) As tables
A) Processing B) Insert C) Receiving D) Storage
A) Message types B) Queues C) Routes D) Contracts
A) Biometric authentication B) Physical firewall control C) Password recovery D) Message encryption
A) Publisher/subscriber model B) Master/slave model C) Client/server model D) Peer-to-peer model
A) Transactional replication B) Merge replication C) Distributed replication D) Snapshot replication
A) Rowguid B) Primary key C) Index D) Foreign key
A) Transactional replication B) Merge replication C) Bi-directional replication D) Snapshot replication
A) Real-time only B) Bi-directional C) Manual only D) Unidirectional
A) SOAP B) XML for Analysis C) SQL/RPC D) REST
A) MDX B) DMX C) LINQ D) T-SQL
A) Naive Bayes B) Merge sort C) Hash join D) B-Tree indexing
A) QuickSort B) A* search C) Neural networks D) Dijkstra's algorithm
A) Full-text indexing B) Database administration C) Report generation D) Data warehousing
A) SQL files B) PDF files C) RDL files D) XML files
A) Data Transformation Services B) SQL Server Management Studio C) Filter Daemon D) Report Builder
A) CSV B) PDF C) DOCX D) JPEG
A) SMTP B) SOAP C) HTTP POST D) Writing to a filesystem file
A) December 2000 B) August 2008 C) January 2005 D) March 2010
A) ETL capabilities B) Web report interface C) Full-text searching D) Notification management
A) 500 B) 255 C) 1000 D) 100
A) msftefd.exe B) sqlservr.exe C) msftesql.exe D) ssis.exe
A) sqlindexer.exe B) msftesql.exe C) gatherer.exe D) msftefd.exe
A) Thesaurus B) Query Processor C) Filter Daemon D) Gatherer
A) Empty fragments B) Excluded tokens C) Noise words D) Stop tags |