DATABASE MANAGEMENT SYSTEM

1. What is DBMS?
a) DBMS is a collections of queries b) DBMS is a high level language
c) DBMS is a programming language d) DBMS stores, modify and retrieves data
2. What is foreign key combined with a primary key create?
a) Network model between the tables what connect them
b) Parent-child relationship between the tables that connect them
c) One to Many relationship between the tables that connect them
d) All of the mentioned above
3. The oldest DB model is________
a)Network b) Physical c) Hierarchical d) Relational
4. Which forms has a relation that processes data about an individual identity?
a) 2NF b) 3NF c) 4NF d) 5NF
5. What is the best way to represent the attributes in a large database?
a) Relational- and b) Concatenation c) Dot representation d) All of above
6. _______ refers to the correctness and completeness of data in a database.
a) Data integrity b) Data security c) Data constraint d) Data independence
7. What do you mean by One to Many relationship?
a) One class may have many teachers
b) One teacher can have many classes
c) Many classes may have many teachers
d) Many teachers may have many classes
8. How many types of data models are there?
a) 1 b) 2 c) 3 d) 4
9. For each attribute of a relation there is a set of permitted values called the ______ of that
attributes.
 a) Domain b) Relation c) Set d) Schema
10. Which of the following is not Armstrong’s action?
a) Reflexivity b) Augmentation c) Transitivity d) Pseudotransitivity
11. Which of the following in the subset of SQL commands used to manipulate oracle
structures, includes tables?
a) Data Described Language b) Data Retrieval Language
c) Data Manipulation Language d) Data Definition Language
12. The ability to query data, as well as insert, delete and alter tuples, is offered by _______.
a) TCL (Transaction Control Language) b) DCL (Data Control Language)
c) DDL (Data Definition Language) d) DML (Data Manipulation Language)
13. Rows of a relation are known as the ______.
a) Degree b) Tuples c) Entity d) All of Above
14. Which one of the following is a type of data manipulation language command?
a) Create b) Alter c) Delete d) All the above
15. Which of the following command is a type of data definition language command?
a) Create b) Update c) Delete d) Merge
16. Which one of the following command is used to delete the existing row in a table?
a) Delete b) Update c) Insert d) None of the above
17. For what purpose the DML is provided?
a) Addition of new structure in the database
b) Manipulation & processing of the database
c) Definition of the physical structure of the database
d) All of the above

18. In the relation model, the relation are generally termed as

a) Tuples b) Attributes c) Rows d) Tables
19. Which one of the following commands is used to modify a column inside a table?
a) Drop b) Update c) Alter d) Set
20. Which process is an instance made of oracle?
a) Data process b) Oracle background process
c) Memory process d) All of the Mentioned
21. The JOIN clause in SQL is used to ________.
a) Create a new table b) Combine data from two or more tables
c) Modify data from related tables d) Update data across multiple tables
22. Which SQL clause is used to sort the result-set?
a) WHERE b) GROUP BY c) ORDERED BY d) HAVING
23. What is a foreign key in a database table?
a) A unique identifier for each row in the table
b) A field that references the primary key of another table
c) A field that cannot be NULL
d) A field that is automatically generated by the database
24. What is the purpose of an index in a database table?
a) To prevent data security b) To speed up data retrieval
c) To prevent duplicate data d) To store data in a temporary location
25. Which JOIN returns only the rows that have a match in the both tables?
a) INNER JOIN b) LEFT JOIN c) RIGHT JOIN d) FULL-OUTER JOIN
26. Which set operation returns only the rows that are common both SELECT statements?
a) UNION ALL b) UNION c) INTERSECT d) EXCEPT

27. How do you refer to the result of a sub query in FORM clause?
a) By using an alias b) By using the HAVING clause
c) By using correlated query d) By using COUNT function
28. How many sub queries can be nested in a SQL query?
a) 1 b) 2 c) 255 d) No defined limit
29. A sub query in the FROM clause is commonly refers to as:
a) Inline view b) Nested query c) Correlated query d) Temporary query
30. Which JOIN retrieves rows that do not have matching rows in the ordered tables?
a) INNER JOIN b) NATURAL JOIN c) OUTER JOIN d) CROSS JOIN
31. Which of the Following Pair of block Structure is Mandantory to include in PL/SQL
Block?
a) Begin,End b) Declare,End c) Exceptions,Begin d) Exceptions,End

32. Which of the following Symbol is used to Denote a Single Line Command in PL/SQL?
a)/*…*/ b) */…*/ c) // d) --
33. ________ command can be used to raise an Exception explicity by a User.
a) RISED b) RAISED c) RISE d) RAISE
34. _______ is raised when PL/SQL ran out of memory (or) was Corrupted.
a) NO_DATA_FOUND b) STORAGE_ERROR
c) VALUE_ERROR d) None of the Above
35. PL/SQL variables are by default _______
a) Uppercase Sensitive b) Not Case Sensitive
c) LowerCase Sensitive d) Not LowerCase Sensitive
36 .In Order to Initialize a variable with the Value other than NULL,it can be done using
Which Method?
a)The Assignment Operator b) The DEFAULT Keyword
c) Both A and B d) None of the Above
37. Which of the Followingis a Character Literal?
a)B b) 4 c) % d) All of the Above
38. PL/SQL procedure consists of ________
a)Header and Footer b) Body and Footer
c) Header and Body d) None of the Above
39.A/An ______ loop in PL/SQL ensures that atleast one Statement is executed before
the loop terminates.
a)While b) For c) Cursor for d) Exit
40. PL/SQL function must contain a _______
a) GoTo Statement b) Follow Statement
 c) Return Statement d) NULL Statement
41. In the Context created by Oracle, a cursor represents a _______
a)Pointer b) Function c) Table D) None of the Above
42. Which of the following PL/SQL cursor is Automatically generated by Oracle?
a) Implicit b) Explicit c) Both A and B d) None of these
43. When Condition is valid for Which Triggers?
a) Row Level Triggers b)Table Level Triggers
c) Column Level Triggers d) Database Level Triggers
44. Which of the following clause is not present in the Syntax of Triggers?
a) Declare b) Trigger c) Cursor d) Instead of
45. In PL/SQL, which of the following data structure can be used to store a fixed number
of elements of same datatype?
a) ARRAY b) NARRAY c) VARRAY d) CARRAY
46. Which of the following statement does not execute a trigger?
a) insert b) update c) select d) create
47. What is the index number for the starting element in VARRAY?
a) 0 b) 1 c) -1 d) 2
48. All objects placed within the package definition are known as which objects?
a) Private Objects b) Protected objects
c) Public objects d) Normal objects
49. Which of the following keyword is must have been creating function in PL/SQL?
a) replace b) in c) as d) return
50. Relational schemas and other metadata about relations are stored in a structure called
the ___
a) Data dictionary b) catalog c) log d) metadata