databases Online Quiz - 17
Description: databases Online Quiz - 17 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: databases |
TRUNCATE IS USED TO?
SQL means
ORACLE IS?
SQL statements are divided into?
ORACLE is used to store?
The life cycle of the explicit cursor goes through __________stages:
Which is a Valid table name:
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);
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 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;