SQL Questions

Q:

What are the rules to use the ROWGUIDCOL property to define a globally unique identifier column?

Answer

Only one column can exist per table that is attached with ROWGUIDCOL property. One can then use $ROWGUID instead of column name in select list.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL - Technology

0 2957
Q:

How to create recursive query in SQL Server?

Answer

Recursive query can be create in SQL using stored procedure but you can also use CTE (Common table expression). It might be also worth asking about performance as CTE is not always very fast.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL - Technology

0 2882
Q:

The arranging of data in a logical sequence is called

A) Summarizing B) Classifying
C) Sorting D) Rearranging
 
Answer & Explanation Answer: C) Sorting

Explanation:

The process of arranging any items in a systematic manner in a logical sequence is called as Sorting. It can be of two types :

1. Ordering

Arranging items following some criterion like ascending or descending order

2. Categorizing

Grouping items with similar properties together.

Report Error

View Answer Report Error Discuss

Filed Under: SQL - Technology
Exam Prep: AIEEE , Bank Exams , CAT

2 2869
Q:

Explain the use of keyword WITH ENCRYPTION. Create a Store Procedure with Encryption

Answer

It is a way to convert the original text of the stored procedure into encrypted form. The stored procedure gets obfuscated and the output of this is not visible to


CREATE PROCEDURE Abc


WITH ENCRYPTION


AS


<< SELECT statement>>


GO

Report Error

View answer Workspace Report Error Discuss

Subject: SQL - Technology

0 2859
Q:

What is Analysis service repository?

Answer

Every Analysis server has a repository to store metadata for the objects like cubes, data sources etc. It’s by default stored in a MS Access database which can be also migrated to a SQL Server database.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL - Technology

0 2858
Q:

What are defaults? Is there a column to which a default can’t be bound?

Answer

A default is a value which will be used by a column, if no value is supplied to that column while inserting data.


Yes, IDENTITY and TIMESTAMP columns are free from the bounds of default.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL - Technology

0 2857
Q:

Where SQL server user names and passwords are stored in SQL server?

Answer

They get stored in System Catalog Views sys.server_principals and sys.sql_logins.

Report Error

View answer Workspace Report Error Discuss

Subject: SQL - Technology

0 2821
Q:

Define a temp table.

Answer

In a nutshell, a temp table is a temporary storage structure. It means you can use a temp table to store data temporarily so you can manipulate and change it before it reaches its destination format.


In table_user.gender column change ‘male to female’ and ‘female to male’ in one SQL statement.


UPDATE table_user


SET gender =


CASE gender


WHEN ‘male’ THEN ‘female’


WHEN ‘female’ THEN ‘male’


ELSE gender


END

Report Error

View answer Workspace Report Error Discuss

Subject: SQL - Technology

1 2778