MySQL, Databases

Question: Which of the following will restore a MySQL DB from a .dump file?
A
mysql -u<user> -p < db_backup.dump

B
mysql -u<user> -p<password> < db_backup.dump

C
mysql -u<user> -p <password> < db_backup.dump

D
mysql -u<user> -p<password> > db_backup.dump

Note: Not available
1. Report
Question: Which of the following will show when a table in a MySQL database was last updated?
A
Using the following query: SELECT UPDATE_TIME FROM information_schema.tables WHERE TABLE_SCHEMA = 'database_name' AND TABLE_NAME = 'table_name'

B
Creating an on-update trigger to write timestamp in a custom table, then querying the custom table

C
Getting the "last modified" timestamp of the corresponding database file in the file system

D
None

Note: Not available
1. Report
Question: Which of the following results in 0 (false)?
A
"EXPERTRATING" LIKE "EXP%"

B
"EXPERTRATING" LIKE "Exp%"

C
BINARY "EXPERTRATING" LIKE "EXP%"

D
BINARY "EXPERTRATING" LIKE "Exp%"

E
All will result in 1 (true)

Note: Not available
1. Report
Question: Which of the following relational database management systems is simple to embed in a larger program?
A
MySQL

B
SQLite

C
Both

D
None

Note: Not available
1. Report
Question: What is true about the ENUM data type?
A
An enum value may be a user variable

B
An enum may contain number enclosed in quotes

C
An enum cannot contain an empty string

D
An enum value may be NULL

E
None of is true

Note: Not available
1. Report
Question: What will happen if two tables in a database are named rating and RATING?
A
This is not possible as table names are case in-sensitive (rating and RATING are treated as same name)

B
This is possible as table names are case sensitive (rating and RATING are treated as different names)

C
This is possible on UNIX/LINUX and not on Windows platform

D
This is possible on Windows and not on UNIX/LINUX platforms

E
This depends on lower_case_table_names system variable

Note: Not available
1. Report
Question: How can a InnoDB database be backed up without locking the tables?
A
mysqldump --single-transaction db_name

B
mysqldump --force db_name

C
mysqldump --quick db_name

D
mysqldump --no-tablespaces db_name

Note: Not available
1. Report
Question: What does the term "overhead" mean in MySQL?
A
Temporary diskspace that the database uses to run some of the queries

B
The size of a table

C
A tablespace name

D
None

Note: Not available
1. Report
Question: Consider the following select statement and its output: SELECT * FROM table1 ORDER BY column1; Column1 -------- 1 2 2 2 2 2 3 Given the above output, which one of the following commands deletes 3 of the 5 rows where column1 equals 2?
A
DELETE FIRST 4 FROM table1 WHERE column1=2

B
DELETE 4 FROM table1 WHERE column1=2

C
DELETE WHERE column1=2 LIMIT 4

D
DELETE FROM table1 WHERE column1=2 LIMIT 3

E
DELETE FROM table1 WHERE column1=2 LEAVING 1

Note: Not available
1. Report
Question: Consider the following queries:
create table foo (id int primary key auto_increment, name int); create table foo2 (id int auto_increment primary key, foo_id int references foo(id) on delete cascade);
Which of the following statements is true?
A
Two tables are created

B
If a row in table foo2, with a foo_id of 2 is deleted, then the row with id = 2 in table foo is automatically deleted

C
Those queries are invalid

D
If a row with id = 2 in table foo is deleted, all rows with foo_id = 2 in table foo2 are deleted

Note: Not available
1. Report

First Prev 1 2 3 4 5 Next Last

Question: Which of the following will restore a MySQL DB from a .dump file?

Question: Which of the following will show when a table in a MySQL database was last updated?

Question: Which of the following results in 0 (false)?

Question: Which of the following relational database management systems is simple to embed in a larger program?

Question: What is true about the ENUM data type?

Question: What will happen if two tables in a database are named rating and RATING?

Question: How can a InnoDB database be backed up without locking the tables?

Question: What does the term "overhead" mean in MySQL?

Question: Consider the following select statement and its output: SELECT * FROM table1 ORDER BY column1; Column1 -------- 1 2 2 2 2 2 3 Given the above output, which one of the following commands deletes 3 of the 5 rows where column1 equals 2?

Question: Consider the following queries:
create table foo (id int primary key auto_increment, name int); create table foo2 (id int auto_increment primary key, foo_id int references foo(id) on delete cascade);
Which of the following statements is true?

Question: Which of the following will restore a MySQL DB from a .dump file?

Question: Which of the following will show when a table in a MySQL database was last updated?

Question: Which of the following results in 0 (false)?

Question: Which of the following relational database management systems is simple to embed in a larger program?

Question: What is true about the ENUM data type?

Question: What will happen if two tables in a database are named rating and RATING?

Question: How can a InnoDB database be backed up without locking the tables?

Question: What does the term "overhead" mean in MySQL?

Question: Consider the following select statement and its output: SELECT * FROM table1 ORDER BY column1; Column1 -------- 1 2 2 2 2 2 3 Given the above output, which one of the following commands deletes 3 of the 5 rows where column1 equals 2?

Question: Consider the following queries:create table foo (id int primary key auto_increment, name int); create table foo2 (id int auto_increment primary key, foo_id int references foo(id) on delete cascade); Which of the following statements is true?

Question: Consider the following queries:
create table foo (id int primary key auto_increment, name int); create table foo2 (id int auto_increment primary key, foo_id int references foo(id) on delete cascade);
Which of the following statements is true?