Download App

Computer MCQ

Introduction to Database Management System · Gujarat Board (GSEB) STD 11 Arts (GSEB - English Medium). 125 questions.

Questions · Page 1 of 3

MCQ

🎯

Test yourself on this topic

50 questions · timed · auto-graded

MCQ 11 Mark
Numeric data type attributes are described by the $………………$
  • A
     binaryvalue
  • B
     signed 
  • C
     unsigned
  • ✓
     Allofthese
Answer
Correct option: D.
 Allofthese
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
View full question & answer→
MCQ 31 Mark
how much bytes are used by field is decided by whom ?
  • A
     Users  
  • B
     Administrator
  • ✓
     Software
  • D
     Allofthese
Answer
Correct option: C.
 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)$
View full question & answer→
MCQ 51 Mark
$……………$ no.  consumes the least memory.
  • A
     Tyny Integer
  • B
     smallinteger             
  • ✓
     Yes/no $($Boolean$)$
  • D
     Decimal
Answer
Correct option: C.
 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$
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
View full question & answer→
MCQ 81 Mark
Maximum storage capacity of Text $\text{[VARCHAR_IGNORECASE]}$ data type is $………. .$
  • A
     $1GB$
  • ✓
    $2GB$
  • C
    $3GB$
  • D
    $4GB$
Answer
Correct option: B.
$2GB$
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
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$
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 $
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 $
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$
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{Text[VARCHAR]}$
  • B
    $\text{Text(fix)[CHAR]}$
  • ✓
    $\text{Text[VARCHAR_IGNORECASE]}$
  • D
     All of these
Answer
Correct option: C.
$\text{Text[VARCHAR_IGNORECASE]}$
View full question & answer→
MCQ 151 Mark
Maximum storage capacity of Text $\text{[VARCHAR]}$ data type is $…………….$
  • A
    $ 1GB$
  • ✓
    $ 2GB$
  • C
    $ 3GB$
  • D
    $ 4GB$
Answer
Correct option: B.
$ 2GB$
View full question & answer→
MCQ 161 Mark
Text $\text{(fix) [CHAR]}$ data type accept which type of character ?
  • A
    $\text{UTF–4}$
  • ✓
    $\text{UTF-8}$
  • C
    $\text{UTF–16}$
  • D
    $\text{UTF–24}$
Answer
Correct option: B.
$\text{UTF-8}$
View full question & answer→
MCQ 171 Mark
Which type is useful for storing alphanumeric character ?
  • A
    $\text{ASCII}$
  • B
     Unicode  
  • C
    $\text{UTF}$
  • ✓
     All of these
Answer
Correct option: D.
 All of these
View full question & answer→
MCQ 191 Mark
First name or last name of person can be stored in $…………….$
  • A
    $\text{Text[VARCHAR]}$
  • B
    $\text{Text(fix)[CHAR]}$
  • ✓
    $\text{Text[VARCHAR_IGNORECASE]}$
  • D
    $\text{Memo[LONGVARCHAR]}$
Answer
Correct option: C.
$\text{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{Text[VARCHAR]}$
  • B
    $\text{Text(fix)[CHAR]}$
  • ✓
    $\text{Text[VARCHAR_IGNORECASE]}$
  • D
    $\text{Memo[LONGVARCHAR]}$
Answer
Correct option: C.
$\text{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
     VarChar Ignore Case
Answer
Correct option: C.
 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
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]}$
View full question & answer→
MCQ 241 Mark
Maximum storage capacity of text $\text{(fix) [CHAR]}$ data type is$ ………………. .$
  • A
    $1GB$
  • ✓
    $2GB$
  • C
    $3GB$
  • D
    $4GB$
Answer
Correct option: B.
$2GB$
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]}$
View full question & answer→
MCQ 261 Mark
What is the full form of $\text{UTF ?}$
  • ✓
    UnicodeTransformation Format    
  • B
     UnicodeTransection Format
  • C
     UnicodeTimeline Format 
  • D
     Unicode transform Format
Answer
Correct option: A.
UnicodeTransformation 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$
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
View full question & answer→
MCQ 291 Mark
Maximum storage capacity of memo data type is $………………. .$
  • A
    $ 1GB $
  • ✓
    $ 2GB$
  • C
    $ 3GB$
  • D
    $ 4GB$
Answer
Correct option: B.
$ 2GB$
View full question & answer→
MCQ 301 Mark
$…………….$  Isa way to define storage structure of the field
  • A
     Fieldname  
  • ✓
     Datatype
  • C
     Description
  • D
     Fieldproperties
Answer
Correct option: B.
 Datatype
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
View full question & answer→
MCQ 321 Mark
In camel back each word in field name status with $………. .$
  • ✓
     capital
  • B
     small  
  • C
    $(A)$ or $(B)$
  • D
     symbol
Answer
Correct option: A.
 capital
View full question & answer→
MCQ 331 Mark
Which option is used for camel back ?
  • A
     FIRSTNAME
  • ✓
     FirstName
  • C
     firstname   
  • D
     fIRSTnAME
Answer
Correct option: B.
 FirstName
View full question & answer→
MCQ 341 Mark
Which type is suitable for address field ?
  • ✓
     Alphanumerictype 
  • B
    Calendartype
  • C
    Binarytype
  • D
     Allofthese
Answer
Correct option: A.
 Alphanumerictype 
View full question & answer→
MCQ 351 Mark
Which type of information is available in address field ?
  • A
     Alphabets
  • B
     Specialcharacter 
  • C
     Number 
  • ✓
     Anyoneofthese
Answer
Correct option: D.
 Anyoneofthese
View full question & answer→
MCQ 361 Mark
To enter which type of information data type is used ?
  • A
     Letter
  • B
     Number  
  • C
     Specialcharacter
  • ✓
     Allofthese
Answer
Correct option: D.
 Allofthese
View full question & answer→
MCQ 371 Mark
Which of the following option display a type of data type ?
  • A
    Alphanumerictype 
  • B
    Calendartype
  • C
    Binarytype
  • ✓
     Allofthese
Answer
Correct option: D.
 Allofthese
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$
View full question & answer→
MCQ 391 Mark
The choice of data type will affect the performance of the $…………$
  • A
     object 
  • ✓
     database 
  • C
     entity  
  • D
     attribute
Answer
Correct option: B.
 database 
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.
  • ✓
     dropdownmenu
  • B
     checkbox
  • C
     radiobutton
  • D
     listbox
Answer
Correct option: A.
 dropdownmenu
View full question & answer→
MCQ 411 Mark
Use $…….$  if needed, to keep the length of attribute name short in data base.  
  • A
     meaningfulform
  • B
     shortform
  • ✓
     abbreviation
  • D
     longform
Answer
Correct option: C.
 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
     noneofthese
Answer
Correct option: A.
 space 
View full question & answer→
MCQ 431 Mark
In data base subsequent characters use either $…………$
  • A
     letter
  • B
     number
  • C
     underscore   
  • ✓
     allofthese
Answer
Correct option: D.
 allofthese
View full question & answer→
MCQ 441 Mark
Start all attributes name with $………$ in data base.
  • ✓
     letter
  • B
     number
  • C
     underscore
  • D
     anyone
Answer
Correct option: A.
 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)$
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
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
View full question & answer→
MCQ 481 Mark
Attributes can be defined as characteristics of an $…….$
  • A
     table
  • B
     keyfield
  • ✓
     entity  
  • D
     form
Answer
Correct option: C.
 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)$
View full question & answer→
MCQ 501 Mark
Product, Suppliers ,Employees and customers are known as $……. .$   in data base.
  • ✓
     entity
  • B
     form
  • C
     field
  • D
     keyfield
Answer
Correct option: A.
 entity
View full question & answer→
Generate Paper FreeAll Introduction to Database Management System topics
MCQ - Computer STD 11 Arts Questions - Vidyadip