Mysql/MY SQL Basic Sample Test Sample Test,Sample questions

Question:
Choose  not a type of SQL constraint?

1.PRIMARY

2.UNIQUE

3.ALTERNATE

4.FOREIGN

Posted Date:-2019-06-11 22:46:02


Question:
Choose following behavior as an SQL virtual table?

1.view

2.relation

3.Query

4.Query results

Posted Date:-2019-06-11 22:49:33


Question:
The query to remove rows from a table  named user ?

1.DROP FROM user where id =1

2.UPDATE FROM user where id =1

3.REMOVE FROM user where id =1

4.DELETE FROM user where id =1

Posted Date:-2019-06-11 23:05:37


Question:
The SQL ALTER statement can be used 

1.to change in table data

2.to change in table structure

3. delete rows from the table

4. delete new recored in the table

Posted Date:-2019-06-11 22:56:24


Question:
The SQL WHERE clause to limits the

1.row data

2.column data

3.Both

4.None

Posted Date:-2019-06-11 23:11:16


Question:
What SQL query can be used to add columns to a table?

1.ALTER TABLE Table_Name ADD Column_Name

2.Update TABLE TableName ADD COLUMN ColumnName

3.MODIFY TABLE TableName ADD ColumnName

4.MODIFY TABLE TableName ADD COLUMN ColumnName

Posted Date:-2019-06-11 23:00:50


Question:
When using the SQL INSERT statement..

1.rows can be modified according to criteria only.

2.rows cannot be copied in mass from one table to another only.

3.rows can either be inserted into a table one at a time or in groups.

4.rows can be inserted into a table only one at a time only

Posted Date:-2019-06-11 22:54:27


Question:
Which of the following is the original purpose of SQL?

1.To define the data structures

2.To specify the syntax and semantics of SQL data definition language

3.To specify the syntax and semantics of SQL manipulation language

4.All of the above

Posted Date:-2019-06-11 23:17:32


Question:
Which of the following SQL query can be used to insert new recorder to a database table?

1.add row

2.ADD

3.APPEND

4.INSERT

Posted Date:-2019-06-11 22:35:18


Question:
Which SQL query can be used to delete columns from a table?

1.update TABLE Table_Name DROP Column_Name

2.MODIFY TABLE Table_Name DROP COLUMN Column_Name

3. ALTER TABLE TableName DROP Column_Name

4.ALTER TABLE TableName DROP COLUMN Column_Name

Posted Date:-2019-06-11 22:59:09


More MCQS

  1. Function Sample Test
  2. MY SQL Basic Sample Test
  3. MY SQL Basic Sample Test 01
  4. MY SQL Basic Sample Test 02
Search
R4R Team
R4Rin Top Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on R4R.in website is done by expert team not only with the help of books but along with the strong professional knowledge in all context like coding,designing, marketing,etc!