Tag: programming languages

CONVERT

TRANSLATE

DECODE

Both B. and C.

Normalization

Indexing

Sequence

Join

INSERT

CREATE

ALTER

Both A. and B.

select empno, empname, salary from emp order by empname, salary desc;

select empno from emp sort by empname, sal in desc;

select empno, empname, salary from emp sort in empname, salary desc;

select # from emp sort by empname and salary in desc;

GENERATE SEQUENCE SE START WITH 30 ADD BY 20;

CREATE SEQUENCE SE START WITH 30 ADD BY 20;

CREATE SEQUENCE SE START WITH 30 INCREMENT BY 20;

GENERATE SEQUENCE SE INITIATE WITH 30 INCREMENT BY 20;

Table name can be an oracle reserved word

Table names must begin with a letter

Table names can contain in it numbers also

None of the Above

Views are windows of existing table

Creation of view is done by using CREATE VIEW statement

Views do not contain data but table from which it is created contain data

All the Above

Non- procedural language

Procedural language

Database Language

Both A. and C.

Sub queries must be enclosed in parenthesis

BETWEEN cannot be used with a sub query

Both A. and B.

None of the Above

Structured database Language

Structured programming Language

Structured Query Analyzer

Structured Query Language