IDM Sessional Test

Which MySQL statement is used to select data from a database?

• Open

• Select

• Extract

• Get

Which MySQL statement is used to update data in a database?

• Insert

• Modify

• ALter

• Update

Which MySQL statement is used to delete data from a database?

• DELETE

• COLLAPSE

• REMOVE

• ALTER

Which MYSQL statement is used to insert new data in a database?

• ADD

• UPDATE

• INSERT

• ADD INTO

With MySQL, how do you select a column named "FirstName" from a table named "Persons"?

Next ❯

• EXTRACT FirstName FROM Persons

• SELECT Persons.FirstName

• SELECT FirstName FROM Persons.FirstName

• SELECT FirstName FROM Persons

With MySQL, how do you select all the columns from a table named "Persons"?

• SELECT .Persons

• SELECT Persons

• SELECT [all] FROM Persons

• None of them

Which is the best description of a database?

• Stores data

• Stores data in a organised structure

• Stores data in an organised and logical structure

A collection of fields and records in a specific category is called as

• Record

• Database

• Field

• Table

Rows in a database tables are called as

• Record

• Database

• Field

• Table

Columns in a database are called...

• Record

• Database

• Field

• Table