Exam MySQL 5.1

[suri]

Hi All,
How's the preparation going on ?

Thanks
Suresh Kuna

[Balaji Kasangudi Srinivasan]

Very great,,,,need to search the book.

[Suresh Kuna]

Hi All,
I'am done with the exam and it is very easy just like below.
1) giving grants
2) revoke grants
3) create table
4) taking dump
5) creating views etc

Thanks
Suresh Kuna

--
Regards,
Suresh Kuna

[Suresh Kuna]

FYI

--
Regards,
Suresh Kuna

[Niyati Verma]

Hi,

 

Gud to hear this atleast a bit relaxing....

 

I am also planning for monday.

 

Bye.

[Niyati Verma]

You are getting error because u r directly wrighting limit variable.
instead prepare the query using concat and then execute the query in
procedure.
Some thing of this sort will do

query=concat('insert into' variable1 , 'select * from table' ,
variable2);
set query1=query;
prepary query1 ;
execute query1;

On Sep 23, 3:14 pm, kali natham <kalinat...@gmail.com> wrote:
> Hi,
> As i know mysql function do not have table type return , so i am creating
> temporary table to solve the issue.
> I am trying to create a procedure which will have two parameters and inside
> the procedure i am using those parameters. Parameter one is table name and
> parameter two is row limit value.
>
> But its giving error.
>
> Below is the code:  in this tblname is table name  and tbllimit is the row
> limit parameters.
>
> *DELIMITER $$
>
> CREATE
>
>     PROCEDURE `httpdb`.`tbllim`(inout tblname varchar(100),inout tbllimit
> int)
>
>        BEGIN
> create temporary table temtbl like tblname;
>
> insert into temtbl select * from tblname limit tbllimit;
>
>     END$$*
>
> DELIMITER ;

>
> On Wed, Sep 23, 2009 at 12:16 PM, Suresh Kuna <sureshkumar...@gmail.com>wrote:
>
>
>
>
>
> > Hi All,
> > I'am done with the exam and it is very easy just like below.
> > 1) giving grants
> > 2) revoke grants
> > 3) create table
> > 4) taking dump
> > 5) creating views etc
>
> > Thanks
> > Suresh Kuna
>
> > On Mon, Sep 21, 2009 at 12:29 PM, Balaji Kasangudi Srinivasan <
> > balajikanna...@gmail.com> wrote:
>
> >> Very great,,,,need to search the book.
>

> >> On Mon, Sep 21, 2009 at 12:28 PM, suri <sureshkumar...@gmail.com> wrote:
>
> >>> Hi All,
> >>> How's the preparation going on ?
>
> >>> Thanks
> >>> Suresh Kuna
>
> > --
> > Regards,
> > Suresh Kuna
>

> --
>
> Regards.
> Kalinatham- Hide quoted text -
>
> - Show quoted text -

[Suresh Kuna]

Hi All,
How's the exam preparation going on ? We have only 3 left to give it.
Those who all have given the exam can help the remaining by sharing their experiences.

Thanks
Suresh Kuna

--
Regards,
Suresh Kuna

[Rohit Vachhani]

Hello All,

 

I took the exam yest. It tests all the concepts. Time is 2.5 hrs. There were 18 quest in all of which first 3 were necessary and of rest 12 any 3 needs to be done. It took 45 mins for me to understand the remote systems itself, suggestion is to keep track of time. The system is bit buggy and need to use "NET STOP MYSQL" and "NET START MYSQL" several times.

 

The questions were as follows:

 

NEcessary quest:

1. Add, delete users. Give grants to users.

2. Take dumps of tables and db's. Populate db from csv file. (be careful while taking dump, if a dump is taken and it doesnot happen for some reason, then the file will be locked by OS and u cant even delete it)

3. Oprtimise queries.

For optional ques:

 

There are 12 of optional quest and most of them are easy which consists of all the chapters from book like repair tables, partation tables, create views etc.

 

Hope this info helps, have the book beside and google will be accessible.... :)

 

All the best,

 

Regards,

Rohit

[Suresh Kuna]

Hi All,
Rohit has given excellent options for us on What and all is required for us to take up an exam. Get ready and go ahead. We have only 2 days left.

Thanks
Suresh Kuna

--
Regards,
Suresh Kuna

[Niyati Verma]

Finally i have also given the exam it was gud and questions are already mentioned by rohit.

 

For rest of those who have not given the exam : BEST OF LUCK.

 

Some people have not even joined the group i think.

[nirmal kumar]

Hi All,

Can any body tell me how to click this link for starting my exam.
Iam able to see the below link and not able to execute it.
Active Labs
Start "MySQL DBA 5.1 Exam" Lab Session

Regards,
Nirmal Kumar

--- On Tue, 9/29/09, Suresh Kuna <sureshk...@gmail.com> wrote:

[Suresh Kuna]

Hi Nirmal,
After login with your id and pwd, Click the link Start "MySQL DBA 5.1 Exam" Lab Session, it take to a window where you can click "start exam".

Thanks
Suresh Kuna

--
Regards,
Suresh Kuna

[nirmal kumar]

Hi Suresh,
Can u give ur cell number..
Regards,
Nirmal Kumar

> > Rohit Vachhani <rohi...@gmail.com>

[Suresh Kuna]

9535275987

> > Rohit Vachhani <rohit.vi@gmail.com>

--
Regards,
Suresh Kuna