Oracle 1Z0-071 Quiz 42 Topic 12 Questions 206-210

Question: 1

Which three arithmetic operations can be performed on a column by using a SQL function that is built into Oracle database? (Choose three.)

AFinding the lowest value

BFinding the quotient

CRaising to a power

DSubtraction

EAddition

Show Answer

Question: 2

View the Exhibit and examine the structure of the EMPLOYEES and JOB_HISTORY tables.

q2_1Z0-071

Examine this query which must select the employee IDs of all the employees who have held the job SA_MAN at any time during their employment.

SELECT employee_id

FROM employees

WHERE job_id = 'SA_MAN'

-------------------------------------

SELECT employee_id

FROM job_history

WHERE job_id='SA_MAN';

Choose two correct SET operators which would cause the query to return the desired result. (Choose two.)

AUNION

BMINUS

CINTERSECT

DUNION ALL

Show Answer

Question: 3

You must create a SALES table with these column specifications and data types:

SALESID: Number

STOREID: Number

ITEMID: Number

QTY: Number, should be set to 1 when no value is specified

SLSDATE: Date, should be set to current date when no value is specified

PAYMENT: Characters up to 30 characters, should be set to CASH when no value is specified

Which statement would create the table? (Choose the best answer.)

ACREATE TABLE sales(salesid NUMBER(4),storeid NUMBER(4),itemid NUMBER(4),qty NUMBER DEFAULT = 1,slsdate DATE DEFAULT SYSDATE,payment VARCHAR2(30) DEFAULT = 'CASH');

BCREATE TABLE sales(salesid NUMBER(4),storeid NUMBER(4),itemid NUMBER(4),qty NUMBER DEFAULT 1,slsdate DATE DEFAULT 'SYSDATE',payment VARCHAR2(30) DEFAULT CASH);

CCREATE TABLE sales(salesid NUMBER(4),storeid NUMBER(4),itemid NUMBER(4),qty NUMBER DEFAULT = 1,slsdate DATE DEFAULT SYSDATE,payment VARCHAR2(30) DEFAULT = 'CASH');

DCREATE TABLE sales(salesid NUMBER(4),storeid NUMBER(4),itemid NUMBER(4),qty NUMBER DEFAULT 1,slsdate DATE DEFAULT SYSDATE,payment VARCHAR2(30) DEFAULT 'CASH');

Show Answer

Question: 4

View the Exhibit and examine the details of the PRODUCT_INFORMATION table. (Choose two.)

q4_1Z0-071

Evaluate this SQL statement:

SELECT TO_CHAR(list_price,'$9,999')

From product_information;

Which two statements are true regarding the output? (Choose two.)

AA row whose LIST_PRICE column contains value 11235.90 would be displayed as #######.

BA row whose LIST_PRICE column contains value 1123.90 would be displayed as $1,123.

CA row whose LIST_PRICE column contains value 1123.90 would be displayed as $1,124.

DA row whose LIST_PRICE column contains value 11235.90 would be displayed as $1,123.

Show Answer

Question: 5

Which statement is true about SQL query processing in an Oracle database instance? (Choose the best answer.)

ADuring parsing, a SQL statement containing literals in the WHERE clause that has been executed by any session and which is cached in memory, is always reused for the current execution.

BDuring execution, the Oracle server may read data from storage if the required data is not already in memory.

CDuring row source generation, rows that satisfy the query are retrieved from the database and stored in memory.

DDuring optimization, execution plans are formulated based on the statistics gathered by the database instance, and the lowest cost plan is selected for execution.

Show Answer

Oracle 1Z0-071 Quiz:42 Topic:12 Questions:206-210