Tag: programming languages

Questions Related to programming languages

MAXVALUE is a valid parameter for sequence creation.
technology programming languages

  1. True

  2. False

Show answer
Correct Option: A

Which function below can best be categorized as similar in function to an IF-THEN-ELSE statement?
technology programming languages

  1. SQRT

  2. DECODE

  3. NEW_TIME

  4. ROWIDTOCHAR

Show answer
Correct Option: B

Creating a foreign-key constraint between columns of two tables defined with two different datatypes will produce an error.
technology programming languages

  1. True

  2. False

Show answer
Correct Option: A

SELECT (TO_CHAR(NVL(SQRT(59483), “INVALID”)) FROM DUAL is a valid SQL statement
technology programming languages

  1. True

  2. False

Show answer
Correct Option: B

The NVL function

technology programming languages

  1. Place the alias at the beginning of the statement to describe the table.

  2. Place the alias after each column, separated by white space, to describe the column.

  3. Place the alias after each column, separated by a comma, to describe the column

  4. Place the alias at the end of the statement to describe the table.

Show answer
Correct Option: C

Issuing the DEFINE_EDITOR=”emacs” will produce which outcome?
technology programming languages

  1. The emacs editor will become the SQL*Plus default text editor.

  2. The emacs editor will start running immediately.

  3. The emacs editor will no longer be used by SQL*Plus as the default text editor.

  4. The emacs editor will be deleted from the system.

Show answer
Correct Option: A

Once defined, how long will a variable remain so in SQL*Plus?
technology programming languages

  1. Until the database is shut down

  2. Until the instance is shut down

  3. Until the statement completes

  4. Until the session completes

Show answer
Correct Option: C

Which of the following options will allow you to drop the user david and all objects in the schema that are associated with that user?
technology programming languages

  1. DROP USER david all

  2. DROP USER david schema

  3. DROP USER david cascade

  4. DROP USER david cascade schema

Show answer
Correct Option: C

identify the meaning of the following SQL statement CREATE USER PETRIE IDENTIFIED EXTERNALLY DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMPS QUOTA 12M ON forms
technology programming languages

  1. The user is being validated by the enterprise directory service

  2. The user has unlimited quota on the USERS tablespace.

  3. The user’s quota will never exceed the size of the temporary tablespace.

  4. All options are correct.

Show answer
Correct Option: B

You are setting up two multiplexed online redo log file groups with three members in each group, how many disks are necessary at minimum?
technology programming languages

  1. 3

  2. 0

  3. 1

  4. no disk required

Show answer
Correct Option: A