Home Library Explore SAT

Home Library Explore SAT

Day 3 - Computed Column Flashcards | StudBud

Explore/Day 3 - Computed Column

Which of the following expressions can be used to create a computed column?

Which of the following statements is true about computed columns in SQL Server?

Day 3 - Computed Column

5 terms·StudBud Administration·10 plays

Imported from external platform

Flashcards5 cardsFPractice quizPHost liveL

Questions 5

Answers

1
Which of the following statements is true about computed columns in SQL Server?
Computed columns cannot use functions like GETDATE() in their expressions
Can use other columns from the same table in their expressions.
Can only be created on tables, not on views.
Computed columns cannot be used in JOIN operations.
2
Which of the following expressions can be used to create a computed column?
Mathematical operations (e.g., +, -, *, /)
Conditional logic (e.g., CASE statement)
All of the above
String functions (e.g., CONCAT(), LEFT())
3
Which data types cannot be used in a computed column in SQL Server?
INT, VARCHAR
DATE, DATETIME
BIGINT, FLOAT
TEXT, IMAGE
4
What happens if you create a computed column without marking it as PERSISTED?
The computed value is recalculated every time the column is accessed
The column can only contain NULL values
The computed column is automatically indexed
The computed value is stored physically in the database
5
Which of the following is a valid use of a computed column?
Holding user login credentials
Automatically calculating the total cost based on quantity and unit price
Storing a hashed value of a password
Defining the primary key