0 of 25 Questions completed
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading…
You must sign in or sign up to start the quiz.
You must first complete the following:
0 of 25 Questions answered correctly
Time has elapsed
You have reached 0 of 0 point(s), (0)
Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)
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
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)
DECLARE @SUM INT
SET @SUM = @NUM1 + @NUM2
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
Which of the following options is True for below code.
Declare @num int = 0
while @num < = 10
Set @num = @num + @num
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
SAVE TRANSACTION T1
SAVE TRANSACTION T2
SAVE TRANSACTION T3
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?