Question 1

TRUNCATE IS USED TO?

technology databases

DROP TABLE
DELETE ALL ROWS
DELETE ALL COLUMNS
DELETE ORACLE

Answer

Correct Option: B

Question 2

SQL means

technology databases

simple questionary language
simple query language
structured questionary language
structured query language

Answer

Correct Option: D

Question 3

ORACLE IS?

technology databases

object oriented programming language
programming language
scripting language
database

Answer

Correct Option: D

Question 4

SQL statements are divided into?

technology databases

2
3
4
5

Answer

Correct Option: D

Question 5

ORACLE is used to store?

technology databases

operational data
historical data
both
none

Answer

Correct Option: A

Question 6

DDL Means data drive language?

technology databases

True
False

Answer

Correct Option: B

Question 7

oracle is a programming language?

technology databases

True
False

Answer

Correct Option: B

Question 8

The life cycle of the explicit cursor goes through __________stages:

technology databases

Declare, Open, Close
Declare, Open, Fetch, Close
None
Declare, Open, Fetch, Close, Remove

Answer

Correct Option: B

Question 9

Which is a Valid table name:

technology databases

[email protected]_tab
emp#_tab
$emp_tab
Emp_delete

Answer

Correct Option: B,D

Question 10

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

technology databases

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

Answer

Correct Option: D

Question 11

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

technology databases

Null
It Gives Error
1000
2000

Answer

Correct Option: D

Question 12

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

technology databases

It Executes Successfully
It throws Error with message: missing right Parenthesis
It throws Error
None

Answer

Correct Option: B,C

Question 13

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

technology databases

Declare, Open, Close
Declare, Open, Fetch, Close
Declare, Open, Fetch, Close, Remove
None

Answer

Correct Option: B

Question 14

Which is a Valid table name:

technology databases

[email protected]_tab
emp#_tab
$emp_tab
Emp_delete

Answer

Correct Option: B,D

Question 15

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

technology databases

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

Answer

Correct Option: D

Question 16

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

technology databases

Null
It Throws Error
1000
2000

Answer

Correct Option: D

Question 17

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

technology databases

True
False

Answer

Correct Option: B

Question 18

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);

technology databases

It throws error with message: table or view already exists
Insufficient privileges
Table will get created successfully
None

Answer

Correct Option: C

Question 19

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;

technology databases

first gives error, 16
16, second gives error
16,16
Both the queries will give error

Answer

Correct Option: C

Question 20

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

technology databases

No rows will be displayed
Sql
It throws Error
None

Answer

Correct Option: A

Description: databases Online Quiz - 17
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

databases Online Quiz - 17

Find more quizzes from top tags