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
sql
  1. Indexed view

  2. procedures

  3. triggers

  4. views


Correct Option: A
sql
  1. Data types

  2. Primary keys

  3. Default values

  4. All of the above.


Correct Option: D

SQL query and modification commands make up a(n)

sql
  1. DDL

  2. DML

  3. HTML

  4. XML


Correct Option: B

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

AI Explanation

To answer this question, you need to understand the concept of wildcards in Microsoft Access.

Wildcards are special characters that are used to represent unknown or variable values in a search pattern. They are used in queries to search for data that matches a specific pattern.

The correct answer is D) question mark (?); asterisk (*).

Option A) asterisk (); percent sign (%) - This option is incorrect because the asterisk () is used to represent any number of characters, while the percent sign (%) is used as a wildcard in SQL, but not in Microsoft Access. Option B) percent sign (%); underscore () - This option is incorrect because the percent sign (%) is used as a wildcard in SQL, but not in Microsoft Access. The underscore () is used as a wildcard in Microsoft Access, but it is not one of the wildcards mentioned in the correct answer. Option C) underscore (); question mark (?) - This option is incorrect because the underscore () is used as a wildcard in Microsoft Access, but it is not one of the wildcards mentioned in the correct answer. The question mark (?) is not a wildcard in Microsoft Access. Option D) question mark (?); asterisk () - This option is correct because the question mark (?) is used to represent a single character, and the asterisk () is used to represent any number of characters in a search pattern in Microsoft Access.

Therefore, the correct answer is D) question mark (?); asterisk (*).

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

Which of the following statements is false?

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

AI Explanation

To answer this question, we need to understand the basic components of a database.

Option A) Tables contain one or more rows - This option is correct. In a database, a table is a collection of rows that represent individual records or entries.

Option B) Rows contain one or more database of information - This option is false. Rows in a table contain the actual data or information for each record or entry. They do not contain databases.

Option C) Databases contain one or more tables - This option is correct. A database is a collection of related data. It can contain one or more tables that are used to organize and store the data.

The correct answer is B) Rows contain one or more database of information. This option is false because rows in a table contain data, not databases.

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