0

databases Online Quiz - 17

Description: databases Online Quiz - 17
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. DROP TABLE

  2. DELETE ALL ROWS

  3. DELETE ALL COLUMNS

  4. DELETE ORACLE


Correct Option: B

SQL means

  1. simple questionary language

  2. simple query language

  3. structured questionary language

  4. structured query language


Correct Option: D

ORACLE IS?

  1. object oriented programming language

  2. programming language

  3. scripting language

  4. database


Correct Option: D
  1. operational data

  2. historical data

  3. both

  4. none


Correct Option: A
  1. Declare, Open, Close

  2. Declare, Open, Fetch, Close

  3. None

  4. Declare, Open, Fetch, Close, Remove


Correct Option: B

Which is a Valid table name:

  1. [email protected]_tab

  2. emp#_tab

  3. $emp_tab

  4. Emp_delete


Correct Option: B,D
  1. Select ename from emp where job in ('MANAGER','CLERK') AND SAL>1000 AND COMM>100 AND DEPTNO=(10,20);

  2. Select ename from emp where job in ('MANAGER' OR 'CLERK') AND SAL>1000 AND COMM>100 AND DEPTNO IN (10,20);

  3. Select ename from emp where job in ('MANAGER','CLERK') AND SAL>1000 AND COMM>100 AND DEPTNO IN (10,20);

  4. None


Correct Option: D

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

  1. It Executes Successfully

  2. It throws Error with message: missing right Parenthesis

  3. It throws Error

  4. None


Correct Option: B,C
  1. Declare, Open, Close

  2. Declare, Open, Fetch, Close

  3. Declare, Open, Fetch, Close, Remove

  4. None


Correct Option: B

Which is a Valid table name:

  1. [email protected]_tab

  2. emp#_tab

  3. $emp_tab

  4. Emp_delete


Correct Option: B,D

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

  1. Select ename from emp where job in ('MANAGER','CLERK') AND SAL>1000 AND COMM>100 AND DEPTNO=(10,20);

  2. Select ename from emp where job in ('MANAGER' OR 'CLERK') AND SAL>1000 AND COMM>100 AND DEPTNO IN (10,20);

  3. Select ename from emp where job in ('MANAGER','CLERK') AND SAL>1000 AND COMM>100 AND DEPTNO IN (10,20);

  4. None


Correct Option: D

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

  1. Null

  2. It Throws Error

  3. 1000

  4. 2000


Correct Option: D

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

  1. True

  2. False


Correct Option: B
  1. It throws error with message: table or view already exists

  2. Insufficient privileges

  3. Table will get created successfully

  4. None


Correct Option: C

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;

  1. first gives error, 16

  2. 16, second gives error

  3. 16,16

  4. Both the queries will give error


Correct Option: C

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

  1. No rows will be displayed

  2. Sql

  3. It throws Error

  4. None


Correct Option: A
- Hide questions