MCQ 11 MarkNumeric data type attributes are described by the ………………Abinary valueBsigned Cunsigned✓All of theseAnswerCorrect option: D. All of these All of theseView full question & answer→
MCQ 21 Mark…………………. Type is used to store numerical information.AAlphabetic type ✓Numeric typeCBinary type Dcalendar typeAnswerCorrect option: B. Numeric typeNumeric typeView full question & answer→
MCQ 31 Markhow much bytes are used by field is decided by whom ?AUsers BAdministrator✓SoftwareDAll of theseAnswerCorrect option: C. SoftwareSoftwareView full question & answer→
MCQ 41 Mark$UTF -8$ is compatible with both …………AASCIIBUnicode✓Both $(A)$ and $(B)$ DNone of theseAnswerCorrect option: C. Both $(A)$ and $(B)$ Both $(A)$ and $(B)$View full question & answer→
MCQ 51 Mark…………… no. consumes the least memory.ATyny IntegerBsmall integer ✓Yes / no (Boolean)DDecimalAnswerCorrect option: C. Yes / no (Boolean)Yes / no (Boolean)View full question & answer→
MCQ 61 MarkBase stores alphanumeric characters using ………………A$ASCII $BUnicode✓$UTF -8$DAll of theseAnswerCorrect option: C. $UTF -8$$UTF -8$View full question & answer→
MCQ 71 MarkWhich of the following code uses more bytes per character ?A$ASCII$✓UnicodeCBoth $(A)$ and $(B)$DNoneAnswerCorrect option: B. UnicodeUnicodeView full question & answer→
MCQ 81 MarkMaximum storage capacity of Text $[VARCHAR\_IGNORECASE]$ data type is ………. .A$1 GB$✓$2 GB$C$3 GB $D$4 GB$AnswerCorrect option: B. $2 GB$$2 GB$View full question & answer→
MCQ 91 MarkWhich type of character set Gujarati and Hindi are ?AExtra character set BExecutable character setCAverage character set ✓Extended character setAnswerCorrect option: D. Extended character setExtended character setView full question & answer→
MCQ 101 MarkIn $ASCII$ code the no of possible character that can be stored is only ………………. .A$24$B$34$✓$256$D$64000$AnswerCorrect option: C. $256$$256$View full question & answer→
MCQ 111 MarkASCII code needs only ………. Type to store a character.✓$1 $B$4$C$8$D$16$AnswerCorrect option: A. $1 $$1$View full question & answer→
MCQ 121 Markhow many numeric types are data type available in data type in Base?A$4 $B$8$✓$10 $D$14$AnswerCorrect option: C. $10 $$10$View full question & answer→
MCQ 131 MarkIn the following data type more than …………… characters are there then memo data type is usedA$64$ B$124$✓$255$D$64000$AnswerCorrect option: C. $255$$255$View full question & answer→
MCQ 141 MarkWhich of the following data type comparison are not case sensitive and stores capital as you type them ?AText [VARCHAR]BText (fix) [CHAR]✓Text [VARCHAR_IGNORECASE] DAll of theseAnswerCorrect option: C. Text [VARCHAR_IGNORECASE] Text [VARCHAR_IGNORECASE]View full question & answer→
MCQ 151 MarkMaximum storage capacity of Text [VARCHAR ] data type is …………….A$1 GB$✓$2 GB$C$3 GB$D$4 GB$AnswerCorrect option: B. $2 GB$$2 GB$View full question & answer→
MCQ 161 MarkText (fix) [CHAR] data type accept which type of character ?A$UTF – 4$✓$UTF -8$C$UTF – 16$D$UTF – 24$AnswerCorrect option: B. $UTF -8$$UTF -8$View full question & answer→
MCQ 171 MarkWhich type is useful for storing alphanumeric character ?A$ASCII$BUnicode C$UTF$✓All of theseAnswerCorrect option: D. All of theseAll of theseView full question & answer→
MCQ 181 MarkHow many types are there for storing alphanumeric character ?A$2 $✓$3$C$4$D$5$AnswerCorrect option: B. $3$$3$View full question & answer→
MCQ 191 MarkFirst name or last name of person can be stored in …………….AText [VARCHAR]BText (fix) [CHAR]✓Text [VARCHAR_IGNORECASE]DMemo [ LONGVARCHAR]AnswerCorrect 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.AText [VARCHAR]BText (fix) [CHAR]✓Text [VARCHAR_IGNORECASE]DMemo [ LONGVARCHAR]AnswerCorrect option: C. Text [VARCHAR_IGNORECASE]Text [VARCHAR_IGNORECASE]View full question & answer→
MCQ 211 MarkWhich form is used for memo data type ?ACharBVarChar✓Long VarChar DVar Char IgnoreCaseAnswerCorrect option: C. Long VarChar Long VarCharView full question & answer→
MCQ 221 MarkThe name of ……………. To be allocated to varchar data type depends on the number of character entered by the user.AfieldBdata Csize ✓bytesAnswerCorrect option: D. bytes bytesView full question & answer→
MCQ 231 MarkWhich 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]}$DAll of theseAnswerCorrect option: A. $\text{Text [VARCHAR]}$$\text{Text [VARCHAR]}$View full question & answer→
MCQ 241 MarkMaximum storage capacity of text (fix) $[CHAR]$ data type is ………………. .A$1\ GB $✓$2\ GB$C$3\ GB$D$4\ GB$AnswerCorrect option: B. $2\ GB$$2\ GB$View full question & answer→
MCQ 251 MarkWhich 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] }$DAll of theseAnswerCorrect option: C. $\text{text (fix) [CHAR] }$$\text{text (fix) [CHAR]}$View full question & answer→
MCQ 261 MarkWhat is the full form of $UTF\ ?$✓Unicode Transformation Format BUnicode Transection FormatCUnicode Timeline Format DUnicode transform FormatAnswerCorrect option: A. Unicode Transformation Format Unicode Transformation FormatView full question & answer→
MCQ 271 MarkMemo data type accepts ………. . character.A$UTF – 4$✓$UTF -8$C$UTF – 16 $D$UTF – 24$AnswerCorrect option: B. $UTF -8$$ UTF -8$View full question & answer→
MCQ 281 MarkWhich data type is used for stores up to the maximum length of number indicated by user ?✓MemoBNumber CCurrencyDTextAnswerCorrect option: A. Memo MemoView full question & answer→
MCQ 291 MarkMaximum storage capacity of memo data type is ………………. .A$1\ GB $✓$2\ GB$C$3\ GB$D$4 \ GB$AnswerCorrect option: B. $2\ GB$$2\ GB$View full question & answer→
MCQ 301 Mark……………. Isa way to define storage structure of the fieldAField name ✓Data typeCDescriptionDField propertiesAnswerCorrect option: B. Data type Data typeView full question & answer→
MCQ 311 MarkWe need to decide data type of each field while ………….Abefore creating table ✓designing the tableCafter creating table DAny oneAnswerCorrect option: B. designing the table designing the tableView full question & answer→
MCQ 321 MarkIn camel back each word in field name status with ………. .✓capitalBsmall Cboth $(A)$ and $(B)$DsymbolAnswerCorrect option: A. capitalcapitalView full question & answer→
MCQ 331 MarkWhich option is used for camel back ?AFIRST NAME✓FirstNameCfirstname DfIRSTnAMEAnswerCorrect option: B. FirstNameFirstNameView full question & answer→
MCQ 341 MarkWhich type is suitable for address field ?✓Alpha numeric type BCalendar typeCBinary typeDAll of theseAnswerCorrect option: A. Alpha numeric type Alphanumeric typeView full question & answer→
MCQ 351 MarkWhich type of information is available in address field ?AAlphabetsBSpecial character CNumber ✓Any one of theseAnswerCorrect option: D. Any one of theseAny one of theseView full question & answer→
MCQ 361 MarkTo enter which type of information data type is used ?ALetterBNumber CSpecial character✓All of theseAnswerCorrect option: D. All of theseAll of theseView full question & answer→
MCQ 371 MarkWhich of the following option display a type of data type ?AAlpha numeric type BCalendar typeCBinary type✓All of theseAnswerCorrect option: D. All of theseAll of theseView full question & answer→
MCQ 381 MarkData type available in base can be divided in ……………… categoryA2 ✓3C4D5AnswerCorrect option: B. 3B. 3View full question & answer→
MCQ 391 MarkThe choice of data type will affect the performance of the ………………….Aobject ✓data base Centity DattributeAnswerCorrect option: B. data base data baseView full question & answer→
MCQ 401 MarkBase data type be presented with a ………………. Of options asking as to choose the kind of attribute want to store.✓drop down menuBcheck boxCradio buttonDlist boxAnswerCorrect option: A. drop down menudrop down menuView full question & answer→
MCQ 411 MarkUse ……. . if needed, to keep the length of attribute name short in data base. Ameaningful formBshort form✓abbreviationDlong formAnswerCorrect option: C. abbreviation abbreviationView full question & answer→
MCQ 421 MarkIn data base, do not use …. . between world of attribute.✓space Bunderscore Cboth (A) and (B) Dnone of theseAnswerCorrect option: A. space spaceView full question & answer→
MCQ 431 MarkIn data base subsequent characters use either …………AletterBnumberCunderscore ✓all of theseAnswerCorrect option: D. all of these all of theseView full question & answer→
MCQ 441 MarkStart all attributes name with ……… in data base.✓letterBnumberCunderscoreDany oneAnswerCorrect option: A. letterletterView full question & answer→
MCQ 451 MarkWhat is First name in data base ?Afield nameBData entity ✓Both $(A)$ and $(B)$Dnone of theseAnswerCorrect 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 nameBPhysical nameCBoth $(A)$ and $(B)$Dnone of theseAnswerCorrect option: A. Logical name Logical nameView full question & answer→
MCQ 471 MarkThe name actually used in the internal structure of our tables is called as …. .ALogical name✓Physical nameCBoth $(A)$ and $(B)$Dnone of theseAnswerCorrect option: B. Physical name Physical nameView full question & answer→
MCQ 481 MarkAttributes can be defined as characteristics of an …….AtableBkey field✓entity DformAnswerCorrect option: C. entity entityView full question & answer→
MCQ 491 MarkWhich option is used for name in data base ?ALogical nameBPhysical name✓Both $(A)$ and $(B)$Dnone of theseAnswerCorrect option: C. Both $(A)$ and $(B)$Both $(A)$ and $(B)$View full question & answer→
MCQ 501 MarkProduct, Suppliers ,Employees and customers are known as ……. . in data base.✓entityBformCfieldDkey fieldAnswerCorrect option: A. entityentityView full question & answer→