How to write test case of an email inbox field
Hi..I am a student and I am learning software quality assurance subject...I want to know how to writes test cases for an email inbox of an email account.I will be very thankful to u
Check list to keep in mind when writing test cases for email inbox field. I will start up with a example with Gmail: 1. Login to gmail and check that when you click on submit by your user credential...
How many control files created at the time of database creation?
there are max 8 control files that we can create, however normally there are 3 control files that are created.
What are GLobal and local index?
Global Index : A single index covering all partitions. Local Index : Separate indexes for each partition. A local index can be unique. However, in order for a local index to be unique, the par...
Can you pass data parameters to forms?
No.
I think you can pass parameters to a form
You also have AWRSQRPT that collects statistics and tracks SQL statements as well.
Automatic Workload Repository (AWR) is the enhanced version of statspack and is used as performance gathering and reporting tool. AWR is basically used to gather performance related statistic such as ...
List out differences between Oracle server 9i and Oracle server 10g.
10 G supports grid computing, ASM (Automatic storage management) and Memory management. Oralce 10g is higher version of 9i , Oracle 10g has added a follwoing features Transparent Data Encryption A...
i is for Internet
g is for Grid Computing
If your database is running slow from last 2 hrs.You can't wait for statspack report generation. What will be your first step to handle the problem? Where can be the problem?
Check for Buffer Cache Size
Check For Poor SQL Query
Remove unnecessary joins, too much normalization can effect query to perform slow, excess use of cursors, indexes, procedures or temporary tables may effect on query to perform slow. If my answer is wrong please correct me
User not able to access database
When users are not able to log onto database, what are all the probable reasons?
1. Database server is not up.
2. User not aware of the correct credentials.
3. TNS entry is not proper.
4. Some network problem.
What are the different types of record groups?
Query record groups nonquery record groups state record groups
Static Record groups
Query Based Record Groups
Non-Query Based Record Groups
A library is a collection of subprograms including user named procedures, functions and packages.
When some procedures, function are frequently used in your applications, you can create a library containing these functions or procedures, and call them from anyform, to avoid redundancy or writing t...
That time use Abstract Data Type i.e.,first step create type.SQL>create type full_addSQL>( addr1 varchar2(15), addr2 varchar2(15),addr3 varchar2(15)); Second stepNow full_add is abstract type, then a...
can any body explain the concept here
Wat is the difference between object library and PL/SQL library
Object group can be used within same form but Object library can be used through out the data base connectivity in any form.
when object library is attached to a form, complete object library are compile/used in compilation, assume that object library has some objects like 1, 2,3. But my form don't use 1,2 & 3 all, it u...
Write a SQL query to reflect changes made in one table if u have two tables emp1& emp2.
For example, if tables Emp1 and Emp2 both have identical structure, and some changes were applied in them, then MINUS can show the difference. Like
select *
from Emp1
MINUS
select *
from Emp2
UNION
select *
from Emp2
MINUS
select *
from Emp1
with triiger we can do this......but in sql there is no such thingbut we can do it by viewfor example emp1 is a table and emp2 is view .if you iinsert rows into view tht may maynot reflect in the base table
You can use a SRW.message() built-in
How to get a calender in date field in Oracle forms?
At first configure webconfig file that have in server folder.
hi, I am a new member in this forum, I tried your ans for attaching a calendar to an LOV field. But when i write a code in key-listval trigger it is giving me an error saying calendar.show...
1. What is bitmapped indexes?2. What is b-tree index?
B-Tree indexes are usually associated with the index that stores a list of ROWIDs for each key.While Bitmap is also organized as B tree , but the leaf node stores a bitmap for each value instead of a list of ROWIDs. B tree can be used for OLTP while bitmap is used for data warehousing system.
Conventional wisdom holds that bitmap indexes are most appropriate for columns having low distinct values—such as GENDER, MARITAL_STATUS, and RELATION. This assumption is not completely accurate, howe...
nvl2 function is the upgraded form of nvl function.In nvl function we need to pass two parameters.i.e. nvl(interest_rate ,returned_value) if the value of interest_rate is null then the nvl function r...
nvl2(exp1,exp2,exp3)
if exp1 is null it manipulate exp3,if exp1 is not null it manipulates exp2
eg:select ename,nvl2(comm,comm+sal,sal) net from emp;
Explain how the cursor can become stuck between two items, resulting in a navigation trap.
Are you talking about EF Codds 12 rules?
I seem to recall that Oracle has satisfied MAX of 12, with the exception being that the empty string is treated as a NULL.
Oracle should satisfy 13 rules of codd