I would like to know the difference and advantage of using a Hot Backup and a Cold Backup. I also need help to restore the database from the backup without any control files. Can anyone help me on this?

Can anyone brief me what will happen if there is not enough memory space in an SQL server processing a query as hash match? Will it spill to the hard-disc?

Hello and Good Day!

Please list the types of Joins that are used in SQL, Oracle and MYSQL and their advantages and uses. I would also like to know in detail about a scenario in which Right and Left joins are used in the same query.

Is it possible?

Thank you…

Hello there!

I would like to know about Index in detail like its need and types. I also need to know the number of Clustered Index that can be implemented in a table. Also, please enumerate the advantages and disadvantages of creating separate index for each column.

Please guide me…

Thank you…

I need certain clarifications regarding my concerns. Will the rapid clone update both global and local inventory or do we have to do it manually? How can I reduce the patch time? Kindly provide briefing about select statements in sub queries.

Hello!

I would like to know whether it is possible to create temporary MYSQL table like that in SQL Server and Oracle using PL/SQL language.

Will it affect the data fetching speed or time?

Please guide me because im newbie on this…

Thank you…

 I would like to use the Index Scan even though it is costlier. Could you suggest me an init.ora SPfile parameter to force the Cost Based Optimizer (CBO) to make a statement execution path to us an Index?

Hello.  Do you know the process of embedding data from JMP to a webpage?  I want to make my reporting easier and nice since I generate reports on a daily basis using script.  I saw a video which allows a person to view the most recent data being reported/plotted. Really appreciate a quick help on this.

Can we transfer our LANrev databases to another drive or partition?  We are running out of space so we would like to rectify it right away.  Can anyone help us?

Hello,

Scenario – I am trying to update a column in a given table with different values. These values have to be taken from another table in the same database.

Challenge- I want to update these different values in each row using a single update statement.

Looking for – Please suggest me an efficient way of doing this along with an example.