One of the early proponents of relational database who laid down many of the principles we use to this day was:
The "father" of MySQL is
A NULL value is treated as a blank or 0.
None of the above
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
How do I find out all databases starting with ‘test to which I have access to?
SHOW DATABASES LIKE ‘%test%’;
SHOW DATABASES LIKE ‘%test;
SHOW DATABASES LIKE ‘'test'%’;
SHOW DATABASES LIKE ‘test%’;
Which SQL statement is used to extract data from a database?
Which SQL statement is used to insert a new data in a database?
What is DCL?
Data Control Language
Data Content Language
Data Column Language
Defined Control Language
The “Mysql command line tool” formats are bounded by
Which of the following commands should be used to create a database named “student”?
CREATE ?I student
CREATE DATABASE student
What is Table?
A table is a data storage structure with rows .
A table is a data storage structure with columns.
A table is a data storage structure with rows and columns.
What does SQL stand for?
Structured Query Language
Structured Question Language
Strong Question Language
The result of a SELECT statement can contain duplicate rows.
Which statement is used to access an existing Database?
none of these
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 not a valid aggregate function?
Which of the following is used to delete an entire MYSQL database?
Which of the following can add a row to a table?
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
Which of the following file extension is a valid MyISAM file extension?
With SQL, how can you delete the records where the "FirstName" is "Peter" in the Persons Table?
DELETE FROM Persons WHERE FirstName = 'Peter'
DELETE ROW FirstName='Peter' FROM Persons
DELETE FirstName='Peter' FROM Persons
Can I call a trigger directly called from an application?
The main MySQL program that does all the data handling is called?
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
Which of these is not a valid name for a column
If you're writing a client using the C language API, your source code should include the following line at the top:
How can we get the number of records or rows in a table?
Both a and c above
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'
How many TRIGGERS are allowed in MySql table?
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