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, '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, in 'nzsql' the command to list a user's permission is.

  1. \du

  2. \dpu

  3. \dt

  4. \d


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, the nzsql internal command '\d' describes an object.exampl \d customer will describe customer table

  1. True

  2. False


Correct Option: A
- Hide questions