COMPUTER SCIENCE AND ENGINEERING
DATABASE MANAGEMENT SYSTEM
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
OLE Object
|
|
|
Lookup Wizard
|
|
|
Attachment
|
|
|
Hyperlink
|
Detailed explanation-1: -Think of a field’s data type as a set of qualities that applies to all the values that are contained in the field. For example, values that are stored in a Text field can contain only letters, numbers, and a limited set of punctuation characters, and a Text field can only contain a maximum of 255 characters.
Detailed explanation-2: -A lookup field is a field in a table whose value is retrieved from another table or query. Whenever possible, you should use the Lookup Wizard to create a lookup field. The Lookup Wizard simplifies the process and automatically populates the appropriate field properties and creates the appropriate table relationships.
Detailed explanation-3: -The %ROWTYPE attribute provides a record type that represents a row in a database table. The record can store an entire row of data selected from the table or fetched from a cursor or cursor variable.