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


                                       

0 Leave your comment here....:

Post a Comment