Database Terms From The Book Flashcards
1
Q
The information about database and table, layout, and properties is called
A
Schema
2
Q
A type of allowed data in a column is called
A
Datatype
It’s restricts the type of data that can be stored in a column
3
Q
A column or instead of columns, whose value uniquely identify every role in the table is called
A
Primary key
It’s used to refer to a specific row
4
Q
SQL stands for
A
Structured Query Language
5
Q
Two Keyboard key that can be used to execute statement
A
F5 and Ctrl+E
6
Q
When a column contains no value, it’s said to contain a________value.
A
NULL value
7
Q
A special keyword used to join or change clause with a WHERE clause is
A
Operator . Also known as logical operator
8
Q
Joining values together ( by appending them to each other) to form a single value is called
A
Concatenate
