Tag: technology

PPOSA_BBP

PPOSW

PPOSA

SM38

You can use group functions in any clause of a select statement

You can use group functions only in the column list of the SELECT statement by grouping on the single row columns

You can pass column names, expressions, constants or functions as parameters to a group function

You cannot group the rows of a table by more than one column while using group functions

SELECT SUBSTR('Hello',) FROM dual;

SELECT INITCAP(TRIM('Hello World',1,1)) FROM dual;

SELECT LOWER(SUBSTR('Hello World',1,1)) FROM dual;

SELECT LOWER(SUBSTR('Hello World',2,1)) FROM dual;

SELECT LOWER(TRIM('H' FROM 'Hello World')) FROM dual;

True

False

Indexes are only used in special cases

Indexes are used to make table storage more efficient

Indexes rarely make a difference in SQL performance

Indexes exist solely to improve query speed.

NOT NULL

PRIMARY KEY

FOREIGN KEY

CHECK

UNIQUE

8

2

3

4

5

There is no such criteria

TRUNCATE * from TABLE Sales

TRUNCATE TABLE Sales

TRUNCATE Sales TABLE

TRUNCATE * FROM Sales

Once created a sequence belongs to a specific schema.

Once created, a sequence is linked to a specified table.

Once created a sequence is automatically available to all users.

Only the DBA can control which sequence is used by a certain table.

Once created a sequence is automatically used in all INSERT and UPDATE statements.

True

False