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

door
Afdrukken
Embedden

Scorebord

Visuele stijl

Opties

Template wisselen

Automatisch opgeslagen activiteit "" herstellen?