Tag: technology

SELECT last_name, 12*salary*commission_pct FROM emp;

SELECT last_name, 12*salary* (commission_pct,0) FROM emp;

SELECT last_name, 12*salary*(nvl(commission_pct,0)) FROM emp

SELECT last_name, 12*salary*(decode(commission_pct,0)) FROM emp;

SUM(start_date)

AVG(start_date)

COUNT(start_date)

AVG(start_date, end_date)

MIN(start_date)

MAXIMUM(start_date)

0

1

0.00

An error statement

The statement executes successfully and returns the student ID and sum of all marks for each student who obtained more than the average mark in each subject.

The statement returns an error at the SELECT clause.

The statement returns an error at the WHERE clause.

The statement returns an error at the ORDER BY clause.

The underlying tables must have data.

You need SELECT privileges on the view.

The underlying tables must be in the same schema.

You need SELECT privileges only on the underlying tables.

SELECT ENAME FROM EMP WHERE SYSDATE-HIRE_DATE > 5;

SELECT ENAME FROM EMP WHERE HIRE_DATE-SYSDATE > 5;

SELECT ENAME FROM EMP WHERE (SYSDATE-HIRE_DATE)/365 > 5;

SELECT ENAME FROM EMP WHERE (SYSDATE-HIRE_DATE)* 365 > 5;

The two statements produce identical results.

The second statement returns a syntax error.

There is no need to specify DESC because the results are sorted in descending order by default.

The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.

INSTR returns the numeric position of a named character.

NVL2 returns the first non-null expression in the expression list.

TRUNCATE rounds the column, expression, or value to n decimal places.

DECODE translates an expression after comparing it to each search value.

TRIM trims the heading or trailing characters (or both) from a character string.

NULLIF compares two expressions and returns null if they are equal, or the first expression if they are not equal.

CREATE USER Susan;

CREATE OR REPLACE USER Susan;

CREATE NEW USER Susan DEFAULT;

CREATE USER Susan IDENTIFIED BY blue;

CREATE NEW USER Susan IDENTIFIED by blue;

CREATE OR REPLACE USER Susan IDENTIFIED BY blue;