SQL Fundamentals_Amr

What does SQL stand for?

• Structured Query Language

• Standard Query Language

• Strong Query Langauge

Which SQL statement is used to extract data from a database?

• EXTRACT

• Get

• OPEN

• SELECT

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

• MODIFY

• SAVE AS

• UPDATE

• SAVE

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

• Modify

• DELETE

• MOVE

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

• ADD RECORD

• INSERT NEW

• INSERT INTO

• ADD NEW

_______used to Create, Manage database objects in the database.

• DDL

• DML

• DCL

• DQL

You issue the following query: SELECT empno, ename FROM emp WHERE empno = 7782 OR empno = 7876;   Which other operator can replace the OR condition in the WHERE clause

• IN

• BETWEEN.. AND..

• LIKE

Roll Back segment is not used in case of:

• DCL

• DDL

• DQL

• All of the above

You query the table with this commandSELECT nameFROM employeeWHERE name LIKE '_a%'; Which names are displayed? 

• Names starting with “a”

• Names containing “a” as any letter except the first

• Names containing “a” as second character

• Names starting with “a” or “A”

How does a TRUNCATE TABLE statement differ from an unrestricted DELETE? Select all that apply.

• Using TRUNCATE all the values in the table will be deleted but not the structure whereas as In Delete a particular row can be deleted but not the structure

• Using TRUNCATE all the values in the table will be deleted and the structure as well but whereas as In Delete a particular row can be deleted but not the structure

• Using TRUNCATE all the values in the table will be deleted but not the structure whereas as In Delete a particular row can be deleted and the structure as well

• None of the Above