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 6921What is the joins and how many types of Joins in sql server a diffrentiate ever one give a suaitable query
2 5102what is the difference detween pairwise comparison subquary and non pairwise comparison subquary?
2 15630How 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?
1779Table 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 7344Table 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 17490
Can you list down the different components of physical and logical database structure?
What is self contained scalar sub query?
Do you know how to make remote connection in database?
what is the difference between functional dependecy and multilevel dependency?
What will you get by the cursor attribute sql%found?
How do I shrink an ldf file?
What do you understand by intension and extension?
What is foreign key and example?
can you tell how can you display the maximum salary in sql? : Mysql dba
What is an oracle database?
What is identity column in sql server?
What are the built-in functions used for sending Parameters to forms ?
Is it true, that there is no difference between a rule and a check constraint?
how can a session indicate its interest in receiving alerts?
What are the three pl sql block types?