MySQL

Question: –i-am-a-dummy flag is used Makes the MySQL engine refuse UPDATE and which other command?
A
WHERE

B
INSERT

C
DELETE

D
TRUNCATE

Note: Not available
1. Report
Question: Which is the default order of sort in ORDER BY clause?
A
Ascending

B
Descending

Note: Not available
1. Report
Question: Can DISTINCT command be used for more than one column?
A
Yes

B
No

Note: Not available
1. Report
Question: On executing DELETE command, if you get an error "foreign key constraint"- what does it imply?
A
Foreign key not defined

B
Table is empty

C
Connectivity issue

D
Data is present in the other table

Note: Not available
1. Report
Question: BLOB data type can have default column value.
A
True

B
False

Note: Not available
1. Report
Question: How much storage space does DATETIME require?
A
4 bytes

B
2 bytes

C
8 bytes

D
1 byte

Note: Not available
1. Report
Question: If an ENUM column is declared NOT NULL, its default value is the first element of the list of allowed values.
A
True

B
False, ENUM column cannot be null

C
False, its default value is the last element of the list of allowed values

D
True , ENUM column cannot be null

Note: Not available
1. Report
Question: Triggers are also referred to as database
A
function

B
event

C
procedure

D
datatype

Note: Not available
1. Report
Question: Which is not the purpose of using triggers?
A
Audit trails

B
Validation

C
Referential integrity enforcement

D
Viewing data

Note: Not available
1. Report
Question: Which of the following statement about limitations of MySQL triggers is incorrect?
A
TEMPORARY tables are not supported

B
Views are not supported

C
Result sets can't be returned from a trigger

D
Triggers must be unique

E
Error handling and reporting support is immature

F
Must use prefix (ad,ai,au,bd,bi,bu) of naming a trigger

Note: Not available
1. Report

First Prev 13 14 15 16 Next Last

Question: –i-am-a-dummy flag is used Makes the MySQL engine refuse UPDATE and which other command?

Question: Which is the default order of sort in ORDER BY clause?

Question: Can DISTINCT command be used for more than one column?

Question: On executing DELETE command, if you get an error "foreign key constraint"- what does it imply?

Question: BLOB data type can have default column value.

Question: How much storage space does DATETIME require?

Question: If an ENUM column is declared NOT NULL, its default value is the first element of the list of allowed values.

Question: Triggers are also referred to as database

Question: Which is not the purpose of using triggers?

Question: Which of the following statement about limitations of MySQL triggers is incorrect?