Data Access Interview Questions

Using pivot option in SQL server 2008.

by using decode function

ps -auxw

Use v$session view.

Here, we can enable the auditing on Database level.
As such we come to know which user has done what tasks and on which objects and at what time.
But for it DB has to be put in auditing mode.

Most simple way is to write an Insert trigger on the table which you want to get audited.

Try and let me know.. surely it will help you..1. Create excel sheet and enter column name with data and save sheet as .csv (employee.csv) extension.2. Open notepad and write theose lines as follows a...

it can be inserted using insert statement :="insert into R1 values('"&A2&"','"&B2&"','"&C2&"','"&D2&...

1)How can restrict the view through view

Adding where clause

2)What does prior statement in pl/sql
Generate hierchy tree

3)What are the different Pragam inPL/sql except Pragam_init,pragma_Automation
Pragma_init - to trap the expection
pragma_automation - to execute the pl/sql block autonomusly.

SQL> create table m( n number);Table created.  1* insert into m values(&1)SQL> /Enter value for 1: 1old   1: insert into m values(&1)new   1: insert into m value...

If you want to delete rows with given DATE

DELETE FROM TABLE_NAME WHERE DATE_COLUMN = GIVEN DATE;



If you want to delete rows >= given DATE

DELETE FROM TABLE_NAME WHERE DATE_COLUMN >= GIVEN DATE;



If you want to delete rows <= given DATE

DELETE FROM TABLE_NAME WHERE DATE_COLUMN <= GIVEN DATE;



If you want to delete rows BETWEEN DATE1 and DATE2

DELETE FROM TABLE_NAME WHERE DATE_COLUMN BETWEEN DATE1 AND DATE2;

Read character column into a PL/SQL table of numeric data type by converting to number, pass the PL/SQL table to JavaScript as a parameter, this is one way.. 

use:

select to_number(rollnumber) from tname order by to_number(rollnumber);

or

select rollnumber from tname order by to_number(rollnumber);

convert the value to integer in java

This error occurs when you try to select rows from a table and try to update the rows of the same table.  Most developers face this problem.  To avoid getting this error, create views,  select the rows from the views, and then try to update the original table rows.

Transaction is a process by which we take the database from one consistent level to another consistent level. A transaction is said to be completed only when we supply COMMIT and apply the changes to the database.

a logical unit of work that comprises dml statements or it is the time between two committs or one and one rollback

Through Dataconnections.

generally we use partinioning for large databases ( if a huge collection of data is there). indexing is the first most process to fast query result,

all dml operations done previsouly makes permanent in hte database

commit ends all previous transactions by making changes permanent in the datafile ( logicaly in tables)

The optimizer determines the most efficient way to use the tables and indexes to complete the request made by an SQL statement after considering many factors related to the objects referenced and the conditions specified in the query.

The operations that the oracle server performs to execute a SQL statement.