What is Inversion Key Entry?
Latest Answer: A column or group of columns used to access data from the table very frequently and may not be unique but are potential candidate for creating non-unique indexes on them are known as Inversion Entry key.Inversion Entry key is represented by IE notation. ...
If 1000 users are connected to the db, and Listener is up and running suddenly system is hanging what will do ?
Latest Answer: In real time environment if a DB goes hang or degrades automatically the DB is allocated to next available instance. This is known as RAC i.e Real Application Cluster. ...
Which one is strongest normal form? Why?
Latest Answer: Boyce codd normal form is the strongest normal form......... ...
How to copy database from one machine to another machine in MYSQL? Explain with an example?
Latest Answer: select * from information_schema.tables where TABLE_SCHEMA='test 'into outfile'D:backuptest_backup.sql'; ...
How can I copy a table from one database instance to another database instance
Latest Answer: By using Db link ...
Why do we need a DDL and DML in a database system?
Latest Answer: DDL is nothing but Data Definition Language . It is very important for a dadabase that we have to define the data such that we can create tables , alter tables, ...
What is the difference between Subquery and Corelated Subquery?Give some examples of each
What is the difference between Case and Decode?In what situation we can use Case and Decode
Latest Answer: DECODE works with expressions which are scalar values.CASE can work with predicates and subqueries in searchable form:CASE is an ANSI standard, where as Decode is proprietary for OracleWe can use expressions as part of case statements, where as Decode ...
What is Upper and Lower Checkpoint?
View page << Previous 1 2 3 [4] 5 6 7 8 9 10 Next >>
Go Top
