dbms Archives - DbaFix

Running two MySQL servers that use the same data directory

By adminPosted on February 17, 2023

Question : The situation I have two MySQL instances, deployed on two different remote machines. Both MySQL instances access the […]

By adminPosted on January 25, 2023

Question : Table : Class Here the className is unique classId| className ——-|——— 1 | 1st Class 2 | 2nd […]

By adminPosted on January 18, 2023

Question : Given two relations R(A,B) with r tuples, S(B,C) with s tuples (r>0, s>0), find the min and max […]

By adminPosted on January 18, 2023

Question : I am running Oracle 11gR2 on an AIX box. I did a rename database and change DB ID […]

By adminPosted on January 16, 2023

Question : Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this […]

By adminPosted on December 2, 2022

Question : I can’t differentiate DBMS, database server and database client. Mysql, for instance, has Mysql shell, Mysql workbench, etc. […]

By adminPosted on November 3, 2022

Question : I’m making a new database in MySQL in which after making the Department table I receive an error […]

By adminPosted on October 21, 2022

Question : I always wondered, why a port must be assigned in order to use a DBMS? And what difference […]

By adminPosted on October 13, 2022

Question : In following table how to print the student number when age occur two or more times, The result […]

By adminPosted on October 11, 2022

Question : so I am trying to create a copy of a table using dbms_metadata. I know you can get […]