0

SQL Online Quiz - 3

Description: SQL Online Quiz - 3
Number of Questions: 9
Created by:
Tags: sql
Attempted 0/9 Correct 0 Score 0

SELF JOIN not allowed in

sql
  1. Indexed view

  2. procedures

  3. triggers

  4. views


Correct Option: A

Which of the following do you need to consider when you make a table in SQL?

sql
  1. Data types

  2. Primary keys

  3. Default values

  4. All of the above.


Correct Option: D

When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s

sql
  1. LIKE only.

  2. IN only.

  3. NOT IN only.

  4. Both IN and NOT IN.


Correct Option: D

The Microsoft Access wildcards are ____ and ____

sql
  1. asterisk (*); percent sign (%)

  2. percent sign (%); underscore (_)

  3. underscore(_); question mark (?)

  4. question mark (?); asterisk (*)


Correct Option: D
sql
  1. SELECT NAME IN CUSTOMER WHERE STATE IN ('VA');

  2. SELECT NAME IN CUSTOMER WHERE STATE = 'VA';

  3. SELECT NAME IN CUSTOMER WHERE STATE = 'V'

  4. SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');


Correct Option: D

On UPDATE CASCADE ensures which of the following

sql
  1. Normalization

  2. Data Integrity

  3. Materialized Views

  4. All of the above


Correct Option: B
sql
  1. Tables contain one or more rows

  2. Rows contain one or more database of information

  3. Databases contain one or more tables


Correct Option: B

Which portion of a database system contains the actual data elements, such as the name, address, or a phone number for a particular person?

sql
  1. Tables

  2. Columns

  3. Rows

  4. Databases


Correct Option: B
- Hide questions