Retrieving Data Using the SQL SELECT Statement

Question

Identify the capabilities of SELECT statement.

Answer 1

Projection

Answer 2

Data Control

Answer 3

Transaction

Answer 4

Projection

Answer 5

SQL statements are case sensitive

Answer 6

Keywords can be abbreviated to build a standard

Answer 7

SQL statements are case in-sensitive

Answer 8

clauses must be placed together

Answer 9

SELECT ename, deptno, sal, job FROM emp;

Answer 10

SELECT * FROM emp;

Answer 11

SELECT DISTINCT ename, deptno, sal, job FROM emp;

Answer 12

SELECT ename, deptno, sal FROM emp;

Answer 13

SELECT ename, sal FROM emp;

Answer 14

SELECT ename, sal=sal+1000 FROM emp;

Answer 15

SELECT ename, sal+1000 FROM emp;

Answer 16

SELECT ename, 1000 FROM emp;

Answer 17

NULL is a special value with zero bytes

Answer 18

NULL is no value or unknown value

Answer 19

NULL is represented by a blank space

Answer 20

NULL is not same as zero

Answer 21

sal + NULL

Answer 22

A column alias renames a column heading

Answer 23

A column alias is an alternate column in a table

Answer 24

A column alias can be specified during table definition

Answer 25

A column alias immediately follows the column or expression in the SELECT statement

Answer 26

(sal + 100) AS NEWSAL

Answer 27

(sal + 100) NEWSAL

Answer 28

(sal + 100) IS NEWSAL

Answer 29

sal + 100 IS NEWSAL

Answer 30

(sal + 100) AS New Salary

Answer 31

(sal + 100) "New Salary"

Answer 32

(sal + 100) IS New Salary .

Answer 33

sal + 100 as "New Salary"

Answer 34

Raises error "SP2-0042: unknown command "desc emp" - rest of line ignored."

Answer 35

Lists the columns of EMP table

Answer 36

Lists the EMP table columns, their data type and nullity

Answer 37

Lists the columns of EMP table along with their data types

Answer 38

It can be used in SQL*Plus only

Answer 39

It can be used in both SQL*Plus as well as SQL Developer

Answer 40

It doesn't works for object tables

Answer 41

It doesn't works for SYS owned tables

Answer 42

It creates a virtual column in the table

Answer 43

It generates a character expression as the result of concatenation of one or more strings

Answer 44

It creates a link between two character columns

Answer 45

It can be used to concatenate date expressions with other column

Answer 46

SMITH NULL

Answer 47

ORA-00904: "NULL": invalid identifier

Answer 48

Use double quote marks for the literal character string

Answer 49

Use [q] operator to enquote the literal character string and selecting the delimiter of choice

Answer 50

Remove the single quote mark (apostrophe) from the literal character string

Answer 51

Use another delimiter to bypass the single quote apostrophe in the literal string

Answer 52

SELECT e.ename || q'[department's name is]'|| d.dname FROM emp e, dept d WHERE e.deptno = d.deptno;

Answer 53

SELECT e.ename || q['department's name is']|| d.dname FROM emp e, dept d WHERE e.deptno = d.deptno;

Answer 54

SELECT e.ename || q[department's name is]|| d.dname FROM emp e, dept d WHERE e.deptno = d.deptno;

Answer 55

SELECT e.ename || q'(department's name is)'|| d.dname FROM emp e, dept d WHERE e.deptno = d.deptno;

Answer 56

SELECT ALL FROM emp

Answer 57

SELECT # FROM emp

Answer 58

SELECT * FROM emp

Answer 59

ELECT empno,ename,deptno,sal,job,mgr,hiredate FROM emp

Answer 60

SELECT ename, deptno, sal FROM emp;

Answer 61

SELECT ename, deptno, sal + comm FROM emp;

Answer 62

SELECT ename, deptno, (sal * 12) Annual_Sal FROM emp;

Answer 63

Annual salary cannot be queried since the column doesn't exists in the table

Next up

Retrieving Data Using the SQL SELECT Statement

Description

Resource summary

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

Question 11

Question 12

Question 13

Question 14

Question 15

Question 16

Question 17

Question 18

Question 19

Question 20

Question 21

Question 22

Question 23

Question 24

Question 25

Similar

	Created by Mylaisa McMullen almost 7 years ago