NASHIM_ORACLE: MNC Interview Questions

MNC Interview Questions

All the questions are typed by candidates who attended the interview. So there may be typo errors and alignment problems. Working on these issues. Sorry for the inconvenience. Also we will give solutions to these question soon…
POLARIS

Daily Activities – Asked about Servers, Escalation Levels & Backup Strategies used
Database creation steps (in Windows)
Browsing d ORACLE Architecture with select & update queries
About Listener’s requirement, usages & its feature in 9i, its Location & about its contents
Default port no for listener in windows
An user complains that he isnt able to connect with listener with that port, whereas other users are getting connected. How to react in such cases
About Library Cache function for a query
what is Hashvalue; How is it generated & where 2 find them (views)
About DBBC’s Classifications, its default sizes
Pinning a table in Keep & How should we know that we have to pin the table
About Recycle Pool, LRU lists description
DBBC of 4mb size & 1gb table; How this table will be used in DBBC!
Statspack Installation Steps; About spcreate.sql location; Def. tablespace, if not allocated, what will happen; Taking snaps; Generating reports
About Optimizer Modes classifications with its usages
Changing DB mode – to Archivelog
About DBMS Job Scheduling & Crontab
LMT & DMT’s Differences
Exp/Imp parameters; Def value for statistics in both Exp/Imp
Exp parameter – Direct, consistent
Imp Parameter – commit, about questionable statistics error..
About PCTUSED, PCTFREE in block level
Finding schma level object’s size (from dba_segments)
Steps for Installation of Oracle on Linux
Errors during installation; About connecting to a remote machine
Knowledge of Installing in Silent mode
Patch Upgradation steps; & About metalink
Migration Steps
User Creation with def. tbs, temp tbs & Quotas
About Password authendication; Using O/S authendication in it (parameters)
To felicitate analyzing all objects for a particular user, what we need to do.

EIFCON
1.what is the difference between 8i,9i,10g?
2.Explain abt datapump?
3.explain consistancy parameter in exp?
4.explain 01555 error?
5.explain Hit ratio?
6.explain incremental backup in rman? differential backup in rman?
7.Rman metadata has been backed up in to the tape, now in the recovery
catalog 3 days data has been lost, how would you recover the data from
tape to recovery catalog?
8.tell abt db migration?is it startup pfile=’old path ‘ migrate or
upgrade?
9.How would you reduce the size of a table?
10.A query takes only 5min., it is been running fine for the past 10
day, but today it took 45min to ran? query is not modified?why?
11.How do i find no. of users loged in to the database? both in os
level and database level??
12.i have 8 processors in my server, how many license should i suppose
to get?
CYPERSS
1. How will you refresh the schema from oracle9i to oracle 8
2. What is PMON, SMON, checkpoint, dbwr?
3. What is tablespace?what are the types of tablespaces?what is the advantage of LMT over DMT?
4. What is cost optimization?
5. What is trigger? Types of Triggers? What is the use of trigger?
6. What is cursor? Types of Cursors? What is the use of cursors?
7. Tell one toughest situation that you have faced?
8. What is parameter file? What are the ma parameters?
9. How will you install oracle? What are the parameters that need to be checked?
10. How will you analyze index?
11. Difference between truncate and delete? (Space storage).
12. What is the size of the datatypes?
CitiBank
1. About Ticketing tool; And what does it contain; like, only errors or errors with description
2. When do we know to analyze a table
3. Which query is taking a long time to execute
4. About TKProf; When ll we go for it & how 2 implement the same; What we see from TKProf
5. How 2 know about, which particular session & 2 which user, 2 trace and then & how 2 implement it
6. Should tracing be set at instance level or at session level; Why;
7.Patch upgradation steps
8.Knowledge of applying OS Patches for Oracle
9.Difference between Roles & Profiles
10.How 2 allocate quotas for a particular user
1.Important Pfile parameters & Database creation steps in Linux
2.To install a new version (software alone), 9204, over an existing version, 9201, what are the steps.
3.Steps for user creation with def. tblsp, temp tblsp, quotas
4.What Default role you ll give to that user
5.Some System privileges & object priveleges (DML- insert, update)
6.Full Export Privilege
7.extend management- local & uniform size- 10m for a tablespace; a table with initial 100m is created; how many extends will get allocated during object creation
8.How to access a table in schema B off Tablespace B from schema A off Tablespace A
9.Steps for relocating a datafile
10. Steps for adding a datafile to a tablespace – what prechecks has to be done before that
11. Moving a table from a tablespace A to tablespace B
12. Moving an index across tablespaces
13. Installation of Statspack
14. Hot Backup procedure
15.Where do we find abt a particular datafile needs recovery
16. Shutdown options & How to find current version
17.To see the current active session
18.Checking bgprocess status for a particular DB;
19. What is listener & What infos are in listener.ora & tnsnames.ora
AIG
1. What is Normalization?
2. What is boyce code Normal Form?
3. What is your daily routine?
4. What is the package to be installed before installing oracle into linux?
5. How will you login into sqlplus?
6. How will you do sql tuning?
7. If table contains index and index is not used what will you do?
8. What is the difference between Statspack and AWR?
9. How will you generate statspack report?
10. What will you see in statspack report?
11. What is the content of control file in sql*loader How will you find
whether the data is loaded properly what is that file name?
12. One export dump is there how will you import it?
13. Difference between view and materialized view?
14. How will refresh a view and where is a log located?
15. Can you delete a log?
16. How many times a refresh is done?
17. Can you export a table that contains constraints what is the
parameter?
18. How will you analyze an object?
19. What will you do if there is any fragmentation?
20. How will you set up a sql tuning?
21. What is the related parameter to Optimizer_index_cost_adj?
22. What are all export and import parameter?
23. What shell programming you know?
CTS
1. What is ASSM? What is the important parameter in ASSM?
2. Temporary tablespace is corrupted,what happened in database level? how to recover that tablespace? If need any recovery?
3. What is the Critical situation which you are facing in your Environment?
4. What is sql_redo & sql_undo in logmnr_contents? what is this use in table recovery?
5. In tbs begin backup mode,It is possible to add datafiles?
6. What are the tuning commands available in linux?
7. What is glance command in linux?
8. How to see wait events other than statspack?
9. What will you see in v$session_events , v$system_events & v$ session_wait?
10. In rman backup, some of the archive log files are missing,rman will continue the process or not?
11. How to tune the query? How long a time taking that query before & after the tuning?
12. Which one is best in v$sql_text,v$ sql_area & v$sql? Why?
13. Which join method is best in tuning? Why?
14. What are the errors occurring frequently in Alert logfiles?
15. How to solve dead lock errors?
16. What is the difference between backupset & image copy?
17. What is the incremental checkpoint?
18. How to solve db file scattered read & db file sequential read?
19. How to configure retention time in rman?
20. How to clone the db using rman?
21. How to clone the db without downtime?
22. How to view user transactions?
23. What is obsolete & expired command in rman?
24. How to stop archive apply in standby database?
25. How to add datafile in standby database( standby_file_ management= manual.)
26. How to add archive log files in standby database if missing?
27. What is DBWn & LGWr?
28. How to change LMT to DMT?
29. What are the types of DB link?
30. What is use of query_rewrite_ enabled parameter?
31. What are types of partitioning?
32. In hash partitioning, how data’s are partitioned internally?
33. In Range partitioning, table partitioned using the values (Jan + 15 days in Feb) & (Feb 15 days + Mar) how to partitioned that table using Feb values only?
34. How to partition the non-partitioned table?
35. What is the difference between patches & patchset?
36. Tell me the full syntax of tablespace creation?
37. Which value is best for Cursor_sharing parameter in OLTP env/why?
38. Why less redo generated, in rman hot backup?
39. How to know oracle to need Instance recovery?
40. When to switchover the databases(scenario) ?
41. What is latches?
42. How to transport the read-only tablespace to new location?
43. User inserts some rows into table, it taking more long times, why?
Finch
1. what is delayed block clean out? ans : to increase the commit frequency… (to avoid)
2. what types of patches? o patch, cpu patch
3. what is the most important kernal parameter for installing the oracle? shmmax ,shmni
4. can restore the back up of rman for recover the database? yes
5. what is your back up stratagy? daily export , weekly hot backup
6. what is the difference between hotcloning and cold cloning? what is the syntax?
7. can u write a shellscript for backup, db startup?
8. what is deadlock explain it?
9. explain about snap shot too old error?1555
10.how will u resize the logsize? suppose i have 30mb log i want 50mb so what i have to do?
11.what is consistent=y in export?
12.for installing the oracle what package have to run? for what purpose?
13.what is database incarnation?
14.what is the view for session?
15.explain about split block concept?
16.what is resumable in export?
17.how will u configure the rman for backup?
18.do u know about the standby concept?
19.what do you know by configure the kernal parameter?
20.how will u monitor a db?
21.what are the major steps for upgrade the db as a dba?
22.what kind of query tunning have u done?
23.what is hitratio? suppose hitratio is 40% it is good or bad? ans: bad
24.how many database you are monitoring?
25.what will u see in the statspack report?
26.how will u tune the query with the help of statspack report?
27.what are the minimum things for upgrade the db?
28.what is pga what are the parameter for that?
29.how will you configure the tnsname and listerner ?
30.what is the relation between rman and block corruptions?
31.what is miss ratio?
32.what is the 10g features?
FORD
1. If a user clicks a button to view a report. It takes longer time to get the report. How will you identify the query that is taking longer time to retrieve the output?
2. What is the Linux script to capture an error message in alert. log and needs to be posted in mobile.
3. Write a shell script to do an health check for 1400 databases.
4. (displaying alert.log,tablespace size, database size)
5. If the archive log destination is filled, database is hanging. What is the solution?
6. Where will you get the various instance names in Linux? What is the name of the text file?
Scenario:
A tablespace is of size 100MB.That Tablespace is filled and hence throwing an error like “unable to extent”. But verified that there is around 20MB freespace present in the tablespace.what is the reason behind this error?
1.Row migration and row chaining?
2.Pctfree and the block parameters?
3.Recovery scenarios:
a) A disc that contains the backup of two
datafiles (non system) got currupted, how would you
recover?
b) Archive log file ( of LSN no 43) corrupted what will you do?
4.How would you set a database to Archivelog mode
and how would you start the Archiver process?
5.Size of the database and how often Backup( Backup
strategies)?
6.Deadlock situation explain?
7.Linux command for IO statistics?
8. Pl sql packages to analyze the table and indexes?
9.RAC and RMAN – but I said I dont know.
10.Tkprof syntax including parameter to do tkprof
on diff users?
11. statspack report and the imp events?
12. explain plan syntax? how often we take?
13. Profile for users? explain?
7. crontab —- how will u use it? (or) have u
used crontab?
8. Difference between direct and buffer?
9. when using direct object does not gets exported
or imported why is tat so?
10. what do u mean by fractured block?
11. Default size for DBBC?
12. Have u worked in a ticketing system?
13. In solaris OS how can determine OS level locks?
(or) where can u find them?
14. Have u used statspack, when do u go for it and
wat is the purpose and
what can u find in it? and some wait events?
one of my colleague (ie) he is also a DBA by
mistake he has deleted a datafile you
come in the next shift and find that users
are complaining that they are not able to
access the data, what will u do?(wat all the
steps u do)(u have all old backups and all
hot/cold)
1.What is mutation table?
2. what is autonomous transaction?
3.What are the difference between Undo and Rollback Segments?
4.How do we calculate the Undo size?
5.About Dbms_ packages.
6.About UTL_ packages.
7.What are type of Indexes?
8.What is Index Height? In which view it shows?
9.How to view the execution plan? In which view?
10.How to move the table from one tablespace to other? What happens when it moves?
11.How to analyze the database,schema,index?
12.What are all the block utilization parameters?
13.How to set a database in archivelog mode,list the parameter to set in init file?
14.How do we find whether the parameter is static or dynamic?
15.How do we find whether our database is startup with pfile or spfile?
16.how do we saw what are all the privileges are granted to a role?
17.what is external table?
18. can we create a table which is not belonging to any of the tablespace?
19.what are the mandatory parameters for export and import?
20.what are the precautions taken while moving tables between tablespaces?
General Questions
1.what is oracle inventory and how could i locate this if i have multiple db’s
Ans.Oracle inventory is used to install and configure oracle s/w and its options.
U can see list of oracle homes under Contents or contents.xml file.
2.how do i find whether my sql query is running or not from command line.
Ans.Join ses_addr from v$transaction and saddr from v$session..
3.suppose i have entered a datafile1.dbf to wrong tablespace named A now i want to move this datafile1.dbf to tablespace B without droping tablespace A.
Ans. Drop and recreate.if u have data in the datafile .. move the data to different tablespace and then drop it..
Oracle RAC Interview Questions
1. What are the major RAC related wait events you see – tuning methods?
2. Why my 2-node RAC peforming worse? Any issue at the inter-connect layer? how to diagnose?
3. What is TAF in RAC and how to configure at server side and client side?
4. What protocol used whilst setting up RAC?
5. How do you propagatee files while installing RAC on different nodes…..what is user equivalence?
6. Why private IP used in RAC and what is the use of VIP defined at client’s side tnsnames.ora?
7. Steps to de-rac a node,what circumstances you’ll recommend it….example,what is diable public thread 2 #
8. Steps to add a new node into RAC
9. crs_stat -t shows target=online and state=offline . What does it mean?
10. How to recover change block tracking file in RAC?
11. What is the use of OCR and voting disks. How many are recommended on each node…?
12. Enqueue : row lock contention is hitting on one of the 2 nodes of my rac cluster…what should be the culprit..and to avoid it?
13. How to copy your ASM files to normal NFS file system in 11g?
14. OCFS to ASM migration…ever worked on…if so,procedure?
15. what are the lib.files required before installing ASM on Linux?
16. srvctl hangs for 30 mins in a powerdown weekend… to bring down cluster..what is the reason ….and what is an interim alternative…you may find and do….?
1.There are no solution for some of the ora-600 errors, wt willl you do
for that?
2.wt would be the dump size of your export file?
3.If a datafile size reached maxsize what will you do , will you do
autoextend or add a datafile?
4.you have given auto extend with maxsize upto 10gb for a particular
datafile, but the particular location has only 5gb, wt will you do?
5.How many datafiles would you add for a particular tablespace?
6.How to create cloning database?
7.While loading bulk load in to a table using sqlloader, dbase becomes
slower, performance decreases, what will you do?
8.Tell the statement for taking full incremental backup in rman?
9. do you know rac, data guard?
10. wt would be the dump size of your export file?
11. If a datafile size reached maxsize what will you do , will you do
autoextend or add a datafile?
12. you have given auto extend with maxsize upto 10gb for a particular
datafile, but the particular location has only 5gb, wt will you do?
13.How many datafiles would you add for a particular tablespace?
14..How to create cloning database?
15.While loading bulk load in to a table using sqlloader, dbase becomes
slower, performance decreases, wt will you do?
Architecture
1. How many memory layers are in the shared pool?
2. Define the SGA and how you would configure SGA for a mid-sized OLTP environment?
3. How does Oracle guarantee data integrity?
4. Explain about the Chained / Migrated Rows
5. What’s the differences between defragmentation (coalescing) and re-organization (rebuilding, moving)?
6. How can I prevent tablespace fragmentation?
7. What are the ways tablespaces can be managed and how do they differ?
8. What are the different types of segments in Oracle?
9. Name and function of oracle background processes?
10. Explain how the Oracle Architecture works?
11. Oracle 10g features over Oracle 9i
12. What is the Flashback Query?
Administration
1. What view(s) do you use to associate a user’s SQLPLUS session with his o/s process?
2. What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
3. In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
4. How would you best determine why your MVIEW couldn’t FAST REFRESH?
5. Which dictionary tables and/or views would you look at to diagnose a locking issue?
6. What query tells you how much space a tablespace named “test” is taking up, and how much space is remaining?
7. Why does Oracle not permit the use of PCTUSED with indexes?
8. From the database level, how can you tell under which time zone a database is operating?
9. What factors need to be considered when adding space to a tablespace?
10. What options do you have when needing to add space to a tablespace?
11. Which Data Dictionary Views do you query when needing to add space to the database?
12. What is a deadlock? What causes it and how can it be resolved?
Backup and Recovery
1. How to export as multiple dump files? How to perform export on platforms where filesize greater than 2 GB is not permitted ?
2. How do you find out from the RMAN catalog if a particular archive log has been backed-up?
3. I have my backup RMAN script called “backup_rman.sh”. I am on the target database. My catalog
4. username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the O/S such that it would run as a background process?
5. How To Do Export/Import, If Source Database Is Newer / Older Than Target Database
6. What is the difference between online and offline backups
7. My database was terminated while in BACKUP MODE, do I need to recover?
8. For an online backup, do you need to put tablespaces hot backup mode when using RMAN?
9. What is media failure, how do you recover from it.
10. How can you speed up database import performance?
11. Which export option could trigger ‘snapshot too old’ error while performing full database export and how do you go about resolving it?
12. How can you improve database export performance?
13. Oracle errors faced – backup errors
Performance Tuning
1. What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
2. Other than making use of the Statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
3. What is the recommended interval at which to run statspack snapshots, and why?
4. What is the difference between DBFile Sequential and Scattered Reads
5. When is cost based optimization triggered?
6. Can one improve the performance of SQL*Loader? How ?
7. What is the difference between Latch and enqueue
8. Which Oracle Tools have you used for tuning or diagnosing performance problems.
9. Which Data Dictionary Views will tell you the current sql loaded in the database? How can you tell which SQL a
session is currently running?
10. Which Data Dictionary Views will tell you the current sql loaded in the database? How can you tell which SQL a session is currently running?
Operating Systems
1. How can you tell how much space is left on a given file system and how much space each of the file system’s subdirectories take-up?
2. How do you tell what your machine name is and what is its IP address?
3. How would you go about verifying the network name that the local_listener is currently using?
4. You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
5. Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
6. How do you increase the OS limitation for open files (LINUX and/or Solaris)?
7. Which file do you modify on Solaris server to set Solaris kernel parameters? And why?
8. Can you tell different commands you can use to copy files from one unix server to other unix sever?
Security
1. What’s your knowledge of security policies, password expiration, etc?
2. What is the least privilege to be granted to a user such that they can log into a database?
3. Have you worked with auditing? If yes, where does the audit trail get written if the AUDIT_TRAIL initialization parameter is set to TRUE?
Oracle RAC
1. Mention the Oracle RAC software components
2. What is GRD
3. Give Details on Cache Fusion
4. Give details on LMON
5. Give details on LMD
6. Give details on LMS
7. What components in RAC must reside in shared storage
8. What is an interconnect network
9. How can we configure the cluster interconnect
10. What is the use of a service in Oracle RAC environemnt?
11. Which enable the load balancing of applications in RAC?
12. What is a virtual IP address or VIP
13. What is the use of VIP?Give situations under which VIP address failover happens
14. What is the significance of VIP address failover?
15. What is FAN?
16. Where can we apply FAN UP and DOWN events?
17. Mention the components of Oracle clusterware:-
18. Name some Oracle clusterware tools and their uses?
19. How do we remove ASM from a Oracle RAC environment?
20. How do we verify that an instance has been removed from OCR after deleting an instance?
21. How do we verify an existing current backup of OCR?
HP FOR DBA’s
General Questions
1. What are the steps to enable password complexity checking?
2. Can you grant DML privileges on a non-administrative schema’s objects using the SYS userid if SYS was not granted explicit privileges on the objects? What system privilege makes it possible?
3. What is a mutating trigger? How would you resolve it?
Change Management
1. Worked on Incident/Change Mgmt?
2. How do handle the Sev1/Sev2 severity based tickets
3. Did you worked on any Monitoring tools
4. Did you worked on Sqlbacktrack/RMAN with TSM/TDPO
5. Did you worked on any DB incident tracker tool
Oracle RAC – L2
1. Why do you have VIP in RAC?
2. How do you shutdown a cluster nodeapps (srvctl stop database -d database -o ommediate)
3. What is the differ between OCFS and ASM…
4. Whats interconnect bonding?
5. What are all the components of nodeapps
6. What is GSD…
7. How will stamp a SAN raw drive to ASM disk? which tool will you use?
8. How will see asm files from linux?
9. Which command will you use to see asm files?
10. Have you ever heard about ASMCMD?
11. What is OCR and voting disk
12. Configure Veritas netbackup to back
13. Configure Veritas netbackup to backup every weekend full backup and every day incr backup
14. How will you plan about archived logs in RAC since you have 3 different thread running on each node..
15. we have to store them into OCFS to make RMAN readable to backup them up
16. Have you did the migration from RAC to RAC
17. Have you did the migration from RDBMS home to RDBMS home
18. What action need to taken if the crusterware got corrupted
19. If the .OCR disk got corruted the CRS services were stuck during bootup
20. What is the purpose of the Oracle Process Manager.
21. Why do you need standby redologs..?
22. How the standby is synced with primany?
23. Why do you NEED standby redologs?
24. How many modes you can keep standby database?
25. If you configure physical standby for max protection..it is advisable to create standby redologs
26. should be max number of log files+1 * num of threads do you know why?
27. Which process does log apply on standby
28. Which oracle data guard dedicated process does recovery on standby
29. Have you ever heard about AWR, ADDM, ASH, ASMM.
Architecture
1. How does propagation differ between Advanced Replication and Snapshot Replication
2. What is mean by cursor sharing explain each types
3. What is mean by TT and how it works?
4. Oracle errors faced – block corruption
5. Explain about the RETENTION GURANTEE in the UNDO
6. Explain about the archiecture and Various 10G hinew Background Process
7. Can You Explain about the Endian Format
8. Can you explain about the DB_FLASHBACK_RETENTION
9. Can you explain about the SQL Files in the DATA PUMP JOBS
10. Explain about the Compatible Parmeter in the Upgrade
Administration
1. Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
2. Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
3. How would you extract DDL of a table without using a GUI tool?
4. How to resolve semaphore and shared memory errors
5. How you fixed any ORA-600 error and how and what you have followed?
6. When do semaphore or shared memory errors most often occur?
7. What is partitioning and explain the types
8. Migration of an Oracle Database
9. What’s the benefit of “dbms_stats” over “analyze”?
10. Describe the procedure for installing the critical patch updates
11. Scenario: OS patching was performed on a server and you need to verify everything is okay with the database afterwards. What kind of things would you do?
Backup & Recovery
1. You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
2. How to export a subset of data from a table ? How do we export a set of records from a table that satisfies a condition.
3. How many server sessions does RMAN use? How can the RMAN server sessions be identified? What is the purpose of each RMAN server sessions? When are the RMan server sessions released?
4. How Do I Recover From Loss of a Active Redo Log Group?
5. How to you move on to next online redo log and archive the current one
6. Scenario: A single datafile gets corrupted and you plan to do online restore and recovery of the file since the database is in ARCHIVELOG mode. You have the datafile restored from tape. You now proceed to recover the datafile with the “ALTER DATABASE RECOVER AUTOMATIC DATAFILE <datafile name>” command.
7. Archive logs are being applied automatically, when, suddenly, the recovery stops because a needed archive log is missing. The missing archive log cannot be found on tape or disk. What steps do you need to take to get the datafile recovered and online
8. Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle’s. What database recovery options are available?
9. Explain how you would restore a database using RMAN to Point in Time?
10. How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
11. How Do I Recover From Loss of an unarchived Redo Log Group?
12. How to Recover From a Lost Datafile That Belongs to the Rollback Tablespace ?
13. How Do I Recover From Loss of a Active Redo Log Group?
14. How to Recover From a Lost Datafile That Belongs to the SYSTEM Tablespace?
15. Expalain about the CTWR process in the 10G
Performance Tunning
1. What is a driving table in a SQL query
2. How do you keep the store PLSQL blocks in memory.
3. A User/Developer calls in saying that their process is running very slow. How would you go about troubleshooting the issue?
4. How would you begin to troubleshoot an ORA-3113 error?
5. An automatic job running via DBMS_JOB has failed. Knowing only that “it’s failed”, how do you approach troubleshooting this issue?
6. You’re getting high “busy buffer waits” – how can you find what’s causing it?
7. Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
8. What would you use to improve performance on an insert statement that places millions of rows into that table?
9. How to get Statspack reports and what you will look into main events
10. How to tune a SQL Queries
11. You’re running a DML statement and you get an error saying the rollback segment cannot extend. What can you do to fix this
Operating Systems
1. What are the difference between RAID 5 and RAID 0+1? Which implementation is better?
2. Major Differences between UNIX and NT for Oracle
3. How would you configure your networking files to connect to a database by the name of DSS which resides in
4. domain icallinc.com?
5. If you’re unsure in which script a sys or system-owned object is created, but you know it’s in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
6. How does dbstart/dbshut know which databases to start/stop?
7. Can you tell name and directory location of some of the most important files used to implement automatic startup and shutdown of Oracle instances during UNIX system startup or shutdown?
8. How would you prevent unauthorized use of privileges granted to a Role?
</tr>
IBM Bang @ Telecon (20 Mins)
1. How many databases maintained by myself & its sizes.
2. How to check the sizes available in the mount points
3. Alert log’s location
4. About Alertlog’s errors
5. Will checkpoint completion entries will be recorded in alertlog
6. Knowledge about 1200 series errors
7. About Error 0600, 1555
8. What do you know about v$session_longops
9. A Query usually executes for 3 hrs; but sometimes it takes, say, for 6 hrs; In Steps
10. How to know whether a particular query/transaction has finished some, say, x% of its 100%
11. To check how many databases are present (that are up)
12. How to calculate the size of a table (DBA_Segments)
13. How to check whether a checkpoint is completed or not (in which view)
14. What is checkpoint
15. Locks & Enqueues
16. How 2 check whether d database is in ArchiveLog mode
17. Export option: consistent=y
18. Hot Backup Steps
19. What happens during tablespace begin backup
20. Knowledge in Tuning; statspack – For eg; About DB_file_scattered_read
In Gavs
1. Steps for HOT Backup and Cold Backup?
2. Have u done cloning can u tell steps?
3. Last week sat Hot backup taken this week friday DB crashed
or Datafile crashed what will you do to get the data back?
4. Explain the difference between $ORACLE_HOME and
$ORACLE_BASE ?
5. What is the difference between ALL_, DBA_,USER_,
V$, GV$ views?
6. A table is classified as a parent table and you
want to drop and re-create it. How would you do this
without affecting the children tables?
7. How will you get the script of a table?
8. How do you switch from an init.ora file to a
spfile?
9. How will you find the files of each segments.write
query.
10. How will you find invalid object and make it valid.
11. What are the uses of nologging,Initrans,Maxtrans?
12. How will you find whether the segment locked or
not.How will you resolved it.
13.What is dead lock,How will you find which sql
segment cause dead lock?
14.You have 5 GB of space in your file system on which
the datafiles are scattered as shown below;
System 500MB
Users 1GB
Undo 1GB
Temp 1GB
Tools 1GB
If user needs 1GB of space what he will do within
the file systems. Explain in detail including
comments.
15.Explain the steps to relocated a datafile.
16.How will you find an objectives locks.How will you
resolve it, with steps.
17.Explain Oracle Server and the process in detail.
18.How will you multiplex the control file & log file
for a running database.
19.How will you find the size of the database and what
is its free size.
20.Explain analyse for all segments
21.Explain Undo and rollback segment
22.What are the new features of 9i?
Questions in Import & Export
How will you export two tables from one schema?
How will you export partitions?
How will you import those tables to another database?
What is the import parameter to append the rows to the table?
Scenario:
Source Database with a tablespace t1 – user A – Table tb1.
Destination Database with a tablespace t2 and t1 .T2 possess User A.
How will you import table tb1 from source to destination? You need to import that to T2 tablespace and not T1?
L&T
1. How to recover the lost objects?
2. What are the mandatory background processes?
3. Tell about 10g background process? Explain?
4. What are the major issues faced with your team?
5. What are the major issues faced separately?
6. How frequently you analyze the table in Ur environment?
7. When u will rebuild the index? In what situation u have to rebuild the index?
8. Tell about yesterday in Ur office what u faced the issues?
9. By using Statspack report how to see the Query problem?
10. Totally 8 database how to identify the query problems in each database?
11. Index segment Fragmentation:
How to identify the fragmentation? How to resolve it?
Table segment Fragmentation?
->How to identify the fragmentation? How to resolve it?
export & Import:
i) How to take the export of another user table without knowing the password of the user?
ii) Why we give consistent=Yes and Compress=No? Reason?
14. What is Block Corruption? How to identify & Resolve it manually?
15. In DB verify tools what is the things u seen in that and how to resolve it?
16. Tell me the steps of RMAN cloning?
17. Cold backup steps? Cold Clone steps? What are the major things modify in clone db?
18. Hot backup steps? Hot Clone steps? What are the major things modify in clone db?
19. What are the major things done when we give begin backup?
20. How Frequently we can take the export & import?
21. When the query slow, but the Index also set and has no problems in otherside?
So that situation how we have to resolve it?
22. In statspack what are the things we have to see?
23. RMAN Cloning Steps?
24. In RMAN how we take the backups in ur environment? ( Having any scripts to run)?
25. In RMAN device type DISK / TAPE?
26. In Disk means how much capacity / size?
27. How many times u installed for the past 4 years?
28. How many times u created the database?
29. How you apply patches?
30. Tell me how u faced & rectify the performance tuning?
31. Tell about Upgradation steps?
32. Tell about Migration steps?
33. RMAN Features?
34. In RMAN 2 weeks backup u have to keep. How?
35. In RMAN types of backups?
36. In RMAN tell me the types of errors?
37. In RMAN tell me the report preview concepts?
38. In Datapump, Include and exclude concepts?
39. Dataguard Steps?
40. Explain the three modes of Dataguard?
41. How to insert the bulk data to the table?
MICROSOFT
1) Throughput and response time?
2) One server 10 database and 10 instance ram size
2GB now facing memory problem?
3) OS level 100% CPU utilization and cause is
ORACLE wat will u do?
4) Oracle memory is leaking?
6) Different types of Index?
7) Wat kind of Index is created in Primary Key?
8) Difference between Where clause and Having
Clause?
9) Physical Join and logical join?
10) Acid Property?
Scope International
1. What should be done before installing oracle into linux?
2. What size of database?
3. What will be the size of SGA,DBBC and SP in OLAP and in OLTP?
4. What is the purpose of inittrans when there is a maxtrans parameter?
5. How will you analyze a table and how to find fragmentation?
6. How will you get a table when it is lost?
7. What and all tuning u have done and the steps?
8. What and all u will see in tkprof?
9. How will u set up a statspack report?
10. Explain about busy buffer wait , db file scattered read , db file
sequential read and remedy for them?
11. What are all joining methods explain?
12. what is Dbverify?
13. How will u repair the blocks that gets corrupted found in dbverify?
14. How will you force an index for a table?
15. What is record length in export , import parameter?
16. How will you truncate a 1000 tables from a user?
17. How will rate u in PL/SQL?
Verizon
1.Steps for migration and upgradation of a db?
2.Steps to tune a query and DB?
3.Questions in optimization?
4.Commands in shell scripts– write a shell script to create a file with the name as subha_06_nov_2006.(date should be current date).
5.Questions in Indexes— Hints,Types of hints–usage of it.
6.Space storage in indexes.
Questions in Import & Export
1.How will you export two tables from one schema?
2.How will you export partitions?
3.How will you import those tables to another database?
4.What is the import parameter to append the rows to the table?
Scenario:
1.Source Database with a tablespace t1 – user A – Table tb1.
2.Destination Database with a tablespace t2 and t1 .T2 possesses User A.
3.How will you import table tb1 from source to destination? You need to import that to T2 tablespace and not T1?
Shell Scripts:
1.Awk commands – to filter the delimiters.
2.What is the command to check the running databases?
3.Where will you identify the instances in linux and in Solaris?
4.Command to identify the size of the database in KB?
Os commands:
1.How to kill the process for a particular day?
2.How will you identify the ram size?
3.How will you identify the swap memory?
4.How will you identify the db size?
5.Difference between view and a materialized view?
6.How will you schedule jobs at os level?
7.What are the command prompt utilities in Linux?
8.What are the preliminary things to be set before installing oracle?
9.Which statement consumes more time, whether select or update statement? A table is having millions of rows.
10.What are the various database stages ?
11.What will happen when you have dropped temp files?
12.If your datafile is corrupted how will you recover it?
13.Difference between dbms_jobs and crontab?
Pl/sql:
1.How will you hide a pl/sql block?
Questions in export and import:
1.From user and to user.
Ignore =y.
Indexes:
A user “a” having a table “emp” with two indexes.”a” is creating a table “b” and creating index for the table “b”.User “a” is complaining that he is not able to retrieve the index columns from “b”?
Command prompt utilities:
Exp/imp
Sqlloader
Dbverify
tkprof
Wipro
1. Tell about yourself , company and ur working shortly? 
2. What is your daily routine? 
4. Will you take daily full export? 
5. How will your analyze an object? 
6. What % will you use Estimate statistics? 
9. Is semmnl includes your background process or not? 
10 How will you restore a table when it is lost? 
12. What tuning you have done and Explain? 
13. How will you set up statspack and what and all wait events you have
seen remedy for them? 
14. If there is so much place in system tablespace and it is not used
it throws an error why? 
15. Have you know about RMAN explain how to configure it?

NASHIM_ORACLE

Saturday, 3 May 2014

MNC Interview Questions

MNC Interview Questions

No comments:

Post a Comment

Pages