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