Explore topic-wise MCQs in Testing Subject.

This section includes 657 Mcqs, each offering curated multiple-choice questions to sharpen your Testing Subject knowledge and support exam preparation. Choose a topic below to get started.

1.

Mysql is ____ ?

A. Object Oriented Database
B. XML Database
C. Relational Database Management System (RDBMS)
D. NoSQL Database
Answer» D. NoSQL Database
Discussion
2.

Query to check value of MYSQL system variable

A. SHOW VARIABLES
B. SHOW VARIABLES GLOBAL
C. SHOW GLOBAL VARIABLES
D. A & C Both
Answer» E.
Discussion
3.

How to set value of "query_cache_size" MYSQL system variable

A. SET GLOBAL query_cache_size = 41980;
B. SET GLOBAL VARIABLE query_cache_size = 41980;
C. SET VARIABLE GLOBAL query_cache_size = 41980;
D. None of the above
Answer» B. SET GLOBAL VARIABLE query_cache_size = 41980;
Discussion
4.

What is IGNORE keyword in MySQL?

A. Ignores Primary key or Unique key violations and continues processing with the next row
B. Ignores Primary key or Unique key violations and leaves any remaining rows unprocessed
C. Do not ignores Primary key or Unique key violations
D. None of the above
Answer» B. Ignores Primary key or Unique key violations and leaves any remaining rows unprocessed
Discussion
5.

Which statement is used to find out what databases currently exist on the server?

A. SHOW DATABASE
B. SHOW DATABASES
C. SHOW ALL DATABASES
D. All the above
Answer» C. SHOW ALL DATABASES
Discussion
6.

Which statement is used to change database?

A. USE db_name;
B. WANT db_name;
C. CHANGE db_name;
D. None of the above
Answer» B. WANT db_name;
Discussion
7.

Which is the right statement to fetch all tables start with "a"?

A. SHOW TABLES LIKE a%;
B. SHOW TABLES LIKE a;
C. SHOW ALL TABLES LIKE a%;
D. All the above
Answer» B. SHOW TABLES LIKE a;
Discussion
8.

Which statement is used to displays information about the columns in a table.

A. SHOW COLUMNS FROM tbl_job;
B. EXPLAIN tbl_job;
C. DESCRIBE tbl_job;
D. All the above
Answer» E.
Discussion
9.

What is maximum length of Database, Table, Column, trigger and view's name in MySQL?

A. 128
B. 256
C. 64
D. Unlimited
Answer» D. Unlimited
Discussion
10.

Which statement is used to load data form file to table?

A. LOAD LOCAL INFILE /path/student.txt INTO TABLE student;
B. LOAD DATA LOCAL INFILE /path/student.txt INTO TABLE student;
C. LOAD DATA LOCAL /path/student.txt INTO TABLE student;
D. All the above
Answer» C. LOAD DATA LOCAL /path/student.txt INTO TABLE student;
Discussion
11.

Which statement is used to count number of rows in table?

A. SELECT COUNT(*) FROM placement_question;
B. SELECT COUNT ALL(*) FROM placement_question;
C. SELECT ROWS(*) FROM placement_question;
D. All the above
Answer» B. SELECT COUNT ALL(*) FROM placement_question;
Discussion
12.

Which statement is wrong to select particular columns from table?

A. SELECT id, question FROM placement_question;
B. SELECT id, question FROM placement_question WHERE id = 2;
C. SELECT id, question FROM placement_question WHERE 1;
D. All are right
Answer» E.
Discussion
13.

  The parameter list in function overloading must differ by?

A. Number of functions
B. Function Size
C. Function Name
D. Number of argument
Answer» E.
Discussion
14.

________ is a default access specifier for members of structures in C++

A. protected
B. public
C. private
D. default
Answer» C. private
Discussion
15.

________ is a default access specifier for members of class in C++.

A. protected
B. public
C. private
D. default
Answer» D. default
Discussion
16.

The value of j at the end of the execution of the following C program ____________ intincr (int i) { staticint count = 0; count = count + i; return (count); } main () { int i, j; for (i = 0; i <= 4; i++) j = incr (i); }

A. 10
B. 4
C. 6
D. 7
Answer» B. 4
Discussion
17.

Consider the following program in a language that has dynamic scooping var x: real; procedure show: begin print(x);end; procedure small; var x: real; begin x: = 0.125; show; end; begin x:=0.25 show; small end. Then the output of the program is:

A. 0.125 0.125
B. 0.25 0.25
C. 0.25 0.125
D. 0.125 0.25
Answer» D. 0.125 0.25
Discussion
18.

Study the following program written in a block-structured language: var x, y : integer; procedure P(n:integer); begin x: = (n + 2) / (n - 3); end; procedure Q var x, y : integer; begin x: = 3; y: = 4; P(y); Write (x) ...(1) end; begin x: = 7; y: = 8; Write (x) ...(2) end What will be printed by write statements marked (1) and (2) in the program if variables are statically scoped?

A. 3, 6
B. 6, 7
C. 3,7
D. None of these
Answer» B. 6, 7
Discussion
19.

What will be output of following program? #include #include int main(){ register a = 25; int far *p; p=&a; printf("%d ",*p); return 0; }

A. 25
B. 4
C. Address
D. Compilation error
Answer» E.
Discussion
Previous Next