It ignores NULL values

Reversing the order of the intersected tables alters the result.

The names of columns in all SELECT statements must be identical.

The number of columns and data types must be identical for all SELECT statements in the

A subquery that defines a view cannot include the GROUP BY clause

A view is created with the subquery having the DISTINCT keyword can be updated

A view that is created with the subquery having the pseudo column ROWNUM keyword cannot be updated

A Data Manipulation Language (DML) operation can be performed on a view that is created with the subquery having all the NOT NULL columns of a table

The default internal storage of dates is in the numeric format

The default internal storage of dates is in the character format

The RR date format automatically calculates the century from the SYSDATE function and does not allow the user to enter the century

The RR date format automatically calculates the century from the SYSDATE function but allows the user to enter the century if required

SELECT TO_CHAR('ll-oct-2007'. 'miDdspth "of Month. Year') FROM DUAL:

SELECT TO_CHAR(TO_DATE('ll-oct-2007'X 'miDdspth of month, year') FROM DUAL;

SELECT TO_CHAR(TO_DATE('ll-oct-2007'). 'miDdthsp "of* Month. Year') FROM DUAL;

SELECT TO_DATE(TO_CHAR('ll-oct-20077fiiiDdspth "of" Month. Year')) FROM DUAL:

Subqueries can contain GROUP BY and ORDER BY clauses

Main query and subquery can get data from different tables

Main query and subquery must get data from the same tables

Subqueries can contain ORDER BY but not the GROUP BY clause

Only one column or expression can be compared between the main query and subqeury

Multiple columns or expressions can be compared between the main query and subquery

addition

subtraction

raising to a power

finding the quotient

finding the lowest value

COMMIT

SELECT

CREATE

ROLLBACK

SAVEPOINT

They can contain a subquery within a subquery.

They can return multiple columns as well as rows.

They cannot contain a subquery within a subquery.

They can return only one column but multiple rows.

They can contain group functions and GROUP BY and HAVING clauses.

They can contain group functions and the GROUP BY clause, but not the HAVING clause.

The numbers generated by a sequence can be used only for one table

DELETE would remove a sequence from the database

CURRVAL is used to refer to the last sequence number that has been generated

When the MAXVALUE limit for a sequence for reached, you can increase the MAXVALUE limit by using the ALTER SEQUENCE statement

It can be used to join a maximum of three tables

It can be used to restrict the number of columns used in a NATURAL join

It can be used to access data from tables through equijoins as well as nonequijoins

It can be used to join tables that have columns with the same name and compatible data types

Pointers are not supported in C#

Pointers are supported in C# as is in C++

Pointers are replaced by delegates

Pointers can be used by declaring unsafe blocks

namespace in C# refers to a holder where name collisions can be avoided whereas in C++ it is used to define templates

namespace in C# and C++ are for same purpose

namespace in C# refers to a holder where name collisions can be avoided whereas in C++ it is used to define STL classes

namespace in C# refers to a holder where name collisions can be avoided whereas in C++ it is undefined.

FileStream fp= new FileStream("c:\test.txt", FileMode.Create, FileAccess.Write,FileShare.Read);

FileStream fp= new FileStream("c:\test.txt", "rws");

FileStream fp= new FileStream("c:\test.txt", FileMode.ReadWriteShared);

FileStream fp= new FileStream("c:\test.txt", FileMode.ReadWrite, FileAccess.Shared);

strcat(str1,str2)

str1.Append(str2)

str1.CopyAtEnd(str2)

str1=str1+str2

Functions

Templates

Function pointers

Pointer of pointers

True

False

True

False

Colon

SemiColon

Hypen

Dot

One

Two

Three

Four

Byte Code

Firewall

Class Code

Bit Code