Current Affairs

Q.1The embedded server library containing the My SQL server linkable into applications is?

(A)
Q.2Which system variable controls the size of the table cache?

(B)
Q.3The character that the MySQL client program recognizes as a statement delimiter is?

(C)
Q.4A synonym for CHARAC TER SET is

(C)
Q.5The number of values that can be returned froma given stored function is?

(C)
Q.6The default storage engine used is?

(D)
Q.7What is the maximum length for alias names in terms of characters?

(C)
Q.8The variable used as a handle to an open file is?

(D)
Q.9The LOCAL capability for client library is enabled by?

(C)
Q.10What does RTF refer to?

(B)
Q.11The string function that returns the index of the first occurrence of substring is?

(B)
Q.12The BIGINT precision is of bit_____?

(C)
Q.13What jobs "Query Optimizer" perform in Mysql?

(B)
Q.14The function used to convert a string to an int is?

(A)
Q.15Which statement can be used for modifying the definition for an existing table?

(B)
Q.16The keyword used with UNION that does not retain duplicate rows is?

(A)
Q.17The maximum length of the varchar columns is?

(B)
Q.18The server listens on a network port for TCP/IP connections unless started with the option?

(C)
Q.19Which of these take more space?

(D)
Q.20Find the missing clause from the following SQL statement?

(B)
Q.21 Mysql command line tool is used to show "how many rows are returned and how long SQL command took to execute?

(C)
Q.22What is the statement used to select a default database?

(B)
Q.23Which declaration represents that "character data will consume the same number of bytes as declared and is right padded"?

(B)
Q.24 Which operator is used to check the expression is not "NULL"?

(C)
Q.25 The functions in Perl DBI called?

(D)
Q.26In MySQL, the default size of the key buffer in MB is?

(C)
Q.27 The spatial datatype used to store a curve is?

(D)
Q.28What is abc in the following MySQL statement?

(A)
Q.29Which of the following characters cannot be used as a delimiter?

(A)
Q.30The context in which the privilege 'CREATE TABLESPACE' applies is?

(B)
Q.31Which grant table scope columns are case insensitive?

(C)
Q.32Which of these can be used in place of MYSQL_SERVER_VERSION?

(D)
Q.33Which of these is also known as a virtual table?

(A)
Q.34Which Clause is used to sort the stored data in alphabetical order?

(B)
Q.35 Prior to MySQL 6.0, utf8 was?

(B)
Q.36The disk data that the FILES table in INFORMATION_SCHEMA stores is?

(B)
Q.37What is the durability property of transactions?

(A)
Q.38Which among the following operators is/are belongs to "Equality conditions"?

(C)
Q.39The option that supplies the pathname to root directory of MySQL installation is?

(B)
Q.40Which of these grant table scope columns is case insensitive?

(D)
Q.41Keyword "ASC" and "DESC" cannot be used without which clause in Mysql?

(B)
Q.42The statement used to selecta default database is?

(B)
Q.43What will be the output of the following SQL statement?

(B)
Q.44FULLTEXT indexes can be created only for?

(B)
Q.45The statement to change the table name is?

(A)
Q.46Which program reads the statement from a binary log?

(C)
Q.47To how many of the following does the prepared-statement API apply to?

(C)
Q.48 The line that is not used to turn on the event scheduler is?

(B)
Q.49The collations this statement lists are?

(B)
Q.50The variable which represents the default time zone of the MySQL server is?

(C)
Q.51 REPAIR TABLE works with how many of the following?

(B)
Q.52Which among the following is the correct representation of "float(1,1)"?

(A)
Q.53Find odd one out?

(B)
Q.54hich statement suspends the replication related activity of the slave server?

(D)
Q.55 The statement used to create a trigger is?

(B)
Q.56Which of these has higher priority?

(B)
Q.57The grant table scope columns that is case insensitive is?

(C)
Q.58Which storage engine in MySQL provides foreign key support?

(B)
Q.59Which storage engine is not available in My SQL 5.0?

(C)
Q.60The system variable in MySQL server that enables to configure the SQL mode is?

(C)
Q.61What does Control-_do in MySQL input editor?

(D)
Q.62How are identifiers quoted in MySQL?

(D)
Q.63 What is data in a MySQL database organized into?

(C)
Q.64Which type of database management system is MySQL?

(D)
Q.65How is communication established with MySQL?

(C)