Tag: databases

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;

SELECT &1, "&2"FROM &3 WHERE last_name = '&4';

SELECT &1, '&2' FROM &3 WHERE '&last_name = '&4'';

SELECT &1, &2 FROM &3 WHERE last_name = '&4';

SELECT &1, '&2' FROM EMP WHERE last_name = '&4';

Alice only

Alice and Rena

Alice, Rena, and Timber

Sue, Alice, Rena, and Timber

Integrated Data Management System

Integrated Database Management System

Integrated Database Messaging System

Internal Database Management System

Hierarchical

Relational

Network

Other

Owner and Child

Head and Child

Owner and Member

Head and Tail

Set

Page

Area

Record Type

Area

Set Type

Record Type

Relation