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