FINAL QUIZ DBMS SOFTWARE FOUNDATION PHASE 5

FINAL QUIZ DBMS SOFTWARE FOUNDATION PHASE 5
1. which among the following is a correct Syntax for raising the user defined exception
handlers?
- Both 1 and 2
2. Which SQL statement returns a numeric value?
- SELECT sysdate-hire_date FROM EMP;
3. when does the for loop terminate?
- When the index reaches the UPPER bound or is terminated early using EXIT statement
4. Table structure:
EmpID | EmpName | ProjId | MNGR-Id | Location | Designation
.
.
.
By referring to the above table structure, for which of the below questions, we would
require to apply the concept of SubQuery?
- All
5. Select an appropriate option for a ‘FUNCTION’ in PLSQL.
- Function can return result value.
6. The ____________ contains a set of tables and views that Oracle use as a reference to the
database
- Data Dictionary
7. What are defined as exceptions in PL/SQL?
- Run time errors
8. From the below table:
EmpId | EmpNAme | ProjId | ProjName | No.OfHoursWorked
…
What are the probable and decomposed tables after performing second normal form?
Let us assume that…..
- Table1:
EmpId | EmpName
Table2:
ProjId | ProjName
Table3:
EmpId | ProjId | No.OfHoursWorked
9. From the below table …….. What would be the primary key to get unique record from the
table? (Pls Confirm)
- EmpID and ProjId together
10. A column with regerence to a record in a table should not have multiple values.
Which normal form, Talks about the above statement?
- First
11. DELETE * FROM STUDENT
What will be the output?
- Deletes all rows from STUDENT table
12. What are the complications, when as exception occurs?
- All of these.
13. The formal classifications describing the level of database normalization in a model are
called normal forms.
- TRUE
14. We can use Transaction control statements in database triggers
- False
15. Select the suitable option from below to create an index on “job” column in emp table?
- Create index emp_ind on emp(job);
16. Which of the statements helps in terminating the PL/SQL LOOP?
- EXIT WHEN
17. Database trigger can be fired when the table is TRUNCATED?
- False
18. Types of SQL statements
- TCL
- DDL
- DML
19. In the below table:
EmpID | EmpName | ProjId
.
.
.
By referring the above table, Select a suitable query which gets all employees whose
project is same as project of ‘d’?
- SELECT * FROM EMP WHERE ProjId=(SELECT ProjId FROM EMP WHERE EMPNAME=’d’)
20. On which of the below statements, acts as trigger firing events?
- All of these
21. We can enable or disable a database trigger
- True
22. Which is the below statement is used to remove access or privileges on database object to
users?
- Revoke
23. A stored function will not allow any parameter to be passed
- False
24. DCL Commands are used to enforce database security in a multiple user environment
- True
25. DDL commands
- CREATE
- ALTER
- DROP
26. Which is the correct syntax for handling Exception handlers?
- WHEN ex_name THEN stmt
27. Which of the below constraints will make sure to allow, only the values of a column (in a
master) to the respective column of a child table?
- Foreign key
28. What does TRUNCATE statement do?
- Remove all rows from a table
29. Select the suitable statement for PLSQL
- Bringing Programming language features to SQL

30. Which of the following is true with respect to Referential Integrity?
- Every foreign key value must match primary key value in the associated table ie
Parent table
31. What is the grant statement to grant select, insert, delete privileges on table: Emp to user:
TestUser?
- Grant Select, Insert, Delete on Emp to TestUser
32. Table 1 : Emp
EmpId | EmpName | ProjId
…
Table2: Proj
ProjId | ProjName
…
By referring to the above table structure, select the query which would Fetch EMPID,
EMPNAME, ProjId, ProjName for each employee?
- Select A.EmpID, A.EmpNAme, A.ProjId, B.ProjName from EMP A, Proj B WHERE
A.ProjID = B.ProjID
33. Select the suitable option for SubQuery
- Inner query executes first…
34. Which Prefixes are available to Oracle triggers?
- Both :new and :old
35. Evaluate the set of SQL statements: CREATE TABLE dept(dept_id NUMBER(2) dname
VARCHAR2(14), Loc VARCHAR2(13)); ROLLBACK; DESCRIBE DEPT. What is true about the
set?
- The DESCRIBE DEPT statement displays the structure of the DEPT table