Sometimes the expression "select count(*)" will return fewer rows than the expression "select count(value)".
Which of the following file extension is a valid MyISAM file extension?
How much character are allowed to create database name?
MySql | Which of the following is available in MySQL:
Which of these commands will delete a table called XXX if you have appropriate authority:
DROP TABLE XXX
DROP XXX WHERE confirm = "YES"
DELETE XXX WHERE confirm = "YES"
What MySQL property is used to create a surrogate key in MySQL?
None of the above
What does SQL stand for?
Structured Query Language
Structured Question Language
Strong Question Language
Which command is used for showing current date and time in Mysql command line tool?
None of these
How can you change "Hansen" into "Nilsen" in the "LastName" column in the Persons table?
UPDATE Persons SET LastName='Hansen' INTO LastName='Nilsen'
UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'
MODIFY Persons SET LastName='Hansen' INTO LastName='Nilsen
MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen'
In a SELECT with a GROUP BY clause, a WHERE clause, and a HAVING clause, the WHERE conditions are applied before the HAVING conditions.
Either True or False
Which of the following can add a row to a table?
Which command is used on Mysql command line tool to return to window command shell?
MySQL comes with as standard with client libraries for:
Java and C
Perl, PHP and C
With SQL, how can you insert a new record into the "Persons" table?
INSERT INTO Persons VALUES ('Jimmy', 'Jackson')
INSERT ('Jimmy', 'Jackson') INTO Persons
INSERT VALUES ('Jimmy', 'Jackson') INTO Persons
USE keyword is used to select a ___________
All of above
The program called mysql is
There isn't a program just called mysql
A wrapper through which Java clients must connect to the databases
A client program that lets you send SQL commands to the database engine
The database engine
A program that starts up and shuts down the database engine
MySQL runs on which operating systems?
Linux and Mac OS-X only
Any operating system at all
Unix, Linux, Windows and others
Unix and Linux only
Can joins be nested?
Internally information is held in tables. Which of these is NOT a valid format:
The ............. statement is used to delete a table.
Which SQL keyword is used to sort the result-set?
Which of these is not a valid name for a column
Which of these field types would be best to hold a .jpg image?
If you want to undo a GRANT, you should use
What's the difference between the DESCRIBE and SHOW FIELDS FROM commands?
Only SHOW FIELDS FROM can take a LIKE clause
Nothing - they're the same thing
Only DESCRIBE can take a LIKE clause
On executing DELETE command, if you get an error "foreign key constraint" what does it imply?
Foreign key not defined
Table is empty
Data is present in the other table
With SQL, how can you return the number of records in the "Persons" table?
SELECT COLUMNS() FROM Persons
SELECT COUNT(*) FROM Persons
SELECT COLUMNS(*) FROM Persons
SELECT COUNT() FROM Persons
What will happen at the end of the following sequence of SQL commands?
DELETE FROM MYTABLE WHERE ID=1
DELETE FROM OTHERTABLE
The contents of OTHERTABLE will be deleted
The contents of both OTHERTABLE and MYTABLE will be deleted
The contents of OTHERTABLE will be deleted, as will be all the contents of MYTAB whoID is 1
The database will remain unchanged to all users except the one that executes these queries.
The database will remain unchanged
Which of the following is used to delete an entire MYSQL database?
Given an employees table as follows:
what value will be return by below query ?
Select count(*) from employees
none of the above