Explore topic-wise MCQs in Technical Programming.

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

1.

‘x’ in the following MySQL statement is ____________

A. column name
B. table name
C. server name
D. database name
Answer» C. server name
Discussion
2.

The function returning reference to array of row values is ______________

A. fetchrow_array()
B. fetchrow_arrayref()
C. fetch()
D. fetchrow_hashref()
Answer» C. fetch()
Discussion
3.

The column attribute provides unique numbers for identification is ______________

A. AUTO_INCREMENT
B. UNSIGNED
C. IDENTIFY
D. DESCRIBE
Answer» B. UNSIGNED
Discussion
4.

The AUTO_INCREMENT column attribute is best used with ______________

A. FLOAT
B. INT
C. CHARACTER
D. DOUBLE
Answer» C. CHARACTER
Discussion
5.

Issuing ‘SELECT’ on a MERGE table is like _____________

A. UNION
B. UNION ALL
C. UNION DISTINCT
D. JOIN
Answer» C. UNION DISTINCT
Discussion
6.

Which of these is not optional?

A. select_list
B. table_list
C. row_constraint
D. grouping_columns
Answer» B. table_list
Discussion
7.

How many digits is the DECIMAL used for expressions containing only exact values with fractional part?

A. 32
B. 64
C. 65
D. 16
Answer» D. 16
Discussion
8.

What is the precision of BIGINT?

A. 32
B. 64
C. 128
D. 16
Answer» C. 128
Discussion
9.

The search mode that uses natural language search as a subroutine is ____________

A. Natural language
B. Boolean mode
C. Query expansion
D. Cross mode
Answer» D. Cross mode
Discussion
10.

The spatial datatype used to store a curve is _____________

A. GEOMETRY
B. POINT
C. LINESTRING
D. POLYGON
Answer» D. POLYGON
Discussion
11.

Stored programs degrade database security.

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

Execution on a time activated basis according to a schedule is done by _____________

A. Stored program
B. Events
C. Triggers
D. Stored procedures
Answer» C. Triggers
Discussion
13.

The system variable ‘system_time_zone’ can be reset at runtime.

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

The following MySQL statement is valid.

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

abc in the following MySQL statement is ___________

A. column name
B. table name
C. row name
D. database name
Answer» B. table name
Discussion
16.

abc in the following MySQL statement is ____________

A. row name
B. column name
C. view
D. database
Answer» C. view
Discussion
17.

xyz in the following MySQL statement is __________

A. table
B. column
C. view
D. database
Answer» D. database
Discussion
18.

Is there any error in the following MySQL statement?

A. No
B. Yes
C. Depends
D. None of the mentioned
Answer» B. Yes
Discussion
19.

Which clause is similar to “HAVING” clause in Mysql?

A. SELECT
B. WHERE
C. FROM
D. None of the mentioned
Answer» C. FROM
Discussion
20.

If in Table “account”, a column “cust_id” consists of {1,2,2,3,3,5,6,7,8,8} then what will be the output on executing the following MySQL statement?

A. {1, 2, 2, 3, 3, 5, 6, 7, 8, 8}
B. {1, 2, 3, 5, 6, 7, 8}
C. { }
D. None of the mentioned
Answer» C. { }
Discussion
21.

If in Table “employee”, a column “emp_id” consists of {1,2,2,3,3,5,6,7,8,8} then what will be the output on executing the following MySQL statement?

A. {1,2,2,3,3,5,6,7,8,8}
B. {1,2,3,5,6,7,8}
C. { }
D. None of the mentioned
Answer» C. { }
Discussion
22.

Is there any error in executing the following MySQL command?

A. Yes
B. No
C. Depends on condition
D. None of the mentioned
Answer» C. Depends on condition
Discussion
23.

What is the meaning of the “WHERE” clause in Mysql?

A. Filtering out unwanted rows from result set
B. Filtering out unwanted columns from result set
C. Filtering out unwanted rows and columns from result set
D. None of the mentioned
Answer» B. Filtering out unwanted columns from result set
Discussion
24.

Which Keyword is used to remove duplicate rows in the result set?

A. DISTINCTS
B. MODIFY
C. DISTINCT
D. All of the mentioned
Answer» B. MODIFY
Discussion
25.

How can we define the clause “FROM” in Mysql?

A. It defines the tables used by a query
B. It defines the linking of tables in Mysql
C. It defines the tables used by a query & linking of tables in Mysql
D. None of the mentioned
Answer» D. None of the mentioned
Discussion
26.

In the following MySQL query, “person_1” belongs to which category of table in MySQL?

A. Permanent Tables
B. Virtual tables
C. Temporary tables
D. None of the mentioned
Answer» C. Temporary tables
Discussion
27.

What is the meaning of “Temporary Tables” in Mysql?

A. Rows returned by sub query
B. Permanent tables
C. Virtual tables
D. All of the mentioned
Answer» B. Permanent tables
Discussion
28.

Find the missing clause from the following SQL statement?

A. FROM
B. WHERE
C. SELECT
D. None of the mentioned
Answer» B. WHERE
Discussion
29.

“SELECT” clause cannot be used without which clause in Mysql?

A. FROM
B. WHERE
C. ORDER BY
D. All of the mentioned
Answer» B. WHERE
Discussion
30.

“CREATE TABLE …” command is used to create which type of table in Mysql?

A. Permanent Tables
B. Virtual tables
C. Temporary tables
D. All of the mentioned
Answer» B. Virtual tables
Discussion
31.

“CREATE VIEW …” command is used to create which type of table in Mysql?

A. Permanent Tables
B. Virtual tables
C. Temporary tables
D. All of the mentioned
Answer» C. Temporary tables
Discussion
32.

If emp_id contain the following set {9, 7, 6, 4, 3, 1, 2}, what will be the output on execution of the following MySQL command?

A. {9, 7, 6, 4, 3, 1, 2}
B. {1, 2, 3, 4, 6, 7, 9}
C. {2, 1, 3, 4, 6, 7, 9}
D. None of the mentioned
Answer» C. {2, 1, 3, 4, 6, 7, 9}
Discussion
33.

Is there any error in the following MySQL command?

A. Yes
B. No error
C. Depends
D. None of the mentioned
Answer» C. Depends
Discussion
34.

Which command is used to create “Temporary tables” in MySQL?

A. CREATE TABLE;
B. CREATE VIEW
C. Both CREATE TABLE; and CREATE VIEW
D. None of the mentioned
Answer» E.
Discussion
35.

What will be the output of the following MySQL statement ?

A. False
B. Null
C. Depend
D. None of the mentioned
Answer» C. Depend
Discussion
36.

Which of the following statements is/are correct with respect to “VIEW”?

A. “VIEW” is a query that stored in the data dictionary
B. There is no data associated with “VIEW”
C. “VIEW” creates virtual tables in Database
D. All of the mentioned
Answer» E.
Discussion
37.

What is the meaning of “GROUP BY” clause in Mysql?

A. Group data by column values
B. Group data by row values
C. Group data by column and row values
D. None of the mentioned
Answer» B. Group data by row values
Discussion
38.

Find odd one out?

A. GROUP BY
B. DESC
C. ASC
D. ORDER BY
Answer» B. DESC
Discussion
39.

What is the need of “column Aliases” in “SELECT” clause?

A. To assign a new label to the column in result set
B. To overwrite the existing column name in result set
C. To modify the column name while using literals, Expression, built_in functions with “SELECT clause
D. All of the mentioned
Answer» E.
Discussion
40.

Which among the following is an optional Keyword?

A. DISTINICTS
B. ALL
C. AS
D. Both AS and ALL
Answer» E.
Discussion
41.

Is “GROUP BY” clause is similar to “ORDER BY” clause?

A. Yes
B. No
C. Depends
D. None of the mentioned
Answer» C. Depends
Discussion
42.

What is the use of “VIEW” in Mysql?

A. To hide columns from the users
B. To hide the complexity of the database
C. To simplify complexity of database design
D. All of the mentioned
Answer» E.
Discussion
43.

Which among the following belongs to an “aggregate function”?

A. COUNT
B. UPPER
C. LOWER
D. All of the mentioned
Answer» B. UPPER
Discussion
44.

What is the meaning of “ORDER BY” clause in Mysql?

A. Sorting your result set using column data
B. Aggregation of fields
C. Sorting your result set using row data
D. None of the mentioned
Answer» B. Aggregation of fields
Discussion
45.

What is the meaning of “HAVING” clause in Mysql?

A. To filter out the row values
B. To filter out the column values
C. To filter out the row and column values
D. None of the mentioned
Answer» B. To filter out the column values
Discussion
46.

“COUNT” keyword belongs to which categories in Mysql?

A. Aggregate functions
B. Operators
C. Clauses
D. All of the mentioned
Answer» B. Operators
Discussion
47.

What is the significance of “ORDER BY” in the following MySQL statement?

A. Data of emp_id will be sorted
B. Data of emp_id will be sorted in descending order
C. Data of emp_id will be sorted in ascending order
D. All of the mentioned
Answer» B. Data of emp_id will be sorted in descending order
Discussion
48.

What is the significance of the statement “GROUP BY d.name” in the following MySQL statement?

A. Aggregation of the field “name” of both table
B. Aggregation of the field “name” of table “department”
C. Sorting of the field “name”
D. None of the mentioned
Answer» C. Sorting of the field “name”
Discussion
49.

What is the significance of the statement “HAVING COUNT (emp_id)>2” in the following MySQL statement?

A. Filter out all rows whose total emp_id below 2
B. Selecting those rows whose total emp_id>2
C. Filter out all rows whose total emp_id below 2 & Selecting those rows whose total emp_id>2
D. None of the mentioned
Answer» D. None of the mentioned
Discussion
50.

Which of the following belongs to an “aggregate function”?

A. COUNT
B. SUM/AVG
C. MIN/MAX
D. All of the mentioned
Answer» E.
Discussion