Data Types
- Which statement is used to select a default database?
-
View Hint View Answer Discuss in Forum
NA
Correct Option: B
MySQL has the facility to use various statements specifically at the database level. For selecting a default database, the keyword or clause used is the ‘USE’ statement.
- What is a synonym for CHARACTER SET?
-
View Hint View Answer Discuss in Forum
NA
Correct Option: D
‘CHARACTER SET’ can be abbreviated into ‘CHARSET’ and can be used in the same contexts and statements where ‘CHARACTER SET’ is used. ‘charset’ is the server-supported character set.
- What is the maximum collations a character set can have?
-
View Hint View Answer Discuss in Forum
NA
Correct Option: A
The MySQL server allows simultaneous use of multiple character sets. A given character set is allowed to have one or more collations. It can be chosen according to the need of the database.
- Which variable is a handle to a database object?
-
View Hint View Answer Discuss in Forum
NA
Correct Option: C
The variable named ‘$dbh’ is a handle to an open file. ‘$h’ is a generic handle and the meaning depends on context. ‘$dbh’ is a handle to a database object. ‘$sth’ is a handle to a query object.
- The variable used as a handle to an open file is ______________.
-
View Hint View Answer Discuss in Forum
NA
Correct Option: D
The variable named ‘$fh’ is a handle to an open file. ‘$h’ is a generic handle and the meaning depends on context. ‘$dbh’ is a handle to a database object. ‘$sth’ is a handle to a query object.