A Guide to SQL
9th Edition
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Philip J. Pratt
Chapter3: Creating Tables
Section: Chapter Questions
Problem 4CAT
icon
Related questions
Question

PLEASE JUST TRUE OR FALSE

1

A row of data has to be all the same data type

 

T

 

F

2

A column of data has to be all the same data type

 

T

 

F

3

A data warehouse is a repository of information gathered from one Relational database

 

T

 

F

4

A trigger can only be connected to one table, and only update one table

 

T

 

F

5

  If none of the attributes in the WHERE clause have indexes, the DBMS engine will be forced to do full table scans

 

T

 

F

6

You can have multiple triggers on the same table, and a trigger can be assigned to multiple tables

 

T

 

F

7

You should put an index on any attribute found in a WHERE clause

 

T

 

F

8

Checkpoints help the Recovery Manger streamline the recovery procedure

 

T

 

F

9

Big Data applications strictly adhere to ACID properties

T

F

10

A data warehouse should be used for OLAP processing

T

F

Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Database Environment
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
A Guide to SQL
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning