-
-
If the entire disk is corrupted how will you and what are the steps to recover the database
gopi
- Mar 7th, 2015
Use disaster recovery just startup stanby database . if the database doesnt have any stanby database, then go to youtube watch funny videos.. and relax
prakashpichika
- Oct 4th, 2006
Entire Disk is corrupted???1) Production database runs on RAID Levels or on HUGE EMC Storage! 2) Changes are less for data loss on all disks - if it's on RAID! Yes - if there is a failure with Disk Co...
-
-
-
How to do the scheduled task/jobs in Unix platform
Nandu
- Aug 11th, 2011
By using the command
crontabmatabrez
- Jan 15th, 2011
Using crontab we can schedule task/jobs to run at particular time, date, day basis. steps. 1. Login to unix 2. At $prompt 'crontab -l' use this command to check what jobs are already schedule...
-
Very next day on the prodction box It looks some procedres/packages got invlidated. What command I should give to know how many packges are invalidated. If suppose thousands are the packages invalidated then what command I should Issut to get then validated.
Sharath
- Jul 27th, 2011
You just validate it.. by using validate procedure and validate package commands.. ok don't worry
vaddapalli
- May 2nd, 2009
we can use the @?/rdbms/admin/utlrp.sqlThe below listed are the scripts that were executed to valid the DBMS_STAT on particular databses.@?/rdbms/admin/dbmsstat.sql@?/rdbms/admin/prvtstas.plb@?/rdbms/admin/prvtstat.plb
-
Schema A has some objects and created one procedure and granted to Schema B. Schema B has the same objects like schema A. Schema B executed the procedure like inserting some records. In this case where the data will be stored whether in Schema A or Schema B
-
Dual table explain. Is any data internally storing in dual table. Lot of users are accessing select sysdate from dual and they getting some millisecond differences. If we execute SELECT SYSDATE FROM EMP; what error will we get. Why
rajesh_bu2001
- Aug 24th, 2009
Dual is a single row table in the system tablespace accessible to all the schema users. Selecting from the DUAL table is useful for computing a constant expression with the SELECT statement. Because D...
P.Sathe
- Jul 19th, 2006
You can issue "sysdate" from any table, but the result will be as many rows as your table , that you used.The whole idea behind using "DUAL" table is to meet the the criteria as defined by RDBMS , that you have to use "Select.. from" syntax to get the values from column.
-
See, If the export dump is in one characterset and the target database which has to be imported is in another characterset how could we import that particular dumpfile into target database ?
aravindhreturns
- Jul 1st, 2009
First look into your character set by using this command:-select * from v$nls_parameters;There will be a character set column in it.Copy it and EXPORT NLS_LANG=(Paste it here before you start your import.)I bet it'll work.
Faraz
- May 24th, 2006
In 10g exp/imp can be used to convert to character set but it can result in some data loss or data corruption.consier also when we are migrating form character set A to set B make sure to avod data loss that B is a superset of A.
-
If the large table contains thousands of records and the application is accessing 35% of the table which method to use: index searching or full table scan
Kedar_Risbud
- Jun 23rd, 2009
Usually, whenever MORE THAN 2 to 4 % of rows in a table are going to be returned by a query, a full table scan is preferred over an indexed scan. So in this case, as 35% of rows of the table are accessed by the application, a full table scan will be used.
Surya Peri
- Feb 18th, 2007
Hi,15% of 100 million rows is still a lot of rows and would take lot of time if there is a full table scan.
-
If you disable the index, can you use it or not?
-
The DBA has added STATE column to the CUSTOMERS table and has asked you to add acorresponding State item to the Customers block of the Orders form. You want to make it easier for order entry clerks to enter the correct state abbreviation. Most customers are located in five southeastern states, although on very rare occasions there will be customers from outside that area. You decide to implement a list item with five values for the State item and allow clerks to enter the state abbreviation director for those customers outside the region.Which style of list item will you create for the State item?
msathishkumar_be
- Mar 12th, 2007
The Combo Box is the best option for this cause it is only accept the user input when compare with other list styles.
-
You are regularly changing the package body part. How will you create or what will you do before creating that package
B.Vijay Karthik
- Aug 25th, 2005
Create package specifications before creatin package body.
-
Explain few Real time scenarios related to deadlock, flashback queries and autonomous transaction
lanka_satya
- Sep 12th, 2008
Mutation of triggers is an example of deadlock.......for flashback we can use to being tables from recyclebin
-
How to check to memory gap once the SGA is started in Restricted mode
-
What are the differences you have seen while installing Oracle on NT and Unix platform
kkalluri
- Oct 27th, 2007
HiI strongly feel, with OUI, installtion is more or less same on Windows and Unix.there is nothing great about Unix installation. krishna
Chiranjeevi Manne
- Mar 30th, 2007
1. installing oracle on Windows is piece of cake which requires less DBA intervention.2. While installing Oracle on Linux is a laborious process which involves ina. creating the groups (oinstall, orac...
-
-
-
-
What are the differences between database designing and database modeling
opbang
- Sep 27th, 2006
Database Modelling is - Logical and Physical Modelling. Logical Modelling is independent of Type of Database.. Once Logical Database Model is built. You can create Phsical Model depe...
dimple
- Sep 8th, 2005
Refer http://www.aisintl.com/case/library/R-Theory_vs_ER/r-theory_vs_er.html it says, database modeling comprises: discovery, design, documentation, communication, DDL generation, re engineering
Real time Oracle Interview Questions
Ans