Tuesday

Oracle Database

Q: What is an Oracle instance?

Every running Oracle database is associated with an Oracle instance. When adatabase is started on a database server (regardless of the type of computer),Oracle allocates a memory area called the System Global Area (SGA) and starts one or more Oracle processes. This combination of the SGA and the Oracle processes is called an Oracle instance. The memory and processes of an instance manage the associated database’s data efficiently and serve the one or multiple users of the database.
The Instance and the Database
After starting an instance, Oracle associates the instance with the specified database. This is called mounting the database. The database is then ready to be opened, which makes it accessible to authorized users.
Multiple instances can execute concurrently on the same computer, each accessing its own physical database. In clustered and massively parallel systems (MPP),the Oracle Parallel Server allows multiple instances to mount a single database.
Only the database administrator can start up an instance and open the database.If a database is open, the database administrator can shut down the database so that it is closed. When a database is closed, users cannot access the information that it contains.
Security for database startup and shutdown is controlled via connections to Oracle with administrator privileges. Normal users do not have control over the current status of an Oracle database.

Q: What is a view?

A view is a tailored presentation of the data contained in one or more tables(or other views). Unlike a table, a view is not allocated any storage space, nor does a view actually contain data; rather, a view is defined by a query that extracts or derives data from the tables the view references. These tables are called base tables.
Views present a different representation of the data that resides within thebase tables. Views are very powerful because they allow you to tailor the presentation of data to different types of users.
Views are often used to:
• provide an additional level of table security by restricting access to a predetermined set of rows and/or columns of a table
• hide data complexity
• simplify commands for the user
• present the data in a different perspective from that of the base table
• isolate applications from changes in definitions of base tables
• express a query that cannot be expressed without using a view

Q: What is referential integrity?

Rules governing the relationships between primary keys and foreign keys of tables within a relational database that determine data consistency. Referential integrity requires that the value of every foreign key in every table be matched by the value of a primary key in another table.

Q: What is a cursor?

A cursor is a private sql work area used to perform manipulations on data using pl\sql, mainly used for multiple row manipulations and locking columns. Data which is populated into the cursor is known as active dataset.
Cursors are of two types
1.implicit
2.explicit

Implicit———attributes or properties for implicit cursor
1.sql%is open:attribute returns a boolean value stating wether the cursor is open or closed.
2.sql % found: returns boolean value stating whether the record is found in the cursor.
3.sql%notfound : returns a boolean value stating whether the record is not found in the cursor
4.sql %rowcount :returns a pneumeric value stating no.of rows executed in the cursor.

Explicit cursors—retrives multiple rows, users can perform locks on th data in the cursor attributes-
1.% is open
2.% found
3.% not found
4.% rowcount

WE CAN WRITE TWO CURSORS IN ONE PROGRAM
WE CAN WRITE A CURSOR SPECIFYING PARAMETERS
CURSOR WITH UPDATE CLAUSE IS USED TO PERFORM LOCKS ON DATA.

Q: Why Use Sql* Loader in Oracle Database?

The Sql Loader utility loads data into an existing ORACLE table from an external files.It is available locally only on CMS and PCs with oracle version
There are several methods other than using SQL *Loader of inserting data into a table.
1. The Sql insert command may be used from the SQL * Plus module, for Example :
insert into CAR values(…) where the values to be inserted into a row of the table are listed inside the parentheses. Dates and Characters data must be Surrounded by single quotes; items are seperated by commas.
2. Sql*Forms allows you to add rows interactively using forms. The forms may contain default values and checks for invalid data.
3. ODL loads the table from a control file and separate fixed format data file. ODL is available on all versions of ORACLE .

SQL * Loader is much more flexible than ODL and will eventually supersede it on all systems.

12 comments:

Anonymous said...

Like all warts, they are harmless growths which will probably go away by themselves or with
minimal treatment, but their location and the amount of pain involved makes them difficult to
ignore. Where diagnosis proves particularly difficult it may be arranged that
you have a small biopsy. Forget all the claims that you hear and read about online.


Feel free to visit my weblog - wartrol

Anonymous said...

Get a test together with her menu for breakfast gadgets.

This, in turn, helps in thinning along the
bloodstream, thus helping in effective operating of
insulin. Keep yourself well-informed about
your daily diet.

Here is my website - http://howtocurediabetestype12.wordpress.com/ (www.grandecrispo.it)

Anonymous said...

Ridiculous story there. What occurred after?
Take care!

Also visit my web blog กระปุกครีม

Anonymous said...

Every thing that functions prior to jailbreaking continues to work
following. It also enables you to resize and conceal
the icons of couple of apps. Verify out the video of it working on an iPod Contact 4G.


Feel free to visit my page ... appcake

Anonymous said...

I was able to find good advice from your blog posts.

Here is my web page ... throne rush hack toolthrone rush cheats ()

Anonymous said...

I needed to thank you for this fantastic read!! I certainly loved every little bit of it.
I have got you book marked to check out new stuff you post…

Also visit my blog post - แร็คเถื่อน

Unknown said...
This comment has been removed by the author.
Anonymous said...

Really nice questions and answers about financials. It can help in an interview a lot. Thanks for sharing. Oracle R12 Financials Training in Hyderabad

yanmaneee said...

yeezy
golden goose sneakers
moncler jackets
golden goose sneakers
goyard handbags
golden goose
goyard
goyard handbags
golden goose
golden goose outlet

yanmaneee said...

nike air vapormax
balenciaga sneakers
jordan shoes
yeezy boost 500
lebron shoes
yeezy shoes
fila
off white shoes
off white hoodie
hermes birkin

Unknown said...

d4p94z5d12 m9k27m4p52 o7f31j3e81 w9w31v7p94 x7j69d7w87 u1y65t4i07

Anonymous said...

off white clothing
off white clothingoutlet
kd 14
off white jordan 1
michael jordan shoes
air jordan 1
jordan shoes
supreme hoodie
off white hoodie
goyard bag

Followers