Elance MySQL Test Answers 2015
·
What identifies a row in a table as unique?
Foreign Key
Main Key
Primary Key
Regular Key
What tests whether integer column i is at
least 1 but no more than 10?
i IN INTERVAL(0, 11)
i IN INTERVAL(1, 10)
i BETWEEN 1 AND 10
i BETWEEN 0 AND 11
A ________ is a stored program that is
attached to a table or a view.
trigger
embedded SELECT statement
pseudofile
None of the above is correct.
Which one of the following statements is
correct?
The WITH ROLLUP modifier will add an extra row to
the results of a query.
The ROLLUP modifier can only be used with the GROUP
BY clause
All of these
Having a key with a unique value for each row,
best describes?
REFERENCE KEY
FOREIGN KEY
PRIMARY KEY
UNIQUE KEY
FIRST KEY
Which SQL statement is used to insert new data
in a database?
Insert data
Insert New
Insert
Insert into
What limits the type of data that goes into a
table?
Constraints
Prevents Restrictions Limitations
A datatype can be changed after a table has
been created.
False
True
With SQL, how can you return all the records
from a table named "Persons" sorted descending by
"FirstName"?
SELECT * FROM Persons ORDER BY FirstName DESC
SELECT * FROM Persons SORT 'FirstName' DESC
SELECT * FROM Persons ORDER FirstName DESC
SELECT * FROM Persons SORT BY 'FirstName' DESC
Which SQL statement is used to extract data
from a database?
Open
Select
Extract
Get
A SELECT statement without a WHERE clause
returns _____.
All of the rows from a table that match the previous
WHERE clause.
An error, because a SELECT statement is invalid
without a WHERE clause.
Nothing.
All of the rows from a table.
Which SQL statement is used to return only
different values?
SELECT UNIQUE
SELECT DISTINCT
SELECT DIFFERENT
How do you remove a table from the database
DESTROY TABLE
REMOVE TABLE
DELETE TABLE
DROP TABLE
Which SQL statement is used to extract data
from a database?
GET
EXTRACT
OPEN
SELECT
Which SQL statement is used to update data in
a database?
Update
Save
Alter
Save as
Which SQL statement is used to delete data
from a database?
ERASE
DELETE
REMOVE
COLLAPSE
* in a SELECT statement portion does what?
Assign a Pointer
Select All
Nothing
Multiply
Group By
Which of the following is not a valid aggregate
function?
MAX
COUNT
MIN
COMPUTE
With SQL, how can you insert a new record into
the "Persons" table?
INSERT ('Jimmy', 'Jackson') INTO Persons
INSERT INTO Persons VALUES ('Jimmy', 'Jackson')
INSERT VALUES ('Jimmy', 'Jackson') INTO Persons
With SQL, how do you select all the records
from a table named "Persons" where the "FirstName" is
"Peter" and the "LastName" is "Jackson"?
SELECT * FROM Persons WHERE
FirstName<>'Peter' AND LastName<>'Jackson'
SELECT FirstName='Peter', LastName='Jackson' FROM
Persons
SELECT * FROM Persons WHERE FirstName='Peter' AND
LastName='Jackson'
Which SQL statement is used to update data in
a database?
SAVE AS
UPDATE
SAVE
MODIFY
Which SQL statement is used to insert new data
in a database?
INSERT INTO
INSERT NEW
ADD NEW
ADD RECORD
What does SQL mean?
Structured Query Language
Simplified Query Language
What does SQL stand for?
Structured Query Language
Structured Question Language
Strong Question Language
With SQL, how can you delete the records where
the "FirstName" is "Peter" in the Persons Table?
DELETE ROW FirstName='Peter' FROM Persons
DELETE FROM Persons WHERE FirstName = 'Peter'
DELETE FirstName='Peter' FROM Persons
It is possible to add a constraint after a table
is created
true
false
With SQL, how do you select all the columns
from a table named "Persons"?
SELECT * FROM Persons
SELECT [all] FROM Persons
SELECT *.Persons
SELECT Persons
A table column can have null values
false
true
With SQL, how do you select a column named
"FirstName" from a table named "Persons"?
SELECT FirstName FROM Persons
SELECT Persons.FirstName
EXTRACT FirstName FROM Persons
With SQL, how do you select all the records
from a table named "Persons" where the value of the column
"FirstName" is "Peter"?
SELECT [all] FROM Persons WHERE FirstName LIKE
'Peter'
SELECT [all] FROM Persons WHERE FirstName='Peter'
SELECT * FROM Persons WHERE FirstName='Peter'
SELECT * FROM Persons WHERE
FirstName<>'Peter'
Which of the following statements about Stored
Procedures is true?
All of these
They allow you to store libraries of functions
inside the database server
They can provide a common set of database
operations to multiple applications
They can improve security by limiting users to specific
approved queries
Which is TRIGGER in Mysql ?
All
Before Insert
Before Update
After Delete
With SQL, how can you insert "Olsen"
as the "LastName" in the "Persons" table?
INSERT ('Olsen') INTO Persons (LastName)
INSERT INTO Persons (LastName) VALUES ('Olsen')
INSERT INTO Persons ('Olsen') INTO LastName
How can you change "Hansen" into
"Nilsen" in the "LastName" column in the Persons table?
MODIFY Persons SET LastName='Nilsen' WHERE
LastName='Hansen'
UPDATE Persons SET LastName='Hansen' INTO
LastName='Nilsen'
UPDATE Persons SET LastName='Nilsen' WHERE
LastName='Hansen'
MODIFY Persons SET LastName='Hansen' INTO
LastName='Nilsen
With SQL, how can you return the number of
records in the "Persons" table?
SELECT COLUMNS() FROM Persons
SELECT COUNT() FROM Persons
SELECT COUNT(*) FROM Persons
SELECT COLUMNS(*) FROM Persons
What is the maximum number of constituents for
a SET datatype?
62
66
60
64
Which port does MySQL Server use by default?
3306
443
8080
80
What locks can be applied to MyISAM tables?
Read and Write
Read and Print
Print
Write
Can I create another MySQL instance in the
same machine?
True
False
What function eliminates beginning and ending
white space characters from a string?
LTRIM()
None of these
MTRIM()
STRIP()
TRIM()
Which clause will order results by the
last_name column?
All of these
ORDER BY last_name
SELECT BY last_name
WHERE last_name IS ALPHABETICAL
Which SQL keyword is used to sort the
result-set?
ORDER
SORT
SORT BY
ORDER BY
How do you rename a table?
DELETE
CHANGE
UPDATE
INSERT
ALTER
Which of the following clauses can be used in
a SELECT statement to reduce the results to a unique list of values?
REDUCE
UNIQUE
DISTINCT
PRIMARY
How would you write a query to select all
teams that won either 2, 4, 6 or 8 games?
SELECT * FROM teams WHERE team_won join (2, 4, 6,
8);
SELECT * FROM teams WHERE team_won IN (2, 4, 6, 8);
SELECT * FROM teams WHERE team_won like (2, 4, 6,
8);
SELECT * FROM teams WHERE team_won on (2, 4, 6, 8);
What is A in ACID?
Atomicity
Analysis Allow Alter
With SQL, how do you select all the records
from a table named "Persons" where the "LastName" is
alphabetically between (and including) "Hansen" and
"Pettersen"?
SELECT * FROM Persons WHERE LastName BETWEEN
'Hansen' AND 'Pettersen'
SELECT LastName>'Hansen' AND
LastName<'Pettersen' FROM Persons
SELECT * FROM Persons WHERE LastName>'Hansen'
AND LastName<'Pettersen'
In linux how do you restart the MySQL service?
/etc/init.d/mysql restart service mysqld restart
restart mysql service init 0 reboot
Which of the following queries returns all the
rows whose names start with "S"?
SELECT * FROM table WHERE name LIKE = 'S*';
None of these
SELECT * FROM table WHERE name LIKE 'S%';
SELECT * FROM table WHERE name = 'S%';
I would like to retrieve the date with this
format : dd/mm/YYYY in a field called btimestamp. Choose the correct way.
SELECT FORMAT_DATE(btimestamp,'%d/%m/%Y') AS bdate
FROM ...
SELECT DATE_FORMAT(btimestamp,'%d/%m/%Y') AS bdate
FROM ...
What does the following command output:
'SELECT 1'
"1"
1
'1'
When a MySQL database is
"normalized", by common definition, it means which of the following?
That common queries assigned to functions to
simplify statements.
That the MySQL "strict" mode is invoked
to avoid incompatibilities with legacy SQL.
That the database is organized in a way to reduce
data redundancy. 1NF, 2NF, and 3NF forms are used as common guidelines.
That the data returned within any given row is
converted to a single object type as most appropriate (string, int, etc.).
That non-common characters are stripped from values
to ensure compatibility with given character set.
What is a surrogate Key ?
A key that acts as a substitution to other natural
keys
a type of join
Same as Primary key
Same as Natural key
Which of the following statements about MySQL
optimization is True?
If GROUP BY is not used, the HAVING and WHERE
clauses will be merged
Each table Index is queried, and the best Index is
used.
All of these
Constant expressions used with Indexes are only
evaluated once
Which set operator is used to combine the
result sets of two or more SELECT statements?
None of these
UNION
MERGE
COMBINE
Which of the following can add a row to a
table?
Insert
Add
Alter
Update
The OR operator displays a record if ANY
conditions listed are true. The AND operator displays a record if ALL of the
conditions listed are true
True
False-True
False
True-False
What are the statements used to manage
transaction processing in MySQL?
COMMIT and UNDO
SAVE and ROLLBACK
COMMIT and ROLLBACK
SAVE and UNDO
Which of these is not a valid name for a
column
Near
From
Under
Far
With SQL, how do you select all the records
from a table named "Persons" where the value of the column
"FirstName" starts with an "a"?
SELECT * FROM Persons WHERE FirstName LIKE '%a'
SELECT * FROM Persons WHERE FirstName LIKE 'a%'
SELECT * FROM Persons WHERE FirstName='a'
SELECT * FROM Persons WHERE FirstName='%a%'
True or False? A table may be joined to
itself.
True
False
How would you write a query to select all
orders that contain either 3, 5, 7 or 9 items?
SELECT * FROM orders WHERE item_count IN (3, 5, 7,
9);
SELECT * FROM orders WHERE LIMIT item_count (3, 5,
7, 9);
SELECT * FROM orders WHERE item_count = (3, 5, 7,
9);
SELECT * FROM orders WHERE item_count LIKE (3, 5,
7, 9);
The USE keyword is used to select a _____.
Column
Table
Row
Database
Which statement is required to add a column to
an existing table?
APPEND
UPDATE
NEW
ALTER
CREATE
Assume, you have two tables company (id int,
name text) and employee(id int, company int, name text). How would you select
all employee names and their corresponding company names, e.g. John, Microsoft
Mary, IBM Jane, Oracle
This is not possible
select e.name, c.name from employee e left join
company c on c.id = e.company
select e.name, c.name from employee e, company c
select employee_name, company_name from employee
and company
select e.name, c.name from employee e left join
company c
The _____ statement enables listing of tables
that match a certain pattern.
SHOW DATABASE
SHOW COLUMNS
SHOW TABLES
SHOW OPEN TABLES
The correct way to average all of the values
from a column "values" from table "foo" is
SELECT AVG(values) FROM foo
SELECT AVERAGE(values) FROM foo
SELECT values.AVERAGE FROM foo
SELECT AVERAGE OF values FROM foo
The data type BLOB stands for:
Big List Object
None of these
Binary Large Object
Binary List Object
HAVING clause is used in combination with
_____.
SELECT
WHERE
FROM
GROUP BY
How can you do an UPDATE?
UPDATE tab SET f1=1 AND f2=2;
UPDATE tab.f1=1 AND tab.f2=2;
UPDATE tab SET f1=1 , f2=2;
UPDATE tab.f1=1 , tab.f2=2;
What represents an unknown or unspecified
value?
()
NULL
UNSPECIFIED
UNSPEC
ANY
What does DCL stand for?
Data Context Language
Define Control Language
Define Context Language
Data Control Language
_____ displays the hour as an integer with
zero padding, in 24H format.
%H
%K
%k
%h
What is the default port number for MySQL?
3006
3396
80
8080
3306
Which of the following is the correct way to
retrieve rows with no duplicates?
SELECT DISTINCT * FROM TableA WHERE
ColumnX="SomeValue";
SELECT UNIQUE * FROM TableA WHERE
ColumnX="SomeValue";
SELECT * FROM TableA WHERE ColumnX IS DISTINCT;
SELECT * FROM TableA WHERE
ColumnX=UNIQUE("SomeValue");
SELECT * FROM TableA WHERE ColumnX IS UNIQUE;
What is the BDB Configuration for RAM
dedicated to holding rows and indexes?
bdb_cache_size
bdb_max_lock
bdb_home
bdb_logdir
What statement would delete the data in a
table without deleting the table structure?
Truncate Table
Alter Table
Drop Table
Delete Table
When joining tables using a left join, which
values are always preserved?
Values from the left table are preserved for NULL
values in the right table
The join will delete rows which contain a NULL
value in the left table and preserve all other rows
Values from the right table are preserved for NULL
values in the right table
The join will delete rows which contain a NULL
value in the right table and preserve all other rows
What is the difference between an inner join
and an outer join?
Inner join returns only rows from the first table;
outer join returns rows from both tables
Inner join deletes rows that don't match; outer
join does not delete any rows
Inner join returns only rows from both tables that
match on the given conditional expression
How would you select all the user_name values
from records whose user_phonenumber field is null?
SELECT user_name FROM users WHERE user_phonenumber
= NULL;
SELECT user_name FROM users WHERE user_phonenumber;
Any of these three statements may work, depending
on the version of MySQL being used.
SELECT user_name FROM users WHERE user_phonenumber
IS NULL;
You have just inserted a new row into a table
whose Primary Key has the AUTO_INCREMENT property, without specifying the
Primary Key. How would you retrieve the new row's Primary Key from the
database?
GET_AUTO_ID();
SELECT LAST_INSERT_ID();
You can't; the row creation would have failed with
a Key Constraint error.
SELECT LAST_KEY_INC();
Which of the following is/are true about
MyISAM vs InnoDB?
All of these are true
Both MyISAM and InnoDB can use full-text index
searches
InnoDB tables can have relationship constraints,
MyISAM tables do not
You can have both types of tables in one database
Which option gets the current time in the
following format? 2012-06-18 19:47:31
FORMAT_DATE(NOW(), '%Y-%m-%d %T')
DATE_FORMAT(NOW(), '%Y-%m-%d %T');
UNIX_TIMESTAMP(NOW())
GET_FORMAT(NOW(), '%Y-%m-%d %T')
Which of the following table declarations
creates column 'name' to hold a fixed-length string?
CREATE TABLE test (VARCHAR(20));
CREATE TABLE test ( name(20) );
CREATE TABLE test (name CHAR(20));
CREATE TABLE test (column: name, type:CHAR(20));
Which of the following correctly calls the
stored procedure "test" which has no parameters?
CALL test;
Set @variable = test;
SELECT test FROM procedures;
SELECT test;
The __________ application performs
verification, repair, analysis, and optimization of MySQL databases, tables,
and data.
mysqlcheck
mysqldump
mysqlshow
mysqladmin
Which of the following options for the INSERT
statement will cause an existing row to be updated in the event of a duplicate
Primary Key value?
ON DUPLICATE VALUE UPDATE
ON REPEAT KEY UPDATE
ON REPEAT VALUE UPDATE
ON DUPLICATE KEY UPDATE
Which of the following is a synonym for
"INDEX" in MySQL.
POINTER
CURSOR
STORE
UNIQUE
KEY
Which of the following is a correct use of the
UNION operator?
SELECT * FROM TableA UNION SELECT * FROM TableB
SELECT UNION * FROM TableA, TableB
SELECT * FROM Table A UNION TableB
SELECT * FROM UNION TableA, TableB
The default size of the buffer for
client/server communication is _______?
1GB No Default Size 500MB
24MB
The user-created stored function 'test' takes
a varchar(5) and an integer and returns a varchar. Which of the following
correctly calls the function?
SELECT test('asdfg', 6);
SELECT test USING 'asdfg', 6;
CALL FUNCTION test ('asdfg', 6);
CALL test('asdfg', 6);
True of false? TEXT is case-insensitive in
BLOB.
True
False
Assign the custom `foo` variable with the
value `bar`
$foo = 'bar';
VAR $foo ='bar';
SET $foo= 'bar';
SET @foo = 'bar';
VAR @foo = 'bar';
Which of the following is used to control case
sensitivity?
bit_or()
binary
bit_count()
bit_and()
Which of the following is used to count the
number of rows with different items?
count(all)
count(*)
count(<column name>)
count(distinct)
What is the maximum length of a table name ?
4 byte
16 byte
32 byte
64 byte
Which of the following are true concerning
indexes?
Indexes can only be done on columns containing
numerical data
None are correct
Indexes will slow down selects, but speed up
inserts
Indexes will slow down inserts, but speed up
selects
Indexes can only be done on primary key columns
What happens when a Unique or Primary Key
column is set to AUTO INCREMENT, and an INSERT would exceed the maximum value
for that column?
It stops incrementing, producing a duplicate key
error.
The value "wraps around" to the lowest
value and continues incrementing.
None of these
Further rows will be inserted with the same value.
What does this statement: DELETE FROM xpto
WHERE 1;
Throw an error depending on sql mode
Delete all records in table 'xpto' and reset the
AUTO_INCREMENT value to 0;
Delete all records in table 'xpto' but does not
reset the AUTO_INCREMENT sequence
Delete all records in table 'xpto' and resets the
AUTO_INCREMENT sequence
In a WAMP environment, what is the correct way
to permanently change the largest possible packet that can be transmitted to or
from a MySQL server?
Edit the my.ini file and change the setting
max_allowed_packet=M. You do not need to restart the service when changing
globals directly on the server.
Using the Windows command prompt, execute "SET
max_allowed_packet=M;". Then restart the service.
Using the Windows command prompt, execute "SET
GLOBAL max_allowed_packet=MB;". You do not need to restart the service
when changing globals directly on the server.
Edit the my.ini file and change the setting
max_allowed_packet. Then restart the service.
Open the MySQL network data config tool and simply
change the setting. The service will be restarted automatically.
Given two tables, t1 and t2, the join
condition "t1.t2_id = t2.id" how do you get rows from t1 that have NO
counterparts in t2?
EXCLUDING JOIN t2 ON t1.t2_id = t2.id
LEFT OUTER JOIN t2 ON t1.t2_id = t2.id
JOIN t2 EXCLUDING t1.t2_id = t2.id
LEFT JOIN t2 ON t1.t2_id = t2.id WHERE t2.id IS
NULL
RIGHT JOIN t2 ON t1.t2_id = t2.id
Which of the following is not a Spatial Data
Type?
CIRCLE
GEOMETRY CIRCLE POINT POLYGON
______ - Nothing that’s being read is actively
being changed by another transaction.
ACID Transaction Rollback
ISOLATION
To select the multiple values from a column as
a string use the _________ function.
GROUP_CONCAT()
JOIN()
COMBINE()
IMPLODE()
What term describes the number of unique
values in an index?
Sub-part
Seq-in-index
Cardinality
Collation
Assume, you have a table inventory(id int,
description text, price int). How can you change the type of price from int to
decimal(10,2)?
This is not possible.
Both are correct.
alter table inventory change column price
decimal(10,2)
alter table inventory modify price decimal(10,2)
Which of the following statements can be used
to remove user accounts from MySQL?
REVOKE USER user;
None of these
DELETE USER user;
DROP USER user;
How would you remove all rows from a table
"STAFF"
DELETE * FROM STAFF
REMOVE * FROM STAFF
DELETE FROM STAFF
DELETE ALL STAFF
REMOVE FROM STAFF
What command executed by a client exports data
to a file?
SELECT ... INTO OUTFILE
MOVE ... INTO OUTFILE
COPY ... INTO OUTFILE
EXPORT ... INTO OUTFILE
Which of the following is used to access a
result set stored in memory after execution of a query, allowing the result
data to be manipulated on a row-by-row basis?
Index
Trigger
View
Cursor
Which of the following queries returns 100
results, starting from the 25th result?
SELECT book_title FROM books LIMIT 24 TO 124
SELECT book_title FROM books LIMIT 25, 125
SELECT book_title FROM books LIMIT 24, 100
SELECT book_title FROM books LIMIT 25 UP TO 100
Which of these queries will return the values
of the "order" column in the "slides" table in descending
order?
SELECT `order` FROM `slides` ORDER BY `order` DESC
SELECT -order FROM -slides ORDER BY -order DESC
All of these return identical results
SELECT order FROM `slides` ORDER BY order DESC
The _____________ privilege is often used when
loading a file into a database table.
Reload_priv
Process_priv
Grant_priv
File_priv
What is the maximum size of the buffer for
client/server communication?
2GB Unlimited 24MB
1GB
What is a major difference between MyISAM and
InnoDB storage engines?
None of these.
InnoDB is innovative where MyISAM is not.
InnoDB uses table locking where MyISAM uses row
locking.
All of these.
InnoDB uses row locking where MyISAM uses table
locking.
What is the maximum allowed length of a column
name?
255
128
64
256
Which foreign keys do MyISAM tables support?
Foreign keys on the primary key only
Foreign keys on indexed columns.
None, MyISAM tables do not support foreign keys.
Foreign keys on columns other than the primary key.
When using the grant command which phrase sets
the password of the user?
Identified By
SET passwd
password
using
passwd
How would you select a value that lets column
B (if specified) override column A?
COALESCE(B, A)
A IF B IS NOT NULL
B IF A IS NOT NULL
COALESCE(A, B)
The GROUP BY clause of a SELECT statement
requires which of the following?
ORDER BY clause
None of these
WHERE clause
LIMIT clause
HAVING clause
Which of the following MySQL client command
line arguments would you use to connect to a server?
% mysql [options]
% mysql servers [options]
% mysql server [options]
% mysql connect [options]
In a LIKE clause, you can ask for any 6 letter
value by writing:
LIKE .{6} Answer 5: LIKE ^.{6}$
LIKE ??????
LIKE ...... (six periods)
LIKE ______ (six underscore characters)
If you specify a column type as DECIMAL (6,2),
what range of values will it accept?
-999999.99 to 999999.99
-9999.99 to 999.99
-999.99 to 99.99
-9999.99 to 9999.99
Which is NOT an available storage engine?
BDB
SQLite
MyISAM
CSV
InnoDB
What will the following SQL return for the
`part` column: SELECT SUBSTRING_INDEX('my.delimited.string', '.', -1) AS `part`
my
my.delimited
string
delimited.string
Which of the following correctly redirects the
results of a select statement to a file?
SELECT * FROM TableA where SomeColumn="a
value" AND OUTFILE = 'out.txt';
SELECT * FROM TableA where SomeColumn="a
value" INTO OUTFILE 'out.txt';
SELECT * INTO OUTFILE 'out.txt' FROM TableA where
SomeColumn="a value";
How do you get the execution plan of a query?
DESCRIBE SELECT select_options
EXPLAIN SELECT select_options
QUERY_PLAN SELECT select_options
It's not possible
Both EXPLAIN and DESCRIBE will work
Within a transaction, how do you apply an
exclusive lock with a SELECT?
SELECT ... DELETE
SELECT ... FOR UPDATE
SELECT ... EXCLUSIVE
SELECT ... ALTER
Which one of these queries will result in an
error?
SELECT NULL
SELECT 0
SELECT *
SELECT ''
All are incorrect, because they are missing the
FROM clause
Which of the following statements about Views
is FALSE?
A trigger cannot be associated with a View.
Their SELECT statements cannot contain subqueries
in the FROM clause.
They can save time and effort on queries that are
frequently executed.
They are not connected to a SELECT statement
When executing an equi-join, what syntax can
you use to specify the order in which the tables are joined?
LEFT OUTER JOIN
OUTER JOIN
MULTIPLE JOIN
STRAIGHT_JOIN
What parameters needed to make mysqldump as a
hot backup?
--single-transaction
--hot-dump --no-lock-tables --databases-no-lock
Which statement returns the current date in
YYYY-MM-DD format?
SELECT NOW();
SELECT DATE();
All of these
SELECT CURDATE();
What switch will prevent MySQL from listening
via TCP?
networking false
skip-networking
protocol tcp=false
networking=off
skip-tcp
How can you set "less" utility as
the default one for reading queries results?
Viewer less
Pager less
Set less
Reader less
Redirect less
Which of the following queries returns the
String "come"?
SELECT SUBSTRING ('welcome to MySQL', 4, 7);
SELECT SUBSTRING ('welcome to MySQL' FROM -4 FOR
2);
SELECT SUBSTRING ('welcome to MySQL', 4);
None of these
What does this query result in? SELECT IF( 1,
2, 3 ) + IF(0, 1, 2 ) ;
3
Syntax Error
5
9
4
The __________ function allows the addition of
months to a given date.
PERIOD_DIFF
MONTH_DIFF
MONTH_ADD
PERIOD_ADD
What MySQL variable is used to limit a single
SQL statement's size?
max_key_buffer
max_allowed_packet
max_query_length
max_packet_size
max_length_query
Which one of the following flags causes the
MySQL engine to refuse UPDATE and DELETE commands that don't include a WHERE
clause?
--i-am-a-dummy
--safe-delete
None of these
--no-blank
Which statements are used for changing the
default character set within a table?
ALTER ... SET
ALTER ... CONVERT
MODIFY ... CONVERT
CHANGE ... COLLATION
SET ... COLLATION
If you grant a user FILE priveliges, you're
allowing:
Read and write (but not overwrite) files on the
server
Read, write and overwrite files on the server
Read files on the server, write new files and
append to existing ones
Read files on the server, but not write them
The _______________ function returns the time
in the HH:MM:SS format from the given number of seconds.
TIME_FORMAT (seconds)
SEC_TO_TIME (seconds)
SYSDATE (seconds)
NOW (seconds)
What privilege must you have to execute a
FLUSH statement?
GRANT_OPTION
RELOAD
DROP
PROCESS
ALTER
Which date calculation interval works on days,
hours, and minutes?
DAY_MINUTE
DAY_HOUR_MINUTE
DAY_SECOND
DAY_ALL
Which one of the following data types causes a
column to have the NOT NULL, PRIMARY KEY and AUTO_INCREMENT properties?
INDEX
SERIAL
UNIQUE
PRIMARY
A MySQL server supports connection pooling.
True
False
Subscribe to:
Posts (Atom)
