Where do you think the users names and passwords will be stored in sql server?
What is lock escalation?
Let us say the SQL Server crashed and you are rebuilding the databases including the master database what procedure to you follow?
What is Livelock?
What are statistics, under what circumstances they go out of date, how do you update them?
What is database replicaion? What are the different types of replication you can set up in SQL Server?
How do I list the available tables in a database I’m querying?
How do I give a user the option of importing Excel and a delimited text file into a SQL Server Database without manually using SQL DTS?
I would like to create a stored procedure that runs a query and outputs the results to a text file and allows me to add extra delimeters and static field info.
If my SQL Server has the following specs: 6.05.02 SQL-DMO 6.50.252 DB-Library Which version do I have? And which service pack version do I have?
Is it possible to delete duplicate rows in a table without using a temporary table (i.e., just do it with a single SQL statement)?
What is Except Operator?
How to Run a Query on a Remote SQL Server?
What is Startup and Shutdown ?
What is the wildcard character in SQL?
Explain ACID rule of thumb for transactions.
Does PL/SQL support overloading?
What are the different types of JOIN operations?
What is a Recovery Model?
What is a SQL * NET?
What is SQL*Loader?
Execute an Operating System Command From Within SQL Server.
Why does my inline or embedded SQL run faster than my stored procedures?
What is difference between ‘Count’ and ‘Count(*)’?
What are the pros and cons of creating extended stored procedures?
What are the benefits of SQL ?
What are the different types of SQL commands ?
What are CLUSTERS ?
What is a SEGMENT ?
What are Packages ?
What are Hash clusters ?
What are Extents?
Explain the Memory Structures of the Oracle database ?
What are OPTIMIZER HINTS ?
Why doesn’t SQL Server permit an ORDER BY clause in the definition of a view?
Why does inline or embedded SQL run faster than my stored procedures?
Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
What operator performs pattern matching?
What operator tests column for the absence of data?
What is the difference between TRUNCATE and DELETE commands?
What command is used to create a table by copying the structure of another table?
What does the following query do?
Why does the following command give a compilation error?
What is the use of DESC in SQL?
What is the use of CASCADE CONSTRAINTS?
What is the use of CASCADE CONSTRAINTS?
What is the difference between TRUNCATE and DELETE commands?
What does the following query do?
What is the difference between TRUNCATE and DELETE commands?
What is the advantage of specifying WITH GRANT OPTION in the GRANT command?
What are the privileges that can be granted on a table by a user to others?
What is the use of DESC in SQL?
How can you compare a part of the name rather than the entire name?
What is the difference among DROPping a table , TRUNCATing a table and DELETing all records from a table.
What’s the difference between a primary key and a unique key?
What is an Index?
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment