IS 410 Study Guide Questions with Correct
Answers
Identify the capabilities of SELECT statement.
A. Projection
B. Selection
C. Data Control
D. Transaction
A & B. The SELECT statement can be used for selection, projection and joining.
2. 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;
A. Selection
B. Filtering
C. Joining
D. Projection
A, C, D. Projection is including only the required columns in query, while Selection is
selecting only the required data. Joining means combining two tables together through a
connecting column.
Which of the following clause is used to suppress duplicates in a SELECT statement?
A. INTERSECT
,B. DUPLICATE
C. DISTINCT
D. UNIQUE
C, D. Duplicate data can be restricted with the use of DISTINCT or UNIQUE in the SELECT
statement.
Determine the output of the below query -
SELECT '5+7'
FROM dual;
A. 12
B. 5+7
C. 5
D. 7
B, Oracle treats the values within double quotes as string expressions.
Chose the statements which correctly define a NULL value.
A. NULL is a special value with zero bytes
B. NULL is no value or unknown value
C. NULL is represented by a blank space
D. NULL is not same as zero
B & D. NULL is NO VALUE but neither same as zero nor as blank or space character.
What is true about data types in Oracle DB?
A. They are given to columns for sorting purposes.
, B. They are given to columns for a structured representation in a table.
C. They are given to columns to constrain the nature of the data it can store.
D. They are not mandatory.
C. Data types define the nature of data which a column can store in a table. A column can
store only one type of data. The primary data types available in Oracle are NUMBER,
VARCHAR2, and DATE.
Which of the following data types are appropriate for general functions?
A. VARCHAR2
B. NUMBER
C. DATE
D. All Datatypes
D. General functions are usually compatible with all primary data types like NUMBER,
VARCHAR2 and DATE.
Assuming the SYSDATE is 01-JAN-13, what will be the outcome of the following
query?
SELECT TO_CHAR (SYSDATE, 'DDTH') FROM dual;
A. 1st of January
B. 1st
C. 1 ST
D. 01ST
D. 01ST
Answers
Identify the capabilities of SELECT statement.
A. Projection
B. Selection
C. Data Control
D. Transaction
A & B. The SELECT statement can be used for selection, projection and joining.
2. 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;
A. Selection
B. Filtering
C. Joining
D. Projection
A, C, D. Projection is including only the required columns in query, while Selection is
selecting only the required data. Joining means combining two tables together through a
connecting column.
Which of the following clause is used to suppress duplicates in a SELECT statement?
A. INTERSECT
,B. DUPLICATE
C. DISTINCT
D. UNIQUE
C, D. Duplicate data can be restricted with the use of DISTINCT or UNIQUE in the SELECT
statement.
Determine the output of the below query -
SELECT '5+7'
FROM dual;
A. 12
B. 5+7
C. 5
D. 7
B, Oracle treats the values within double quotes as string expressions.
Chose the statements which correctly define a NULL value.
A. NULL is a special value with zero bytes
B. NULL is no value or unknown value
C. NULL is represented by a blank space
D. NULL is not same as zero
B & D. NULL is NO VALUE but neither same as zero nor as blank or space character.
What is true about data types in Oracle DB?
A. They are given to columns for sorting purposes.
, B. They are given to columns for a structured representation in a table.
C. They are given to columns to constrain the nature of the data it can store.
D. They are not mandatory.
C. Data types define the nature of data which a column can store in a table. A column can
store only one type of data. The primary data types available in Oracle are NUMBER,
VARCHAR2, and DATE.
Which of the following data types are appropriate for general functions?
A. VARCHAR2
B. NUMBER
C. DATE
D. All Datatypes
D. General functions are usually compatible with all primary data types like NUMBER,
VARCHAR2 and DATE.
Assuming the SYSDATE is 01-JAN-13, what will be the outcome of the following
query?
SELECT TO_CHAR (SYSDATE, 'DDTH') FROM dual;
A. 1st of January
B. 1st
C. 1 ST
D. 01ST
D. 01ST
