MySQL

Question: An outer join requires each record in the two joined tables to have a matching record.
A
True

B
False

Note: Not available
1. Report
Question: Which aggregate function is used get the number of records or rows in a table?
A
Using COUNT()

B
Using NUM()

C
Using NUMBER()

D
None

Note: Not available
1. Report
Question: A view is nothing but a _____ table or a stored query
A
Dymanic

B
Real

C
Virtual

D
Static

Note: Not available
1. Report
Question: Can I call a trigger directly called from an application?
A
No

B
Yes

Note: Not available
1. Report
Question: When do we use a HAVING clause?
A
To limit the output of a query

B
To limit the output of a query using an aggregate function only

C
When GROUP by is used

D
all

Note: Not available
1. Report
Question: USE keyword is used to select a _____
A
Table

B
Column

C
Database

D
All

Note: Not available
1. Report
Question: Enum values are stored accodring to their index numbers
A
True

B
False

Note: Not available
1. Report
Question: Which of the following ways below are the correct way to get the current date?
A
SELECT CURTIME();

B
SELECT CURDATE();

C
SELECT CURRENT_TIME();

D
All

Note: Not available
1. Report
Question: Which of the following file extension is a valid MyISAM file extension?
A
.ism

B
.myd

C
.my

D
.mys

Note: Not available
1. Report
Question: User() function returns the current users user name and _____
A
password

B
host name

C
database

D
none

Note: Not available
1. Report

First Prev 12 13 14 15 16 Next Last

Question: An outer join requires each record in the two joined tables to have a matching record.

Question: Which aggregate function is used get the number of records or rows in a table?

Question: A view is nothing but a _____ table or a stored query

Question: Can I call a trigger directly called from an application?

Question: When do we use a HAVING clause?

Question: USE keyword is used to select a _____

Question: Enum values are stored accodring to their index numbers

Question: Which of the following ways below are the correct way to get the current date?

Question: Which of the following file extension is a valid MyISAM file extension?

Question: User() function returns the current users user name and _____