Mysql Questions Set 26:
. The “Mysql command line tool” formats are bounded by
Solution:
How are identifiers quoted in MySQL?
Solution:
What is the command to move the cursor to the beginning of the line in MySQL input editor?
Solution:
Which server mode value enables use of double quotes to wrap identifier names?
Solution:
The number of attributes in the following table is ______________
CREATE TABLE employee (
emp_name CHAR(30), emp_id INT
);
Solution:
Which among the following is the correct syntax for creating a table?
Solution:
Is there any error in the following query?
SELECT emp_id, title, start_date, fname, fed_id FROM person ORDER BY RIGHT (fed_id, 3);
Solution:
Is there any error in this query?
SELECT e.emp_id, e.fname,e.lname,d.name FROM employee e INNER JOIN department d ON e.dept_id=e.dept_id;
Solution:
Which collations does this statement list?
SHOW COLLATION LIKE 'utf8%'
Solution:
What will be the output of the query given below?
SELECT * FROM employee WHERE title=’HEAD TELLER’;
Solution:
Related Question Sets:
Related Topics:
Scroll to Top
