Mysql Questions Set 7:
Which of the following is not a valid aggregate function?
Solution:
Which keyword used with UNION does not retain duplicate rows?
Solution:
Which of these modes is a composite server mode?
Solution:
Is it necessary to insert the value in each column of the table?
Solution:
On what does the default case sensitivity of database and table names depends on?
Solution:
What is meant by the term 'candidate key'?
Solution:
. What will be the output of the following query?
SELECT *
FROM employee
WHERE start_date>=’2007-01-01’ AND
Start_date<=’2005-01-01’
Solution:
If the table 'account' has a column 'cust_id' with the values {1, 2, 2, 3, 3, 5, 6, 7, 8, 8}, what will be the output of the following MySQL statement?
SELECT DISTINCT cust_id
FROM account;
Solution:
Which among the following is the correct syntax for modifying the definition of an existing table?
Solution:
What will be the output of the following query?
SELECT * FROM employee WHERE lname LIKE ‘F%’ AND lname LIKE ‘%T’;
Solution:
Related Question Sets:
Related Topics:
Scroll to Top
