Tag: databases

Removes the table

Removes all rows from a table

shortens the table to 10 rows

Removes all columns from a table

Removes foreign keys from a table

"&"

ACCEPT

PROMPT

"&&"

A view can be created as read only

A view can be created as a join on two or more tables.

A view cannot have an ORDER BY clause in the SELECT statement

A view cannot be created with a GROUP BY clause in the SELECT statement

A view must have aliases defined for the column names in the SELECT statement

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;