Database quiz for IT officer exam

As we all know,DBMS is very important subject for SO exam. For that reading book in detail is not possible,also its boring too. We are providing important question as a quiz

00:00:00

1. In SQL, the CREATE TABLESPACE is used :

To create a place in the database for storage of scheme objects

To create a database trigger

To add/rename data files, to change storage

All of the above

None of the above

2. 'AS' clause is used in SQL for

Selection operation

Rename operation

Join operation

Projection operation

none of the above

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

To re-compile view

To define a view of one or more tables or views

To re-compile a table

To create a trigger

None of the above

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

REMOVE FUNCTION

DELETE FUNCTION

DROP FUNCTION

ERASE FUNCTION

None of these

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

DELETE INDEX

DROP INDEX

REMOVE INDEX

ROLLBACK INDEX

None of the above

6. In SQL, GRANT command is used to

Allow user to access database

Allow user to create database

Grant system privileges, roles and object privileges to uses and roles

Choose auditing for specific SQL commands

None of the above

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

DELETE

REMOVE

TRUNCATE

Both (a) and (c)

None of the above

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

SELECT EMPNO, DEPT FROM EMPL=8000

SELECT EMPNO, DEPT FROM EMPL WHERE SALARY=8000

SELECT EMPNO, DEPT, SALARY=8000 FROM EMPL

SELECT EMPNO, DEPT, FROM TABLE EMPL WHEN SALARY-800

None of these

9. Multivalued dependencies should ________ be eliminated.

always

commonly

seldom

never

None of these

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

braces -- {...}

CAPITAL LETTERS

parenthesis -- (...)

brackets -- [...]

None of these