End Sql quizes Copy

How to rename table names in mssql.

You have a table of employee in which there are 1000 rows and 3 columns name as

     Emp_id, emp_name, Salary,  You have to show the total salary of the top 10 rows from

     the table.

     Which query is correct for the above statement.

Which of the following is not True about user defined functions in sql

If we have m number of rows in table A and n number of rows in table B so total number of 

     rows we get from doing cartesian product between Table A and B is.

Which of the following code will find Total Null Values from a column of table

If we have Table A in which C_ID  and C_NAME column there and in Table B we have C_ID and 

     C_ADDR , In table A we have C_ID values (1,2,3) and in Table B we have (4,5,6) , so when we 

     Will perform inner join between both tables what data we will get.

Will below code execute successfully or it will show error. 

CREATE FUNCTION ADD_NUMBERS(@NUM1 INT, @NUM2 INT)

RETURNS INT

AS

BEGIN

DECLARE @SUM INT

SET @SUM = @NUM1 + @NUM2

RETURN SUM

END;

SELECT [DBO].[ADD_NUMBERS](5)

Which of the following is an illegal data type in SQL

How to view Table Value function in sql server.

In Below Normalisation form which can have transitive dependency.

In Below Normalisation form which of the following can not have partial dependency

Which of the following code is correct for fetching salary between 15000 to 30000 from an

        Employee table.

Which of the following options is True for below code.

Declare @num int = 0

while @num < = 10

As

Begin

Set @num = @num + @num

End

Which of the following options is correct for concating two or more strings.

How can we view a Procedure in sql Server if our procedure name is ‘Prime_Number’ and we 

        We are already using current database

Exception handling is possible in SQL Server using _____________

 Which of the following stored procedures is already defined in SQL Server?

Features provided by ALTER DATABASE statement do not include ____________

The query given below will give an error. Which one of the following has to be replaced to get the desired output?

SELECT ID, name FROM 1_Order WHERE instructor=1;

Which of the following statements contains an error?

Consider Below code , select the correct option from given below

        BEGIN TRANSACTION

SAVE TRANSACTION T1

/*CODE*/

SAVE TRANSACTION T2

/*CODE*/

  SAVE TRANSACTION T3

/*CODE*/

        ROLLBACK TRANSACTION T1

Which of the following is a large object data type?

 Exact Numeric data type is ___________

What type of join do you need when you want to include rows with values that don’t match?

Which of the following option matched a CASE SQL statement?