MCQ IN COMPUTER SCIENCE & ENGINEERING

COMPUTER SCIENCE AND ENGINEERING

DATABASE MANAGEMENT SYSTEM

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
The type of datatype which allows alphanumeric characters and special symbols but can store up to 255 characters.
A
Auto number
B
Text
C
OLE Object
D
Memo
Explanation: 

Detailed explanation-1: -Short Text In . accdb files, the Short Text field works the same as the Text field in earlier versions. It stores up to 255 characters. Learn more about data types for Access desktop databases.

Detailed explanation-2: -Overview of Character Data Types You can use these SQL data types to store alphanumeric data: CHAR and NCHAR data types store fixed-length character literals. VARCHAR2 and NVARCHAR2 data types store variable-length character literals.

Detailed explanation-3: -The CHAR data type stores any string of letters, numbers, and symbols. It can store single-byte and multibyte characters, based on the database locale. The CHARACTER data type is a synonym for CHAR.

There is 1 question to complete.