CS 514 Test Questions with Correct Answers Latest Update 2025 Graded A+
Characteristic of hash structure in a key value database - Answers Buckets are stored on different
machines, enabling horizontal scaling.
Which graph combines a graph and relational database? - Answers Layered graph
Which wide-column database has no single point of failure and is always reliable? - Answers Cassandra
How are columns of a family stored within each row of wide column to optimize performance of read
queries? - Answers Contiguously
A wide column database is similar to relational database EXCEPT - Answers It does not support foreign
keys and joins
What happens when primary replica fails in a document database? - Answers A secondary replica
becomes active
Which NoSQL database uses tables that consist of a key and a group of items? - Answers DynamoDB
Each vertex in a graph contains a pointer to all connected vertices - Answers Index-free adjacency
What are vertices in a graph database similar to in a relational table? - Answers rows
To fulfil data processing reqs in a growing transactional database, what scales up by increasing
processing power of a limited number of systems? - Answers Vertical scaling
What assigns documents to shards? - Answers range function
Which approach splits data across multiple systems? - Answers Sharding
Which language is created specifically for graph databases? - Answers Gremlin
What represents entities in a database as a graph? - Answers vertices
A document database stores data as? - Answers collections
A relational database stores data as? - Answers tables
A big data application generates about 20,000 data entries per second. This rate is called? - Answers
Velocity
Which document type is most commonly used by document databases? - Answers XML/ Json
What database stores related data as column families? - Answers Wide column
Which would be acceptable as key value database? - Answers key= car make, value= Ford
, In a MongoDB shell what happens when a command without _id specified executes? - Answers
document is added to the collection with a generated _id
In MongoDB how is every student EXCEPT Larry selected? - Answers $ne, "Larry"
Strict consistency is enforced in some document databases by directing read queries to? - Answers the
primary replica
A No SQL database that represents data as a key with multiple values is called a? - Answers Wide column
When a key value database allows multiple values per key, how is each value identified? - Answers By
using a name for each value
In a PHP application using PDO, what consists of the host, port, and name of the database that will be
used to establish a connection to the database? - Answers Data source name
Why would mysql.connector.connect( )throw out an exception in a Connector/Python Program? -
Answers the function was called with a username that does not have access to the database
Which required keyword specifies if the trigger will affect all rows of the table? - Answers FOR EACH
ROW
In Connector/Python, what method prevents SQL injection, a type of attack that causes a program to
execute malicious sql statements? - Answers cursor.execute( )
What retrieves rows from a query that has multiple rows in the result set? - Answers cursor
Which database programming technique is commonly used with object-oriented programming
languages? - Answers API
Which two paradigms to programming languages fall under? - Answers imperative and declarative
Which is an example of database programming? - Answers creating a web app using JAVA and SQL
What does API define for applications written in procedural programming language? - Answers
procedure calls
What does API define for applications in object-oriented languages? - Answers classes
Why are database queries commonly implemented using declarative programming language? - Answers
Easier programming and faster execution
What is an ISO standard that extends procedural SQL for use in stored procedures? - Answers SQL PSM
Which database programming technique is an extension of the SQL language that is typically used for
database applications ? - Answers Procedural SQL
Characteristic of hash structure in a key value database - Answers Buckets are stored on different
machines, enabling horizontal scaling.
Which graph combines a graph and relational database? - Answers Layered graph
Which wide-column database has no single point of failure and is always reliable? - Answers Cassandra
How are columns of a family stored within each row of wide column to optimize performance of read
queries? - Answers Contiguously
A wide column database is similar to relational database EXCEPT - Answers It does not support foreign
keys and joins
What happens when primary replica fails in a document database? - Answers A secondary replica
becomes active
Which NoSQL database uses tables that consist of a key and a group of items? - Answers DynamoDB
Each vertex in a graph contains a pointer to all connected vertices - Answers Index-free adjacency
What are vertices in a graph database similar to in a relational table? - Answers rows
To fulfil data processing reqs in a growing transactional database, what scales up by increasing
processing power of a limited number of systems? - Answers Vertical scaling
What assigns documents to shards? - Answers range function
Which approach splits data across multiple systems? - Answers Sharding
Which language is created specifically for graph databases? - Answers Gremlin
What represents entities in a database as a graph? - Answers vertices
A document database stores data as? - Answers collections
A relational database stores data as? - Answers tables
A big data application generates about 20,000 data entries per second. This rate is called? - Answers
Velocity
Which document type is most commonly used by document databases? - Answers XML/ Json
What database stores related data as column families? - Answers Wide column
Which would be acceptable as key value database? - Answers key= car make, value= Ford
, In a MongoDB shell what happens when a command without _id specified executes? - Answers
document is added to the collection with a generated _id
In MongoDB how is every student EXCEPT Larry selected? - Answers $ne, "Larry"
Strict consistency is enforced in some document databases by directing read queries to? - Answers the
primary replica
A No SQL database that represents data as a key with multiple values is called a? - Answers Wide column
When a key value database allows multiple values per key, how is each value identified? - Answers By
using a name for each value
In a PHP application using PDO, what consists of the host, port, and name of the database that will be
used to establish a connection to the database? - Answers Data source name
Why would mysql.connector.connect( )throw out an exception in a Connector/Python Program? -
Answers the function was called with a username that does not have access to the database
Which required keyword specifies if the trigger will affect all rows of the table? - Answers FOR EACH
ROW
In Connector/Python, what method prevents SQL injection, a type of attack that causes a program to
execute malicious sql statements? - Answers cursor.execute( )
What retrieves rows from a query that has multiple rows in the result set? - Answers cursor
Which database programming technique is commonly used with object-oriented programming
languages? - Answers API
Which two paradigms to programming languages fall under? - Answers imperative and declarative
Which is an example of database programming? - Answers creating a web app using JAVA and SQL
What does API define for applications written in procedural programming language? - Answers
procedure calls
What does API define for applications in object-oriented languages? - Answers classes
Why are database queries commonly implemented using declarative programming language? - Answers
Easier programming and faster execution
What is an ISO standard that extends procedural SQL for use in stored procedures? - Answers SQL PSM
Which database programming technique is an extension of the SQL language that is typically used for
database applications ? - Answers Procedural SQL
