SQLServer_ADO

Which of the following is not a aggregate function ?

• Avg

• Sum

• With

• Min

Which of the following SQL clauses is used to DELETE record from a database table ?

• DELETE

• REMOVE

• DROP

• CLEAR

Which of the following is one of the basic approaches for joining tables?

• Subqueries

• Union Join

• Natural join

• All of the Mentioned

Which of the following constraint does not enforce uniqueness ?

• UNIQUE

• Primary key

• Foreign key

• None of the mentioned

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

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

What is the full form of SQL

• Structured Query Language

• Structured Query List

• Simple Query Language

• None of these

Which is the subset of SQL commands used to manipulate database structures, including tables?

• Data Definition Language(DDL)

• Data Manipulation Language(DML)

• Both of above

• None

Which operator performs pattern matching?

• BETWEEN operator

• LIKE operator

• EXISTS operator

• None of these

What operator tests column for the absence of data?

• EXISTS operator

• NOT operator

• IS NULL operator

• None of these