How can I partition any table in Sybase
How can I partition any table in Sybase? Explain.
Expert
No, you cannot partition any table in Sybase. There are some kinds of tables where you cannot partition:
1. Tables along with clustered indexes (like release 11.5 this is possible to have a clustered index upon a partitioned table)2. Adaptive server enterprise system tables3. Work tables4. Temporary tables5. Tables which are already partitioned. Nonetheless, you can unpartition and after that re-partition tables to modify the number of partitions.
Whenever we are prepared to create a table in DBMS than what are the steps to follow?
What do you understand by the term SQL view in DBMS? Briefly describe the utilization of views?
Write a brief note on a distributed database?
Explain the term Super servers?
You have been given a setup of tables with data and inquired to make a new database to store them. What are you looking for, when you observe the data values in the tables?
How do I set a password to be null?
Why there is a need to create the user object?
Specify the other areas for the purpose of Data warehousing and the data mining.
What do you understand by the term snapshot replication in DBMS?
Define the term Data Independence?
18,76,764
1925652 Asked
3,689
Active Tutors
1425260
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!