MYSQL Test-1

A relation can have only one ________.

• Primary Key
• Alternate Key
• Unique key
• Foreign Key

The vertical subset of a table is known as:

• Tuple
• Row
• Attribute
• Relation

A field or a combination of fields in a table that has a unique value for each row is called:

• Candidate key.
• Foreign key.
• Main key.
• Alternate key.

Which statement is used to extract data from a table?

• SELECT
• DISPLAY
• EXTRACT
• READ

How do you select all the columns from a table named "Employee"?

• SELECT [all] FROM Employee;
• SELECT * FROM Employee ;
• SELECT Employee;
• SELECT * BY Employee;

Which of the following are valid column names?

• Marks Eng
• 66_Marks
• Marks_Eng
• #Eng_Marks

Which statement is used to insert new data in a table?

• ADD RECORD
• INSERT RECORD
• INSERT INTO
• INSERT ROW

How would you display all those rows from a table named "Friends" where the value of the column "Hobbies" is "SWIMMING"

• SELECT ALL FROM Friends WHERE Hobbies IS 'SWIMMING';
• SELECT * FROM Friends WHERE Hobbies='SWIMMING';
• SELECT * FROM Friends WHERE Hobbies = 'Swimming" ;
• SELECT ALL FROM Friends WHERE Hobbies 'SWIMMING' ;

Which statement is used to modify data in a table?

• CHANGE
• MODIFY
• UPDATE
• SAVE AS

How do you select all the rows from a table named "Student" where the value of the column "FName" starts with "G"?

• SELECT * FROM Student WHERE FName LIKE 'G_' ;
• SELECT * FROM Student WHERE FName='G';
• SELECT * WHERE Student WHERE FName='%G%' ;
• SELECT * FROM Student WHERE FName LIKE 'G%' ;