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
Command makes the updates performed by the transaction permanent in the database?
1.COMMIT
2.ROLLBACK
3.TRUNCATE
4.DELETE
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
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
Keyword is used to sort ?
1.SORT BY
2.ORDER BY
3.ORDER
4.SORT
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
undo all the updates performed by the SQL in the transaction?
1.ROLLBACK
2.COMMIT
3.TRUNCATE
4.DELETE
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
What operator tests column for the absence of data?
1.IS NULL
2.NOT
3.EXISTS
4.All of the above
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
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
Which of the following is a SQL aggregate function?
1.AVG
2.LEFT
3.JOIN
4.LEN
which of the following is not a data definition language commands?
1.RENAME
2.GRANT
3.REVOKE
4.UPDATE
Which of the following must be enclosed in double quotes?
1.Column Alias
2.Dates
3.Strings
4.All of the above
Which of the following SQL commands is used to retrieve data?
1.DELETE
2.SELECT
3.INSERT
4.SELECT
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
Which SQL keyword is used to retrieve a maximum value?
1.TOP
2.MAX
3.UPPER
4.MOST
Which SQL keyword is used to retrieve only unique values?
1.DISTINCTIVE
2.UNIQUE
3.DIFFERENT
4.DISTINCT
Which SQL statement is used to delete data FROM a database?
1.REMOVE
2.ALTER
3.DELETE
4.COLLAPSE
Which SQL statement is used to update data in a database?
1.SAVE
2.SAVE AS
3.UPDATE
4.MODIFY