A system is a system with a Network, Database server, and clients.
DBMS stands for .
Processing done by the DBMS is typically referred to as and the database server is referred to as the .
The does the work that the users wants to do. This type of software can be purchased or developed.
API stands for .
The provides the interface between the application program and the DBMS.
SQL stands for .
A networked system using an application server goes from to application server to and responds back.
A simple web based system goes from client to web server to server and responds back.
Schema is another word for .
Which error message will be produced from not selecting a database before executing a SQL statement?
Error code: 1146. Table 'ex.vendors' doesn't exist
Error code: 1046. No database selected
Which error code will generate if you haven't selected the correct database before executing a SQL statement?
EER model stands for model.
ER model stands for model.
T or F, an EER diagram can be created before an EER or ER model has been created.
An model is a representation of the entities, or objects, of the database including the tables, views, and stored programs.
The processing that’s done by the DBMS is typically referred to as
Front-end processing
Back-end processing
The file server
The user interface
Which column can NOT be primary key?
Item_id
(order_id , product_id)
order_id
All above
Foreign Key should be unique
The most common type of relationship between two tables is a/an .
one-to-one
one-to-many
many-to-many
all above
Which of the following types of SQL statements is NOT a DML statement?
INSERT
UPDATE
SELECT
CREATE TABLE
Which join type does this graph illustrate?
Left Join
Left Inner Join
Right Join
Right Inner Join
A person’s name needs to be saved as first name, last name, middle name separately in database.
Which of the following diagrams best represents the relationship between a table of customers and a table of orders placed by customers?
Which
Foreign key is used to maintain _____.
Referential integrity
Uniqueness of record
Null values in the field
None of the above
A is a SELECT statement that's coded within another SQL statement,
Subqueries can be within other subqueries.
value indicates that the value of the column is unknown.
A value is a value that is used if another value isn't provided when a row is added to the table.
A constraint may prevent you from deleting a row. In that case, you can only delete the row if you delete all child rows for that row first.
In creating referential integrity, it makes sure that any changes to the data in the database don't create invalid relationships between tables.
A clause using ON DELETE would cause a deleted row from the Vendors table to delete all related rows in the Invoices table.
If you code an aggregate function in the SELECT clause, that clause can't include non aggregate columns from the base table unless those columns are named on a clause.
Which of the following cannot be used in an aggregate function?
MAX
MIN
AVG
COUNT
SUM
NONE OF THE ABOVE
By using a relational database type you CANNOT reduce data redundancy.
A row contains a set of values for a single INSTANCE of the entity, such as one invoice or one vendor.
A column does NOT represent an attribute of the entity.
In designing a data structure, each table represents on object, or , in the real world system.
What is not an option for the CHECK TABLE statement?
extended
slow
fast
medium
quick
changed
for upgrade
Like a join, a combines data from tow or more tables. Instead of combining columns from base tables, however, a union combines rows from tow or more result sets.
An intersection of a row is sometimes called a cell.
SQLEXCEPTION condition can be used to produce a SHOW ERRORS statement to display to handle the error that occurs when a row cannot be inserted.
To group data and use aggregate functions to summarize the data in each group you use two new clauses of the SELECT STATEMENT: BY and .
Which are logical operators?
And
HAVING
OR
NOT
A TRIGGER executes when which statements are run against a specific table.
DELETE
Please wait - loading…