0

databases Online Quiz - 195

Description: databases Online Quiz - 195
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

In NPS, 'RENAME TABLE customer TO customer_new' will rename the customer table to customer_new.

  1. True

  2. False


Correct Option: B

In NPS the minimum NPS row overhead is how many bytes

  1. 22

  2. 24

  3. 26

  4. 28


Correct Option: D

In NPS, boolean data types make good distribution keys

  1. True

  2. False


Correct Option: B
  1. Sending data to all SPUs by SMP host

  2. Sending data to all SPUs by user

  3. Sending data to all SPUs by Operating system

  4. Sending data to SMP host by SPUs


Correct Option: A

In NPS, by default, what is used to signal the end of a line or SQL command within an nzsql session?

  1. single quote

  2. semicolon

  3. double quote

  4. colon


Correct Option: B

An NPS 10600 has how many SPU's

  1. 672

  2. 674

  3. 676

  4. 678


Correct Option: A

In NPS, 'RENAME TABLE customer TO customer_new' will rename the customer table to customer_new

  1. True

  2. False


Correct Option: B

In NPS , 'ALTER TABLE customer ADD COLUMN (newcol char(10))' will add a new column to the table

  1. True

  2. False


Correct Option: B

In NPS, the minimum size of an extent on a SPU is:

  1. 2 mb

  2. 3 mb

  3. 4 mb

  4. 5 mb


Correct Option: B
- Hide questions