gs gs113 General MySQL Use - MySQL Setup - Quiz No.1
gs gs113 MySQL Quiz
This quiz belongs to book/course code gs gs113 MySQL of gs organization. We have 126 quizzes available related to the book/course MySQL. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic General MySQL Use. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
Question 2: What column names are displayed when this SQL command is executed?
SHOW COLUMNS FROM tbl_name LIKE '%name';
suffixed with ‘name’
prefixed with ‘name’
suffixed with ‘%name’
prefixed with ‘%name’
Question 3: The special database that always exists after setting up MySQL in a computer is __________
sampdb
mysql
information_schema
readme_db
Question 4: In the following SQL code, InnoDB is __________
CREATE TABLE student ( name CHAR(30), student_id INT, PRIMARY KEY (student_id) ) ENGINE = InnoDB;
database name
table name
reference engine
storage engine
Question 6: What is ‘xyz’ in the following SQL statement?
SELECT abc FROM xyz;
row name
column name
table name
database name
Question 8: The NULL value also means ___________
value equal to zero
unknown value
negative values
a large value
Question 9: What does comparing a known value with NULL result into?
zero
a positive value
a negative value
null
Question 10: Which clause is used to sort query elements?
GROUP
GROUP BY
ORDER
ORDER BY
Online Quizzes of gs113 MySQL
MySQL Programs Using C - Using the Embedded Server Library - Quiz No.1
gs gs113
MySQL Online Quizzes
System, Status and User Variables - User-Defined Variables - Quiz No.1
gs gs113
MySQL Online Quizzes
Using SQL to Manage Data - Populating and Modifying Tables - Quiz No.1
gs gs113
MySQL Online Quizzes
Using SQL to Manage Data - Populating and Modifying Tables - Quiz No.2
gs gs113
MySQL Online Quizzes
