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

Question: A command that lets you change one or more fields in a record is

1.Insert

2.Modify

3.Look-up

4.All of the above


Question: Command makes the updates performed by the transaction permanent in the database?

1.COMMIT

2.ROLLBACK

3.TRUNCATE

4.DELETE


Question: Find all the user whose id is 10

1.SELECT * FROM user WHERE id= 10;

2.SELECT * FROM WHERE id= 10;

3.SELECT * FROM user.id= 10;

4.None


Question: Find the temperature in increasing order of all cities

1.SELECT city FROM weather ORDER BY temperature

2.SELECT city, temperature FROM weather

3.SELECT city, temperature FROM weather ORDER BY temperature

4.SELECT city, temperature FROM weather ORDER BY city


Question: Keyword is used to sort ?

1.SORT BY

2.ORDER BY

3.ORDER

4.SORT


Question: The FROM SQL clause is used to.

1.specify what table we are selecting or deleting data FROM

2.specify range for search condition

3.specify search condition

4.None of these


Question: undo all the updates performed by the SQL in the transaction?

1.ROLLBACK

2.COMMIT

3.TRUNCATE

4.DELETE


Question: What is the meaning of LIKE %0%0%

1. Feature begins with two 0

2.Feature ends with two 0

3.Feature has more than two 0

4.Feature has two 0 in it, at any position


Question: What operator tests column for the absence of data?

1.IS NULL

2.NOT

3.EXISTS

4.All of the above


Question: which command is used to SELECT only one copy of each set of duplicate rows

1.SELECT DISTINCT

2.SELECT UNIQUE

3.SELECT DIFFERENT

4.All of the above


Question: Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?

1.Data Definition Language(DDL)

2.Data Manipulation Language(DML)

3.Both

4.None of these is correct


Question: Which of the following is a SQL aggregate function?

1.AVG

2.LEFT

3.JOIN

4.LEN


Question: which of the following is not a data definition language commands?

1.RENAME

2.GRANT

3.REVOKE

4.UPDATE


Question: Which of the following must be enclosed in double quotes?

1.Column Alias

2.Dates

3.Strings

4.All of the above


Question: Which of the following SQL commands is used to retrieve data?

1.DELETE

2.SELECT

3.INSERT

4.SELECT


Question: Which of the SQL statements is correct?

1.SELECT Username AND Password FROM Users

2.SELECT Username, Password FROM Users

3.ELECT Username, Password WHERE Username = user1

4.None of these


Question: Which SQL keyword is used to retrieve a maximum value?

1.TOP

2.MAX

3.UPPER

4.MOST


Question: Which SQL keyword is used to retrieve only unique values?

1.DISTINCTIVE

2.UNIQUE

3.DIFFERENT

4.DISTINCT


Question: Which SQL statement is used to delete data FROM a database?

1.REMOVE

2.ALTER

3.DELETE

4.COLLAPSE


Question: Which SQL statement is used to update data in a database?

1.SAVE

2.SAVE AS

3.UPDATE

4.MODIFY


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!