3783155
Descrição
Quiz por Kait Schroeder, atualizado more than 1 year ago
|
Criado por Kait Schroeder
quase 9 anos atrás
|
|
Questão 1
Questão
A [blank_start]simple client server[blank_end] system is a system with a Network, Database server, and clients.
Responda
-
simple client server
Questão 2
Questão
DBMS stands for [blank_start]database management system[blank_end].
Responda
-
database management system
Questão 3
Questão
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].
Responda
-
back end processing
-
back end
Questão 4
Questão
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.
Responda
-
application software
Questão 5
Questão
API stands for [blank_start]application programming interface[blank_end].
Responda
-
application programming interface
Questão 6
Questão
The [blank_start]data access API[blank_end] provides the interface between the application program and the DBMS.
Responda
-
data access API
Questão 7
Questão
SQL stands for [blank_start]structured query language[blank_end].
Responda
-
structured query language
Questão 8
Questão
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.
Responda
-
client
-
database server
Questão 9
Questão
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.
Responda
-
web browser
-
database
Questão 10
Questão
Schema is another word for [blank_start]database[blank_end].
Responda
-
database
Questão 11
Questão
Which error message will be produced from not selecting a database before executing a SQL statement?
Responda
-
Error code: 1146. Table 'ex.vendors' doesn't exist
-
Error code: 1046. No database selected
Questão 12
Questão
Which error code will generate if you haven't selected the correct database before executing a SQL statement?
Responda
-
Error code: 1146. Table 'ex.vendors' doesn't exist
-
Error code: 1046. No database selected
Questão 13
Questão
EER model stands for [blank_start]enhanced entity relationship[blank_end] model.
Responda
-
enhanced entity relationship
Questão 14
Questão
ER model stands for [blank_start]entity relationship[blank_end] model.
Responda
-
entity relationship
Questão 15
Questão
T or F, an EER diagram can be created before an EER or ER model has been created.
Responda
- True
- False
Questão 16
Questão
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.
Responda
-
EER
Questão 17
Questão
The processing that’s done by the DBMS is
typically referred to as
Responda
-
Front-end processing
-
Back-end processing
-
The file server
-
The user interface
Questão 18
Questão
Which column can NOT be primary key?
Responda
-
Item_id
-
(order_id , product_id)
-
order_id
-
All above
Questão 19
Questão
Foreign Key should be unique
Responda
- True
- False
Questão 20
Questão
The most common type of relationship
between two tables is a/an .
Responda
-
one-to-one
-
one-to-many
-
many-to-many
-
all above
Questão 21
Questão
Which of the following types of SQL
statements is NOT a DML statement?
Responda
-
INSERT
-
UPDATE
-
SELECT
-
CREATE TABLE
Questão 22
Questão
Which join type does this graph illustrate?
Responda
-
Left Join
-
Left Inner Join
-
Right Join
-
Right Inner Join
Questão 23
Questão
A person’s name needs to be saved as first
name, last name, middle name separately
in database.
Responda
- True
- False
Questão 24
Questão
Which of the following diagrams best represents the relationship between a table of customers and a table of orders placed by customers?
Responda
Questão 25
Responda
Questão 26
Questão
Foreign key is used to maintain _____.
Responda
-
Referential integrity
-
Uniqueness of record
-
Null values in the field
-
None of the above
Questão 27
Questão
A [blank_start]subquery[blank_end] is a SELECT statement that's coded within another SQL statement,
Responda
-
subquery
Questão 28
Questão
Subqueries can be [blank_start]nested[blank_end] within other subqueries.
Responda
-
nested
Questão 29
Questão
[blank_start]Null[blank_end] value indicates that the value of the column is unknown.
Responda
-
Null
Questão 30
Questão
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.
Responda
-
default
Questão 31
Questão
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.
Responda
-
foreign key
Questão 32
Questão
In creating referential integrity, it makes sure that any changes to the data in the database don't create invalid relationships between tables.
Responda
- True
- False
Questão 33
Questão
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.
Responda
-
CASCADE
Questão 34
Questão
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.
Responda
-
GROUP BY
Questão 35
Questão
Which of the following cannot be used in an aggregate function?
Responda
-
MAX
-
MIN
-
AVG
-
COUNT
-
SUM
-
NONE OF THE ABOVE
Questão 36
Questão
By using a relational database type you CANNOT reduce data redundancy.
Responda
- True
- False
Questão 37
Questão
A row contains a set of values for a single INSTANCE of the entity, such as one invoice or one vendor.
Responda
- True
- False
Questão 38
Questão
A column does NOT represent an attribute of the entity.
Responda
- True
- False
Questão 39
Questão
In designing a data structure, each table represents on object, or [blank_start]entity[blank_end], in the real world system.
Responda
-
entity
Questão 40
Questão
What is not an option for the CHECK TABLE statement?
Responda
-
extended
-
slow
-
fast
-
medium
-
quick
-
changed
-
for upgrade
Questão 41
Questão
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.
Responda
-
union
Questão 42
Questão
An intersection of a row is sometimes called a cell.
Responda
- True
- False
Questão 43
Questão
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.
Responda
- True
- False
Questão 44
Questão
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].
Responda
-
GROUP
-
HAVING
Questão 45
Questão
Which are logical operators?
Responda
-
And
-
HAVING
-
OR
-
NOT
Questão 46
Questão
A TRIGGER executes when which statements are run against a specific table.
Responda
-
INSERT
-
SELECT
-
DELETE
-
UPDATE
Quer criar seus próprios Quizzes gratuitos com a GoConqr? Saiba mais.