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 2005

  1. DES (Data Encryption Standard)

  2. AES (Advanced Encryption Standard)

  3. user defined password

Answer: Answer is c
Further Reading:

Useful resources,EncryptByPassPhrase


  1. sp_addtype

  2. Create Type

  3. Create Data Type

  4. None of these

Answer: Answer is b
Further Reading:

Useful resources,CREATE TYPE


10000, 11000, 12000, 10000, 14000, 12000, 13000, 10000, 14000, 10000

What will the following query return?

Select distinct (salary) from employees

  1. 10000, 14000, 12000, 10000, 11000

  2. 10000, 11000, 12000, 10000, 14000, 12000

  3. 10000, 11000, 14000, 12000, 13000, 10000

  4. 10000, 11000, 12000, 13000, 10000, 14000

  5. 10000, 11000, 12000, 14000, 13000

Answer: Answer is e

  1. AVG()

  2. LEN()

  3. COUNT()

  4. SUM()

  5. MAX(column)

Answer: Answer is b

  1. Indexes are created in an existing table to locate rows more quickly and efficiently

  2. It is possible to create an index on one or more columns of a table

  3. A table is scanned when index is not available

  4. Indexes can only be implemented on integer datatypes

Answer: Answer is d

  1. View Level

  2. Procedural Level

  3. Physical Level

  4. Logical Level

  5. Conceptual Level

Answer: Answer is e
Further Reading:

Useful resources, DBMS Architecture and Data Independence


  1. RESTORE DATABASE marketnikkie FROM DISK = 'D:/marketnikkie.bak'

  2. RESTORE DATABASE FROM DISK = 'D:/marketnikkie.bak'

  3. RESTORE DATABASE marketnikkie FROM = 'D:/marketnikkie.bak'

  4. RESTORE marketnikkie FROM DISK = 'D:/marketnikkie.bak'

  5. RESTORE DATABASE marketnikkie.mdf FROM DISK = 'D:/marketnikkie.bak'

Answer: Answer is a

  1. %

  2. _ (underscore)

  3. =

  4. ==

  5. is =

Answer: Answer is a, b

  1. It checks the current identity field value of the specified table

  2. It sets the identity field value to the new reseed value

  3. It sets the identity field value to 1

  4. None of the above

Answer: Answer is a, b

  1. A Super key is a column or a set of columns that uniquely identifies rows in a table

  2. A Super key checks the number of columns in a table which have non-null values

  3. A Super key is used to match columns in other tables

  4. A Super key checks the number of rows in a table which have non-null values

Answer: Answer is a

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.

;