Tag: programming languages

addition

subtraction

raising to a power

finding the quotient

finding the lowest value

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

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:

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

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

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

1> filename

2> /dev/null

&> filename

2> filename

find all

find -a

all

ls -a

cd ..

cd ~

cd -

cd /up

less filename

rm filename

dl filename

touch filename