News:

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

Online Test Knowledge of SQL Server 2008 Skills

Which of the following values specifies that each instance of the XML data type in column_name can contain multiple top-level elements?

  1. DEFAULT

  2. CONTENT

  3. DOCUMENT

  4. FILESTREAM

Answer: Answer is b
Further Reading:

Useful resources, columns

Analyze the following code using wild card characters of SQL Server 2008:

SELECT Name FROM person.employees WHERE Name LIKE '[_]n' GO

Which of the following values will be returned by the above code?

  1. In

  2. Sin

  3. _n

  4. All of the above

Answer: Answer is a
Further Reading:

Useful resources, LIKE

Which of the following stored procedures is used to delete data from the management data warehouse of a Data Collector?

  1. core.sp_delete_data

  2. core.sp_purge_data

  3. core.sp_remove_data

  4. None of the above

Answer: Answer is b
Further Reading:

Useful resources, Managing Data Collection

Which function/functions are performed by the following statement?

DBCC CHECKIDENT ('table_name', RESEED, new_reseed_value)

  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. All of the above.

Answer: Answer is a, b
Further Reading:

Useful resources, DBCC CHECKIDENT

How many groupings are generated when CUBE is used with the GROUP BY clause of SQL Server 2008?

  1. n (n= number of expressions in the element list passed to CUBE)

  2. n+1 (n= number of expressions in the element list passed to CUBE)

  3. 2^n (n= number of expressions in the element list passed to CUBE)

  4. 2^n+1 (n= number of expressions in the element list passed to CUBE)

Answer: Answer is c
Further Reading:

Useful resources, GROUP BY

The regular identifiers of SQL Server 2008 may contain a range of _____________ characters

  1. 1 to 116

  2. 1 to 127

  3. 1 to 128

  4. 1 to 512

Answer: Answer is c
Further Reading:

Useful resources, Identifiers

If the characters 'D', 'C', 'B', 'A' are placed in a queue (in that order) and then removed one at a time, in what order will they be removed?

  1. ABCD

  2. ABDC

  3. DCAB

  4. DCBA

Answer: Answer is a

Which of these are standard operations of Stack Data Structure?

  1. Push, delete

  2. Insert, pop

  3. Put, extract

  4. Push, pop

Answer: Answer is d
Further Reading:

Useful resources, Stack

How many real links are required for a sparse matrix having 10 rows, 10 columns and 15 non-zero elements? (Pick the nearest answer)

  1. 15

  2. 20

  3. 50

  4. 100

Answer: Answer is c

Which graph traversal algorithm uses a queue to keep track of the vertices which need to be processed?

  1. Breadth-first search

  2. Depth-first search

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.

;