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, the max number of columns that can be used for a distribution key?

  1. 2

  2. 3

  3. 4

  4. 5


Correct Option: C

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, '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, 'RENAME TABLE customer TO customer_new' will rename the customer table to customer_new.

  1. True

  2. False


Correct Option: B

In NPS, boolean data types make good distribution keys

  1. True

  2. False


Correct Option: B

In NPS, broadcasting of a table means

  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

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, '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, 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, '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

In NPS, the nzsql internal command '\d' describes an object.exampl \d customer will describe customer table

  1. True

  2. False


Correct Option: A
- Hide questions