- | P a g e
CIT 381 Final Actual EXAM Newest 2025/2026 With Complete Questions And Correct Answers |Already Graded A+||Brand New Version!|
In a SQL view, changes to base tables are always automatically updated in the view. - ANSWER-true -Views are dynamically updated each time the view is invoked, so any changes to a view's base tables are always represented in the view results -Changes to base tables require revisiting views to ensure the view still functions as expected
Identify the definition of a SQL stored procedure. - ANSWER-database API -Relational databases support the ability to create your own database API (application programming interface)
A stored procedure is used exactly like a SQL view - ANSWER-false -A view represents a virtual table. You can join multiple tables in a view and use the view to present the data as if the data were coming from a single table.-A stored procedure uses parameters to do a function... whether it is updating and inserting data, or returning single values or data sets.
- / 2
- | P a g e
Identify the correct referential action to ensure data in related tables through a foreign key are deleted when the data in the table with the primary key is deleted. - ANSWER-cascade -Delete or update the row from the parent table, and automatically delete or update the matching rows in the child table
Relational databases are no longer the dominant category of databases - ANSWER-false -Relational databases currently reign worldwide
NoSQL databases do not have SQL-like data manipulation commands - ANSWER-false -Partially misnamed as many NoSQL systems include SQL-like data manipulation
Identify the typical element(s) of a graph database - ANSWER--NodesB.-Edges (relationships) -Properties
Our world consists of domains of connected data - ANSWER-true -Our world, and our information, consists of domains of data -These bits and bytes of data are not isolated, but connected
- / 2