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