1) Smallest unit of storage in sqlserver is called as _______ a) blocks b) Pages c) Extents d) Segments 2) Identify the Sql server logical storage hierarchy a) Page,extent,filegroup b) Page,filegroup,extent c) extent,segment,filegroup d) page,extent,segment,filegroup 3) Sql server filegroups can be mapped to ________ files only a) Log b) Control c) Data d) Alert 4) Identify the command used to create database in sqlserver a) create dbname; b) dbcreate dbname; c) create sqldb dbname; d) create database dbname; 5) Type of extents available in sqlserver a) Multiple b) Unique c) Mixed d) Different 6) Identify the tool used to configure the network seetings for sql server a) SQL Server DTA b) SQL server management studio c) SQL server Profiler d) SQL server configuration manager 7) Which filegroup in sqlserver database cotains metadata? a) Primary b) Secondary c) Logfile d) Backupfile 8) Identify the valid protocols in sqlserver? a) IP b) Shared Memory c) IPC d) TPC 9) Whenever creating table in sqlserver, _______ will be allocated a) Segment b) Extent c) Block d) Page 10) What is TDS? a) Tabular Data Stream b) Table data Stream c) Tabular format d) Truncate Data Stream

Sql Server Database

โดย
สั่งพิมพ์
ฝัง

ลีดเดอร์บอร์ด

สไตล์ภาพ

ตัวเลือก

สลับแม่แบบ

คืนค่าการบันทึกอัตโนมัติ: ใช่ไหม