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

No comments:

Post a Comment