Tag: technology

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

DELETE <sequencename> 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

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.

COMMIT

SELECT

CREATE

ROLLBACK

SAVEPOINT

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