Elance Resources and Guide: Skills Test Answers

Skills Test Answers - MySQL

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?

Which port does MySQL Server use by default?

3306

443

8080

What locks can be applied to MyISAM tables?

Read and Write

Read and 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'

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.

What is the default port number for MySQL?

3006

3396

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

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.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 ) ;

Syntax Error

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