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.
You have two tables, STUDENT and COMPUTER which are in a one-to-one relationship. The foreign key is StudNumber in COMPUTER that references StudNumber as the primary key of STUDENT. Describe what must be done to convert the one--to-one STUDENT -COMPUT
Differentiate between Multiload and Fastload in terms of Performance?
State some of the sectors where the data warehousing and data mining are utilized.
Briefly describe the term dimension tables and fact tables?
Describe truncate commands.
Explain about Server Job and Parallel Jobs?
Explain the extended, standard and secured mode?
Write down the some of the important security characteristics of a DBMS?
Write about the term Attribute, Entity and Relationship?
Briefly explain the functional differentiations between COGNOs and BO?
18,76,764
1948580 Asked
3,689
Active Tutors
1421338
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!