Thursday, August 7, 2008

Top 100 Oracle Questions Asked in Actual Interviews


What is Trigger at one Line?
http://www.coolinterview.com/interview/11340

Explaint the nvl2 function
http://www.coolinterview.com/interview/10943

If the application is running very slow? At what points you need to go about the database in order to improve the performance?
http://www.coolinterview.com/interview/10944

Explaint the nvl2 function
http://www.coolinterview.com/interview/8550

I want to know that..is there any special way to login into oracle SQL*PLUS Editor directly..Rather than every time u have enter user,password,host string…what should i do with login.sql script.. i Put it in /Bin directory..but not working..
http://www.coolinterview.com/interview/8551

I have a server with 2GB RAM.Who is the optimal size for the shared pool size The shared pool reserved size is 1/10 to shared pool size Is there a mathematic type for compute the shared pool size ?
http://www.coolinterview.com/interview/8552

How to get a calender in date field in oracle forms?
http://www.coolinterview.com/interview/8553

What is the difference between Anonymous Block and subprogram? Can we call a procedure from Anonymous PL/SQL block?
http://www.coolinterview.com/interview/8554

Explain truncate with restore option with example
http://www.coolinterview.com/interview/8555

List out differences between Oracle Server 9i and Oracle Server 10g.
http://www.coolinterview.com/interview/8556

What is the difference between object library and pl/sql library
http://www.coolinterview.com/interview/8557

How many codds rule should oracle satisfies
http://www.coolinterview.com/interview/8558

What is the process of upgrading oracle forms /reports from older version to new versions?
http://www.coolinterview.com/interview/8559

What is the difference between groupby and orderby?
http://www.coolinterview.com/interview/8560

List components of an Oracle instance?
http://www.coolinterview.com/interview/4611

Which background process and associated database component guarantees that committed data is saved even when the changes have not been recorded in the data files?
http://www.coolinterview.com/interview/4612

What is the maximum number of database writer processes allowed in an Oracle instance?
http://www.coolinterview.com/interview/4613

Which background process is not started by default when you start up the Oracle instance?
http://www.coolinterview.com/interview/4614

Describe a parallel server configuration.
http://www.coolinterview.com/interview/4615

Choose the right hierarchy, from largest to smallest, from this list of logical database structures.
http://www.coolinterview.com/interview/4616

Which component of the SGA contains the parsed SQL code?
http://www.coolinterview.com/interview/4617

Name the stages of processing a DML statement. What stages are part of processing a query?
http://www.coolinterview.com/interview/4618

Which background process is responsible for writing the dirty buffers to the database files?
http://www.coolinterview.com/interview/4619

Which component in the SGA has the dictionary cache?
http://www.coolinterview.com/interview/4620

When a server process is terminated abnormally, which background process is responsible for releasing the locks held by the user?
http://www.coolinterview.com/interview/4621

What is a dirty buffer?
http://www.coolinterview.com/interview/4622

If you are updating one row in a table using the ROWID in the WHERE clause (assume that the row is not already in the buffer cache), what will be the minimum amount of information read to the database buffer cache?
http://www.coolinterview.com/interview/4623

What happens next when a server process is not able to find enough free buffers to copy the blocks from disk?
http://www.coolinterview.com/interview/4624

Which memory structures are shared? Name two.
http://www.coolinterview.com/interview/4625

When a SELECT statement is issued, which stage checks the user’s privileges?
http://www.coolinterview.com/interview/4626

Which memory structure records all database changes made to the instance?
http://www.coolinterview.com/interview/4627

What is the minimum number of redo log files required in a database?
http://www.coolinterview.com/interview/4628

When are the system change numbers assigned?
http://www.coolinterview.com/interview/4629

Name the parts of the database buffer pool.
http://www.coolinterview.com/interview/4630

List all the valid database start-up option?
http://www.coolinterview.com/interview/4631

Which two values from the V$SESSION view are used to terminate a user session?
http://www.coolinterview.com/interview/4632

To use operating system authentication to connect the database as an administrator, what should the value of the parameter REMOTE_LOGIN_PASSWORDFILE be set to?
http://www.coolinterview.com/interview/4633

What information is available in the alert log files?
http://www.coolinterview.com/interview/4634

Which parameter value is use to set the directory path where the alert log file is written?
http://www.coolinterview.com/interview/4635

Which SHUTDOWN option requires instance recovery when the database is started the next time?
http://www.coolinterview.com/interview/4636

Which SHUTDOWN option will wait for the users to complete their uncommitted transactions?
http://www.coolinterview.com/interview/4637

How do you make a database read-only?
http://www.coolinterview.com/interview/4638

Which role is created by default to administer databases?
http://www.coolinterview.com/interview/4639

Which parameter in the ORAPWD utility is optional?
http://www.coolinterview.com/interview/4640

Which priviledge do you need to connect to the database, if the database is started up by using STARTUP RESTRICT?
http://www.coolinterview.com/interview/4641

At which stage of the database start-up is the control file opened?
http://www.coolinterview.com/interview/4642

13. User SCOTT has opened a SQL * Plus session and left for lunch. When you queired the V$SESSION view, the STATUS was INACTVE. You terminated SCOTT’s session in V$SESSION?
http://www.coolinterview.com/interview/4643

Which command will “bounce” the database-that is, shut down the database and start up the database in a single command?
http://www.coolinterview.com/interview/4644

15. When performing the command SHUTDOWN TRANASACTIONAL, Oracle performs the following tasks in what order?
http://www.coolinterview.com/interview/4645

How many panes are there in the Enterprise Manager console?
http://www.coolinterview.com/interview/4646

Using SQL*Plus, list two options which show the value of the parameter DB_BLOCK_SIZE?
http://www.coolinterview.com/interview/4647

When you issue the command ALTER SYSTEM ENABLE RESTRICTED SESSION, what happens to the users who are connected to the database?
http://www.coolinterview.com/interview/4648

Which view has information about users who are ghranted SYSDBA or SYSOPER privilege?
http://www.coolinterview.com/interview/4649

Which DB administration tools are included in the DBA Studio Pack?
http://www.coolinterview.com/interview/4650

How many control files are required to create a database?
http://www.coolinterview.com/interview/4651

Which environment variable or registry entry variable is used to represent the instance name?
http://www.coolinterview.com/interview/4652

. What is the recommended configuration for control files?
http://www.coolinterview.com/interview/4653

You have specified the LOGFILE clause in the CREATE DATABASE command as follows. What happens if the size of the log file redo0101.log, which already exists, is 10MB?
http://www.coolinterview.com/interview/4654

Which command should be issued before you can execute the CREATE DATABASE command?
http://www.coolinterview.com/interview/4655

Which initialization parameter cannot be changed after creating the database?
http://www.coolinterview.com/interview/4656

What does OFA stand for?
http://www.coolinterview.com/interview/4657

When creating a database, where does Oracle find information about the control files that need to be created?
http://www.coolinterview.com/interview/4658

Which script creates the data dictionary views?
http://www.coolinterview.com/interview/4659

Which prefix for the data dictionary views indicate that the contents of the view belong to the current user?
http://www.coolinterview.com/interview/4660

Which data dictionary view shows information about the status of a procedure?
http://www.coolinterview.com/interview/4661

How do you correct a procedure that has become invalid when one of the tables it is referring to was altered to drop a constraint?
http://www.coolinterview.com/interview/4662

Which event trigger from the following cannot be created at the database level?
http://www.coolinterview.com/interview/4663

How many data files can be specified in the DATAFILE clause when creating a database?
http://www.coolinterview.com/interview/4664

Who owns the data dictionary?
http://www.coolinterview.com/interview/4666

What is the default password for the SYS user?
http://www.coolinterview.com/interview/4667

Which data dictionary view provides information on the version of the database and installed components?
http://www.coolinterview.com/interview/4668

What is the prefix for dynamic performance views?
http://www.coolinterview.com/interview/4669

Which clauses in the CREATE DATABASE command specify limits for the database?
http://www.coolinterview.com/interview/4670

Which clauses in the CREATE DATABASE command specify limits for the database?
http://www.coolinterview.com/interview/4671

Which optional component in the database creation process sets up functions and procedures to store, access, and analyze data needed for Geographical Information Systems (GIS)?
http://www.coolinterview.com/interview/4672

What is the best method to rename a control file?
http://www.coolinterview.com/interview/4673

What piece of information is not available in the control file?
http://www.coolinterview.com/interview/4674

When you create a control file, the database has to be:
http://www.coolinterview.com/interview/4675

Which data dictionary view provides the names of the control files?
http://www.coolinterview.com/interview/4676

The initialization parameter file has LOG_CHECKPOINT_INTERVAL = 60; What does this mean?
http://www.coolinterview.com/interview/4677

Which data dictionary view shows that the database is in ARCHIVELOG mode?
http://www.coolinterview.com/interview/4678

What is the biggest advantage of having the control files on different disks?
http://www.coolinterview.com/interview/4679

Which file is used to record all changes made to the database and is used only when performing an instance recovery?
http://www.coolinterview.com/interview/4680

What will happen if ARCn could not write to a mandatory archive destination?
http://www.coolinterview.com/interview/4681

How many ARCn processes can be associated with an instance?
http://www.coolinterview.com/interview/4682

What are the valid status codes in the V$LOGFILE view?
http://www.coolinterview.com/interview/4683

If you have two redo log groups with four members each, how many disks does Oracle recommend to keep the redo log files?
http://www.coolinterview.com/interview/4684

What happens if you issue the following command? ALTER DATABASE ADD LOGFILE (‘/logs/file1’ REUSE, ‘/logs/file2’ REUSE)
http://www.coolinterview.com/interview/4685

Which two parameters cannot be used together to specify the archive destination?
http://www.coolinterview.com/interview/4686

What packages are associated with the LogMiner utility?
http://www.coolinterview.com/interview/4687

Querying which view will show whether automatic archiving is enabled?
http://www.coolinterview.com/interview/4688

If you need to have your archive log files named with the log sequence numbers as arch_0000001, arch_0000002, and so on (zero filled, fixed width), what should be the value of the LOG_ARCHIVE_FORMAT parameter?
http://www.coolinterview.com/interview/4689

List the steps needed to rename a redo log file.
http://www.coolinterview.com/interview/4690

Which parameter is used to limit the number of dirty buffers in the buffer cache, thereby limiting the time required for instance recovery?
http://www.coolinterview.com/interview/4691

Create a statement that will add a member /logs/redo22.log to log file group 2.
http://www.coolinterview.com/interview/4692

When does the SMON process automatically coalesce the tablespaces?
http://www.coolinterview.com/interview/4693

Which operation is permitted on a read – only tablespace?
http://www.coolinterview.com/interview/4694

How would you drop a tablespace if the tablespace were not empty?
http://www.coolinterview.com/interview/4695

Which command is used to enable the auto-extensible feature for a file, if the file is already part of a tablespace?
http://www.coolinterview.com/interview/4696

13. The database block size is 4KB. You created a tablespace using the following command. CREATE TABLESPACE USER_DATA DATAFILE ‘C:/DATA01.DBF’; If you create an object in the database without specifying any storage parameters, what will be the size of the third extent that belongs to the object?
http://www.coolinterview.com/interview/4697

Related Articles :


Stumble
Delicious
Technorati
Twitter
Facebook

0 comments:

Post a Comment

Career Launchers!!!

Note:

This blog can be viewed using all the browsers but can be best viewed in Mozilla Browser.
 

Career Launchers!!! Copyright © 2010 LKart Theme is Designed by Lasantha