How to perform 1st and 2nd normalization? Explain with example.
Latest Answer: For a relation to be in 1st NF the relation should contain atomic attributes
only that is they must be single-valued. If its not so break the composite
attribute into its parts and for multivalued duplicate the tuple with all its
multiple values.
For ...
How to delete duplicate records in Teradata?
What is the difference between choosing a multi dimensional database and a relational database?
Tell the step by step procedure of taking backup of database & restore the same in case of database crash.
Latest Answer: Well there are several methods used to backup and recover the database. So it depends on scenario which methods has to be followed.Go through the link given below to learn more about Backup & Restore:-http://download.oracle.com/docs/cd/B10501_01/server.920/a96519/toc.htm ...
How to monitor the database ?Why shmmax and semaphore parameters are used whenever we are installing database on linux?
Latest Answer: Monitoring the database means providing security to the database, Tuning the database, Creating users and granting privileges to the users, Taking backup and performing recovery operations etc. ...
In SyBase, How we identify which table is replicating to warm standby
How to Connect MySQL with XML?
Latest Answer: use strict; use DBI; my $dbh = DBI->connect ("DBI:mysql:test", "testuser", "testpass", { RaiseError => 1, PrintError => 0}); my $sth = $dbh->prepare ...
How to find Number of Updated rows from a procedure which is having a Update Query?
Latest Answer: Add COUNT keyword to the Update queary by which we can get the number of rows effected by the applied update queary. Else by using the front end code we can call the update queary as string which will run after the loop which will count the rows under ...
How to convert .mdf to .sql or .xml?
What is the main difference between Parallel Exender and previous Parallel Editions?
View page << Previous 1 [2] 3 4 5 6 7 8 9 10 Next >>
Go Top
