SQL Server 2005/08 and PostgreSQL 8.4/9.3 technical interview question answer

1. Default port number on which SQL Server listens

  

    Port 1433

   A database can contain a maximum of 32,767 files

There are primary 2 types of data files 

A. Primary data file  B. Scondary data file

There can be only one primary data file and multiple secondary data file and multiple secondary data files as long  as the total of files less than 32767 files.

DCL(data control language) command:

GRANT,DENY and REVOKE

Different ways you can create database in sql server.

Following different ways you can create database 

1    A.  T-SQL create database command

2    B.   Using management studio

3    C.  Restoring a database backup

4    D.  Copy database wizard

Normalization :

1. It is set of rules that has been established in the design of tables that are meant to be connected through relationships.

This set of rules is known as normalization

Benefits of normalizing your database

1    A.  Avoiding repetitive entries

2    B.  Reducing required storage space

3    C.  Preventing the need to restructure existing tables to accommodate new data

      D.  Increased speed and flexibility of queries,sorts and summaries.

More Reading...!