Tag: databases

Questions Related to databases

In NPS, in 'nzsql' the command to list a user's permission is.

  1. \du

  2. \dpu

  3. \dt

  4. \d


Correct Option: B

In NPS, 'nzsql -d' will list all the databases

  1. True

  2. False


Correct Option: B

In NPS, the max number of columns that can be used for a distribution key?

  1. 2

  2. 3

  3. 4

  4. 5


Correct Option: C

An NPS 10600 has how many SPU's

  1. 672

  2. 674

  3. 676

  4. 678


Correct Option: A

In NPS, boolean data types make good distribution keys

  1. True

  2. False


Correct Option: B

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