what is the maximum number of indexes i can create for a table? What happens if i create indexes for all the columns of a table? Will it slow down the speed of retrieval
2 6946What is the joins and how many types of Joins in sql server a diffrentiate ever one give a suaitable query
2 5131what is the difference detween pairwise comparison subquary and non pairwise comparison subquary?
2 15693How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
1797Table Order_Name has a column Order_Date which gives the date & Time at which the order is passed.Find the table to write a query to find out the latest order.
5 7395Table Student has 3 columns,Student_id,Student_Name & Course_Id. Table Course has 2 columns, Course_Id & Course_Name.Write a query to listdown all the Courses and number of student in each course.
TCS,
10 17584
What is join and how many types of joins?
What are the two modes of authentication in sql server?
What is difference between drop truncate and delete?
what is the difference between inner and outer join? Explain with example. : Sql dba
What is the use of microsoft access 2010?
What is sql used for?
Explain an exception and its types?
What are the advantages of views in a database?
How does mongodb replication work?
What is the default postgres user?
What are partitioned views and distributed partitioned views?
Which trace flags are enabled in sql server?
How do you see the locking status in mongo instances?
What is a definer?
Where is mongodb located?