News:

SQL Table To C# Entity Model ConverterEntity Model (Class Properties) to SQL Table ConverterIf you encounter any trouble visiting our site, please contact us.

Online Test MS SQL Server 2000

  1. DEFAULT and NOT NULL constraints

  2. FOREIGN KEY constraints

  3. PRIMARY KEY and UNIQUE constraints

  4. IDENTITY columns

  5. CHECK constraints

Answer: Answer is c
Further Reading:

Useful resources, Constraints


  1. A trigger cannot maintain cascading referential integrity

  2. Manipulating columns of datatype IMAGE / TEXT does not cause triggers to be executed

  3. Only the database owner can create triggers

  4. Triggers are executed on INSERT, UPDATE, DELETE and SELECT statements

Answer: Answer is b
Further Reading:

Useful resources, CREATE TRIGGER


  1. Select * from students where marks > avg(marks);

  2. Select * from students order by marks where subject = 'SQL';

  3. Select * from students having subject ='SQL';

  4. Select name from students group by subject, name;

  5. Select group(*) from students;

  6. Select name,avg(marks) from students;

  7. g. None of the above

Answer: Answer is d

  1. /* … */ are used for multiline comments

  2. // is used for single line comments

  3. – is used for single line comments

  4. Nested comments are allowed i.e. /* comment 1 /* comment 2 */ comment 1*/

  5. ‘ is used for single line comments

Answer: Answer is b, c, e

  1. When a procedure name is passed to sp_help, it shows the parameters

  2. When a table name is passed to sp_help, it shows the structure of the table

  3. When no parameter is passed, it provides a list of all objects and user-defined datatypes in a database

  4. All of the above are true

Answer: Answer is d
Further Reading:

Useful resources, sp_help


SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY salary DESC

SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY 2 DESC

What is true about them?

  1. The two statements produce identical results

  2. The second statement returns an error

  3. There is no need to specify DESC because the results are sorted in descending order by default

  4. None of the above

Answer: Answer is a

  1. Select * from Products order by CurrentStock,ProductGroup

  2. Select * from Products order by CurrentStock DESC,ProductGroup

  3. Select * from Products order by ProductGroup,CurrentStock

  4. Select * from Products order by ProductGroup,CurrentStock DESC

  5. None of the above

Answer: Answer is d

  1. Parenthesis

  2. Multiplication, Division and Exponents

  3. Addition and Subtraction

  4. Logical Operations

Answer: Answer is a
Further Reading:

Useful resources, Operator Precedence (Transact-SQL)


  1. soundex(Smith) is the same as soundex(Smithson)

  2. soundex(SMITH) is different from soundex(smith)

  3. soundex(smith) is the same as soundex(smyth)

  4. soundex(smith) is different from soundex(smythe)

  5. All are false

Answer: Answer is c
Further Reading:

Useful resources, SOUNDEX


  1. Use UNIQUE constraints

  2. Use PRIMARY KEY constraints

  3. Use DEFAULT and NOT NULL constraints

  4. Use FOREIGN KEY constraints

  5. Use SET constraints

Answer: Answer is c

Advertisement

BCS Preparation now even more easy. ReadBD is the place where you can find all kind of resources to be successful in BCS,Bank,Islami Bank exam and interview.

Looking for job. Try JobLoader- First ever job search engine in Bangladesh. All open bd jobs now a single mouse click away.

;