Which of these is not optional?SELECT select_list FROM table_list WHER – McqOptions

MCQOPTIONS

1.	Which of these is not optional?SELECT select_list FROM table_list WHERE row_constraint GROUP BY grouping_columns;
A.	table_list
B.	grouping_columns
C.	select_list
D.	row_constraint
E.	None of these
Answer» D. row_constraint

Discussion

No Comment Found

Related MCQs

Which of these is not optional?SELECT select_list FROM table_list WHERE row_constraint GROUP BY grouping_columns;
How many of these are for use with only MyISAM tables?mysql, mysqladmin, mysqldump, mysqlisamchk
How many of these can replace level in myisam-recover = level ?BACKUP, FORCE, QUICK
REPAIR TABLE works with how many of the following?MyISAM, ARCHIVE, CSV
The higher priority is ______________.writes, reads
With only MyISAM tables, how many of the following are for use?mysql, mysqladmin, mysqldump, mysqlisamchk
How many of the following languages can interface to bind to the C API of MySQL?Perl, PHP, Python
CHECK TABLE works with how many of the following?MyISAM, ARCHIVE, CSV
What is the table name in the following?INSERT INTO Employee VALUES('Rahul','M',NULL);
What is InnoDB in the following code?CREATE TABLE Employee ( Emp_name CHAR(30), Emp_id INT, PRIMARY KEY (Emp_id) ) ENGINE = InnoDB;