Breadcrumbs Image

Breadcrumbs Image

Breadcrumbs Image

MySQL (PACE)

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

libmysqld
libmysqla
libmysqlb
libmysqlc

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

cache_open
table_cache
cache_table
open_cache

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

:
,
;
.

Q.4A synonym for CHARAC TER SET is

CHSET
CSET
CHARSET
CHCSET

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

3
0
1
2

Q.6The default storage engine used is?

ARCHIVE
EXAMPLE
NDB
MylSAM

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

32
64
128
256

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

h
dbh
sth
fh

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

enable-local-file
enabled-local-file
enable-local-infile
enable-global-file

Q.10What does RTF refer to?

Right Text Format
Rich Text Format
Rich Text Function
Right Text Function

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

INSERT()
INSTR()
INSTRING()
INFSTR()

Q.12The BIGINT precision is of bit_____?

16
32
64
128

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

Permissions
Determine the efficient way to executea query
Syntax errors
All of the mentioned

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

INET STOI()
INET ATON()
INET NTOA(
INET_ITOS()

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

FROM
ALTER
Modified
SELECT

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

DISTINCT
ALL
NARROW
STRICT

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

Upto 65, 567 bytes
Upto 65, 535 bytes
Upto 256 bytes
None of the mentioned

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

Quit-networking
networking
Skip-networking
Skip-networks

Q.19Which of these take more space?

indeterminate
variable length
same
fixed length

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

SELECT
FROM
WHERE
None of the mentioned

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

False
True
undetermined
Depend

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

SCHEMA
USE
CREATE
DROP

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

Varchar
Char
Both Char and Varchar
None of the mentioned

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

ON
IS NULL
NOT NULL
None of the mentioned

Q.25 The functions in Perl DBI called?

programs
functions
procedures
methods

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

32
4
8
16

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

POLYGON
GEOMETRY
POINT
LINESTRING

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

column name
table name
search string
database name

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

/
,
.
;

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

Views
Server administration
Tables
Stored routines

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

Db
Host
User
Password

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

MYSQL ID
LIBMYSQL VERSION
LIBMYSQL VERSION ID
MYSQL VERSION ID

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

VIEW
SCHEMA
DATABASE
JOIN

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

UPDATE
ORDER by CLAUSE
MODIFY
ALTER

Q.35 Prior to MySQL 6.0, utf8 was?

9 bytes
3 bytes
4 bytes
8 bytes

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

NCD
NDB
NBD
NBK

Q.37What is the durability property of transactions?

transaction effects are recorded permanently
statements form a logic unit
database remains consistent
one transaction does not affectthe other

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

<>
!=
>/<
=

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

socket
basedir
datadir
port

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

DЬ
Host
User
Password

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

HAVING
ORDER BY
GROUP BY
SELECT

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

SCHEMA
USE
CREATE
DROP

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

Shows only columns person_id
Show all columns but only those rows which belongs to person_id=1
Show all columns and rows
None of the mentioned

Q.44FULLTEXT indexes can be created only for?

TRANSITION
MylSAM
InnoDB
MEMORY

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

RENAME
CHANGE
CHANGENAME
CHANGENM

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

mysqlimport
mysql_config
mysqlbinlog
mysqldump

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

4
1
2
3

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

Total of four digits, not distributed uniformly
Total of four digits, two to the left of decimal and two to the right of decimal
Total of six digits
None of the mentioned

Q.49The collations this statement lists are?

names ending in utf8%
names beginning with utf8
names ending with utf8
names containing utf8% anywhere

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

system_time
time_zone
system_time_zone
date_and_time

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

0
1
3
2

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

Total of 2 digit, one digit at right of the decimal, one digit at left of the decimal
Total of 1 digit
Total of 2 digit
None of the mentioned

Q.53Find odd one out?

ORDER BY
GROUP BY
DESC
ASC

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

GET SLAVE
RESUME SLAVE
START SLAVE
STOP SLAVE

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

PRODUCE TRIGGERS
CREATE TRIGGER
CREATE TRIGGERS
PRODUCE TRIGGER

Q.56Which of these has higher priority?

machine dependent
writes
reads
same priority

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

Db
Host
User
Password

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

TRANSACTION
InnoDB
MylSAM
MEMORY

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

InnoDB
ARCHIVE
Falcon
NDB

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

sql enable
sql_config
sql_mode
sql server

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

deletes the current line
copies to clipboard
pastes from clipboard
undoes last change

Q.62How are identifiers quoted in MySQL?

can't be quoted
single quotes
double quotes
backticks

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

File systems
Objects
Tables
Networks

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

Network
Object-oriented
Hierarchical
Relational

Q.65How is communication established with MySQL?

APIs
SQL
Network calls
A programming language like C++