Tag: databases

Questions Related to databases

An NPS 10600 has how many SPU's
technology databases

  1. True

  2. False

Show answer
Correct Option: A

In NPS, you can ALTER DATABASE while other people are accessing the same database
technology databases

  1. No

  2. Yes

  3. 1

  4. 0

Show answer
Correct Option: A

In NPS, in the expression 'NULL = NULL' results in a value of 'true'
technology databases

  1. 0

  2. NULL=NULL

  3. 1

  4. 2

Show answer
Correct Option: B

In NPS, you can use datasliceid to view distribution
technology databases

  1. No

  2. Yes

  3. 0

  4. 1

Show answer
Correct Option: B

Which operators can be used for a subquery to return multiple rows? (MCQ)
technology databases

  1. IN

  2. ALL

  3. <>

  4. ANY

Show answer
Correct Option: A,B,D

Choose the options which represent true statements? (MCQ)
technology databases

  1. SQL is a language for accessing data from an Oracle server

  2. iSQL*Plus cannot be abbreviated

  3. SQL cannot be abbreviated.

  4. iSQL*Plus is a language for accessing data from an Oracle

Show answer
Correct Option: A,C

Which of the following options IS NOT represent types of Single-Row functions?
technology databases

  1. Number functions

  2. Conversion functions

  3. Date Functions

  4. Compute functions

Show answer
Correct Option: D

Which of the following options represent explicit data-type conversion functions?
technology databases

  1. TO_CHAR

  2. TO_VALUE

  3. TO_DATE

  4. TO_ERROR

Show answer
Correct Option: A,C

What can NOT you accomplish using a SQL SELECT statement?
technology databases

  1. Creation of a new table based off of the output of SELECT statements

  2. Return information from specific columns

  3. Return information from specific rows

  4. The combination of values in different tables

Show answer
Correct Option: A

A subquery can consist of a statement located within a clause from a parent statement?
technology databases

  1. Creation of a new table based off of the output of SELECT statements

  2. Return information from specific columns

  3. Return information from specific rows

  4. The combination of values in different tables

Show answer
Correct Option: B,C,D