Database Technology soln.pdf - Shriram Mantri Vidyanidhi...

Shriram Mantri Vidyanidhi Info Tech Academy
PG DAC Data Base Technologies Question Bank
1) In ..................... , we have a strict parent-child relationship only.
A ) hierarchical databases. B) network databases
C) object oriented databases D) relational databases
2) The file in DBMS is called as .................. in RDBMS. 3) What operator tests column for the absence of data? 4) The .................... refers to the way data is organized in and accessible from DBMS. 5) ............................ is the powerful language for working with RDBMS.
A) Embedded Programs B) Dynamic Programs
C ) Query Language D) Static Language Programs
6) A table can have only 0 or 1 primary key 7) How many unique keys can a table have 8) SQL stands for
9) Which is more secured
A) File System B) RDBMS C) Both D) None
10) Excel is --------------- 11) Oracle is ----------- 12) Office register is --------- 13) Various Keywords supported by SQL are
A) Insert B) Update C) Select D) All of the Above
14) Which Databases supports SQL
15) Example of Non-Numerical Data is

Shriram Mantri Vidyanidhi Info Tech Academy
PG DAC Data Base Technologies Question Bank
B) Bank Balance D) None of the Above
16) which of the following is a correct SQL query
17) which of the following constraint is not supported by MySQL
A) Primary Key B) Unique Key C) Check Constraint D) Not Null