SQL Server MCQs - CSE MCQs Questions and Answers

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

Select * from employee where salary>10000 and dept_id=101; Which of the following fields are displayed as output?

Salary, dept_id

Employee

Salary

All the field of employee relation

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

The command ________________ such tables are available only within the transaction executing the query, and are dropped when the transaction finishes.

Create table

Create temporary table

Create view

Create label view

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

Which of the following is the simplest ranking function ?

RANK

NTILE

ROW_NUMBER

None of the mentioned

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

Select ID, GPA from student grades order by GPA ____________ Inorder to give only 10 rank on the whole we should use :

Limit 10

Upto 10

Only 10

Max 10

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

Which of the following is not the function of client ?

Compile queries

Query optimization

Receive queries

Result formatting and presentation

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

Windowing function was added in which of the following versions of SQL Server ?

2003

2005

2008

None of the mentioned

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

Which of the the function is not a ranking window function ?

RANK

NTILE

ROW_NUMBER

None of the mentioned

Whatsapp
Facebook
Copy
Copy Text
Copy
Copy URL

Purpose of foreign key constraint in SQL Server is :

FOREIGN KEY constraints identify and enforce the relationships between tables

A foreign key in one table points to a candidate key in another table

You cannot insert a row with a foreign key value, except NULL, if there is no candidate key with that value

None of the mentioned