MySQL, Databases

Question: Which of the following are true in case of Indexes for MYISAM Tables?
A
Indexes can have NULL values

B
BLOB and TEXT columns can be indexed

C
Indexes per table cannot be more than 16

D
Columns per index cannot be more than 16

E
None

Note: Not available
1. Report
Question: Below is the table “messages,” please find proper query and result from the choices below. Id Name Other_Columns ------------------------- 1 A A_data_1 2 A A_data_2 3 A A_data_3 4 B B_data_1 5 B B_data_2 6 C C_data_1
A
He cannot rename any MySQL database

B
By using: RENAME DATABASE db_old_name TO db_new_name

C
By using: RENAME DATABASE TO db_new_name

D
By creating the new empty database, then rename each table using: RENAME TABLE db_old_name.table_name TO db_new_name.table_name

E
None

Note: Not available
1. Report
Question: Consider the following tables: books ------ bookid bookname authorid subjectid popularityrating (the popularity of the book on a scale of 1 to 10) language (such as French, English, German etc) Subjects --------- subjectid subject (such as History, Geography, Mathematics etc) authors -------- authorid authorname country Which is the query to determine the Authors who have written at least 1 book with a popularity rating of less than 5?
A
select authorname from authors where authorid in (select authorid from books where popularityrating<5)

B
select authorname from authors where authorid in (select authorid from books where popularityrating<=5)

C
select authorname from authors where authorid in (select bookid from books where popularityrating<5)

D
select authorname from authors where authorid in (select authorid from books where popularityrating in (0,5))

E
None

Note: Not available
1. Report
Question: The Flush statement cannot be used for:
A
Closing any open tables in the table cache

B
Closing open connections

C
Flushing the log file

D
Flushing the host cache

E
All

Note: Not available
1. Report
Question: Consider the query:
SELECT name FROM Students WHERE name LIKE '_a%';
Which names will be displayed?
A
Names starting with "a"

B
Names containing "a" as the second lette

C
Names starting with "a" or "A"

D
Names containing "a" as any letter except the first

Note: Not available
1. Report
Question: Which of the following is the best MySQL data type for currency values?
A
SMALLINT

B
DECIMAL(19,4)

C
VARCHAR(32)

D
BIGINT

Note: Not available
1. Report
Question: What are MySQL Spatial Data Types in the following list?
A
GEOMETRY

B
CIRCLE

C
SQUARE

D
POINT

E
POLYGON

Note: Not available
1. Report
Question: Examine the two SQL statements given below:
SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY salary DESC SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY 2 DESC
What is true about them?
A
The two statements produce identical results

B
The second statement returns an error

C
There is no need to specify DESC because the results are sorted in descending order by default

D
None of the statments is correct

Note: Not available
1. Report
Question: Which of the following will raise MySQL's version of an error?
A
SIGNAL

B
RAISE

C
ERROR

D
None

Note: Not available
1. Report
Question: Which query will return values containing strings "Pizza", "Burger", or "Hotdog" in the database?
A
SELECT * FROM fiberbox WHERE field REGEXP 'Pizza|Burger|Hotdog';

B
SELECT * FROM fiberbox WHERE field LIKE '%Pizza%' OR field LIKE '%Burger%' OR field LIKE '%Hotdog%';

C
SELECT * FROM fiberbox WHERE field = '%Pizza%' OR field = '%Burger%' OR field = '%Hotdog%';

D
SELECT * FROM fiberbox WHERE field = '?Pizza?' OR field = '?Burger?' OR field = '?Hotdog?';

Note: Not available
1. Report

First Prev 1 2 3 Next Last

Question: Which of the following are true in case of Indexes for MYISAM Tables?

Question: Below is the table “messages,” please find proper query and result from the choices below. Id Name Other_Columns ------------------------- 1 A A_data_1 2 A A_data_2 3 A A_data_3 4 B B_data_1 5 B B_data_2 6 C C_data_1

Question: The Flush statement cannot be used for:

Question: Consider the query:
SELECT name FROM Students WHERE name LIKE '_a%';
Which names will be displayed?

Question: Which of the following is the best MySQL data type for currency values?

Question: What are MySQL Spatial Data Types in the following list?

Question: Examine the two SQL statements given below:
SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY salary DESC SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY 2 DESC
What is true about them?

Question: Which of the following will raise MySQL's version of an error?

Question: Which query will return values containing strings "Pizza", "Burger", or "Hotdog" in the database?

Question: Which of the following are true in case of Indexes for MYISAM Tables?

Question: Below is the table “messages,” please find proper query and result from the choices below. Id Name Other_Columns ------------------------- 1 A A_data_1 2 A A_data_2 3 A A_data_3 4 B B_data_1 5 B B_data_2 6 C C_data_1

Question: The Flush statement cannot be used for:

Question: Consider the query:SELECT name FROM Students WHERE name LIKE '_a%'; Which names will be displayed?

Question: Which of the following is the best MySQL data type for currency values?

Question: What are MySQL Spatial Data Types in the following list?

Question: Examine the two SQL statements given below: SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY salary DESC SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY 2 DESC What is true about them?

Question: Which of the following will raise MySQL's version of an error?

Question: Which query will return values containing strings "Pizza", "Burger", or "Hotdog" in the database?

Question: Consider the query:
SELECT name FROM Students WHERE name LIKE '_a%';
Which names will be displayed?

Question: Examine the two SQL statements given below:
SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY salary DESC SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY 2 DESC
What is true about them?