OMIS 452 Quiz | Questions and Answers
100% Solved
Fixed-length; Alpha/Numeric (ex. State Abbreviation) - 🧠 ANSWER
✔✔Char
Whole Number (1,234,567,890) - 🧠 ANSWER ✔✔Integer
Decimal Number (ex. 3.141592) - 🧠 ANSWER ✔✔Numeric
Variable Length; Alpha/numeric (ex. Notes, Blobs, etc.) - 🧠 ANSWER
✔✔Text
Variable length; alpha numeric; max= 8000 - 🧠 ANSWER ✔✔varchar
Decimal number- 10,000th precision (ex. 3.1416) - 🧠 ANSWER ✔✔Money
, Which SQL keyword is used to change one or more rows in a table? - 🧠
ANSWER ✔✔UPDATE
A SQL virtual table is called - 🧠 ANSWER ✔✔A view
When the correct SQL command is used to delete a table's structure, what
happens to the data in the table? - 🧠 ANSWER ✔✔The data in the table is
also deleted
Which SQL keyword is used to delete a table's structure? - 🧠 ANSWER
✔✔DROP
A set of SQL statements stored in an application written in a standard
programming language is called - 🧠 ANSWER ✔✔embedded SQL
Which of the following constraints MUST appear in each CREATE TABLE
statement? - 🧠 ANSWER ✔✔Primary Key
A set of SQL statements stored in an application written in a standard
programming language is called embedded SQL. - 🧠 ANSWER ✔✔True
T/F The SQL keyword MODIFY is used to change a column value. - 🧠
ANSWER ✔✔FALSE
100% Solved
Fixed-length; Alpha/Numeric (ex. State Abbreviation) - 🧠 ANSWER
✔✔Char
Whole Number (1,234,567,890) - 🧠 ANSWER ✔✔Integer
Decimal Number (ex. 3.141592) - 🧠 ANSWER ✔✔Numeric
Variable Length; Alpha/numeric (ex. Notes, Blobs, etc.) - 🧠 ANSWER
✔✔Text
Variable length; alpha numeric; max= 8000 - 🧠 ANSWER ✔✔varchar
Decimal number- 10,000th precision (ex. 3.1416) - 🧠 ANSWER ✔✔Money
, Which SQL keyword is used to change one or more rows in a table? - 🧠
ANSWER ✔✔UPDATE
A SQL virtual table is called - 🧠 ANSWER ✔✔A view
When the correct SQL command is used to delete a table's structure, what
happens to the data in the table? - 🧠 ANSWER ✔✔The data in the table is
also deleted
Which SQL keyword is used to delete a table's structure? - 🧠 ANSWER
✔✔DROP
A set of SQL statements stored in an application written in a standard
programming language is called - 🧠 ANSWER ✔✔embedded SQL
Which of the following constraints MUST appear in each CREATE TABLE
statement? - 🧠 ANSWER ✔✔Primary Key
A set of SQL statements stored in an application written in a standard
programming language is called embedded SQL. - 🧠 ANSWER ✔✔True
T/F The SQL keyword MODIFY is used to change a column value. - 🧠
ANSWER ✔✔FALSE
