Quiz
Database Design [State Exam | 75 questions]
Questions in this quiz (75)
1The SQL BETWEEN operator …
- ASpecifies a range to test
- BNone of the given
- CSpecifies that a column is a primary key
- DSpecifies which tables we are selecting from
2SQL aggregate functions are …
- AMIN, MAX, AVG, COUNT, SUM
- BSUM, AVG, MULT, DIV, MIN
- CSUM, AVG, MIN, MAX, MULT
- DSUM, AVG, MIN, MAX, NAME
3Which SQL keyword is used to specify conditional search?
- AHAVING
- BWHERE
- CSELECT
- DFIND
4The AVG SQL function returns the ...
- AThe sum of values in a column
- BAverage in the values in a group.
- CMaximum value from a column.
5What does follow after the SQL WHERE clause?
- ASelection condition
- BList of columns that will be selected or the * symbol
- CNone of the given
- DName of the table we are selecting from
6What does the SQL FROM clause do?
- ASpecifies the tables to retrieve rows from.
- BSpecifies a search condition
- CNone of the given
- DSpecifies the columns we are retrieving
7Which SQL keyword is used to retrieve a maximum value?
- AUPPER
- BMOST
- CTOP
- DMAX
8What does follow after the SQL SELECT clause?
- AList of columns to be selected or the * symbol
- BName of the table we are selecting from
- CNone of the given
- DSelection condition
9Which SQL functions is used to count the number of rows?
- ACOUNT ( )
- BNUMBER ( )
- CSUM ( )
- DCOUNTOF ( )
10What is the purpose of the SQL AS clause?
- AThe AS SQL clause is used change the name of a column in the result set or to assign a name to a derived column
- BThe AS clause is used with the JOIN clause only
- CThe AS clause defines a search condition
- DAll of the mentioned
11Which SQL statement is used to extract data from a database?
- ASELECT
- BOPEN
- CGET
- DEXTRACT
12Which SQL statement is used to return only different (unique) values?
- ASELECT DIFFERENT
- BSELECT UNIQUE
- CSELECT DISTINCT
- DSELECT *
13Which SQL keyword is used to sort the result set?
- AORDER BY
- BFILTER
- CSORT BY
- DSORT
14If you want to apply a second condition to your statement where both statements must be true, what keyword would you use between the conditions?
- AAND
- BBOTH
- CTRUE
- DWHERE
15What keyword would you use to group your results by a column's values?
- AORDER BY
- BGROUP BY
- CBY
- DJOIN
16What keyword can you use to search for a string in a column?
- AFIND STRING
- BHAS STRING
- CCONTAINS STRING
- DLIKE
17Which of the following is the correct order of keywords for SQL SELECT statements?
- ASELECT, FROM, WHERE
- BFROM, WHERE, SELECT
- CWHERE, FROM, SELECT
- DSELECT, WHERE, FROM
18A subquery in an SQL SELECT statement is enclosed in …
- Aparenthesis -- (...).
- Bbrackets -- [...].
- CCAPITAL LETTERS.
- Dbraces -- {...}.
19The result of an SQL SELECT statement is a(n) ________ .
- Areport
- Bform
- Cfile
- Dtable
20In an SQL SELECT statement querying a single table, the asterisk (*) means that …
- Aall columns of the table are to be returned
- Ball records meeting the full criteria are to be returned
- Call records with even partial criteria met are to be returned
- DNone of the above is correct
21The HAVING clause does which of the following?
- AActs EXACTLY like a WHERE clause
- BActs like a WHERE clause but is used for columns rather than groups
- CActs like a WHERE clause but is used for groups rather than rows
- DActs like a WHERE clause but is used for rows rather than columns
22LIKE operator uses ___ and ___ .
- Aasterisk (*) ; percent sign (%)
- Bquestion mark (?) ; asterisk (*)
- Cpercent sign (%) ; underscore ( _ )
- Dunderscore ( _ ) ; question mark (?)
23What SQL structure is used to limit column values of a table?
- AThe LIMIT constraint
- BThe CHECK constraint
- CThe VALUE constraint
- DNone of the above is correct
24What operator tests column for the absence of data?
- ANOT operator
- BIS NULL operator
- CEXISTS operator
- DAll of the above
25What is the meaning of LIKE '%0%0%' ?
- AFeature has two 0's in it, at any position
- BFeature begins with two 0's
- CFeature has more than two 0's
- DFeature ends with two 0's
26The _______ operator returns all tuples in one relation that are not found in the other relation.
- ASelect
- BNone
- CIntersect
- DDifference
27What is meant by the following relational algebra statement: STUDENT X GROUP ?
- ACompute the left outer join between the STUDENT and GROUP relations
- BCompute the full outer join between the STUDENT and GROUP relations
- CCompute the cartesian product between the STUDENT and GROUP relations
- DCompute the right outer join between the STUDENT and GROUP relations
28What is meant by the term union compatibility?
- ANone
- BWhen two or more tables share the same (or compatible) domains
- CWhen two or more tables share the same number of columns and when they share the same domains
- DWhen two or more tables share the same number of columns
29Which of the following is used to denote the selection operation in relational algebra?
- APi (Greek)
- BSigma (Greek)
- CLambda (Greek)
- DOmega (Greek)
30Which product is returned in a join query have no join condition?
- ANone
- BEquijoins
- CBoth
- DCartesian
31The ____________ operator combines all tuples from two relations excluding duplicates.
- AIntersect
- BDifference
- CUnion
- DDivide
32Which of the following is used to denote the projection operation in relational algebra?
- APi (Greek)
- BSigma (Greek)
- CLambda (Greek)
- DOmega (Greek)
33_______ specifies a search condition for a group or an aggregate function.
- AGROUP BY clause
- BHAVING clause
- CFROM clause
- DWHERE clause
34The command to remove rows from CUSTOMER table is …
- ADROP FROM CUSTOMER ...
- BUPDATE FROM CUSTOMER ...
- CREMOVE FROM CUSTOMER ...
- DDELETE FROM CUSTOMER WHERE ...
35DML is used to …
- Amanipulate the structure of database applications
- Badd and delete tables
- Cadd / modify / delete data in the database
- Dspecify the structure of a database
36Identify the characteristic(s) of transactions
- AAtomicity
- BDurability
- CIsolation
- DAll of the mentioned
37The ______ statement is used to end a successful transaction.
- ACOMMIT TRANSACTION
- BROLLBACK TRANSACTION
- CCOMMIT WORK
- DAll of the mentioned
38DCL stands for …
- AData Control Language
- BData Console Language
- CData Console Level
- DData Control Level
39Types of update anomalies are … (NF)
- Aц
- Bу
40Types of functional dependencies are …(NF)
- Aw
- B2
41TCL stands for …
- ATransaction control language
- BTransaction command language
- CTransaction connect language
- DNone of the given
42UNIQUE constraint allows to create .. (NF)
- A4
- B5
43Types of JOIN statement are ... (NF)
- AINNER JOIN
- BOUTER JOIN (LEFT, RIGHT, FULL JOIN)
- CCROSS JOIN
- DAll of the mentioned
44The statement to create a new user is …
- Aw
- B2
45The column of a table is referred to as the …
- AEntity
- BDegree
- CTuple
- DAttribute
46The another name for a row is …
- AAttribute
- BTuple
- CDegree
- DEntity
47A primary key for an entity is
- AA relationship
- BA tuple
- CA unique attribute
- DAny attribute
48In ER Diagram by Chen’s notation a relationship type is represented by …
- ADiamond (rhombus)
- BRectangle
- CEllipse
- DDashed ellipse
49Key to represent relationship between tables is called :
- APrimary Key
- BForeign Key
- CSecondary Key
- DNone of these
50An entity relationship diagram is a tool to represent … (NF)
- A?
- B3
51The 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.
- ANo, removed from
- BAt least one, removed from
- CAt least one, added to
- DNo, added to
52Through normalization, data redundancy …
- Acan be eliminated
- Bcan be maximized
- Ccan be minimized, but not eliminated
- Dare usually left unchanged
53Through normalization, update anomalies …
- ACan be eliminated
- BCan be maximized
- CAre usually unchanged
- DCan be minimized, but not eliminated
54For a relation to be in 3NF, it should not contain _____ attribute that is transitively dependent on _____.
- Aa primary key, a foreign key
- Ba non-primary key, a foreign key
- Ca non-primary key, the primary key
- Da primary key, a non-primary key
55For a relation to be in 2NF, _____ attribute must be fully functionally dependent on _____.
- Aevery non-primary key, the primary key
- Bevery alternate key, the primary key
- Cevery non-key, every key
- Devery non-key, at least one key
56Which normal form is considered “good” for relational database design?
- A3NF
- B2NF
- C1NF
- D4NF
57A relation in which the intersection of each row and column contains one and only one value is said to be in
- A3NF
- B2NF
- C1NF
- D4NF
58Table is synonymous with the term …
- ARecord
- BColumn
- CField
- DRelation
59If a relation scheme is in 3NF then it is also in …
- A2NF
- B4NF
- C5NF
- DNone of these
60A functional dependency is a relationship between or among:
- ATables
- BRelations
- CRows
- DAttributes
61In an ER diagram an entity is represented by a …
- ARectangle
- BEllipse
- CCircle
- DDiamond box
62In an ER diagram by Chen’s notation attributes are represented by …
- ARectangle
- BSquare
- CEllipse
- DTriangle
63Who proposed the relational model?
- ABill Gates
- BCharles Babbage
- CE. F. Codd
- DHerman Hollerith
64Phases of a database development are …
- ALogical Design
- BConceptual Design
- CPhysical Design
- DAll of these
65A goal of normalization is …
- AMinimize the number of relationships
- BMinimize the number of tables
- CMinimize the number of entities
- DMinimize the number of redundancy
- ENone of these
66A table in 1NF in which the unique candidate key consists of two of its three attributes:
- AAlways violates 2NF
- BNever violates 2NF
- CMay violate 2NF
- DNone of the above
67Database is a collection of … (NF)
- Aw
- B2
68DBMS stands for …
- ANone of these
- BDatabase Administrator System
- CDatabase Basic Management System
- DDatabase Management System
69Normalization is ...
- Athe process of adding primary key to a table
- Bthe process of arranging information stored in a database in a way, which redundancy and ambiguity
- Ca special way of selecting data
- Dnone of these
70What does SQL stand for?
- AStandard Query Language
- BStructured Query Language
- CStrict Query Language
- DStrong Query Language
71Which language is used to specify database structure?
- AData Manipulation Language
- BData Management Language
- CData Definition Language
- DData Development Language
72The statement in SQL which allows to change the structure of a table is …
- ASELECT
- BALTER
- CCREATE
- DUPDATE
73The SQL DROP TABLE clause is used to ...
- Acreate a new table in the database
- Bmodify an existing table in a database
- Cdelete a table from the database
- Dnone of these
74Determine the primary key by description of the table: Students (stud_id, lname, fname, bdate)
- Astud_id
- Blname
- Cfname
- Dbdate
75Determine 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)
- AOne-to-One
- BOne-to-Many
- CMany-to-Many
- DNone of these
Information
- Description
- State Database Design [Teachers: Kozina Lyudmila, Alshynov Chyngiz | FINAL EXAM + STATE EXAM ] ▼ (State Exam) Quiz on Database Design [State Exam | 75 questions], created by Good Guy Beket on 25/02/2019.
- Author
- Good Guy Beket
- Language
- English
- Views
- 526
- Tags
- Rating
- 5.0 out of 5 · 1 rating Rate this quiz