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