adplus-dvertising
1. Which system variable when set to 1, makes all temporary tables to get stored on disk rather than in memory?
a. basedir
b. back_log
c. big_tables
d. bind_address
Answer: (c).big_tables
2. The permitted value type for the variable ‘character_set_client’ is _____________
a. integer
b. float
c. double
d. string
Answer: (d).string
3. ‘character_set_database’ represents the character set used by the default database.
a. True
b. False
c. May be True or False
d. Can't say
Answer: (a).True
4. Which string function returns the index of the first occurrence of substring?
a. INSERT()
b. INSTR()
c. INSTRING()
d. INFSTR()
Answer: (b).INSTR()
5. Which module links DBI to the web?
a. CGI.pn
b. CGI.pem
c. CGI.pm
d. CGI.po
Answer: (c).CGI.pm
6. What does CGI stand for?
a. Computer Gateway Interface
b. Common Gateway Interface
c. Computer Generated Interface
d. Common Generated Interface
Answer: (b).Common Gateway Interface
7. The line that is written at the top of the script to write a Perl script using CGI.pm is ___________
a. use this CGI
b. put CGI
c. use CGI
d. include CGI
Answer: (c).use CGI
8. What is the shebang line?
a. #!
b. !#
c. #$
d. $#
Answer: (a).#!
9. Which of these is a read only variable?
a. error_count
b. big_tables
c. autocommit
d. foreign_key_checks
Answer: (a).error_count
10. Which variable when set to 1 would enable foreign key checking for InnoDB tables?
a. error_count
b. identity
c. foreign_key_checks
d. autocommit
Answer: (c).foreign_key_checks
Page 1 of 4

GATE CSE Resources

Questions from Previous year GATE question papers

UGC NET Computer science Resources

UGC NET Previous year questions and practice sets

NET General Paper 1

UGC NET Previous year questions and practice sets

GATE CSE Online Test

Attempt a small test to analyze your preparation level. This GATE exam includes questions from previous year GATE papers.

UGC NET practice Test

Practice test for UGC NET Computer Science Paper. The questions asked in this NET practice paper are from various previous year papers.