Follow Us On: Twitter

For Software Jobs

Top 100 Oracle Questions with Oracle Certification link

इस पृष्ठ का हिन्दी अनुवाद
By ⋅ November 11, 2007 ⋅ Post a comment

What is Trigger at one Line?

Explain the nvl2 function


If the application is running very slow? At what points you need to go about the database in order to improve the performance?


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..

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 ?


How to get a calender in date field in oracle forms?

What is the difference between Anonymous Block and subprogram? Can we call a procedure from Anonymous PL/SQL block?

Explain truncate with restore option with example

List out differences between Oracle Server 9i and Oracle Server 10g.

What is the difference between object library and pl/sql library


How many codds rule should oracle satisfy

What is the difference between group by and order by?


List components of an Oracle instance?

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?


What is the maximum number of database writer processes allowed in an Oracle instance?


Which background process is not started by default when you start up the Oracle instance?

Describe a parallel server configuration.

Choose the right hierarchy, from largest to smallest, from this list of logical database structures.

Which component of the SGA contains the parsed SQL code?

Name the stages of processing a DML statement. What stages are part of processing a query?

Which background process is responsible for writing the dirty buffers to the database files?

Which component in the SGA has the dictionary cache?

When a server process is terminated abnormally, which background process is responsible for releasing the locks held by the user?


What is a dirty buffer?

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?

What happens next when a server process is not able to find enough free buffers to copy the blocks from disk?

Which memory structures are shared? Name two.


When a SELECT statement is issued, which stage checks the user’s privileges?

Which memory structure records all database changes made to the instance?

What is the minimum number of redo log files required in a database?

When are the system change numbers assigned?


Name the parts of the database buffer pool.

List all the valid database start-up option?

Which two values from the V$SESSION view are used to terminate a user session?

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?


What information is available in the alert log files?

Which parameter value is use to set the directory path where the alert log file is written?

Which SHUTDOWN option requires instance recovery when the database is started the next time?

Which SHUTDOWN option will wait for the users to complete their uncommitted transactions?
How do you make a database read-only?

Which role is created by default to administer databases?

Which parameter in the ORAPWD utility is optional?

Which privilege do you need to connect to the database, if the database is started up by using STARTUP RESTRICT?

At which stage of the database start-up is the control file opened?

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?

Which command will “bounce” the database-that is, shut down the database and start up the database in a single command?


15. When performing the command SHUTDOWN TRANSACTIONAL, Oracle performs the following tasks in what order?

How many panes are there in the Enterprise Manager console?


Using SQL*Plus, list two options which show the value of the parameter DB_BLOCK_SIZE?


When you issue the command ALTER SYSTEM ENABLE RESTRICTED SESSION, what happens to the users who are connected to the database?

Which view has information about users who are granted SYSDBA or SYSOPER privilege?

Which DB administration tools are included in the DBA Studio Pack?

How many control files are required to create a database?

. What is the recommended configuration for control files?

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?

Which command should be issued before you can execute the CREATE DATABASE command?

Which initialization parameter cannot be changed after creating the database?


What does OFA stand for?

When creating a database, where does Oracle find information about the control files that need to be created?

Which script creates the data dictionary views?

Which prefix for the data dictionary views indicate that the contents of the view belong to the current user?

Which data dictionary view shows information about the status of a procedure?

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?


Which event trigger from the following cannot be created at the database level?


How many data files can be specified in the DATAFILE clause when creating a database?

Who owns the data dictionary?

What is the default password for the SYS user?

Which data dictionary view provides information on the version of the database and installed components?


What is the prefix for dynamic performance views?

Which clauses in the CREATE DATABASE command specify limits for the database?

Which clauses in the CREATE DATABASE command specify limits for the database?

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)?

What is the best method to rename a control file?


What piece of information is not available in the control file?

When you create a control file, the database has to be:

Which data dictionary view provides the names of the control files?


The initialization parameter file has LOG_CHECKPOINT_INTERVAL = 60; What does this mean?


Which data dictionary view shows that the database is in ARCHIVELOG mode?

What is the biggest advantage of having the control files on different disks?

Which file is used to record all changes made to the database and is used only when performing an instance recovery?


What will happen if ARCn could not write to a mandatory archive destination?

How many ARCn processes can be associated with an instance?


What are the valid status codes in the V$LOGFILE view?

If you have two redo log groups with four members each, how many disks does Oracle recommend to keep the redo log files?


What happens if you issue the following command? ALTER DATABASE ADD LOGFILE (‘/logs/file1’ REUSE, ‘/logs/file2’ REUSE)


Which two parameters cannot be used together to specify the archive destination?


What packages are associated with the LogMiner utility?

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?

List the steps needed to rename a redo log file.


Which parameter is used to limit the number of dirty buffers in the buffer cache, thereby limiting the time required for instance recovery?

Create a statement that will add a member /logs/redo22.log to log file group 2.

When does the SMON process automatically coalesce the tablespaces?


Which operation is permitted on a read – only table space?

How would you drop a tablespace if the table space were not empty?


Which command is used to enable the auto-extensible feature for a file, if the file is already part of a tablespace?

Other Related Posts You Might Be Interested In

Don't be the last to know! Keep yourself subscribed either by RSS or e-mail. We will deliver you all the latest news and if you wish you can unsubscribe any time.

RSS

Discussion

No comments for “Top 100 Oracle Questions with Oracle Certification link”

Post a comment

Switch to our mobile site