Explore topic-wise MCQs in Structured Query Language (SQL).

This section includes 23 Mcqs, each offering curated multiple-choice questions to sharpen your Structured Query Language (SQL) knowledge and support exam preparation. Choose a topic below to get started.

1.

What does CGI stand for?

A. Computer Gateway Interface
B. Common Gateway Interface
C. Computer Generated Interface
D. Common Generated Interface
Answer» C. Computer Generated Interface
Discussion
2.

What is the number of attributes in the following SQL table?

A. 1
B. 2
C. 3
D. 30
Answer» C. 3
Discussion
3.

How many of the following do not return rows?

A. 0
B. 1
C. 2
D. 3
Answer» B. 1
Discussion
4.

How many among the following use NULL to indicate failure?

A. 0
B. 1
C. 2
D. 3
Answer» D. 3
Discussion
5.

What returns a string containing an error message?

A. mysql_error()
B. mysql_errno()
C. mysql_sqlstate()
D. mysql_close()
Answer» B. mysql_errno()
Discussion
6.

How many among the following does not return a value?

A. 0
B. 1
C. 2
D. 3
Answer» C. 2
Discussion
7.

The columns containing a binary value that include null bytes will print properly using the %s printf() format specifier.

A. True
B. False
C. May be True or False
D. Can't say
Answer» C. May be True or False
Discussion
8.

What does mysql_fetch_row() return?

A. integer
B. float
C. structure
D. pointer
Answer» E.
Discussion
9.

What does mysql_query() return on failure?

A. 0
B. 1
C. -1
D. a non-zero
Answer» E.
Discussion
10.

The one that is more restrictive is __________

A. mysql_query()
B. mysql_real_query()
C. same
D. machine dependent
Answer» B. mysql_real_query()
Discussion
11.

What is preferred when stored procedures are not being used?

A. CLIENT_MULTI_STATEMENTS
B. mysql_set_server_option()
C. any of the two
D. neither of the two
Answer» D. neither of the two
Discussion
12.

‘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» B. False
Discussion
13.

The permitted value type for the variable ‘character_set_client’ is _____________

A. integer
B. float
C. double
D. string
Answer» E.
Discussion
14.

WHAT_IS_THE_PERL_DBI??$

A. database inheritance
B. database integrity
C. database interface
D. database isolation
Answer» D. database isolation
Discussion
15.

What_is_the_default_path_to_perl_in_Unix?$

A. /usr/bin/perl
B. /usr/bin
C. /usr/perl
D. /usr/perl/bin
Answer» B. /usr/bin
Discussion
16.

What is the shebang line?

A. !
B. !
C. $
D. $
Answer» B. !
Discussion
17.

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» D. include CGI
Discussion
18.

What is the full form of CGI in System Variables?

A. Computer Gateway Interface
B. Common Gateway Interface
C. Computer Generated Interface
D. Common Generated Interface
Answer» C. Computer Generated Interface
Discussion
19.

Which module links DBI to the web?

A. CGI.pn
B. CGI.pem
C. CGI.pm
D. CGI.po
Answer» D. CGI.po
Discussion
20.

Which string function returns the index of the first occurrence of substring?

A. INSERT()
B. INSTR()
C. INSTRING()
D. INFSTR()
Answer» C. INSTRING()
Discussion
21.

‘character_set_database’ represents the character set used by the default database.$

A. True
B. False
Answer» B. False
Discussion
22.

The permitted value type for the variable ‘character_set_client’ is _____________$

A. integer
B. float
C. double
D. string
Answer» E.
Discussion
23.

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» D. bind_address
Discussion