Quiz
Database Design 1
Crie uma conta grátis para terminar este quiz
Salve seu progresso e veja sua nota final.
Já tem uma conta? Inicie sessão
Perguntas do 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
Informações
- Descrição
- 75 questions from Kozina's file + 42 questions from known Midterm or Endterm tests screenshots
- Autor
- Bekinston Talgio
- Idioma
- English
- Visualizações
- 0
- Etiquetas
- Avaliação
- Ainda sem avaliações Avalie este quiz