Which of the following is not a character manipulation function?
concat
substr
instr
coalesce
A view is nothing but a ________ table or a stored query
Dymanic
Real
Virtual
Static
An outer join requires each record in the two joined tables to have a matching record.
True
False
None
Both
How can we get the number of records or rows in a table?
Using COUNT
Using NUM
Using NUMBER
Both a and c above
Which of the following ways below are the correct way to get the current date?
SELECT CURTIME();
SELECT CURDATE();
SELECT CURRENT_TIME();
All of above
On executing DELETE command, if you get an error "foreign key constraint" what does it imply?
Foreign key not defined
Table is empty
Connectivity issue
Data is present in the other table
Which is the default order of sort in ORDER BY clause?
Ascending
Descending
In a LIKE clause, you can ask for any 6 letter value by writing?
LIKE ??????
LIKE .{6} Answer 5: LIKE ^.{6}$
LIKE ...... (that's six dots)
LIKE ______ (that's six underscore characters)
Which function used to get the current time in mysql?
getTime()
Time()
NOW()
Transactions are used to treat sets of SQL statements atomically.
SQL is not case sensitive. SELECT is the same as select.
With SQL, how do you select all the columns from a table named "Persons"?
SELECT * FROM Persons
SELECT Persons
SELECT [all] FROM Persons
SELECT *.Persons
What kind of replication is supported by the MySQL server?
Multiple-master replication
Master to slave replication
Single file based clustering
MySQL doesn't support replication
Which authentications are required for login into Mysql command line tool?
Username
Password
Only Username
Both a) and b)
Which SQL statement is used to extract data from a database?
GET
Open
Extract
Select
Query
What is Row?
A row is a unit of data with related data items stored as one item in multiple columns in a table
A row is a unit of data with related data items stored as multiple item in one column in a table
A row is a unit of data with related data items stored as one item in two columns in a table
A row is a unit of data with related data items stored as one item in one column in a table
If you're writing a client using the C language API, your source code should include the following line at the top:
use mysql;
include ("mysql.h");
#include
import com.mysql.*;
How to view all Triggers in MySQL?
Show triggers;
Display triggers;
select triggers;
view triggers;
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
Which of the following is not an SQL aggregate function?
AVG
SUM
MIN
MAX
CURRENT_DATE()