Microsoft SQL Server Knowledge Test/10 0 votes, 0 avg 18 Microsoft SQL Server Chapter 1Microsoft SQL Server Chapter 1 helps you to increase your knowledge on SQL and it's sub languages 1 / 10Which sub language have drop command? Data Manipulation Language Data Query Language Data Control Language Data Definition Language 2 / 10Choose correct one SELECT * FROM EMPLOYEE WHERE SALARY>3000 GROUP BY EMPLOYEENAME HAVING COUNT(USERNAME)=1 ORDER BY ID DESCENDING SELECT * FROM EMPLOYEE WHERE SALARY>3000 GROUP BY EMPLOYEENAME HAVING USERNAME =1 ORDER BY ID DESC SELECT EMPLOYEENAME FROM EMPLOYEE WHERE SALARY>3000 GROUP BY EMPLOYEENAME HAVING USERNAME =1 ORDER BY ID DESC SELECT EMPLOYEENAME FROM EMPLOYEE WHERE SALARY>3000 GROUP BY EMPLOYEENAME HAVING COUNT(USERNAME)=1 ORDER BY ID DESC 3 / 10What is the use of grant? Provide privileges to database objects for a user Provide access to only table for a user Remove privileges to database objects for a user All of the above 4 / 10Which is correct query on the below lists SELECT EMPLOYEE NAME FROM EMPLOYEE SELECT FROM NAME EMPLOYEE SELECT ENAME FROM EMPLOYEE SELECT *, NAME, EMPLOYEE SALARY FROM EMPLOYEE 5 / 10Why use TRUNCATE in SQL? Remove table from database Remove all of the rows from a table Truncate will work as drop None of the above 6 / 10is ALTER command belongs to DQL statement? True False 7 / 10When should we use commit? Use before DDL statements Use before DML statements Use after DML statements Use after DDL statements 8 / 10How many types of projection in SQL 2 3 1 5 9 / 10Is create command used for create only table in SQL Server? True False 10 / 10Which will give you better performance Truncate Delete Both None of the above Your score isThe average score is 54% 0% Restart quiz
