ashu

• Mar 20th, 2013

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.

rojalinpanigrahi

 Profile Answers by rojalinpanigrahi Questions by rojalinpanigrahi

• Sep 30th, 2008

Oracle should satisfy 13 rules of codd

Answer Question  Select Best Answer

Difference b/w client server and web based applications?

divya

• Mar 9th, 2013

Client server application refers to an application which has client and its own server. Client can be an employee of an organisation and server of that organisation. For example: College SERVER HAS ...

Answer Question  Select Best Answer

Hi friends,
I m 2012 pass out in CSE discipline. And recently joined Cybage Software as Production Support Engineer. But my ultimate goal lies in Database System. So joining Cybage was merely to keep relatives shut up and parents happy as well as prepare for my goal. But right now I have gone through various sites stating that jobs in DBA is tough to get, for freshers. And also...

DBA

• Feb 15th, 2013

Hope you are aware that being a DBA means working odd hours , indiscriminate routines , erratic week-offs ,etc (occupational hazards ! ) Even then if you wish to take this career option ,here is the w...

Answer Question  Select Best Answer

I have two Table A and B.With table A I fired a query to get a count, and a query with table B to get a count.now I want total of both count.But I want to this all in one query.Example:- I fired tqo queries as-1- select DATE(Today_DATE), count(1) from table DAY1 group by DATE(Today_DATE);2- Select DATE(Yesturday_DATE), count(1) from table DAY2 group by DATE(Yesturday_DATE);Here both table give separate...

Lokesh M

 Profile Answers by Lokesh M Questions by Lokesh M

• Jan 3rd, 2013

You can do it like this

SELECT (SELECT COUNT(1) FROM table DAY1 GROUP BY DATE(Today_DATE)) + (SELECT COUNT(1) FROM table DAY2 GROUP BY DATE(Yesterday_DATE)) AS TotalCount FROM day1 LIMIT 1

Answer Question  Select Best Answer

Greetings friends,

I am looking to find examples of test cases for an MPP Appliance - basically I am looking to purchase, but must first do a proof of concept against 3 separate MPP Appliances. I am looking for some standard test criteria to use in this objective.

Thanks.

How do you estimate for database testing ?

I am using Teradata SQL Assistant.I have a table in SQL server whose table structure I wanna see through SQL assistant.....So please help me out...

Priya Aggarwal

• Nov 27th, 2012

I think sphelp stored procedure provided by sql server should of your help here. try sp_help

Answer Question  Select Best Answer

Hello I was asked to research a Test cases on Yahoo Registration ID.... and I have been trying to put the words together on Test Description, Execution steps and and Expected Behavior but it seems not to come out right. Please any idea???

Plz show me
Denifiton of Nested query , how it work and how optimize with Nested query?

jazz

• Sep 10th, 2012

There are max 8 control files that we can create, however normally there are 3 control files that are created.

Answer Question  Select Best Answer

What exactly is encoding?

Sameer Zaidi

• Sep 3rd, 2012

The Decode stage is a processing stage. It decodes a data set using a UNIX decoding command, such as
gzip, that you supply. It converts a data stream of raw binary data into a data set. Its companion stage,
Encode, converts a data set from a sequence of records to a stream of raw binary data.

Answer Question  Select Best Answer

What are the steps to apply service packs in sql server2008?

My DB is running with out Backup and also DB is in NO Archive log mode.How to find out the below issue.

The following problem occured during DB operation:
ORA-01115: IO error reading block from file 11 (block # 236928)
ORA-27072: File I/O error
Additional information: 4
Additional information: 236928
Additional information: 409600
ORA-01115: IO error...

Hello,
I am trying to create a database with mySQL : I do not managed to load the .cvs table into the mySQL : it keeps saying that the table does not exist but I have check the path and it is correct. Can someone help please

farhad alam

• May 22nd, 2012

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...

Answer Question  Select Best Answer

How are candidate key that are not primary key indicated in the create table statement?

ravinder

• May 4th, 2012

Create table table_name
(ename varchar(9),
eno number(9),
edob date,
egrade varchar(9),
primary key(ename,eno);

Answer Question  Select Best Answer

Explain the steps involved in creating JDBC connection?

mfsi_chinmayb

 Profile Answers by mfsi_chinmayb Questions by mfsi_chinmayb

• Apr 6th, 2012

For more details go through this site URL : http://scornik.blogspot.in/2011/05/sql-query-performance-test-with-jmeter.html

Shravan Mahendra

 Profile Answers by Shravan Mahendra Questions by Shravan Mahendra

• Mar 31st, 2010

Here I'm Using Type-4 Driver to connect to Oracle 10g application and there it goesStep-1: JDBC Driver loading which will be as follows         Class.forName("o...

Answer Question  Select Best Answer

suji

 Profile Answers by suji Questions by suji

• Feb 18th, 2012

During report execution the designer can fill in any part of the report definition such as filter or template. The designer will determine which part of the report to be prompted at the time of report...

Answer Question  Select Best Answer

No.

geekano

 Profile Answers by geekano Questions by geekano

• Feb 3rd, 2012

I think you can pass parameters to a form

Answer Question  Select Best Answer