Quiz
Database Design 1
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (25)
1Which SQL keyword is used to specify conditional search?
- AHAVING
- BWHERE
- CSELECT
- DFIND
2The AVG SQL function returns the ...
- AThe sum of values in a column
- BAverage in the values in a group.
- CMaximum value from a column.
3What 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
4What 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
5Which SQL keyword is used to retrieve a maximum value?
- AUPPER
- BMOST
- CTOP
- DMAX
6What 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
7Which SQL functions is used to count the number of rows?
- ACOUNT ( )
- BNUMBER ( )
- CSUM ( )
- DCOUNTOF ( )
8What 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
9Which SQL statement is used to extract data from a database?
- ASELECT
- BOPEN
- CGET
- DEXTRACT
10Which SQL statement is used to return only different (unique) values?
- ASELECT DIFFERENT
- BSELECT UNIQUE
- CSELECT DISTINCT
- DSELECT *
11Which SQL keyword is used to sort the result set?
- AORDER BY
- BFILTER
- CSORT BY
- DSORT
12If 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
13What keyword would you use to group your results by a column's values?
- AORDER BY
- BGROUP BY
- CBY
- DJOIN
14What keyword can you use to search for a string in a column?
- AFIND STRING
- BHAS STRING
- CCONTAINS STRING
- DLIKE
15Which 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
16A subquery in an SQL SELECT statement is enclosed in …
- Aparenthesis -- (...).
- Bbrackets -- [...].
- CCAPITAL LETTERS.
- Dbraces -- {...}.
17The result of an SQL SELECT statement is a(n) ________ .
- Areport
- Bform
- Cfile
- Dtable
18In 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
19The 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
20LIKE operator uses ___ and ___ .
- Aasterisk (*) ; percent sign (%)
- Bquestion mark (?) ; asterisk (*)
- Cpercent sign (%) ; underscore ( _ )
- Dunderscore ( _ ) ; question mark (?)
21What 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
22What operator tests column for the absence of data?
- ANOT operator
- BIS NULL operator
- CEXISTS operator
- DAll of the above
23What 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
24A functional dependency is a relationship between or among:
- ATables
- BRelations
- CRows
- DAttributes
25In an ER diagram an entity is represented by a …
- ARectangle
- BEllipse
- CCircle
- DDiamond box
Information
- Description
- 75 questions from Kozina's file + 42 questions from known Midterm or Endterm tests screenshots
- Author
- Bekinston Talgio
- Language
- English
- Views
- 0
- Tags
- Rating
- No ratings yet Rate this quiz