Site Map

techfaq360: Certification Expert

/ 492 pages

Any issue Contact Us at contact@techfaq360.com

Advertise with us, email to contact@techfaq360.com

Free scjp questions,scjp syllabus,scjp 6, scjp5, SCJP Success Kit Free Download, Free SCJP 5.0 Mock Test Exam, Preparation Exam Kit, Free SCJP 6.0 Mock Test Exam,Free SCJP 1.6 Mock Test exam,Free SCJP 1.5 Mock Test exam,SCWCD 5.0 Mock Test, SCWCD 4.0 Mock Test,SCJP 1.4 Mock Test Exam,SCJP 5.0 DUMP,SCJP 6.0 DUMP, scjp mock test,SCJP Mock Exam Questions DUMP,SCJP 5.0 Mock Practice Test, SCJP 6.0 Mock Practice Test, CX-310-065 , CX-310-066 , CX-310-055 , CX-310-056, SCWCD 5.0 Mock Test, SCWCD 4.0 Mock Test, SCJP 1.4 Mock Practice Test, ORACLE Mock Test, OCP Mock Test, JAVA Mock Test, JSP Mock Test,Hibernate Mock Test, Struts Mock Test, Servlet Mock Test,SCJP DUMPS,OCA Mock Test, OCP Mock test

SCJP 5.0 Mock Test Exam, SCJP 6.0 Mock Test Exam,SCWCD 5.0 Practice Mock Test , SCWCD 4.0 Practice Mock Test,SCJP DUMP, scjp mock test,SCJP Mock Exam Questions DUMP,SCJP 1.4 Mock Test Exam

Free Download SCJP 6.0 Mock,SCJP Success Kit, SCJP 5.0 Mock Test Exam, SCJP 6.0 Mock Test Exam,SCJP 1.6 Mock Test exam,OCA ORACLE 10G ADMIN-I Mock Test, 1Z0-043,SCJP 1.5 Mock Test exam,SCWCD 5.0 Mock Test, SCWCD 4.0 Mock Test,SCJP 1.4 Mock Test Exam,SCJP DUMP, scjp mock test,SCJP Mock Exam Questions DUMP, Free OCA ORACLE 10G ADMIN-I Mock Test, 1Z0-043 , Oracle Database 10g Database Administrator Oracle Certified Professional, OCP ORACLE 10G ADMIN-II Success Kit, Oracle Database 10g: Administration II,Mock Practice Exam, 1Z0-042, Oracle Database SQL Expert Mock Exam

Replication Troubleshooting using DBMS_REFRESH:

Apache Tomcat/5.5.15 - Error report

How to retrieve a key and Value from a map ?

How do i include static files within a jsp page ?

Details about load on startup (load-on-startup tag) in Servlet ?

Q.What is Action Class? Explain with Example ?

Difference between session.save() , session.saveOrUpdate() and session.persist()?

Image upload from JSP to DataBase ?

what are Container-Managed Transactional attributes ?

Q. When to Remove messages from the queue ?

Which transformation should we use to normalize the COBOL and relational sources?

What is a container class?

How do you integrate Struts Spring and Hibernate ?

Java Mock test

JSP Mock test

ORACLE Mock test

Free OCA ORACLE 10G ADMIN-I Mock Test Preparation Exam Kit, OCA ORACLE 10G ADMIN-I DUMP, OCA certifications, OCA certification, 1Z0-043 , Free OCA Mock Exam, OCP mock test, OCA OCP DUMP, Oracle Database 10g Database Administrator Oracle Certified Professional, OCP ORACLE 10G ADMIN-II Success Kit, Oracle Database 10g: Administration II,Mock Practice Exam, 1Z0-042, Oracle Database SQL Expert Mock Exam

Free scwcd questions,scwcd books, scwcd 1.5, scwcd 1.4, SCWCD 5.0 Practice Mock Test , Free SCWCD 1.5 Practice Mock Test, CX-310-081, CX-310-083 , CX-310-084, SCWCD 4.0 Practice Mock Test, SCWCD 1.4 Practice Mock Test

Java Script Tutorials

JDBC Tutorials

Freshers/Beginners Interview Questions and Answers

Struts interview questions : Q.What is Action Class? Explain with Example ?

Hibernate interview questions : Difference between session.save() , session.saveOrUpdate() and session.persist()?

ORACLE interview questions : Replication Troubleshooting using DBMS_REFRESH:

JSP interview questions : How do i include static files within a jsp page ?

Servlet interview questions : Details about load on startup (load-on-startup tag) in Servlet ?

Java interview questions : How to retrieve a key and Value from a map ?

Spring interview questions : How do you integrate Struts Spring and Hibernate ?

JMS interview questions : Q. When to Remove messages from the queue ?

EJB interview questions : what are Container-Managed Transactional attributes ?

JDBC interview questions : Image upload from JSP to DataBase ?

C C++ interview questions : What is a container class?

Informatica interview questions : Which transformation should we use to normalize the COBOL and relational sources?

OOPs and Design Pattern interview questions : "is-a" relationship describes inheritance relationship between objects

Technical Articles on Java JSP Servlet Struts Hibernate Spring EJB ORACLE JMS

Java Technology Forum

Technology FAQ | Your Technology Expert

Free scjp questions,scjp syllabus,scjp 6, scjp5,Download SCJP 6.0 Mock,SCJP 5.0 DUMPS, SCJP 6.0 DUMPS, SCJP 6 DUMPS,SCJP 5 DUMPS, SCJP 1.5 DUMPS,SCJP 1.6 DUMPS, SCWCD 5.0 DUMP, SCWCD 4.0 DUMP, SCJP 1.4 DUMPS, ORACLE Mock Test, OCP Mock Test, JAVA Mock Test, JSP Mock Test,Hibernate Mock Test, Struts Mock Test, Servlet Mock Test

Free scjp questions,scjp syllabus,scjp 6, scjp5,SCJP 6.0 Mock Test Exam,Free SCJP Success Kit Free Download, Free SCJP 5.0 Mock Test Exam, Preparation Exam Kit, Free SCJP 6.0 Mock Test Exam,Free SCJP 1.6 Mock Test exam,Free SCJP 1.5 Mock Test exam,SCWCD 5.0 Mock Test, SCWCD 4.0 Mock Test,SCJP 1.4 Mock Test Exam,SCJP 5.0 DUMP,SCJP 6.0 DUMP, scjp mock test,SCJP Mock Exam Questions DUMP,SCJP 5.0 Mock Practice Test, SCJP 6.0 Mock Practice Test, CX-310-065 , CX-310-066 , CX-310-055 , CX-310-056, SCWCD 5.0 Mock Test, SCWCD 4.0 Mock Test, SCJP 1.4 Mock Practice Test, ORACLE Mock Test, OCP Mock Test, JAVA Mock Test, JSP Mock Test,Hibernate Mock Test, Struts Mock Test, Servlet Mock Test,SCJP DUMPS,OCA Mock Test, OCP Mock test

SCJP Practice Mock test

Download SCWCD 4.0 Mock Test Exam, SCWCD 1.4 Mock Test Exam, SCWCD Mock Exam Questions DUMP

why techfaq360

How to Pay - Steps

Free SCBCD Mock Exam , Sun Certified Business Component Developer(SCBCD 5.0) Mock Test, SCBCD Mock test - Free

http://www.techfaq360.com/mocktestfree.jsp?catId=999&index=0

SCJP 1.4 Mock test

SCJP 5.0 , SCJP 6.0 Mock test

Freshers/Beginners Interview Questions and Answers

http://www.techfaq360.com/terms and conditions.html

Download java,jsp,servlet,hibernate,spring,jdbc,jms,struts,oracle,c,c++,informatica interview questions and answers in pdf format

Replication Troubleshooting using DBMS_REFRESH:

How to work with Oracle Data Pump?

dbv: DBVERIFY utility in oracle:

Physical Standby Database Creation in Oracle

Working with AWR - Oracle 10g for Performance tuning in Oracle

DBMS_SCHEDULER in Detail:

How to manually Create Oracle DataBase:

How to create Oracle Database Version: 10.2.0.1.0 in Linux:

Change DB Name in Oracle:

ORA-06502: PL/SQL: numeric or value error in Database Version: 10.2.0.3

Subtracting values in PL/SQL and merging result into cursor or table ----------------------- I am trying to pull in values from two different dates on a table (start and end) and subtract one from the other and store it into my result set which I'll be passing back via a cursor with my PL/SQL procedure. I'm a little stuck on how to accomplish this. Here's what I have so far. The FOR loop doesn't work and it's obviously not the way to go but it represents what I'm trying to get to. CODE: create or replace PROCEDURE BLMROUTING (startDate IN DATE, endDate IN DATE, series IN VARCHAR, p_cursor OUT SYS_REFCURSOR) AS TYPE rec IS RECORD (integ diag.blm_acct.integ_over_val%TYPE, signal diag.PV_SGNL_ID_ASSC.sgnl_id%TYPE, sampleDate diag.blm_acct.smpl_dte%TYPE); TYPE tableResults IS TABLE OF rec; ResultTableStart tableResults; ResultTableEnd tableResults; ResultTable tableResults; BEGIN SELECT tc.integ_over_val, ta.sgnl_id, MAX(startDate) as MaxStartDate BULK COLLECT INTO ResultTableStart FROM diag.pv_sgnl_id_assc ta INNER JOIN diag.series_sgnl_rec_asgn tb ON ta.sgnl_id = tb.sgnl_id INNER JOIN diag.blm_acct tc on ta.pv_id = tc.pv_id WHERE tb.series_id = series ORDER BY disp_ord_nbr; SELECT tc.integ_over_val, ta.sgnl_id, MAX(endDate) as MaxEndDate BULK COLLECT INTO ResultTableEnd FROM diag.pv_sgnl_id_assc ta INNER JOIN diag.series_sgnl_rec_asgn tb ON ta.sgnl_id = tb.sgnl_id INNER JOIN diag.blm_acct tc on ta.pv_id = tc.pv_id WHERE tb.series_id = series ORDER BY disp_ord_nbr; FOR j IN ResultTableStart.FIRST..ResultTableStart.LAST LOOP INSERT INTO ResultTable VALUES (ResultTableStart(j).integ_over_val - ResultTableEnd(j).integ_over_val, ResultTableStart(j).sgnl_id, ResultTableStart(j).MaxStartDate); END LOOP; END BLMROUTING;

What is an PL/SQL Block in Oracle ?

How To Invoke the Original Export Import Utilities?

Migrating a Database across platforms.

Export and Import exp / imp in Oracle

Renaming or Relocating Datafiles belonging to a Single Tablespace

Procedure for transporting tablespaces

Transporting Tablespaces

Increasing or Decreasing the size of a Temporary Tablespace

Temporary Tablespace

Dropping Tablespaces

Renaming Tablespaces

Making a Tablespace Read only.

Taking tablespaces Offline or Online

How To Change System Global Area (SGA) in Oracle?

How To Unlock the Sample User Account in Oracle?

What Operating Systems Are Supported by Oracle Database 10g XE?

What Are the Limitations Oracle Database 10g XE?

What is Oracle Database 10g Express Edition?

What Is Open Database Communication (ODBC) in Oracle?

What Is Transport Network Substrate (TNS) in Oracle?

What Is SQL*Plus?

What Is a Recycle Bin in Oracle?

What Is a Dynamic Performance View in Oracle?

What Is a Static Data Dictionary in Oracle?

What Is an Oracle Data File?

What Is an Oracle Tablespace?

What Is a Table Index in Oracle?

What Is a Database Table in Oracle?

What is a Database Schema in Oracle?

What Is a User Role in Oracle?

What Is the Relation of a User Account and a Schema in Oracle?

What Is a User Account in Oracle?

What is Program Global Area (PGA) in Oracle?

What is System Global Area (SGA) in Oracle?

What Is a Initialization Parameter File in Oracle?

What Is a Server Parameter File in Oracle?

What Is a Parameter File in Oracle?

What Is an Oracle Instance?

What Is an Oracle Database?

What Is Oracle?

What are various constraints used in SQL?

What is pseudo columns ? Name them?

What are the Various Master and Detail Relation ships.

Can a view be updated/inserted/deleted? If Yes under what conditions ?

What is CYCLE/NO CYCLE in a Sequence ?

Explain UNION,MINUS,UNION ALL, INTERSECT ?

What is difference between TRUNCATE & DELETE ?

Which is more faster - IN or EXISTS?

When do you use WHERE clause and when do you use HAVING clause?

What is a join ? Explain the different types of joins ?

What is ON DELETE CASCADE ?

What is difference between UNIQUE and PRIMARY KEY constraints?

What are the advantages of VIEW ?

List few advantages of Stored Procedure.

What is an execution plan? When would you use it? How would you view the execution plan?

What are different normalization forms?

What is normalization?

What are the properties of the Relational tables?

How to know the days or months or years between two employees in emp table?

Please explain Outer Join in SQL

Explain Concept of Self Join

Explain Normal Join

Explain the concept of NULL

Please explain the concepts of transaction, commit and rollback

Emp table had an employee with salary 2000. I issued an update statement to set the salary to 3000. Then I issued a create table statement. However the create table command errored out. I want to rollback the earlier update statement. Can I do that?

What is the difference between Rule based optimization and Cost based optimization in Oracle SQL queries?

What is a Shared Folder?

You get a call from you backup DBA while you are on vacation. He has corrupted all of the control files while playing with the ALTER DATABASE BACKUP CONTROLFILE command. What do you do?

Your users get the following error: ORA-00055 maximum number of DML locks exceeded What is the problem and how do you fix it?

You look at your fragmentation report and see that smon hasn?t coalesced any of you tablespaces, even though you know several have large chunks of contiguous free extents. What is the problem?

You attempt to add a datafile and get: ORA-01118: cannot add anymore datafiles: limit of 40 exceeded What is the problem and how can you fix it?

Where would you look to find out if a redo log was corrupted assuming you are using Oracle mirrored redo logs?

Users aren?t being allowed on the system. The following message is received: ORA-00257 archiver is stuck. Connect internal only, until freed What is the problem?

What file will give you Oracle instance status information? Where is it located?

How can you determine if the SQLNET process is running for SQLNET V1? How about V2?

Users from the PC clients are getting the following error stack:

Users from the PC clients are getting messages indicating :

How can you determine if an Oracle instance is up from the operating system level?

If you aren?t sure what command does a particular UNIX function what is the best way to determine the command?

What does >> do?

What is the easiest method to create a file on UNIX?

What is the finger command?

How can you find your id on a system?

How can you find all the processes on your system?

How can you find dead processes?

What is redirection and how is it used?

The system administrator tells you that the system hasn?t been rebooted in 6 months, should he be proud of this?

What is an inode?

The system has a program that always includes the word nocomp in its name, how can you determine the number of processes that are using this program?

What is the purpose of the grep command?

How do you create a decision tree in a shell script?

Can you remove an open file under UNIX?

What command is used to remove a file?

What command is used to type files to the screen?

How can you determine the number of SQLNET users logged in to the UNIX system?

How can you determine the space left in a file system?

When should you consider denormalization?

What is an artificial (derived) primary key? When should an artificial (or derived) primary key be used?

How should a many-to-many relationship be handled?

What does a hard one-to-one relationship mean (one where the relationship on both ends is ?must?)?

Why are recursive relationships bad? How do you resolve them?

What is an ERD?

Is the following statement true or false: ?All relational databases must be in third normal form? Why or why not?

Describe third normal form?

You have a simple application with no ?hot? tables (i.e. uniform IO and access requirements). How many disks should you have assuming standard layout for SYSTEM, USER, TEMP and ROLLBACK tablespaces?

How many redo logs should you have and how should they be configured for maximum recoverability?

How many control files should you have? Where should they be located?

When should the default values for Oracle initialization parameters be used as is?

OS user should be used for the first part of an Oracle installation (on UNIX)?

You have just started a new instance with a large SGA on a busy existing server. Performance is terrible, what should you check for?

What must be installed with ODBC on the client in order for it to work with Oracle?

When configuring SQLNET on the client what files need to be set up?

When configuring SQLNET on the server what files must be set up?

You have installed Oracle and you are now setting up the actual instance. You have been waiting an hour for the initialization script to finish, what should you check first to determine if there is a problem?

What should be done prior to installing Oracle (for the OS and the disks)?

How do you set up your tablespace on installation?

Define OFA.

You see multiple extents in the temporary tablespace. Is this a problem?

In a system with an average of 40 concurrent users you get the following from a query on rollback extents: ROLLBACK CUR EXTENTS --------------------- -------------------------- R01 11 R02 8 R03 12 R04 9 SYSTEM 4 You have room for each to grow by 20 more extents each. Is there a problem? Should you take any action?

You look at the dba_rollback_segs view and see that you have a large number of wraps is this a problem?

You look at the dba_rollback_segs view and see that there is a large number of shrinks and they are of relatively small size, is this a problem? How can it be fixed if it is a problem?

If you see the value for reloads is high in the estat library cache report is this a matter for concern?

you see the value for reloads is high in the estat library cache report is this a matter for concern?

If you see a pin hit ratio of less than 0.8 in the estat library cache report is this a problem? If so, how do you fix it?

What can cause a high value for recursive calls? How can this be fixed?

You see the following on a status report: redo log space requests 23 redo log space wait time 0 Is this something to worry about? What if redo log space wait time is high? How can you fix this?

How can you tell if a tablespace has excessive fragmentation?

If a tablespace shows excessive fragmentation what are some methods to defragment the tablespace? (7.1,7.2 and 7.3 only)

If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?

If you see statistics that deal with ?undo? what are they really talking about?

you see contention for library caches how can you fix it?

When looking at the estat events report you see that you are getting busy buffer waits. Is this bad? How can you find what is causing it?

Discuss row chaining, how does it happen? How can you reduce it? How do you correct it?

Describe hit ratio as it pertains to the database buffers. What is the difference between instantaneous and cumulative hit ratio and which should be used for tuning?

Where can you get a list of all initialization parameters for your instance? How about an indication if they are default settings or have been changed?

When should you increase copy latches? What parameters control copy latches?

When looking at v$sysstat you see that sorts (disk) is high. Is this bad or good? If bad -How do you correct it?

Explain the use of TKPROF? What initialization parameter should be turned on to get full TKPROF output?

What is the fastest query method for a table?

What is the general guideline for sizing db_block_size and db_multi_block_read for an application that does many full table scans?

What are some indications that you need to increase the SHARED_POOL_SIZE parameter?

You see multiple fragments in the SYSTEM tablespace, what should you check first?

How do you set up tablespaces during an Oracle installation?

A tablespace has a table with 30 extents in it. Is this bad? Why or why not.

How do you generate file output from SQL?

How do you prevent Oracle from giving you informational messages during and after a SQL statement execution?

How do you prevent output from coming to the screen?

How do you set the number of lines on a page of output? The width?

What is explain plan and how is it used?

What is tkprof and how is it used?

What is the default ordering of an ORDER BY clause in a SELECT statement?

You are joining a local and a remote table, the network manager complains about the traffic involved, how can you reduce the network traffic?

What is a Cartesian product?

You want to determine the location of identical rows in a table before attempting to place a unique index on the table, how can this be done?

What special Oracle feature allows you to specify how the cost based system treats a SQL statement?

You want to group the following set of select returns, what can you group on? Max(sum_of_cost), min(sum_of_cost), count(item_no), item_no

What SQLPlus command is used to format output from a select?

You want to use SQL to build SQL, what is this called and give an example

How do you execute a host operating system command from within SQL?

can you call a PL/SQL procedure from SQL?

You want to include a carriage return/linefeed in your output from a SQL script, how can you do this?

How can variables be passed to a SQL routine?

How can you determine if an index needs to be dropped and rebuilt?

A user selects from a sequence and gets back two values, his select is: SELECT pk_seq.nextval FROM dual; What is the problem?

How can you find out how many users are currently logged into the database? How can you find their operating system id?

If you have an example table, what is the best way to get sizing data for the production table implementation?

A developer is trying to create a view and the database won?t let him. He has the ?DEVELOPER? role which has the ?CREATE VIEW? system privilege and SELECT grants on the tables he is using, what is the problem?

A user is getting an ORA-00942 error yet you know you have granted them permission on the table, what else should you check?

How can you tell if a database object is invalid?

What causes the ?snapshot too old? error? How can this be prevented or mitigated?

You are using hot backup without being in archivelog mode, can you recover in the event of a failure? Why or why not?

(On UNIX) When should more than one DB writer process be used? How many should be used?

What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?

What is the proper method for disabling and re-enabling a primary key constraint?

What happens if a tablespace clause is left off of a primary key constraint clause?

What happens if the constraint name is left out of a constraint clause?

What are some of the Oracle provided packages that DBAs should be aware of?

If the DEFAULT and TEMPORARY tablespace clauses are left out of a CREATE USER command what happens? Is this bad or good? Why?

You have a rollback segment in a version 7.2 database that has expanded beyond optimal, how can it be restored to optimal?

What is the purpose of the IMPORT option IGNORE? What is it?s default setting?

Give one method for transferring a table from one schema to another:

What are the types of triggers?

How can you generate debugging output from PL/SQL?

How can you find within a PL/SQL block, if a cursor is open?

What are SQLCODE and SQLERRM and why are they important for PL/SQL developers?

In what order should a open/fetch/loop set of commands in a PL/SQL block be implemented if you use the %NOTFOUND cursor variable in the exit when statement? Why?

When is a declare statement needed ?

Describe the use of PL/SQL tables

What packages (if any) has Oracle provided for use by developers?

Describe the use of %ROWTYPE and %TYPE in PL/SQL

What is a mutating table error and how can you get around it?

Describe the difference between a procedure, function and anonymous pl/sql block.

What is a self join? Explain it with an example.

What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?

What is the system function to get the current user?s user id?

What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

Can you have a nested transaction?

What is a join and explain different types of joins?

What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?

How to determine the service pack currently installed on SQL Server?

What is database replication? What are the different types of replication you can set up in SQL Server?

Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

What are the different ways of moving data/databases between servers and databases in SQL Server?

What are statistics, under what circumstances they go out of date, how do you update them?

How to restart SQL Server in single user mode? How to start SQL Server in minimal configuration mode?

What is blocking and how would you troubleshoot it?

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

What are the steps you will take, if you are tasked with securing an SQL Server?

What are the steps you will take to improve performance of a poor performing query?

What is RAID and what are different types of RAID configurations?

What is an index? What are the types of indexes? How many clustered indexes can be created on a table? I create a separate index on each column of a table. What are the advantages and disadvantages of this approach?

What are constraints? Explain different types of constraints.

What are the new features introduced in SQL Server 2000 (or the latest release of SQL Server at the time of your interview)? What changed between the previous version of SQL Server and the current version?

Explain the storage models of OLAP ?

What?s the difference between DELETE TABLE and TRUNCATE TABLE commands?

What is lock escalation?

What?s the maximum size of a row?

What is a transaction and what are ACID properties?

What are defaults? Is there a column to which a default can?t be bound?

Define candidate key, alternate key, composite key.

What is bit datatype and what?s the information that can be stored inside a bit column?

What are user defined datatypes and when you should go for them?

What?s the difference between a primary key and a unique key?

How do you implement one-to-one, one-to-many and many-to-many relationships while designing tables?

What is denormalization and when would you go for it?

What is normalization? Explain different levels of normalization?

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

Explain an ORA-01555 (snapshot too old )

How would you go about increasing the buffer cache hit ratio?

How would you go about generating an EXPLAIN plan?

What column differentiates the V$ views to the GV$ views and how ?

Give the stages of instance startup to a usable state where normal users may access it.

What command would you use to create a backup control file?

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

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?

Give two examples of referential integrity constraints.

What type of index should you use on a fact table?

Give the two types of tables involved in producing a star schema and the type of data they hold.

Give the reasoning behind using an index.

Compare and contrast TRUNCATE and DELETE for a table.

Where would you look for errors from the database engine?

Give two examples of how you might determine the structure of the table DEPT.

Explain the difference between a data block, an extent and a segment.

How do you switch from an init.ora file to a spfile?

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

Explain the difference between a hot backup and a cold backup and the benefits associated with each.

How do you view version information in Oracle?

Explain implicit cursor attributes.

Explain explicit cursor attributes.

The NVL function only allows the same data type. But here?s the task: if the commission field is null, then the text ?Not Applicable? should be displayed, instead of blank space. How do you write the query?

How do you display the records within a given range?

How do I display row number with records?

How do I eliminate duplicate rows in an Oracle database?

How do you switch to DOS prompt from SQL prompt?

What?s the command to change the SQL prompt name?

What?s the command to see the current user name?

What are the pros and cons of using triggers? Expected answer:

When a query is sent to the database and an index is not being used, what type of execution is taking place?

What is the difference of a LEFT JOIN and an INNER JOIN statement?

What is an advantage to using a stored procedure as opposed to passing an SQL query from an application.

What is a Cartesian product? What causes it?

Name the operators that cannot be overloaded. sizeof, ., .*, .->, ::, ?:

How to use " in Oracle data ? Question -- We are encountering db values that contain both double quotes and apostrophes. Has anyone found a work-around for this situation?

What Is Input Buffer in SQL*Plus?

How To Save Query Output to a Local File?

What Is Output Spooling in SQL*Plus?

What Are SQL*Plus Environment Variables?

How To Look at the Current SQL*Plus System Settings?

How To Change SQL*Plus System Settings?

What Information Is Needed to Connect SQL*Plus an Oracle Server?

How To Get Help at the SQL Prompt?

How To Start the Command-Line SQL*Plus?

What Is SQL*Plus?

What Is Open Database Communication (ODBC)?

What Is Transport Network Substrate (TNS)?

What Is SQL*Plus?

What Is a Recycle Bin?

What Is a Dynamic Performance View?

What Is a Static Data Dictionary?

What Is an Oracle Data File?

What Is an Oracle Tablespace?

What Is a Table Index?

What Is a Database Table?

What is a Database Schema?

What Is a User Role?

What Is the Relation of a User Account and a Schema?

What Is a User Account?

What is Program Global Area (PGA)?

What is System Global Area (SGA)?

What Is a Initialization Parameter File?

What Is a Server Parameter File?

What Is a Parameter File?

What Is an Oracle Instance?

What Is an Oracle Database?

What Is Oracle?

How to find out the third highest salary / nth highest salary ?

Can one read/write files from PL/SQL?

Is there a limit on the size of a PL/SQL block?

What is PL/SQL?

What is implicit cursor and how is it used by Oracle ?

What is a transaction ?

What are the various types of queries ?

If you insert a row in a table, then create another table and then say Rollback. In this case will the row be inserted ?

What is a package cursor ?

What is the use of Data Dictionary ?

What is the use of Control files ?

Can you increase the size of a tablespace ? How ?

Describe Oracle database's physical and logical structure ?

What are constraining triggers ?

What are mutating triggers ?

What are cascading triggers? What is the maximum no of cascading triggers at a time?

What are the values of :new and :old in Insert/Delete/Update Triggers ?

Can views be specified in a trigger statement ?

What is the maximum no. of statements that can be specified in a trigger statement ?

What is the advantage of a stored procedure over a database trigger ?

What are the various types of database triggers ?

What are the parts of a database trigger ?

Can you pass parameters in packages ? How ?

Why Create or Replace, and not Drop and recreate procedures ?

What are the constructs of a procedure, function or a package ?

Can 2 functions have same name & input parameters but differ only by return data type

Can functions be overloaded ?

What is Over Loading and what are its restrictions ?

What are the various types of parameter modes in a procedure ?

Can you have two stored functions with the same name ?

Can you have two functions with the same name in a PL/SQL block ?

What is the difference between a procedure and a function ?

Can we define exceptions twice in same block ?

What are the various types of Exceptions ?

PROCEDURE TO PICK RANDOM SET OF NUMBERS FROM A GIVEN RANGE OF NUMBERS

FUNCTIONS AS STORED PROGRAM UNITS : insert a record into the table emp1 for job = 'MGR' and sal >5000 - if sal <5000 return false and don't insert

Calling a stored procedure within the main procedure

PROCEDURES AS STORED PROGRAM UNITS

Procedures with FUNCTIONS

Procedure Non-Stored Program Units with the "IN OUT PARAMETER"

Procedure Non-Stored Program Units with the "OUT PARAMETER"

Procedure Non-Stored Program Units with the "IN PARAMETER" ## IN parameter data cannot be manipulated ## IN parameter can only receive a constant value from the main program ## IN parameter does not return any value to the calling program

PROCEDURES AS NON-STORED PROGRAM UNITS

Procedure to delete rownum 6 to 9 and update 10 to end using the WHERE CURRENT OF CURSOR

Procedure using WHERE CURRENT OF CURSOR

parameterized cursor with DEFAULT OPTION another option

parameterized cursor with DEFAULT OPTION

Procedure with parameterized cursors

Procedure to find the nth maximum salary use PL/SQL

Procedure to select 1st 'n' higest persons & salaries using PL/SQL

Procedure with EXCEPTIONS

Procedure with RECORDS

Procedure with USER-DEFINED EXCEPTIONS

Procedure with TOO_MANY_ROWS error handling

Procedure with GOTO statement

Procedure for scope of variables

Procedure to check for PALINDROME and to print the reverse of the string

create user defined datatype (arrays)

Program for Fibonacci Series

Program to generate Prime Numbers

Stripping part Numbers of unwanted characters

Program to print reverse of values

SIMPLE PROGRAM USING PARAMETERIZED CURSOR

SIMPLE PROGRAM IMPLEMENT EXPLICIT CURSORS

PROGRAM TO GENERATE MULTIPLICATION TABLE FOR A NUMBER 'n'

PROGRAM TO GENERATE FIBONACCI SERIES UPTO 'n' NUMBERS

PROGRAM TO CHECK A STRING FOR PALINDROME

PROGRAM TO REVERSE A GIVEN STRING

PROGRAM TO FIND ODD & EVEN NUMBERS

Query to find the #week from the date given

Query as follows /* Query*/ need to split a string into seperate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,b,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.

Query to display date in 3 different formats

Query to delete duplicate records from a table

Query as follows /* query*/ iam having data in column called col1 ------ 23.23456 456.7894 123.3456 324.67845 like this i have 20000 records here in data after the dot i want only 2 digits with out rounding

Query to insert ?&? into a varchar2 datatype column

Query as follows I have a query as below: select quantity from material_table. quantity --------- 20 40 10 I want the query to return only first two records (i.e. to stop the query when the sum of quantity is 60 in this case).

Query as below /* query asked*/ If an employee taken continues leave from 25-Feb-2006 to 03-Apr-2006, we have to display the monthly leave breakup like Feb ? 4 Days, Mar ? 31 Days and Apr ? 3 Days. How to write a procedure, Please advice us. Record it will be store in Start Date : 25-Feb-2006 End Date : 03-Apr-2006 Notification Date : 25-Feb-2006 No of Days : 38

Query as follows /* query asked */ Say in Table ?T? I have two colums ?A?, ? B? I want to get the sum of A based on values of B. I should get the sum in two buckets For B=0 And B not equal zero. Example A B ___ ___ 1 0 2 1 3 0 4 3 5 2 6 0 So I should get the result set as SUM (A) B ______ __________ 10 For B=ZERO 11 For B=NONZERO

Following is the query SQL> DESC PATH Name Null? Type ------------------------------- -------- ---- COL1 CHAR(1) COL2 CHAR(1) SQL> select * from path; Col1 Col2 ------ ------ A B B C B D C M D G M H R Y 7 rows selected. the result to be as follows B,C,C,M,M,H

Query to show all running SQL?s

SYS_CONNECT_BY_PATH implementation and examples in Oracle 9i

Query to find the day of the week

Query to find the current day of the week

Query to find the last day of the given date (format as mm-yyyy)

Partitions Queries details

Write a Query to display the Lowest & Highest in Sal column with following Conditions 1. Display 'LOW' in column SAL If SAL < 4000 2. Display 'HIGH' in column SAL if SAL > 4000

Query to find the TOP N Analysis

How to find only the duplicate records

Following is the Query IF I HAVE TWO COLUMNS LIKE THAT ID COLUMN A COLUMN B 1 A 10000 2 Z 20000 3 I 30000 4 Z 40000 5 P 50000 6 D 60000 7 A 70000 8 P 80000 9 I 90000 Find the Query which will SUM THE COLUMN B, GROUP BY COLUMN A WITHOUT DISTRUBING THE SEQUENCE Output shud be as A 80000 Z 60000 I 12000 P 13000 D 6000

The Follwing is the Query id date --------------- 1 NULL 1 NULL 1 NULL 2 NULL 2 21.03.2004 3 22.04.2003 3 10.04.2003 Want the id when the date is never filled Output shud return as ID 1

Following is the Query?O/P Wanted ! Table A ------- SNo Sname 1 a 2 b 3 c Table B -------- SNo Course 1 x 1 y 1 k 1 z 2 x 2 z 2 d 3 y 3 z 3 e I need the output in the following format where course is x or y or z. 1 x y z 2 x z 3 y z

. Following is the query Table 1 Col1 2 5 7 9 4 6 Query output to be as follows (row1+row2) 2+5=7 (row2+row3) 5+7 =12 (row3+row4) 7+9=16 etc etc

Query to extract the given string 'a;b;c;d;e;f' as (a b c d e f)

Query to get the number of days between two dates is easy to get

projects/ 1 pages

Student Live Projects : we offer live projects for Final year students ( BE, BTech, MCA, MSc, MCM, BCA etc) and just passed out ( all streams)

tutorial/ 2 pages

Struts Tutorial, Struts Tutorial with Code Examples Step by Step

Hibernate Tutorial, Hibernate Tutorial with Code Examples Step by Step

ejb/ 1 pages

EJB Tutorial, EJB tutorials with code examples

jdbc/ 1 pages

JDBC Tutorial, jdbc tutorials with code examples Step by Step

jsp/ 1 pages

JSP Tutorial, JSP tutorials with code examples Step by Step

spring/ 1 pages

Spring Tutorial, Spring tutorials with code examples

webservices/ 1 pages

WebServices Tutorial

TechFAQ

Technology Expert Comments

Site Map

techfaq360: Certification Expert