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

만든이
인쇄
퍼가기

순위표

비주얼 스타일

옵션

템플릿 전환하기

자동 저장된 게임을 복구할까요?