{"id":75826,"date":"2023-06-25T11:30:52","date_gmt":"2023-06-25T15:30:52","guid":{"rendered":"http:\/\/bangla.salearningschool.com\/recent-posts\/some-topics-to-know-and-understand-to-prepare-for-a-dbms-related-job-interview\/"},"modified":"2023-06-25T11:30:52","modified_gmt":"2023-06-25T15:30:52","slug":"some-topics-to-know-and-understand-to-prepare-for-a-dbms-related-job-interview","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=75826","title":{"rendered":"Some Topics to Know and Understand to prepare for a DBMS related Job Interview"},"content":{"rendered":"<h1> <strong>Some Topics to Know and Understand <\/strong><br \/>\n<strong>to prepare <\/strong><br \/>\n<strong>for a DBMS related Job Interview<\/strong><\/h1>\n<h1>ACID<\/h1>\n<ul>\n<li>\n<h2>ACID: <a href=\"https:\/\/www.geeksforgeeks.org\/acid-properties-in-dbms\">https:\/\/www.geeksforgeeks.org\/acid-properties-in-dbms<\/a> <\/h2>\n<\/li>\n<\/ul>\n<h1><strong>Database Normalization<\/strong><\/h1>\n<ul>\n<li>\n<h2><strong>1NF: <\/strong>No repeating groups possible for a cell, PK identified, dependencies mapped<\/h2>\n<\/li>\n<li>\n<h2><strong>2NF: <\/strong>No Partial Dependence. Non key attributes must have to depend on the full key<\/h2>\n<\/li>\n<li>\n<h2><strong>3NF:<\/strong> No transitive dependency. non key attributes must have to depend on the primary key, not on any other attributes. if there is another candidate key, still that is in 3NF<\/h2>\n<\/li>\n<li>\n<h2><strong>BCNF:<\/strong> 3NF satisfied but multiple candidate key exist then BCNF required<\/h2>\n<\/li>\n<li>\n<h2><strong>4NF:<\/strong> Multivalued Dependency exist. Need to remove that.<\/h2>\n<\/li>\n<li>\n<h2>5NF: Do not have Join dependency<\/h2>\n<\/li>\n<\/ul>\n<h1><strong>4NF: Normalization<\/strong><\/h1>\n<ul>\n<li>\n<h2><strong>Fourth Normal Form<\/strong><\/h2>\n<\/li>\n<li>\n<h3>Multivalued Dependency exist<\/h3>\n<\/li>\n<li>\n<h4>Attributes independent of each other but depends on the same attribute<\/h4>\n<\/li>\n<li>\n<h4>No row should show multivalued dependency<\/h4>\n<\/li>\n<li>\n<h4>Solution: usually break into multiple tables<\/h4>\n<\/li>\n<li>\n<h3><a href=\"https:\/\/bohr.wlu.ca\/cp363\/notes\/theory\/20_4nf.php\">https:\/\/bohr.wlu.ca\/cp363\/notes\/theory\/20_4nf.php<\/a><\/h3>\n<\/li>\n<li>\n<h3>Definition: Multivalued Dependency: <\/h3>\n<\/li>\n<li>\n<h4><a href=\"https:\/\/www.javatpoint.com\/dbms-multivalued-dependency\">https:\/\/www.javatpoint.com\/dbms-multivalued-dependency<\/a><\/h4>\n<\/li>\n<li>\n<h2><strong>5NF:<\/strong> is already in 4NF. and if contains join dependency.<\/h2>\n<\/li>\n<li>\n<h3>Remove join dependency, break into new tables, but lossless break<\/h3>\n<\/li>\n<li>\n<h3><a href=\"https:\/\/www.javatpoint.com\/dbms-fifth-normal-form\">https:\/\/www.javatpoint.com\/dbms-fifth-normal-form<\/a> <\/h3>\n<\/li>\n<li>\n<h3>Table: lecturer, semester, course. <\/h3>\n<\/li>\n<li>\n<h4>We cannot create semester without knowing other attributes.<\/h4>\n<\/li>\n<li>\n<h4>Not in 5NF<\/h4>\n<\/li>\n<li>\n<h4>Solution: usually break into multiple tables<\/h4>\n<\/li>\n<\/ul>\n<h4>\n<\/h4>\n<h2>\n<\/h2>\n<h1><strong>Normalization<\/strong><\/h1>\n<ul>\n<li>\n<h2>Normalization: Determinant<\/h2>\n<\/li>\n<li>\n<h3><a href=\"https:\/\/mix.sumdu.edu.ua\/textbooks\/11961\/472103\/index.htm\">https:\/\/mix.sumdu.edu.ua\/textbooks\/11961\/472103\/index.htm<\/a><\/h3>\n<\/li>\n<\/ul>\n<h1>Read Misc.: PL\/SQL, T-SQL<\/h1>\n<ul>\n<li>\n<h2>PL\/SQL Tutorial:<\/h2>\n<\/li>\n<li>\n<h3><a href=\"https:\/\/www.tutorialspoint.com\/plsql\/index.htm\">https:\/\/www.tutorialspoint.com\/plsql\/index.htm<\/a><\/h3>\n<\/li>\n<li>\n<h2>Oracle vs SQL Server<\/h2>\n<\/li>\n<li>\n<h3><a href=\"https:\/\/www.cybrary.it\/blog\/database-differences-microsoft-sql-server-vs-oracle-database\">https:\/\/www.cybrary.it\/blog\/database-differences-microsoft-sql-server-vs-oracle-database<\/a><\/h3>\n<\/li>\n<li>\n<h2>Oracle Vs MS SQL Server<\/h2>\n<\/li>\n<li>\n<h3><a href=\"https:\/\/www.guru99.com\/oracle-vs-sql-server.html\">https:\/\/www.guru99.com\/oracle-vs-sql-server.html<\/a><\/h3>\n<\/li>\n<li>\n<h3><a href=\"https:\/\/www.guru99.com\/oracle-vs-sql-server.html\">https:\/\/www.guru99.com\/oracle-vs-sql-server.html<\/a><\/h3>\n<\/li>\n<li>\n<h2>T-SQL vs PL\/SQL:<\/h2>\n<\/li>\n<li>\n<h3><a href=\"https:\/\/hevodata.com\/learn\/t-sql-vs-p-l-sql\">https:\/\/hevodata.com\/learn\/t-sql-vs-p-l-sql<\/a><\/h3>\n<\/li>\n<\/ul>\n<h2>\n<\/h2>\n<h1>Cursors, Triggers, Functions, Stored Procedures<\/h1>\n<ul>\n<li>\n<h2>An INSTEAD OF trigger <\/h2>\n<\/li>\n<li>\n<h3>is an SQL trigger that is processed \u201cinstead of\u201d an SQL UPDATE, DELETE or INSERT statement. Unlike SQL BEFORE and AFTER triggers, an INSTEAD OF trigger can be defined only on a view, not a table. <\/h3>\n<\/li>\n<li>\n<h3><strong><a href=\"https:\/\/www.ibm.com\/docs\/en\/i\/7.2?topic=triggers-instead-sql\">https:\/\/www.ibm.com\/docs\/en\/i\/7.2?topic=triggers-instead-sql<\/a><\/strong><\/h3>\n<\/li>\n<li>\n<h2><strong>Implicit Cursor:<\/strong><\/h2>\n<\/li>\n<li>\n<h3><strong><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/lnpls\/implicit-cursor-attribute.html\">https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/19\/lnpls\/implicit-cursor-attribute.html<\/a> [may have wrong info]<\/strong><\/h3>\n<\/li>\n<li>\n<h3><strong><a href=\"https:\/\/www.mygreatlearning.com\/plsql\/tutorials\/pl-sql-cursors\">https:\/\/www.mygreatlearning.com\/plsql\/tutorials\/pl-sql-cursors<\/a><\/strong><\/h3>\n<\/li>\n<li>\n<h2><strong>Function vs Stored Procedure:<\/strong><\/h2>\n<\/li>\n<li>\n<h3><strong><a href=\"https:\/\/www.tutorialspoint.com\/what-are-the-differences-between-stored-procedures-and-functions\">https:\/\/www.tutorialspoint.com\/what-are-the-differences-between-stored-procedures-and-functions<\/a><\/strong><\/h3>\n<\/li>\n<\/ul>\n<h1><strong>Oracle Misc.<\/strong><\/h1>\n<ul>\n<li>\n<h2>Oracle Three Tier:<\/h2>\n<\/li>\n<li>\n<h3>Application Architecture:<\/h3>\n<\/li>\n<li>\n<h3><a href=\"https:\/\/docs.oracle.com\/cd\/E18727-01\/doc.121\/e12841\/T120505T120508.htm\">https:\/\/docs.oracle.com\/cd\/E18727-01\/doc.121\/e12841\/T120505T120508.htm<\/a><\/h3>\n<\/li>\n<li>\n<h2>Oracle Datastore<\/h2>\n<\/li>\n<li>\n<h3><a href=\"https:\/\/www.oracle.com\/webfolder\/technetwork\/data-quality\/edqhelp\/content\/concepts\/data_stores.htm\">https:\/\/www.oracle.com\/webfolder\/technetwork\/data-quality\/edqhelp\/content\/concepts\/data_stores.htm<\/a> <\/h3>\n<\/li>\n<\/ul>\n<h2>\n<\/h2>\n<h1>Oracle Admin and Policies<\/h1>\n<ul>\n<li>\n<h2>Oracle Tutorials:<\/h2>\n<\/li>\n<li>\n<h3><a href=\"https:\/\/www.oracletutorial.com\/oracle-administration\/\">https:\/\/www.oracletutorial.com\/oracle-administration\/<\/a><\/h3>\n<\/li>\n<li>\n<h2>Database Admin Policy:<\/h2>\n<\/li>\n<li>\n<h3><a href=\"https:\/\/study.com\/academy\/lesson\/database-security-policies-examples-and-creation.html\">https:\/\/study.com\/academy\/lesson\/database-security-policies-examples-and-creation.html<\/a><\/h3>\n<\/li>\n<li>\n<h2>Establish Security Policies:<\/h2>\n<\/li>\n<li>\n<h3><a href=\"https:\/\/docs.oracle.com\/cd\/A58617_01\/server.804\/a58397\/ch19.htm\">https:\/\/docs.oracle.com\/cd\/A58617_01\/server.804\/a58397\/ch19.htm<\/a><\/h3>\n<\/li>\n<li>\n<h2>The critical elements for creating a database environment are (1) data administration, (2) data-planning and modeling methodology, (3) database technology and management, and (4) users.<\/h2>\n<\/li>\n<li>\n<h3><a href=\"https:\/\/docs.microfocus.com\/OpsCx\/10.11\/Content\/policies\/database\/db_policies.htm\">https:\/\/docs.microfocus.com\/OpsCx\/10.11\/Content\/policies\/database\/db_policies.htm<\/a><\/h3>\n<\/li>\n<li>\n<h2>Policies in Oracle:<\/h2>\n<\/li>\n<li>\n<h3><a href=\"https:\/\/docs.oracle.com\/en-us\/iaas\/Content\/Identity\/Concepts\/policies.htm\">https:\/\/docs.oracle.com\/en-us\/iaas\/Content\/Identity\/Concepts\/policies.htm<\/a><\/h3>\n<\/li>\n<li>\n<h2>Common Policies:<\/h2>\n<\/li>\n<li>\n<h3><a href=\"https:\/\/docs.oracle.com\/en-us\/iaas\/Content\/Identity\/Concepts\/commonpolicies.htm#top\">https:\/\/docs.oracle.com\/en-us\/iaas\/Content\/Identity\/Concepts\/commonpolicies.htm#top<\/a><\/h3>\n<\/li>\n<\/ul>\n<h2>\n<\/h2>\n<h1>Misc. Oracle<\/h1>\n<ul>\n<li>\n<h2>Oracle: SQL Plus<\/h2>\n<\/li>\n<li>\n<h3><a href=\"https:\/\/docs.oracle.com\/cd\/B14117_01\/server.101\/b12170\/qstart.htm\">https:\/\/docs.oracle.com\/cd\/B14117_01\/server.101\/b12170\/qstart.htm<\/a><\/h3>\n<\/li>\n<li>\n<h2>Start Working with Oracle:<\/h2>\n<\/li>\n<li>\n<h3><a href=\"https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/21\/\">https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/21\/<\/a><\/h3>\n<\/li>\n<\/ul>\n<h1>MongoDB Misc.<\/h1>\n<ul>\n<li>\n<h2>Tutorial:<\/h2>\n<\/li>\n<li>\n<h3><a href=\"https:\/\/www.tutorialspoint.com\/mongodb\/mongodb_interview_questions.htm\">https:\/\/www.tutorialspoint.com\/mongodb\/mongodb_interview_questions.htm<\/a> <\/h3>\n<\/li>\n<li>\n<h3>Read the Q &amp; A, the online Quiz<\/h3>\n<\/li>\n<li>\n<h2>BSON:<\/h2>\n<\/li>\n<li>\n<h3><a href=\"https:\/\/www.mongodb.com\/basics\/bson\">https:\/\/www.mongodb.com\/basics\/bson<\/a> <\/h3>\n<\/li>\n<li>\n<h2>Explain:<\/h2>\n<\/li>\n<li>\n<h3><a href=\"https:\/\/www.mongodb.com\/docs\/manual\/reference\/command\/explain\/\">https:\/\/www.mongodb.com\/docs\/manual\/reference\/command\/explain\/<\/a> <\/h3>\n<\/li>\n<\/ul>\n<hr \/>\n<p>Sayed Ahmed<br \/>\nProfessor, Software Engineer, Data Scientist, and ML EngineerPart-time Professor and Course Facilitator at Colleges in Ontario, Canada<br \/>\nExtensive experience in Software Development and Engineering<br \/>\nSignificant experience in Teaching.<br \/>\nTaught in Universities, Colleges, and Training Institutes<br \/>\nMaster of Engineering (MEng.) in Electrical and Computer Engineering (McMaster University) (Changed Ph.D. Studies to MEng)<br \/>\nMSc in Data Science and Analytics (TMU\/Ryerson)<br \/>\nMSc in Computer Science (U of Manitoba)<br \/>\nBSc. Engineering in Computer Science and Engineering (BUET).<br \/>\n(Session: 1994-95 to 1996-97 Class: 1996 to 2001)<\/p>\n<p>Linkedin: <a href=\"https:\/\/ca.linkedin.com\/in\/sayedjustetc\">https:\/\/ca.linkedin.com\/in\/sayedjustetc<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Some Topics to Know and Understand to prepare for a DBMS related Job Interview ACID ACID: https:\/\/www.geeksforgeeks.org\/acid-properties-in-dbms Database Normalization 1NF: No repeating groups possible for a cell, PK identified, dependencies mapped 2NF: No Partial Dependence. Non key attributes must have to depend on the full key 3NF: No transitive dependency. non key attributes must have &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"http:\/\/bangla.sitestree.com\/?p=75826\">Continue reading<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[182],"tags":[],"class_list":["post-75826","post","type-post","status-publish","format-standard","hentry","category---blog","item-wrap"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":69013,"url":"http:\/\/bangla.sitestree.com\/?p=69013","url_meta":{"origin":75826,"position":0},"title":"Normalization in Relational DBMS Systems #6","author":"Author-Check- Article-or-Video","date":"August 10, 2021","format":false,"excerpt":"First Normal Form:All table columns should have distinct meaningIn another word: All attributes of an entity\/table must be uniqueSolution: Grow the table row wise[in the direction of rows] not the column wiseGroup the columns with same meaning into oneTo handle multiple values for the same attribute of an entity create\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":13933,"url":"http:\/\/bangla.sitestree.com\/?p=13933","url_meta":{"origin":75826,"position":1},"title":"Bangla RDBMS Lesson 25 : Relational Database Design Part 2 \u2013 Functional dependency","author":"Author-Check- Article-or-Video","date":"November 5, 2017","format":false,"excerpt":"\u09a1\u09be\u099f\u09be\u09ac\u09c7\u099c \u09b6\u09bf\u0996\u09be\u09b0 \u09b8\u09ac \u09ad\u09bf\u09a1\u09bf\u0993 \u09aa\u09c7\u09a4\u09c7 \u09ad\u09bf\u099c\u09bf\u099f \u0995\u09b0\u09c1\u09a8 http:\/\/jompesh.com\/videos\/list\/category\/112 , \u098f\u0996\u09be\u09a8\u09c7 \u0986\u09b0\u0993 \u09ac\u09be\u0982\u09b2\u09be\u09df \u09b6\u09bf\u0996\u09a4\u09c7 \u09aa\u09be\u09ac\u09c7\u09a8 Computer Science \u0985\u09a8\u09cd\u09af\u09be\u09a8\u09cd\u09af \u09ac\u09bf\u09b7\u09df \u09af\u09c7\u09ae\u09a8 data structure , System Analysis and Design , C,C++, JAVA, OOP , Operating System \u09b8\u09b9 \u0986\u09b0\u0993 \u0985\u09a8\u09c7\u0995 \u0995\u09bf\u099b\u09c1 . Keyword: Bangla RDBMS , Bangla Oracle , Bangla database , database tutorials\u2026","rel":"","context":"In &quot;AI ML DS RL DL NN NLP Data Mining Optimization&quot;","block_context":{"text":"AI ML DS RL DL NN NLP Data Mining Optimization","link":"http:\/\/bangla.sitestree.com\/?cat=1910"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":69015,"url":"http:\/\/bangla.sitestree.com\/?p=69015","url_meta":{"origin":75826,"position":2},"title":"Boyce\/Codd and Fourth Normal Form #6","author":"Author-Check- Article-or-Video","date":"August 10, 2021","format":false,"excerpt":"Boyce\/Codd Normal Form----------------------It is just an extension to the third normal form. Third normal form ensures that non key attributes does not depend on any non key attribute but fully depend on the key[primary] attributes.Boyce codd normal form ensures that non key attributes are fully dependent on the total set\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":62716,"url":"http:\/\/bangla.sitestree.com\/?p=62716","url_meta":{"origin":75826,"position":3},"title":"Process Details. Part &#8211; 2: Project Activity and Time Management #PMP &#8211; Project Management","author":"Author-Check- Article-or-Video","date":"May 20, 2021","format":false,"excerpt":"Process: Define Activities Required: List all the activities, functionalities, modules, components you want to develop. When the project scope is defined, use it to decompose the work into activity list. Work breakdown structure will be useful at this stage. List what modules, components the project will handle. List all the\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":62537,"url":"http:\/\/bangla.sitestree.com\/?p=62537","url_meta":{"origin":75826,"position":4},"title":"Project Time Management: Part-1 #PMP &#8211; Project Management","author":"Author-Check- Article-or-Video","date":"May 16, 2021","format":false,"excerpt":"[note: My articles are just a note\/reminder to me. I keep them here so that I can refresh my memory whenever required. The artcles may be weak as a writing component. Thanks.]Project Time ManagementProject time management process1. Define Activities Required2. Sequence Activities3. Estimate Resources for the Activities4. Calculate Duration of\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":70215,"url":"http:\/\/bangla.sitestree.com\/?p=70215","url_meta":{"origin":75826,"position":5},"title":"Must Read: Database Driven Software Development #106","author":"Author-Check- Article-or-Video","date":"August 29, 2021","format":false,"excerpt":"If you are developing database driven applications, you must need to know and clearly understand the following concepts. Yes, you also need to apply them in your design and implementation. If you do not follow proper database design strategies, many complexities will arise, adjusting new requirements may become cumbersome to\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/75826","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=75826"}],"version-history":[{"count":0,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/75826\/revisions"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=75826"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=75826"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=75826"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}