…………. . is efficient when the fields are used for searching and i… - Vidyadip

MCQ

…………. . 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]

Need a full question paper?

Generate a complete, print-ready paper with questions like this in minutes — across 16+ boards, with answer keys.

Start Generating Free

Explore more

More "MCQ . (1 Marks)" from Introduction to Database Management System→Introduction to Database Management System — all question types→COMPUTER STD 11 Science question papers→Gujarat Board STD 11 Science question papers→Gujarat Board question paper generator→

Similar questions

………………… condition tested using file operators is True if a file with the specified name exists and has size greater than 0.

Which name will not be included in file list shown by giving Is ? at ?

what kind of image is obtained after its size is change ?

if we have detained each field for table table the data entry in base is controlled and restricted based on the ?

A $DBMS$ is based on relational model called ……. .

Which option is used to select the label ?

The name of ……………. To be allocated to varchar data type depends on the number of character entered by the user.

Which command is to be issued to insert the text in the file ?

To give special effects to fonts,………… software is used.

In ps –ef, $PID$ is ……………