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

さんの投稿です
印刷
埋め込み

リーダーボード

表示スタイル

オプション

テンプレートを切り替える

自動保存: を復元しますか?