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

Posted Date:-2019-06-12 03:10:42


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

1.COMMIT

2.ROLLBACK

3.TRUNCATE

4.DELETE

Posted Date:-2019-06-12 02:51:02


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

Posted Date:-2019-06-12 02:55:25


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

Posted Date:-2019-06-12 02:59:17


Question:
Keyword is used to sort ?

1.SORT BY

2.ORDER BY

3.ORDER

4.SORT

Posted Date:-2019-06-12 02:47:14


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

Posted Date:-2019-06-12 03:09:01


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

1.ROLLBACK

2.COMMIT

3.TRUNCATE

4.DELETE

Posted Date:-2019-06-12 02:51:53


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

Posted Date:-2019-06-12 03:00:48


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

1.IS NULL

2.NOT

3.EXISTS

4.All of the above

Posted Date:-2019-06-12 02:49:44


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

Posted Date:-2019-06-12 03:11:27


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

Posted Date:-2019-06-12 02:48:33


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

1.AVG

2.LEFT

3.JOIN

4.LEN

Posted Date:-2019-06-12 03:06:58


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

1.RENAME

2.GRANT

3.REVOKE

4.UPDATE

Posted Date:-2019-06-12 03:12:03


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

1.Column Alias

2.Dates

3.Strings

4.All of the above

Posted Date:-2019-06-12 03:05:19


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

1.DELETE

2.SELECT

3.INSERT

4.SELECT

Posted Date:-2019-06-12 03:06:18


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

Posted Date:-2019-06-12 03:09:44


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

1.TOP

2.MAX

3.UPPER

4.MOST

Posted Date:-2019-06-12 03:08:11


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

1.DISTINCTIVE

2.UNIQUE

3.DIFFERENT

4.DISTINCT

Posted Date:-2019-06-12 03:07:40


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

1.REMOVE

2.ALTER

3.DELETE

4.COLLAPSE

Posted Date:-2019-06-12 03:03:53


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

1.SAVE

2.SAVE AS

3.UPDATE

4.MODIFY

Posted Date:-2019-06-12 03:03:19


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!