IT Officer Quiz For IBPS SO (DBMS)

1. In SQL, the CREATE TABLESPACE is used :

2. 'AS' clause is used in SQL for

3. In SQL, the CREATE VIEW command is used :

4. In SQL, which command is used to remove a stored function from the database ?

5. Which command is used to remove an index from the database in SQL?

6. In SQL, GRANT command is used to

7. In SQL, which command(s) is (are) used to remove rows from a table :

8. In SQL, which statement is used to select employee number (EMP_NO) and Department (DEPT) from (EMPLE) table whose salary (SALARY) is 8000?

9. Multivalued dependencies should ________ be eliminated.

10. A subquery in an SQL SELECT statement is enclosed in:


                                       

For Syllabus: CLICK HERE

This entry passed through the Full-Text RSS service - if this is your content and you're reading it on someone else's site, please read the FAQ at http://ift.tt/jcXqJW.