• Sign In
• Register
• AdSense Revenue

• Athira Appukut... (278)
• vipul (175)
• D.Jeya kumar(J... (143)

• Athira Appukut... (1737)
• D.Jeya kumar(J... (1341)
• Sridhar R (1336)

SQL Server

Question	Category
Which of the following aggregate functions returns a row count as an integer?	SQL Server
Which types of joins let you retrieve nonmatching data?	SQL Server
What is a Index?	SQL Server
datetime	SQL Server
track date and time of the last write access	SQL Server
What's the maximum number of parameters can a SQL Server 2000 stored procedure have	SQL Server
SELECT CAST(0 AS DATETIME)	SQL Server
What's the maximum number of columns can a SQL Server 2000 table have	SQL Server
Which of the following fixed database roles can manage all permissions, object ownerships, roles and role memberships	SQL Server
Which of the following is NOT a reserved keyword in SQL Server 2000 and therefore can be used as an object name or as a column name in a table without using delimiters?	SQL Server
Which of the following is NOT a valid description of the db_securityadmin fixed database role?	SQL Server
Which of the following fixed database roles can add or remove user IDs	SQL Server
What is the out put of SELECT DATEADD(DD, 0, DATEDIFF(DD, 0, GETDATE())) statement	SQL Server
What will be the result of SELECT STR(6365, 3) Statement	SQL Server
which command is used to set a set of Prevelages that can be granted to users or to other roles?	SQL Server
which operator is used in character string comparisons with pattern matching?	SQL Server
which clause returns only one copy of each set of duplicate rows selected?	SQL Server
which clause specifies the conditions that determines the groups included in the query?	SQL Server
what is database replication?	SQL Server
If we want to store true/false in sql, fetching values to the front end which datatype should we have to use at the best level?	SQL Server
With SQL, how can you return the number of records in the "Persons" table?	SQL Server
How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?	SQL Server
Which SQL keyword is used to sort the result-set?	SQL Server
With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"?	SQL Server
Which SQL statement is used to insert new data in a database?	SQL Server
Which SQL statement is used to extract data from a database?	SQL Server
DBCC stands for	SQL Server
You are designing an inventory and shipping database for Contoso,Ltd. You create the logical database design shown below: You must ensure that the referential integrity of the database is maintained. Which three types of constraints should you apply to your design	SQL Server
With SQL, how do you select all the columns from a table named "Persons"	SQL Server
With SQL, how do you select a column named "FirstName" from a table named "Persons"	SQL Server
Which SQL statement is used to insert new data in a database?	SQL Server
Which SQL statement is used to delete data from a database?	SQL Server
Which SQL statement is used to update data in a database?	SQL Server
Which SQL statement is used to extract data from a database?	SQL Server
What does SQL stand for	SQL Server
SQL	SQL Server
UPDATE STATISTICS	SQL Server
Odd one out - a transaction must be...	SQL Server
Which is not a return value of @@FETCH_STATUS variable	SQL Server
@@RowCount	SQL Server
Which data type would you use to store up to 2 GB of text data and still be able to query and manipulate it by using standard functions and operators?	SQL Server
Difference between view and stored procedure?	SQL Server
Function	SQL Server
Stored Procedure Query Plan	SQL Server
Given an employees table as follows: empid name managerid a1 bob NULL b1 jim a1 B2 tom a1 What value will select count(*) from employees return?	SQL Server
Given an employees table as follows: empid name managerid a1 bob NULL b1 jim a1 B2 tom a1 What value will select count(managerid) from employees return?	SQL Server
Which of the following is not a valid aggregate function?	SQL Server
Which clause you can use to restrict groups returned by a grouped query.	SQL Server
Which of the following is the correct SQL statement to use to remove rows from a table?	SQL Server
RAID stands for?	SQL Server

Next Results