Mylaisa McMullen
Quiz by , created more than 1 year ago

List the capabilities of SQL SELECT statements Execute a basic SELECT statement

238
0
0
Mylaisa McMullen
Created by Mylaisa McMullen almost 7 years ago
Close

Retrieving Data Using the SQL SELECT Statement

Question 1 of 25

1

Identify the capabilities of SELECT statement.

Select one or more of the following:

  • Projection

  • Selection

  • Data Control

  • Transaction

Explanation

Question 2 of 25

1

Determine the capability of the SELECT statement demonstrated in the given query.

SELECT e.ename, d.dname
FROM emp e, dept d
WHERE e.deptno = d.deptno
AND e.sal > 1000;

Select one or more of the following:

  • Selection

  • Filtering

  • Joining

  • Projection

Explanation

Question 3 of 25

1

Which of the following clause is used to suppress duplicates in a SELECT statement?

Select one or more of the following:

  • INTERSECT

  • DUPLICATE

  • DISTINCT

  • UNIQUE

Explanation

Question 4 of 25

1

Chose the statements which correctly specify a rule to write a SQL statement

Select one of the following:

  • SQL statements are case sensitive

  • Keywords can be abbreviated to build a standard

  • SQL statements are case in-sensitive

  • clauses must be placed together

Explanation

Question 5 of 25

1

Determine the output of the below query

SELECT '5+7'
FROM dual;

Select one of the following:

  • 12

  • 5+7

  • 5

  • 7

Explanation

Question 6 of 25

1

Write a query to display employee details (Name, Department, Salary and Job) from EMP table

Select one of the following:

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

  • SELECT * FROM emp;

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

  • SELECT ename, deptno, sal FROM emp;

Explanation

Question 7 of 25

1

Which of the below queries displays employees' name and new salary after the increment of 1000?

Select one of the following:

  • SELECT ename, sal FROM emp;

  • SELECT ename, sal=sal+1000 FROM emp;

  • SELECT ename, sal+1000 FROM emp;

  • SELECT ename, 1000 FROM emp;

Explanation

Question 8 of 25

1

Determine the output of the below query

SELECT 36/2-5*10 FROM dual;

Select one of the following:

  • 130

  • -32

  • -120

  • 175

Explanation

Question 9 of 25

1

Determine the output of the below query

SELECT (100-25)/15*(20-3) FROM dual;

Select one of the following:

  • 0.294

  • -85

  • 63.67

  • 85

Explanation

Question 10 of 25

1

Chose the statements which correctly define a NULL value.

Select one or more of the following:

  • NULL is a special value with zero bytes

  • NULL is no value or unknown value

  • NULL is represented by a blank space

  • NULL is not same as zero

Explanation

Question 11 of 25

1

Determine the output of the below query

SELECT sal + NULL
FROM emp
WHERE empno = 7369;

Select one of the following:

  • sal + NULL

  • NULL

  • 0

  • 1250

Explanation

Question 12 of 25

1

Which of the below statements define column alias correctly?

Select one or more of the following:

  • A column alias renames a column heading

  • A column alias is an alternate column in a table

  • A column alias can be specified during table definition

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

Explanation

Question 13 of 25

1

Specify the column alias NEWSAL for the expression containing salary in the below SQL query

SELECT ename, job, sal + 100 FROM emp;

Select one or more of the following:

  • (sal + 100) AS NEWSAL

  • (sal + 100) NEWSAL

  • (sal + 100) IS NEWSAL

  • sal + 100 IS NEWSAL

Explanation

Question 14 of 25

1

Specify the column alias "New Salary" for the expression containing salary in the below SQL query

SELECT ename, job, sal + 100 FROM emp;

Select one or more of the following:

  • (sal + 100) AS New Salary

  • (sal + 100) "New Salary"

  • (sal + 100) IS New Salary
    .

  • sal + 100 as "New Salary"

Explanation

Question 15 of 25

1

Which command is used to display the structure of a table?

Select one of the following:

  • LIST

  • SHOW

  • DESCRIBE

  • STRUCTURE

Explanation

Question 16 of 25

1

Predict the output when below statement is executed in SQL* Plus?

DESC emp

Select one of the following:

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

  • Lists the columns of EMP table

  • Lists the EMP table columns, their data type and nullity

  • Lists the columns of EMP table along with their data types

Explanation

Question 17 of 25

1

Which of the below statements are true about the DESCRIBE command?

Select one of the following:

  • It can be used in SQL*Plus only

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

  • It doesn't works for object tables

  • It doesn't works for SYS owned tables

Explanation

Question 18 of 25

1

Which of the below alphanumeric characters are used to signify concatenation operator in SQL?

Select one of the following:

  • +

  • ||

  • -

  • ::

Explanation

Question 19 of 25

1

Which of the below statements are correct about the usage of concatenation operator in SQL?

Select one or more of the following:

  • It creates a virtual column in the table

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

  • It creates a link between two character columns

  • It can be used to concatenate date expressions with other column

Explanation

Question 20 of 25

1

Predict the output of the below query

SELECT ename || NULL
FROM emp
WHERE empno = 7369

Select one of the following:

  • SMITH

  • SMITH NULL

  • SMITHNULL

  • ORA-00904: "NULL": invalid identifier

Explanation

Question 21 of 25

1

Predict the output of the below query

SELECT 50 || 0001
FROM dual

Select one of the following:

  • 500001

  • 51

  • 501

  • 5001

Explanation

Question 22 of 25

1

You execute the below query

SELECT e.ename||' departments's name is:'|| d.dname
FROM emp e, dept d
where e.deptno=d.deptno;

And get the exception - ORA-01756: quoted string not properly terminated. Which of the following solutions can permanently resolve the problem?

Select one of the following:

  • Use double quote marks for the literal character string

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

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

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

Explanation

Question 23 of 25

1

Which of the below SELECT statement shows the correct usage of [q] operator?

Select one of the following:

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

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

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

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

Explanation

Question 24 of 25

1

Which of the below SELECT statement is used to select all columns of EMP table?

Select one of the following:

  • SELECT ALL FROM emp

  • SELECT # FROM emp

  • SELECT * FROM emp

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

Explanation

Question 25 of 25

1

Which of the below SQL query will display employee names, department, and annual salary?

Select one of the following:

  • SELECT ename, deptno, sal FROM emp;

  • SELECT ename, deptno, sal + comm FROM emp;

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

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

Explanation

Previous
Next