CSE MCQs :: SQL Server MCQs
- Which of the following constraint does not enforce uniqueness ?
- Select * from employee where salary>10000 and dept_id=101; Which of the following fields are displayed as output?
- The command ________________ such tables are available only within the transaction executing the query, and are dropped when the transaction finishes.
- Which of the following is the simplest ranking function ?
- Select ID, GPA from student grades order by GPA ____________ Inorder to give only 10 rank on the whole we should use :
- Which of the following is not the function of client ?
- Windowing function was added in which of the following versions of SQL Server ?
- Which of the the function is not a ranking window function ?
- Purpose of foreign key constraint in SQL Server is :
Whatsapp
Facebook
