3783155
Beschreibung
Quiz von Kait Schroeder, aktualisiert more than 1 year ago
|
Erstellt von Kait Schroeder
vor fast 9 Jahre
|
|
Frage 1
Frage
A [blank_start]simple client server[blank_end] system is a system with a Network, Database server, and clients.
Antworten
-
simple client server
Frage 2
Frage
DBMS stands for [blank_start]database management system[blank_end].
Antworten
-
database management system
Frage 3
Frage
Processing done by the DBMS is typically referred to as [blank_start]back end processing[blank_end] and the database server is referred to as the [blank_start]back end[blank_end].
Antworten
-
back end processing
-
back end
Frage 4
Frage
The [blank_start]application software[blank_end] does the work that the users wants to do. This type of software can be purchased or developed.
Antworten
-
application software
Frage 5
Frage
API stands for [blank_start]application programming interface[blank_end].
Antworten
-
application programming interface
Frage 6
Frage
The [blank_start]data access API[blank_end] provides the interface between the application program and the DBMS.
Antworten
-
data access API
Frage 7
Frage
SQL stands for [blank_start]structured query language[blank_end].
Antworten
-
structured query language
Frage 8
Frage
A networked system using an application server goes from [blank_start]client[blank_end] to application server to [blank_start]database server[blank_end] and responds back.
Antworten
-
client
-
database server
Frage 9
Frage
A simple web based system goes from client [blank_start]web browser[blank_end] to web server to [blank_start]database[blank_end] server and responds back.
Antworten
-
web browser
-
database
Frage 10
Frage
Schema is another word for [blank_start]database[blank_end].
Antworten
-
database
Frage 11
Frage
Which error message will be produced from not selecting a database before executing a SQL statement?
Antworten
-
Error code: 1146. Table 'ex.vendors' doesn't exist
-
Error code: 1046. No database selected
Frage 12
Frage
Which error code will generate if you haven't selected the correct database before executing a SQL statement?
Antworten
-
Error code: 1146. Table 'ex.vendors' doesn't exist
-
Error code: 1046. No database selected
Frage 13
Frage
EER model stands for [blank_start]enhanced entity relationship[blank_end] model.
Antworten
-
enhanced entity relationship
Frage 14
Frage
ER model stands for [blank_start]entity relationship[blank_end] model.
Antworten
-
entity relationship
Frage 15
Frage
T or F, an EER diagram can be created before an EER or ER model has been created.
Antworten
- True
- False
Frage 16
Frage
An [blank_start]EER[blank_end] model is a representation of the entities, or objects, of the database including the tables, views, and stored programs.
Antworten
-
EER
Frage 17
Frage
The processing that’s done by the DBMS is
typically referred to as
Antworten
-
Front-end processing
-
Back-end processing
-
The file server
-
The user interface
Frage 18
Antworten
-
Item_id
-
(order_id , product_id)
-
order_id
-
All above
Frage 19
Frage
Foreign Key should be unique
Antworten
- True
- False
Frage 20
Frage
The most common type of relationship
between two tables is a/an .
Antworten
-
one-to-one
-
one-to-many
-
many-to-many
-
all above
Frage 21
Frage
Which of the following types of SQL
statements is NOT a DML statement?
Antworten
-
INSERT
-
UPDATE
-
SELECT
-
CREATE TABLE
Frage 22
Frage
Which join type does this graph illustrate?
Antworten
-
Left Join
-
Left Inner Join
-
Right Join
-
Right Inner Join
Frage 23
Frage
A person’s name needs to be saved as first
name, last name, middle name separately
in database.
Antworten
- True
- False
Frage 24
Frage
Which of the following diagrams best represents the relationship between a table of customers and a table of orders placed by customers?
Antworten
Frage 25
Antworten
Frage 26
Frage
Foreign key is used to maintain _____.
Antworten
-
Referential integrity
-
Uniqueness of record
-
Null values in the field
-
None of the above
Frage 27
Frage
A [blank_start]subquery[blank_end] is a SELECT statement that's coded within another SQL statement,
Antworten
-
subquery
Frage 28
Frage
Subqueries can be [blank_start]nested[blank_end] within other subqueries.
Antworten
-
nested
Frage 29
Frage
[blank_start]Null[blank_end] value indicates that the value of the column is unknown.
Antworten
-
Null
Frage 30
Frage
A [blank_start]default[blank_end] value is a value that is used if another value isn't provided when a row is added to the table.
Antworten
-
default
Frage 31
Frage
A [blank_start]foreign key[blank_end] 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.
Antworten
-
foreign key
Frage 32
Frage
In creating referential integrity, it makes sure that any changes to the data in the database don't create invalid relationships between tables.
Antworten
- True
- False
Frage 33
Frage
A [blank_start]CASCADE[blank_end] clause using ON DELETE would cause a deleted row from the Vendors table to delete all related rows in the Invoices table.
Antworten
-
CASCADE
Frage 34
Frage
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 [blank_start]GROUP BY[blank_end] clause.
Antworten
-
GROUP BY
Frage 35
Frage
Which of the following cannot be used in an aggregate function?
Antworten
-
MAX
-
MIN
-
AVG
-
COUNT
-
SUM
-
NONE OF THE ABOVE
Frage 36
Frage
By using a relational database type you CANNOT reduce data redundancy.
Antworten
- True
- False
Frage 37
Frage
A row contains a set of values for a single INSTANCE of the entity, such as one invoice or one vendor.
Antworten
- True
- False
Frage 38
Frage
A column does NOT represent an attribute of the entity.
Antworten
- True
- False
Frage 39
Frage
In designing a data structure, each table represents on object, or [blank_start]entity[blank_end], in the real world system.
Antworten
-
entity
Frage 40
Frage
What is not an option for the CHECK TABLE statement?
Antworten
-
extended
-
slow
-
fast
-
medium
-
quick
-
changed
-
for upgrade
Frage 41
Frage
Like a join, a [blank_start]union[blank_end] 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.
Antworten
-
union
Frage 42
Frage
An intersection of a row is sometimes called a cell.
Antworten
- True
- False
Frage 43
Frage
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.
Antworten
- True
- False
Frage 44
Frage
To group data and use aggregate functions to summarize the data in each group you use two new clauses of the SELECT STATEMENT: [blank_start]GROUP[blank_end] BY and [blank_start]HAVING[blank_end].
Antworten
-
GROUP
-
HAVING
Frage 45
Frage
Which are logical operators?
Antworten
-
And
-
HAVING
-
OR
-
NOT
Frage 46
Frage
A TRIGGER executes when which statements are run against a specific table.
Antworten
-
INSERT
-
SELECT
-
DELETE
-
UPDATE
Möchten Sie mit GoConqr kostenlos Ihre eigenen Quiz erstellen? eigenen Mehr erfahren.