gs gs113 Query Optimization - When Good Statements Go Bad - 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 Query Optimization. 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 1: Which command is used to remove existing tables or database?
DROP TABLE
DELETE
Either DROP TABLE or DELETE
None of the mentioned
Question 2: Which command is used to display all the existing tables in a database?
SHOW TABLES
SHOW TABLE
SHOW
None of the mentioned
Question 3: Is duplicate entry of primary key is allowed in SQL?
Yes
No
Depends
None of the mentioned
Question 4: Is duplicate entry of other attributes are allowed in SQL?
Yes
No
Depends
None of the mentioned
Question 5: Which is the correct format to store date in the SQL?
DEC-01-1991
01-1991-11
01-DEC-12
1991-11-01
Question 6: Which of the following are the valid “database datatypes” in Mysql?
Numerical
Temporal
Text
All of the mentioned
Question 7: Find the error in the following SQL statement?
CREATE TABLE person ( person_id SMALLINT, name varchar, last varchar CONSTRAINTS pk_person PRIMARY KEY (person_id)); INSERT INTO person VALUES( person_id, name, last) (1, ’s’, ’p’); INSERT INTO person ( person_id, name, last) VALUES(1,’s’,’p’);
No error
Error, Duplicate value
Any other error
None of the mentioned
Question 8: Find the error in the following SQL statement?
CREATE TABLE person ( person_id SMALLINT, name varchar, last varchar, Bith_date DATE CONSTRAINTS pk_person PRIMARY KEY (person_id)); INSERT INTO person VALUES( person_id, name, last, Birth_date) (1,’s’,’p’, 24-1991-01);
In correct data value
No error
Any other error
None of the mentioned
Question 9: Which Key is used to link two tables in Mysql?
Primary Key
Foreign Key
Both Primary and Foreign Key
None of the mentioned
Question 10: Which line of the following statements will produce error?
SELECT * FROM person WHERE person_id=1;
SELECT pname FROM person;
SELECT pname, lname, person_id FROM person;
None of the mentioned
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
