gs gs113 Using SQL to Manage Data - MySQL Identifier Syntax and Naming Rules - 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 Using SQL to Manage Data. 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 3: How are identifiers quoted in MySQL?
single quotes
double quotes
backticks
can’t be quoted
Question 4: Which of the following is an illegal unquoted identifier name?
123_id
123id
id1
123
Question 5: Which server mode value enables use of double quotes to wrap identifier names?
ANSI
ANSI_QUOTES
TRADITIONAL
PIPES_AS_CONCAT
Question 6: Which server mode value disables use of built in function names as identifiers?
ANSI
IGNORE_FUNC
TRADITIONAL
IGNORE_SPACE
Question 8: What does a fully qualified table name consist of?
only the table name
only the database name
table name followed by database name
database name followed by table name
Question 10: Which of the following MySQL statements is valid if ‘`sampledb`’ is a database and ‘`tbl`’ is a table in it?
SELECT * FROM `sampledb.member`
SELECT * FROM `sampledb`.`member`
SELECT * FROM `member`.`sampledb`
SELECT * FROM `member.sampledb`
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
