OMIS 452 Quiz | Questions and Answers 100% Solved
Save
3
Practice questions for this set
Learn 1 /7 Study with Learn
T/F SQL Server has facilities for generating XML documents from database data.
Choose an answer
1 True 2 False
Don't know?
Terms in this set (79)
, Fixed-length; Alpha/Numeric Char
(ex. State Abbreviation)
Whole Number (1,234,567,890) Integer
Decimal Number (ex. 3.141592) Numeric
Variable Length; Alpha/numeric Text
(ex. Notes, Blobs, etc.)
Variable length; alpha numeric; varchar
max= 8000
Decimal number- 10,000th Money
precision (ex. 3.1416)
Which SQL keyword is used to UPDATE
change one or more rows in a
table?
A SQL virtual table is called A view
When the correct SQL The data in the table is also deleted
command is used to delete a
table's structure, what happens
to the data in the table?
Which SQL keyword is used to DROP
delete a table's structure?
Save
3
Practice questions for this set
Learn 1 /7 Study with Learn
T/F SQL Server has facilities for generating XML documents from database data.
Choose an answer
1 True 2 False
Don't know?
Terms in this set (79)
, Fixed-length; Alpha/Numeric Char
(ex. State Abbreviation)
Whole Number (1,234,567,890) Integer
Decimal Number (ex. 3.141592) Numeric
Variable Length; Alpha/numeric Text
(ex. Notes, Blobs, etc.)
Variable length; alpha numeric; varchar
max= 8000
Decimal number- 10,000th Money
precision (ex. 3.1416)
Which SQL keyword is used to UPDATE
change one or more rows in a
table?
A SQL virtual table is called A view
When the correct SQL The data in the table is also deleted
command is used to delete a
table's structure, what happens
to the data in the table?
Which SQL keyword is used to DROP
delete a table's structure?
