0

databases Online Quiz - 240

Description: databases Online Quiz - 240
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. SELECT FROM GROUP BY WHERE

  2. SELECT FROM GROUP BY ROLLUP

  3. SELECT GROUP BY FROM

  4. SELECT WHERE FROM GROUP BY


Correct Option: B
  1. Restricts the length of the String

  2. Replaces a sequence of characters in a string with another set of characters

  3. Modifies the datatype of a column

  4. Renames a column


Correct Option: B
  1. Replaces word by word

  2. Replaces a column with another column

  3. Replaces character by character

  4. Replaces a row with another row


Correct Option: A
  1. IN executes the inner query for each row affected by the outer query and EXISTS executes the inner query only once irrespective of the outer query

  2. IN executes the inner query only once irrespective of the outer query and EXISTS executes the inner query only once irrespective of the outer query

  3. IN executes the inner query only once irrespective of the outer query and EXISTS executes the outer query for each row affected by the outer query

  4. IN executes the inner query for each row affected by the outer query and EXISTS executes the outer query for each row affected by the outer query


Correct Option: C
  1. AMP bucket number

  2. Primary Index

  3. Primary Key

  4. None of the above


Correct Option: B

_____ and _____ are true about the Primary Index

  1. Defined immediately after the table CREATE statement, used to find the Primary Key

  2. Defined during the table CREATE statement, used to assign rows to an AMP

  3. Defined immediately after the table CREATE statement, used to assign rows to an AMP

  4. Defined during the table CREATE statement, used to find the Primary Key


Correct Option: B
  1. Defined immediately after the table CREATE statement, used to assign rows to an AMP

  2. Defined immediately after the table CREATE statement, used to find the Primary Key

  3. Defined during the table CREATE statement, used to assign rows to an AMP

  4. Defined during the table CREATE statement, used to find the Primary Key


Correct Option: C
  1. select '''||'TCS'||''' from dual

  2. select 'TCS' from dual

  3. select '''TCS''' from dual

  4. select "TCS" from dual


Correct Option: A
  1. select '''||'TCS ||''' from dual

  2. select '''TCS''' from dual

  3. select "TCS" from dual

  4. select 'TCS' from dual


Correct Option: B
  1. Nothing

  2. Everything

  3. Disk

  4. Processor


Correct Option: A
- Hide questions