Open a file

Find file pointer

Find address of file

Find end of file

Find begining of file

-- and /

-- and &

-- and &&

-- and //

// and --

Char

Varchar

Number

Integer

Date

1

10

3

30

0

% and _

% and &

_ and &

& and *

none of these

Given after all column definition.

Composite constraints can be given.

Not NULL cannot be given.

Columns can be compared with each other.

None of these

Table joins to itself.

Used to handle self referential integrity.

The table is logically divided and table alias are used.

Table appears twice in the from clause following their alias.

None of these

Single table

Multiple table

Non-existing tables

Triggers

None of these

dbms_output.put_line ('Text');

dbms-output.put-line ('Text');

dbms_output ('Text');

printf (Text);

puts(Text);

1

01

13

31

None of these

single variable

entire row of a table

entire column of a table

entire table

multiple row

It is a stored query.

Replica or image of a table.

Changes either in table or in view will reflect in both.

It provides restricted access to table.

It occupies same storage space as table does.

Select * from emp where not Job = 'Manager';

Select * from emp where Job != 'Manager;

Select * from emp where Job <> 'Manager';

Select * from emp where Job not in ('Manager');

Select * from emp where Job in ('Manager');

Select ENAME, SAL, SAL* 0.1 10% INCREASED SAL from emp;

Select ENAME, SAL, SAL* 10 10% INCREASED SAL from emp;

Select ENAME, SAL, SAL* 0.01 '10% INCREASED SAL' from emp;

Find ENAME, SAL, SAL* 0.1 10% INCREASED SAL from emp;

Seek ENAME, SAL, SAL* 0.1 10% INCREASED SAL from emp;

Insert

Update

Delete

Select

Create

Characters enclosed within single quotes

Date datatypes enclosed within single quotes

NULL values are written as NULL.

Number data not to be enclosed in single quotes

If some columns are fed with values, then rest will be assigned zero

BLOB

CLOB

NCLOB

BFILE

None of these

% is open

% found

% not found

% row count

% cursor

declaration

executable

exception handler

declaration and executable

none of these

%h

%o

%x

%d

%z