InterviewSolution
Saved Bookmarks
InterviewSolution
This section includes InterviewSolutions, each offering curated multiple-choice questions to sharpen your knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
What is the difference between DBMS and RDBMS? |
| Answer» | |
| 2. |
What do you understand by cardinality and why it is used? |
| Answer» | |
| 3. |
What is the purpose of acid properties? |
| Answer» | |
| 4. |
Why E-R models are used? |
| Answer» | |
| 5. |
How view is related to data independence? |
| Answer» | |
| 6. |
What do you understand by Data Independence? |
| Answer» | |
| 7. |
What are its two major subsystems of System R? |
| Answer» | |
| 8. |
What is the difference between extension and intension? |
| Answer» | |
| 9. |
How many levels of data abstraction are available? |
| Answer» | |
| 10. |
What is the type of de-normalization? |
| Answer» | |
| 11. |
How de-normalization is different from normalization? |
| Answer» | |
| 12. |
What are the different types of normalization that exists in the database? |
| Answer» | |
| 13. |
What do you understand by database Normalization? |
| Answer» | |
| 14. |
What are the relational operations that can be performed on the database? |
| Answer» | |
| 15. |
What is an index represent in relational database model? |
| Answer» | |
| 16. |
Why stored procedures are called as executable code? |
| Answer» | |
| 17. |
What is the difference between primary and foreign key? |
| Answer» | |
| 18. |
8. What are the two principles of relational database model? What is the difference between them? |
| Answer» | |
| 19. |
What are constraints in database? |
| Answer» | |
| 20. |
What is the difference between base and derived relation? |
| Answer» | |
| 21. |
Why domain is of high importance? |
| Answer» | |
| 22. |
What do you understand by relation in relational database model? |
| Answer» | |
| 23. |
What are entities and attributes referring to? |
| Answer» | |
| 24. |
Why a database is called as relational database model? |
| Answer» | |
| 25. |
VSIZE( ) function returns ___________. |
| Answer» | |
| 26. |
Which of the following is a string function? |
| Answer» | |
| 27. |
EXTRACT() function returns ___________. |
| Answer» | |
| 28. |
______ constraint can only applied at column level. |
| Answer» | |
| 29. |
A____ level constraint must be applied if data constraint spans across multiple columns in a table. |
| Answer» | |
| 30. |
The____ data types are used to store binary data. |
| Answer» | |
| 31. |
A sub query is a form of an SQL statement that appears ______ another SQL statement. |
| Answer» | |
| 32. |
Joining a table to itself is referred to as __________. |
| Answer» | |
| 33. |
What is true about join? |
| Answer» | |
| 34. |
______ condition can’t contain sub queries or sequence. |
| Answer» | |
| 35. |
Which of the following is not a valid SQL data type? |
| Answer» | |
| 36. |
______ clause can be used to find unique values in situations to which ____ apply. |
| Answer» | |
| 37. |
_______ used to sort the data in the table |
| Answer» | |
| 38. |
Which of the following column is not a part of USER_CONSTRAINTS? |
| Answer» | |
| 39. |
Which of the following query will correctly create the view of Employee table having fields fname,lname,dept? |
| Answer» | |
| 40. |
What are the prerequisite for a View to be updateable? |
| Answer» | |
| 41. |
A View is mapped to __________ statement. |
| Answer» | |
| 42. |
Grant all on Customer to Reeta with grant option, what is the significance of ‘with grant option’ in this query? |
| Answer» | |
| 43. |
________ allows grantee to in turn grant object privileges to other users. |
| Answer» | |
| 44. |
The ___ operator is used to calculate aggregates and super aggregates for expressions within a ________. |
| Answer» | |
| 45. |
Which of the following query is correctly give the user name of the currently logged in user? |
| Answer» | |
| 46. |
To compare one value with more than one or list of values then which of the following operator will fulfil the need? |
| Answer» | |
| 47. |
Select from the following option which not true about primary key |
| Answer» | |
| 48. |
Up to how many columns can be combined to form a composite primary key for a table? |
| Answer» | |
| 49. |
The _______ command is used to change or modify data values in a table |
| Answer» | |
| 50. |
Which of the following tasks cannot be performed when using Alter Table clause? |
| Answer» | |