|
Related Questions |
View Answer |
|
What is the default format of date in Oracle? How can I change my default date format?
|
View Answer
|
|
How do I list all of my tables? How do I list all the indexed created for a particular table(say EMP)? How do I SELECT FROM DIFFERENT USERS TABLE?
|
View Answer
|
|
What is sql?
|
View Answer
|
|
What is outer join?Explain with examples.
|
View Answer
|
|
What is DML,DDL?
|
View Answer
|
|
How we get second highest salary in database. Please show me this coding.
|
View Answer
|
|
How to analyze the performance of a query using Explain Plan? Can any one explain me this in detail... if you can provide me with a link where I can get full information on it I would appreciate it...?
|
View Answer
|
|
Explain the concept of joins and list out the different type of joins?
|
View Answer
|
|
What is the difference between varchar & varchar2?
|
View Answer
|
|
what is analyze command how to use ?
|
View Answer
|
|
How you define which session run and how long time ?
|
View Answer
|
|
How to save the output of a query/ stored procedure to a text file using T-SQL?
|
View Answer
|
|
How to get the first day of the week, last day of the week and last day of the month using T-SQL date functions?
|
View Answer
|
|
How to programmatically find out when the SQL Server service started?
|
View Answer
|
|
Write a Query to find unique names of authors who have written books. (Using Pubs database)?
|
View Answer
|
|
Write a Query to pull out the maximum unit price for each in the database. (Using Northwind database)
|
View Answer
|
|
Write a SQL statement to draw the second highest salary in Employee Table (Using Sub query) Table structure is: Employe ID Name Salary
|
View Answer
|
|
What is a default TCP/IP socket assigned for SQL Server?
|
View Answer
|
|
What is a default TCP/IP socket assigned for SQL Server?
|
View Answer
|
|
What’s the difference between a primary key and a unique key?
|
View Answer
|