16999798
Descripción
Test por Good Guy Beket, actualizado hace más de 1 año
|
Creado por Good Guy Beket
hace más de 5 años
|
|
Pregunta 1
Pregunta
The SQL BETWEEN operator …
Respuesta
-
Specifies a range to test
-
None of the given
-
Specifies that a column is a primary key
-
Specifies which tables we are selecting from
Pregunta 2
Pregunta
SQL aggregate functions are …
Respuesta
-
MIN, MAX, AVG, COUNT, SUM
-
SUM, AVG, MULT, DIV, MIN
-
SUM, AVG, MIN, MAX, MULT
-
SUM, AVG, MIN, MAX, NAME
Pregunta 3
Pregunta
Which SQL keyword is used to specify conditional search?
Respuesta
-
HAVING
-
WHERE
-
SELECT
-
FIND
Pregunta 4
Pregunta
The AVG SQL function returns the ...
Respuesta
-
The sum of values in a column
-
Average in the values in a group.
-
Maximum value from a column.
Pregunta 5
Pregunta
What does follow after the SQL WHERE clause?
Respuesta
-
Selection condition
-
List of columns that will be selected or the * symbol
-
None of the given
-
Name of the table we are selecting from
Pregunta 6
Pregunta
What does the SQL FROM clause do?
Respuesta
-
Specifies the tables to retrieve rows from.
-
Specifies a search condition
-
None of the given
-
Specifies the columns we are retrieving
Pregunta 7
Pregunta
Which SQL keyword is used to retrieve a maximum value?
Respuesta
-
UPPER
-
MOST
-
TOP
-
MAX
Pregunta 8
Pregunta
What does follow after the SQL SELECT clause?
Respuesta
-
List of columns to be selected or the * symbol
-
Name of the table we are selecting from
-
None of the given
-
Selection condition
Pregunta 9
Pregunta
Which SQL functions is used to count the number of rows?
Respuesta
-
COUNT ( )
-
NUMBER ( )
-
SUM ( )
-
COUNTOF ( )
Pregunta 10
Pregunta
What is the purpose of the SQL AS clause?
Respuesta
-
The AS SQL clause is used change the name of a column in the result set or to assign a name to a derived column
-
The AS clause is used with the JOIN clause only
-
The AS clause defines a search condition
-
All of the mentioned
Pregunta 11
Pregunta
Which SQL statement is used to extract data from a database?
Respuesta
-
SELECT
-
OPEN
-
GET
-
EXTRACT
Pregunta 12
Pregunta
Which SQL statement is used to return only different (unique) values?
Respuesta
-
SELECT DIFFERENT
-
SELECT UNIQUE
-
SELECT DISTINCT
-
SELECT *
Pregunta 13
Pregunta
Which SQL keyword is used to sort the result set?
Respuesta
-
ORDER BY
-
FILTER
-
SORT BY
-
SORT
Pregunta 14
Pregunta
If you want to apply a second condition to your statement where both statements must be true, what keyword would you use between the conditions?
Respuesta
-
AND
-
BOTH
-
TRUE
-
WHERE
Pregunta 15
Pregunta
What keyword would you use to group your results by a column's values?
Respuesta
-
ORDER BY
-
GROUP BY
-
BY
-
JOIN
Pregunta 16
Pregunta
What keyword can you use to search for a string in a column?
Respuesta
-
FIND STRING
-
HAS STRING
-
CONTAINS STRING
-
LIKE
Pregunta 17
Pregunta
Which of the following is the correct order of keywords for SQL SELECT statements?
Respuesta
-
SELECT, FROM, WHERE
-
FROM, WHERE, SELECT
-
WHERE, FROM, SELECT
-
SELECT, WHERE, FROM
Pregunta 18
Pregunta
A subquery in an SQL SELECT statement is enclosed in …
Respuesta
-
parenthesis -- (...).
-
brackets -- [...].
-
CAPITAL LETTERS.
-
braces -- {...}.
Pregunta 19
Pregunta
The result of an SQL SELECT statement is a(n) ________ .
Respuesta
-
report
-
form
-
file
-
table
Pregunta 20
Pregunta
In an SQL SELECT statement querying a single table, the asterisk (*) means that …
Respuesta
-
all columns of the table are to be returned
-
all records meeting the full criteria are to be returned
-
all records with even partial criteria met are to be returned
-
None of the above is correct
Pregunta 21
Pregunta
The HAVING clause does which of the following?
Respuesta
-
Acts EXACTLY like a WHERE clause
-
Acts like a WHERE clause but is used for columns rather than groups
-
Acts like a WHERE clause but is used for groups rather than rows
-
Acts like a WHERE clause but is used for rows rather than columns
Pregunta 22
Pregunta
LIKE operator uses ___ and ___ .
Respuesta
-
asterisk (*) ; percent sign (%)
-
question mark (?) ; asterisk (*)
-
percent sign (%) ; underscore ( _ )
-
underscore ( _ ) ; question mark (?)
Pregunta 23
Pregunta
What SQL structure is used to limit column values of a table?
Respuesta
-
The LIMIT constraint
-
The CHECK constraint
-
The VALUE constraint
-
None of the above is correct
Pregunta 24
Pregunta
What operator tests column for the absence of data?
Respuesta
-
NOT operator
-
IS NULL operator
-
EXISTS operator
-
All of the above
Pregunta 25
Pregunta
What is the meaning of LIKE '%0%0%' ?
Respuesta
-
Feature has two 0's in it, at any position
-
Feature begins with two 0's
-
Feature has more than two 0's
-
Feature ends with two 0's
Pregunta 26
Pregunta
The _______ operator returns all tuples in one relation that are not found in the other relation.
Respuesta
-
Select
-
None
-
Intersect
-
Difference
Pregunta 27
Pregunta
What is meant by the following relational algebra statement: STUDENT X GROUP ?
Respuesta
-
Compute the left outer join between the STUDENT and GROUP relations
-
Compute the full outer join between the STUDENT and GROUP relations
-
Compute the cartesian product between the STUDENT and GROUP relations
-
Compute the right outer join between the STUDENT and GROUP relations
Pregunta 28
Pregunta
What is meant by the term union compatibility?
Respuesta
-
None
-
When two or more tables share the same (or compatible) domains
-
When two or more tables share the same number of columns and when they share the same domains
-
When two or more tables share the same number of columns
Pregunta 29
Pregunta
Which of the following is used to denote the selection operation in relational algebra?
Respuesta
-
Pi (Greek)
-
Sigma (Greek)
-
Lambda (Greek)
-
Omega (Greek)
Pregunta 30
Pregunta
Which product is returned in a join query have no join condition?
Respuesta
-
None
-
Equijoins
-
Both
-
Cartesian
Pregunta 31
Pregunta
The ____________ operator combines all tuples from two relations excluding duplicates.
Respuesta
-
Intersect
-
Difference
-
Union
-
Divide
Pregunta 32
Pregunta
Which of the following is used to denote the projection operation in relational algebra?
Respuesta
-
Pi (Greek)
-
Sigma (Greek)
-
Lambda (Greek)
-
Omega (Greek)
Pregunta 33
Pregunta
_______ specifies a search condition for a group or an aggregate function.
Respuesta
-
GROUP BY clause
-
HAVING clause
-
FROM clause
-
WHERE clause
Pregunta 34
Pregunta
The command to remove rows from CUSTOMER table is …
Respuesta
-
DROP FROM CUSTOMER ...
-
UPDATE FROM CUSTOMER ...
-
REMOVE FROM CUSTOMER ...
-
DELETE FROM CUSTOMER WHERE ...
Pregunta 35
Pregunta
DML is used to …
Respuesta
-
manipulate the structure of database applications
-
add and delete tables
-
add / modify / delete data in the database
-
specify the structure of a database
Pregunta 36
Pregunta
Identify the characteristic(s) of transactions
Respuesta
-
Atomicity
-
Durability
-
Isolation
-
All of the mentioned
Pregunta 37
Pregunta
The ______ statement is used to end a successful transaction.
Respuesta
-
COMMIT TRANSACTION
-
ROLLBACK TRANSACTION
-
COMMIT WORK
-
All of the mentioned
Pregunta 38
Pregunta
DCL stands for …
Respuesta
-
Data Control Language
-
Data Console Language
-
Data Console Level
-
Data Control Level
Pregunta 39
Pregunta
Types of update anomalies are … (NF)
Respuesta
-
ц
-
у
Pregunta 40
Pregunta
Types of functional dependencies are …(NF)
Respuesta
-
w
-
2
Pregunta 41
Pregunta
TCL stands for …
Respuesta
-
Transaction control language
-
Transaction command language
-
Transaction connect language
-
None of the given
Pregunta 42
Pregunta
UNIQUE constraint allows to create .. (NF)
Respuesta
-
4
-
5
Pregunta 43
Pregunta
Types of JOIN statement are ... (NF)
Respuesta
-
INNER JOIN
-
OUTER JOIN (LEFT, RIGHT, FULL JOIN)
-
CROSS JOIN
-
All of the mentioned
Pregunta 44
Pregunta
The statement to create a new user is …
Respuesta
-
w
-
2
Pregunta 45
Pregunta
The column of a table is referred to as the …
Respuesta
-
Entity
-
Degree
-
Tuple
-
Attribute
Pregunta 46
Pregunta
The another name for a row is …
Respuesta
-
Attribute
-
Tuple
-
Degree
-
Entity
Pregunta 47
Pregunta
A primary key for an entity is
Respuesta
-
A relationship
-
A tuple
-
A unique attribute
-
Any attribute
Pregunta 48
Pregunta
In ER Diagram by Chen’s notation a relationship type is represented by …
Respuesta
-
Diamond (rhombus)
-
Rectangle
-
Ellipse
-
Dashed ellipse
Pregunta 49
Pregunta
Key to represent relationship between tables is called :
Respuesta
-
Primary Key
-
Foreign Key
-
Secondary Key
-
None of these
Pregunta 50
Pregunta
An entity relationship diagram is a tool to represent … (NF)
Respuesta
-
?
-
3
Pregunta 51
Pregunta
The FD X -> Y is a full dependency in a relation R, if there is _____ attribute A that can be _____ X and the dependency still holds.
Respuesta
-
No, removed from
-
At least one, removed from
-
At least one, added to
-
No, added to
Pregunta 52
Pregunta
Through normalization, data redundancy …
Respuesta
-
can be eliminated
-
can be maximized
-
can be minimized, but not eliminated
-
are usually left unchanged
Pregunta 53
Pregunta
Through normalization, update anomalies …
Respuesta
-
Can be eliminated
-
Can be maximized
-
Are usually unchanged
-
Can be minimized, but not eliminated
Pregunta 54
Pregunta
For a relation to be in 3NF, it should not contain _____ attribute that is transitively dependent on _____.
Respuesta
-
a primary key, a foreign key
-
a non-primary key, a foreign key
-
a non-primary key, the primary key
-
a primary key, a non-primary key
Pregunta 55
Pregunta
For a relation to be in 2NF, _____ attribute must be fully functionally dependent on _____.
Respuesta
-
every non-primary key, the primary key
-
every alternate key, the primary key
-
every non-key, every key
-
every non-key, at least one key
Pregunta 56
Pregunta
Which normal form is considered “good” for relational database design?
Respuesta
-
3NF
-
2NF
-
1NF
-
4NF
Pregunta 57
Pregunta
A relation in which the intersection of each row and column contains one and only one value is said to be in
Respuesta
-
3NF
-
2NF
-
1NF
-
4NF
Pregunta 58
Pregunta
Table is synonymous with the term …
Respuesta
-
Record
-
Column
-
Field
-
Relation
Pregunta 59
Pregunta
If a relation scheme is in 3NF then it is also in …
Respuesta
-
2NF
-
4NF
-
5NF
-
None of these
Pregunta 60
Pregunta
A functional dependency is a relationship between or among:
Respuesta
-
Tables
-
Relations
-
Rows
-
Attributes
Pregunta 61
Pregunta
In an ER diagram an entity is represented by a …
Respuesta
-
Rectangle
-
Ellipse
-
Circle
-
Diamond box
Pregunta 62
Pregunta
In an ER diagram by Chen’s notation attributes are represented by …
Respuesta
-
Rectangle
-
Square
-
Ellipse
-
Triangle
Pregunta 63
Pregunta
Who proposed the relational model?
Respuesta
-
Bill Gates
-
Charles Babbage
-
E. F. Codd
-
Herman Hollerith
Pregunta 64
Pregunta
Phases of a database development are …
Respuesta
-
Logical Design
-
Conceptual Design
-
Physical Design
-
All of these
Pregunta 65
Pregunta
A goal of normalization is …
Respuesta
-
Minimize the number of relationships
-
Minimize the number of tables
-
Minimize the number of entities
-
Minimize the number of redundancy
-
None of these
Pregunta 66
Pregunta
A table in 1NF in which the unique candidate key consists of two of its three attributes:
Respuesta
-
Always violates 2NF
-
Never violates 2NF
-
May violate 2NF
-
None of the above
Pregunta 67
Pregunta
Database is a collection of … (NF)
Respuesta
-
w
-
2
Pregunta 68
Pregunta
DBMS stands for …
Respuesta
-
None of these
-
Database Administrator System
-
Database Basic Management System
-
Database Management System
Pregunta 69
Pregunta
Normalization is ...
Respuesta
-
the process of adding primary key to a table
-
the process of arranging information stored in a database in a way, which redundancy and ambiguity
-
a special way of selecting data
-
none of these
Pregunta 70
Pregunta
What does SQL stand for?
Respuesta
-
Standard Query Language
-
Structured Query Language
-
Strict Query Language
-
Strong Query Language
Pregunta 71
Pregunta
Which language is used to specify database structure?
Respuesta
-
Data Manipulation Language
-
Data Management Language
-
Data Definition Language
-
Data Development Language
Pregunta 72
Pregunta
The statement in SQL which allows to change the structure of a table is …
Respuesta
-
SELECT
-
ALTER
-
CREATE
-
UPDATE
Pregunta 73
Pregunta
The SQL DROP TABLE clause is used to ...
Respuesta
-
create a new table in the database
-
modify an existing table in a database
-
delete a table from the database
-
none of these
Pregunta 74
Pregunta
Determine the primary key by description of the table: Students (stud_id, lname, fname, bdate)
Respuesta
-
stud_id
-
lname
-
fname
-
bdate
Pregunta 75
Pregunta
Determine the type of the relationship between Students and Groups entities by its description: “One student can be enrolled only in one group, and from the other side one group contains many students” (NF)
Respuesta
-
One-to-One
-
One-to-Many
-
Many-to-Many
-
None of these
¿Quieres crear tus propios Tests gratis con GoConqr? Más información.