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.
Explain the term version Control?
Explain an unsupported method to shrink a database.
Explain the Hash file and the Sequential File?
What is meant by the term Context?
Explain the automated document scheduling and distribution?
Briefly describe snow flake system design in database?
Write a brief note on the difference between data and database administration?
Define the term environment variables?
explain binary relationship set and terenary relationship set
Define the term merge stage?
18,76,764
1934001 Asked
3,689
Active Tutors
1453045
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!