MTA DAF 2

Question 1

Wich data type should you use to store text based on English?

Answer 1

varchar

Question 2

How many bytes does the int data type take up?

Answer 2

4

Question 3

What are previously written SQL statements that habe been stored within a database?

Answer 3

stored procedures

Question 4

What is a virtual table consisting of different columns from one or more tables?

Answer 4

view

Question 5

What type of conversion occurs without specifying the actual callout function?

Answer 5

implicit

Question 6

Which naming conversion would capitalize the first of each word with no spaces?

Answer 6

PascalCase

Question 7

Wich attribute specifies the type of data that an object can hold and specifies how many bytes it will take up?

Answer 7

data type

Question 8

What is the set of rules that determine how data is stored and compared?

Answer 8

collation

Question 9

What command is used to execute a stored procedure?

Answer 9

exec

Question 10

What kind of character takes up two bytes of storage and can include almost any language including Chinese, Japanese and Arabic?

Answer 10

Unicode

Question 11

What is a type of attack in which malicious code is inserted into strings that are passed to the SQL server instance?

Answer 11

SQL injection

Question 12

How many bytes does the money data type take up?

Answer 12

8 Byte

Question 13

What common data type you would be used to count objects?

Answer 13

integer

Question 14

How many bytes does a single character take up if it is a varchar that supports English and most European languages?

Answer 14

1 byte

Question 15

What type of data type would you use to store true/false or yes/no answers?

Answer 15

Boolean

Question 16

What common data type is used to store decimal numbers such as 3.14 and 7.07?

Answer 16

float

Question 17

What data type should you use to support Japanese or Arabic Text?

Answer 17

nvarchar