Oracle SQL and PL/SQL - Final Exam

The three main hardware components of a client/server system are the clients, the server, and the... - Answer- network To retrieve or update the data in a database, the client sends a/an _________ to the database. - Answer- query A relational database consists of one or more... - Answer- tables A/An _______________ uniquely identifies each row in a table. - Answer- primary key The intersection of a row and a column is commonly called a... - Answer- cell To relate one table to another, a/an ________________ in one table is used to point to the primary key in another table. - Answer- foreign key The most common type of relationship between two tables is a/an _______________________ relationship. - Answer- one-to-many When a column in a table is defined, it is given a data _______ that determines what kind of data it can store. - Answer- type The extension tot he SQL language that Oracle Database offers is called... - Answer- PL/SQL SQL statements that define the tables in a database are referred to as ______ statements. - Answer- DDL Insert, Update, and Delete statements can be referred to as _________ queries. - Answer- action A view is a SELECT statement that is stored with the... - Answer- database The processing that's done by the DBMS is typically referred to as... a.) front-end processing b.