Join Dotnetcodes is online Discussion Forum for Software professionals . It lets you find friends around the world and Create professional network that share similar interests as you. Get help on ur projects by industry specialists. Also get answers to all ur technical/placement related querries.Get an edge over others.
Already MemberClick here to login MVC Interview Questions Answers Interview Questions
Serial Number in SSRS Articles
Get Started Developing for Android Apps with Eclipse Articles
How to Print a Crystal Report direct to printer Articles
Razor View Engine Interview Questions Answers Interview Questions
.Net framework 4.0 Interview Questions Answers Interview Questions
SQL server reporting services Interview Questions (SSRS) part 1 Articles
Whats New in ASP.NET 4.0 Part 2 Articles
Difference between Encapsulation and Abstraction Interview Questions
Explaining SDLC -System Development Life Cycle Articles
SPIRE PDF Library Articles
Infosys Interview Questions Interview Questions
Html5 interview questions and answers Interview Questions
Dynamic Menu using HTML List Tag and CSS in ASP.Net Articles
SharePoint 2010 interview Questions Answers Interview Questions
Submit Articles | More Articles..

Oracle Interview Questions part 1

Posted By: Jaishree On:1/7/2011 3:43:40 AM in:Articles Category:Oracle Hits:1714
List of Oracle interview Questions and answers

What are the different types of Record Groups? 
Query Record Groups
NonQuery Record Groups
State Record Groups

From which designation is it preferred to send the output to the printed? 

What is the Maximum allowed length of Record group Column?
Record group column names cannot exceed 30 characters.

Which parameter can be used to set read level consistency across multiple queries? 
Read only

What are difference between post database commit and post-form commit? 

Post-form commit fires once during the post and commit transactions process, after the database commit occurs. The post-form-commit trigger fires after inserts, updates and deletes have been posted to the database but before the transactions have been finalized in the issuing the command. The post-database-commit trigger fires after oracle forms issues the commit to finalized transactions.

What are the different display styles of list items? 
Pop_listText_listCombo box

Which of the above methods is the faster method? 
performing the calculation in the query is faster.

With which function of summary item is the compute at options required? 
percentage of total functions.

What are parameters? 
Parameters provide a simple mechanism for defining and setting the valuesof inputs that are required by a form at startup. Form parameters are variables of type char,number,date that you define at design time.

What are the three types of user exits available ? 
Oracle Precompiler exits, Oracle call interface, NonOracle user exits.

How many windows in a form can have console? 
Only one window in a form can display the console, and you cannot change the console assignment at runtime.

What is an administrative (privileged) user? (for DBA )
Oracle DBAs and operators typically use administrative accounts to manage the database and database instance. An administrative account is a user that is granted SYSOPER or SYSDBA privileges. SYSDBA and SYSOPER allow access to a database instance even if it is not running. Control of these privileges is managed outside of the database via password files and special operating system groups. This password file is created with the orapwd utility.

What are the two repeating frame always associated with matrix object? 
One down repeating frame below one across repeating frame.

What are the master-detail triggers?

How does one connect to an administrative user? (for DBA )
If an administrative user belongs to the "dba" group on Unix, or the "ORA_DBA" (ORA_sid_DBA) group on NT, he/she can connect like this: 
connect / as sysdba
No password is required. This is equivalent to the desupported "connect internal" method. 
A password is required for "non-secure" administrative access. These passwords are stored in password files. Remote connections via Net8 are classified as non-secure. Look at this example: 
connect sys/password as sysdba

How does one create a password file? (for DBA )
The Oracle Password File ($ORACLE_HOME/dbs/orapw or orapwSID) stores passwords for users with administrative privileges. One needs to create a password files before remote administrators (like OEM) will be allowed to connect. 
Follow this procedure to create a new password file: 
. Log in as the Oracle software owner 
. Runcommand: orapwd file=$ORACLE_HOME/dbs/orapw$ORACLE_SID password=mypasswd 
. Shutdown the database (SQLPLUS> SHUTDOWN IMMEDIATE) 
. Edit the INIT.ORA file and ensure REMOTE_LOGIN_PASSWORDFILE=exclusive is set. 
. Startup the database (SQLPLUS> STARTUP) 
NOTE: The orapwd utility presents a security risk in that it receives a password from the command line. This password is visible in the process table of many systems. Administrators needs to be aware of this!

Is it possible to modify an external query in a report which contains it? 

Does a grouping done for objects in the layout editor affect the grouping done in the data model editor? 

How does one add users to a password file? (for DBA )
One can select from the SYS.V_$PWFILE_USERS view to see which users are listed in the password file. New users can be added to the password file by granting them SYSDBA or SYSOPER privileges, or by using the orapwd utility. GRANT SYSDBA TO scott;

If a break order is set on a column would it affect columns which are under the column? 

Why are OPS$ accounts a security risk in a client/server environment? (for DBA)
If you allow people to log in with OPS$ accounts from Windows Workstations, you cannot be sure who they really are. With terminals, you can rely on operating system passwords, with Windows, you cannot. 
If you set REMOTE_OS_AUTHENT=TRUE in your init.ora file, Oracle assumes that the remote OS has authenticated the user. If REMOTE_OS_AUTHENT is set to FALSE (recommended), remote users will be unable to connect without a password. IDENTIFIED EXTERNALLY will only be in effect from the local host. Also, if you are using "OPS$" as your prefix, you will be able to log on locally with or without a password, regardless of whether you have identified your ID with a password or defined it to be IDENTIFIED EXTERNALLY.

Do user parameters appear in the data modal editor in 2.5? 

Can you pass data parameters to forms? 

Is it possible to link two groups inside a cross products after the cross products group has been created? 

What are the different modals of windows? 
Modalless windows
Modal windows

What are modal windows? 
Modal windows are usually used as dialogs, and have restricted functionality compared to modelless windows. On some platforms for example operators cannot resize, scroll or iconify a modal window.

What are the different default triggers created when Master Deletes Property is set to Non-isolated? 
Master Deletes Property Resulting Triggers
Non-Isolated(the default) On-Check-Delete-Master

What are the different default triggers created when Master Deletes Property is set to isolated? 
Master Deletes Property Resulting Triggers
Isolated On-Clear-Details

What are the different default triggers created when Master Deletes Property is set to Cascade? 
Master Deletes Property Resulting Triggers
Cascading On-Clear-Details

What is the diff. bet. setting up of parameters in reports 2.0 reports2.5? 
LOVs can be attached to parameters in the reports 2.5 parameter form.

What are the difference between lov & list item? 
Lov is a property where as list item is an item. A list item can have only one column, lov can have one or more columns.

comments powered by Disqus
User Profile
Sr. Engineer
Delhi , India
Email :You must Log In to access the contact details.
Latest Post from :Jaishree
Function to Convert Text String to Title Case – Proper Case
View: 903 | Submitted on: 3/6/2013 11:23:44 PM
Uploading an image directly into the database and retreive in the PictureBox control in Windows Forms Application
View: 2581 | Submitted on: 9/21/2012 3:05:29 AM
Oracle Interview Questions part 2
View: 1717 | Submitted on: 1/7/2011 3:45:40 AM
Oracle Interview Questions part 1
View: 1714 | Submitted on: 1/7/2011 3:43:40 AM
Oracle Interview Questions
View: 1799 | Submitted on: 1/7/2011 3:36:49 AM
Submit Articles | All Post of This User..

All rights reserved to dotnetcodes. Logos, company names used here if any are only for reference purposes and they may be respective owner's right or trademarks.
Best viewed at 1024 x 768 resolution with Internet Explorer 5.0 or Mozila Firefox 3.5 or Google Crome and higher