Questions · Page 1 of 3

MCQ . (1 Marks)

🎯

Test yourself on this topic

50 questions · timed · auto-graded

MCQ 11 Mark
Numeric data type attributes are described by the ………………
  • A
    binary value
  • B
    signed 
  • C
    unsigned
  • All of these
Answer
Correct option: D.
All of these
 All of these
View full question & answer
MCQ 21 Mark
………………….  Type is used to store numerical information.
  • A
    Alphabetic type 
  • Numeric type
  • C
    Binary type 
  • D
    calendar type
Answer
Correct option: B.
Numeric type
Numeric type
View full question & answer
MCQ 31 Mark
how much bytes are used by field is decided by whom ?
  • A
    Users  
  • B
    Administrator
  • Software
  • D
    All of these
Answer
Correct option: C.
Software
Software
View full question & answer
MCQ 41 Mark
$UTF -8$ is compatible with both …………
  • A
    ASCII
  • B
    Unicode
  • Both $(A)$ and $(B)$              
  • D
    None of these
Answer
Correct option: C.
Both $(A)$ and $(B)$              
Both $(A)$ and $(B)$
View full question & answer
MCQ 51 Mark
…………… no.  consumes the least memory.
  • A
    Tyny  Integer
  • B
    small integer             
  • Yes / no (Boolean)
  • D
    Decimal
Answer
Correct option: C.
Yes / no (Boolean)
Yes / no (Boolean)
View full question & answer
MCQ 61 Mark
Base stores alphanumeric characters using ………………
  • A
    $ASCII  $
  • B
    Unicode
  • $UTF -8$
  • D
    All of these
Answer
Correct option: C.
$UTF -8$
$UTF -8$
View full question & answer
MCQ 71 Mark
Which of the following code uses more bytes per character ?
  • A
    $ASCII$
  • Unicode
  • C
    Both $(A)$ and $(B)$
  • D
    None
Answer
Correct option: B.
Unicode
Unicode
View full question & answer
MCQ 81 Mark
Maximum storage capacity of Text $[VARCHAR\_IGNORECASE]$ data type is ………. .
  • A
    $1 GB$
  • $2 GB$
  • C
    $3 GB  $
  • D
    $4 GB$
Answer
Correct option: B.
$2 GB$
$2 GB$
View full question & answer
MCQ 91 Mark
Which type of character set Gujarati and Hindi are ?
  • A
    Extra character set 
  • B
    Executable character set
  • C
    Average character set  
  • Extended  character set
Answer
Correct option: D.
Extended  character set
Extended character set
View full question & answer
MCQ 101 Mark
In $ASCII$ code the no of possible character that can be stored is only ………………. .
  • A
    $24$
  • B
    $34$
  • $256$
  • D
    $64000$
Answer
Correct option: C.
$256$
$256$
View full question & answer
MCQ 111 Mark
ASCII code needs only ……….  Type to store a character.
  • $1 $
  • B
    $4$
  • C
    $8$
  • D
    $16$
Answer
Correct option: A.
$1 $
$1$
View full question & answer
MCQ 121 Mark
how many numeric types are data type available in data type in Base?
  • A
    $4 $
  • B
    $8$
  • $10 $
  • D
    $14$
Answer
Correct option: C.
$10 $
$10$
View full question & answer
MCQ 131 Mark
In the following data type more than …………… characters are there then memo data type is used
  • A
    $64$  
  • B
    $124$
  • $255$
  • D
    $64000$
Answer
Correct option: C.
$255$
$255$
View full question & answer
MCQ 141 Mark
Which of the following data type comparison are not case sensitive and stores capital as you type them ?
  • A
    Text [VARCHAR]
  • B
    Text (fix) [CHAR]
  • Text [VARCHAR_IGNORECASE]  
  • D
    All of these
Answer
Correct option: C.
Text [VARCHAR_IGNORECASE]  
Text [VARCHAR_IGNORECASE]
View full question & answer
MCQ 151 Mark
Maximum storage capacity of Text [VARCHAR ] data type is …………….
  • A
    $1 GB$
  • $2 GB$
  • C
    $3 GB$
  • D
    $4 GB$
Answer
Correct option: B.
$2 GB$
$2 GB$
View full question & answer
MCQ 161 Mark
Text (fix) [CHAR] data type accept which type of character ?
  • A
    $UTF – 4$
  • $UTF -8$
  • C
    $UTF – 16$
  • D
    $UTF – 24$
Answer
Correct option: B.
$UTF -8$
$UTF -8$
View full question & answer
MCQ 171 Mark
Which type is useful for storing alphanumeric character ?
  • A
    $ASCII$
  • B
    Unicode  
  • C
    $UTF$
  • All of these
Answer
Correct option: D.
All of these
All of these
View full question & answer
MCQ 181 Mark
How many types are there for storing alphanumeric character ?
  • A
    $2 $
  • $3$
  • C
    $4$
  • D
    $5$
Answer
Correct option: B.
$3$
$3$
View full question & answer
MCQ 191 Mark
First name or last name of person can be stored in …………….
  • A
    Text [VARCHAR]
  • B
    Text (fix) [CHAR]
  • Text [VARCHAR_IGNORECASE]
  • D
    Memo [ LONGVARCHAR]
Answer
Correct option: C.
Text [VARCHAR_IGNORECASE]
Text [VARCHAR_IGNORECASE]
View full question & answer
MCQ 201 Mark
…………. .  is efficient when the fields are used for searching and it is unsure that whether user will enter searching text in lower case or uppar case.
  • A
    Text [VARCHAR]
  • B
    Text (fix) [CHAR]
  • Text [VARCHAR_IGNORECASE]
  • D
    Memo [ LONGVARCHAR]
Answer
Correct option: C.
Text [VARCHAR_IGNORECASE]
Text [VARCHAR_IGNORECASE]
View full question & answer
MCQ 211 Mark
Which form is used for memo data type ?
  • A
    Char
  • B
    VarChar
  • Long VarChar 
  • D
    Var Char IgnoreCase
Answer
Correct option: C.
Long VarChar 
 Long VarChar
View full question & answer
MCQ 221 Mark
The name of …………….  To be allocated to varchar data type depends on the number of character entered by the user.
  • A
    field
  • B
    data   
  • C
    size 
  • bytes
Answer
Correct option: D.
bytes
 bytes
View full question & answer
MCQ 231 Mark
Which type of data type is used for storing up to the specified length ?
  • $\text{Text [VARCHAR]}$
  • B
    $\text{Text (fix) [CHAR]}$
  • C
    $\text{Memo [LONGVARCHAR]}$
  • D
    All of these
Answer
Correct option: A.
$\text{Text [VARCHAR]}$
$\text{Text [VARCHAR]}$
View full question & answer
MCQ 241 Mark
Maximum storage capacity of text (fix) $[CHAR]$ data type is ………………. .
  • A
    $1\ GB $
  • $2\ GB$
  • C
    $3\ GB$
  • D
    $4\ GB$
Answer
Correct option: B.
$2\ GB$
$2\ GB$
View full question & answer
MCQ 251 Mark
Which of the following data type is used for spaces for shorties strings ?
  • A
    $\text{Text [VARCHAR]}$
  • B
    $\text{Text [VARCHAR_ IGNORECASE]}$
  • $\text{text (fix) [CHAR] }$
  • D
    All of these
Answer
Correct option: C.
$\text{text (fix) [CHAR] }$
$\text{text (fix) [CHAR]}$
View full question & answer
MCQ 261 Mark
What is the full form of $UTF\ ?$
  • Unicode Transformation Format    
  • B
    Unicode Transection Format
  • C
    Unicode Timeline Format 
  • D
    Unicode transform Format
Answer
Correct option: A.
Unicode Transformation Format    
Unicode Transformation Format
View full question & answer
MCQ 271 Mark
Memo data type accepts ………. .  character.
  • A
    $UTF – 4$
  • $UTF -8$
  • C
    $UTF – 16 $
  • D
    $UTF – 24$
Answer
Correct option: B.
$UTF -8$
$ UTF -8$
View full question & answer
MCQ 281 Mark
Which data type is used for stores up to the maximum length of number indicated by user ?
  • Memo
  • B
    Number  
  • C
    Currency
  • D
    Text
Answer
Correct option: A.
Memo
 Memo
View full question & answer
MCQ 291 Mark
Maximum storage capacity of memo data type is ………………. .
  • A
    $1\ GB $
  • $2\ GB$
  • C
    $3\ GB$
  • D
    $4 \ GB$
Answer
Correct option: B.
$2\ GB$
$2\ GB$
View full question & answer
MCQ 301 Mark
…………….  Isa way to define storage structure of the field
  • A
    Field name  
  • Data type
  • C
    Description
  • D
    Field properties
Answer
Correct option: B.
Data type
 Data type
View full question & answer
MCQ 311 Mark
We need to decide data type of each field while ………….
  • A
    before creating table   
  • designing the table
  • C
    after creating table  
  • D
    Any one
Answer
Correct option: B.
designing the table
 designing the table
View full question & answer
MCQ 321 Mark
In camel back each word in field name status with ………. .
  • capital
  • B
    small  
  • C
    both $(A)$ and $(B)$
  • D
    symbol
Answer
Correct option: A.
capital
capital
View full question & answer
MCQ 331 Mark
Which option is used for camel back ?
  • A
    FIRST NAME
  • FirstName
  • C
    firstname   
  • D
    fIRSTnAME
Answer
Correct option: B.
FirstName
FirstName
View full question & answer
MCQ 341 Mark
Which type is suitable for address field ?
  • Alpha numeric type 
  • B
    Calendar type
  • C
    Binary type
  • D
    All of these
Answer
Correct option: A.
Alpha numeric type 
Alphanumeric type
View full question & answer
MCQ 351 Mark
Which type of information is available in address field ?
  • A
    Alphabets
  • B
    Special character 
  • C
    Number 
  • Any one of these
Answer
Correct option: D.
Any one of these
Any one of these
View full question & answer
MCQ 361 Mark
To enter which type of information data type is used ?
  • A
    Letter
  • B
    Number  
  • C
    Special character
  • All of these
Answer
Correct option: D.
All of these
All of these
View full question & answer
MCQ 371 Mark
Which of the following option display a type of data type ?
  • A
    Alpha numeric type 
  • B
    Calendar type
  • C
    Binary type
  • All of these
Answer
Correct option: D.
All of these
All of these
View full question & answer
MCQ 381 Mark
Data type available in base can be divided in ……………… category
  • A
    2  
  • 3
  • C
    4
  • D
    5
Answer
Correct option: B.
3
B. 3
View full question & answer
MCQ 391 Mark
The choice of data type will affect the performance of the ………………….
  • A
    object 
  • data base 
  • C
    entity  
  • D
    attribute
Answer
Correct option: B.
data base 
 data base
View full question & answer
MCQ 401 Mark
Base data type be presented with a ……………….  Of options asking as to choose the kind of attribute want to store.
  • drop down menu
  • B
    check box
  • C
    radio button
  • D
    list box
Answer
Correct option: A.
drop down menu
drop down menu
View full question & answer
MCQ 411 Mark
Use ……. .  if needed, to keep the length of attribute name short in data base.  
  • A
    meaningful form
  • B
    short form
  • abbreviation
  • D
    long form
Answer
Correct option: C.
abbreviation
 abbreviation
View full question & answer
MCQ 421 Mark
In data base, do not use …. .  between world of attribute.
  • space 
  • B
    underscore  
  • C
    both (A) and (B) 
  • D
    none of these
Answer
Correct option: A.
space 
space
View full question & answer
MCQ 431 Mark
In data base subsequent characters use either …………
  • A
    letter
  • B
    number
  • C
    underscore   
  • all of these
Answer
Correct option: D.
all of these
 all of these
View full question & answer
MCQ 441 Mark
Start all attributes name with ……… in data base.
  • letter
  • B
    number
  • C
    underscore
  • D
    any one
Answer
Correct option: A.
letter
letter
View full question & answer
MCQ 451 Mark
What is First name in data base ?
  • A
    field name
  • B
    Data entity 
  • Both $(A)$ and $(B)$
  • D
    none of these
Answer
Correct option: C.
Both $(A)$ and $(B)$
Both $(A)$ and $(B)$
View full question & answer
MCQ 461 Mark
……… names are used at the time of designing the data model.
  • Logical name
  • B
    Physical name
  • C
    Both $(A)$ and $(B)$
  • D
    none of these
Answer
Correct option: A.
Logical name
 Logical name
View full question & answer
MCQ 471 Mark
The name actually used in the internal structure of our tables is called as …. .
  • A
    Logical name
  • Physical name
  • C
    Both $(A)$ and $(B)$
  • D
    none of these
Answer
Correct option: B.
Physical name
 Physical name
View full question & answer
MCQ 481 Mark
Attributes can be defined as characteristics of an …….
  • A
    table
  • B
    key field
  • entity  
  • D
    form
Answer
Correct option: C.
entity  
entity
View full question & answer
MCQ 491 Mark
Which option is used for name in data base ?
  • A
    Logical name
  • B
    Physical name
  • Both $(A)$ and $(B)$
  • D
    none of these
Answer
Correct option: C.
Both $(A)$ and $(B)$
Both $(A)$ and $(B)$
View full question & answer
MCQ 501 Mark
Product, Suppliers ,Employees and customers are known as ……. .   in data base.
  • entity
  • B
    form
  • C
    field
  • D
    key field
Answer
Correct option: A.
entity
entity
View full question & answer
MCQ . (1 Marks) - COMPUTER STD 11 Commerce Questions - Vidyadip