WorksheetsData Type
Total questions: 20
Worksheet time: 7mins
Which attribute specifies the type of data that an object can hold and specifies how many bytes it will take up?
specifier
data type
validator
data specific
What common data type you would be used to count
money
integer
float
double
What common data type is used to store decimal numbers such as 3.14 and 7.07?
money
integer
float
char
Which data type should you use to store text based on English?
text
int
float
varchar
How many bytes does the int data type take up?
1 byte
4 byte
8 byte
16 byte
How many bytes does the money data type take up?
1 byte
4 byte
8 byte
16 byte
What type of conversion occurs without specifying the actual callout function?
implicit
explicit
casting
autocasting
How many bytes does a single character take up if it is a varchar that supports English and most European languages?
1 byte
2 byte
4 byte
8 byte
What kind of character takes up two bytes of storage and can include almost any language including Chinese, Japanese, and Arabic?
standard
ANSI
Unicode
Duocode
What data type should you use to support Japanese or Arabic text?
nvarchar
varchar
Unicode
varchar
Which naming conversion would capitalize the first character of each word with no spaces?
PascalCase
camelCase
CapCase
FirstCase
What is a virtual table consisting of different columns from one or more tables?
index
view
vtable
vlookup
What are previously written SQL statements that have been stored within a database?
data statements
views
DDL statements
stored procedures
What command is used to execute a stored procedure?
go
use
start
exec
What is a type of attack in which malicious code is inserted into strings that are passed to the SQL server instance?
SQL infection
SQL takeover
SQL injection
SQL force
What is the set of rules that determine how data is sorted and compared?
sort rule
filter
constraint
collation
What type of data type would you use to store true/false or yes/no answers?
int
char
boolean
logic
A char string can be up to _______ characters long.
5000
8000
10000
2500
What does VARCHAR(25) represent?
A character string up to 25 characters long
A character string up to 50 characters long
A character string up to 75 characters long
A character string up to 125 characters long
What two commands will perform implicit conversion?
Cast and Convert.
Cash and Convert.
Cast and Concern.
Cash and Comfort.
