TRUNCATE IS USED TO?

SQL means

ORACLE IS?

SQL statements are divided into?

ORACLE is used to store?

DDL Means data drive language?

oracle is a programming language?

The life cycle of the explicit cursor goes through __________stages:

Which is a Valid table name:

Select employee name whose job is 'Manager' or 'Clerk' and Salary greater than 1000 and comm >100 and deptno is either 10 or 20

What is the Output of the Following Program: declare n number:=2000; cursor c1 is select sal into n from emp where empno=7788; begin dbms_output.put_line(n); end; Data in Emp Table empno sal 123 1000

What is the output of the Query: select * from emp where dept_no in (select dept_no from dept order by dept_no desc);

The life cycle of the explicit cursor goes through _______ stages:

Which is a Valid table name:

Select employee name whose job is 'Manager' or 'Clerk', Salary greater than 1000, comm >100 and deptno is either 10 or 20

What is the Output of the Following Program: declare n number := 2000; cursor c1 is select sal into n from emp where empno = 7788; begin dbms_output.put_line(n); end; Data in Emp Table empno sal 123 1000

The below query Executes Successfully without Error: select * from emp where dept_no in (select dept_no from dept order by dept_no desc);

What happens if we execute the below create table query at first time in a database with other than sys user and the user is having create table privileges: create table dual(a number);

What is the output of the below queries: if table A is having 16 rows: select count() from A where 10=10; select count() from A having 10=10;

what is the output of the the query: select 'Sql' from dual where null = null;