Quiz
CIT 111
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 (16)
1The locationKey attribute in the Location table is an auto-incrementing number that the database guarantees is unique for each GPS reading. This means that within the Location table, the locationKey is what? (Check all that apply.)
- Aprimary key
- Bsurrogate key
- Cforeign key
- Dnatural key
2Numbers that don't include a decimal point are known as _____________________.
- Afixed point
- Bintegers
- Cfloating
3All of the following values can be stored in a column that’s defined as DECIMAL(6,2), except
- A-246.29
- B2479.95
- C0
- D32492.05
4Which uses the least amount of storage?
- Aexample' stored in a column of type VARCHAR2(20)
- B'exam' stored in a column of type VARCHAR2(20)
- C'ex' stored in a column of type VARCHAR2(20)
- Dthey all use the same amount of storage
5If I want to delete a ward row in the ward table, but the related table members has members from that ward; (In other words, the primary key of that ward is used as a foreign key of the members table) What has to happen first before I can delete that ward?
- AAny member of that ward must be deleted first
- BThe members table must be deleted
- CThe foreign key column must be removed from the members table
- DNew members must be added to that ward
6What does the DROP command do in this code?
DROP TABLE movie;- ADelete the data in the movie table leaving it an empty table
- BDeletes not only the data in the movie table, but the table definition as well--the entire table
- CDrops the rows in the movie table according to certain criteria.
- DDrops the last row of the current table
7Typically, most database designers consider a database structure normalized if it’s in the ________________________ normal form.
- A1st
- B2nd
- C3rd
- D4th
- EBoyce codd
8What is the SQL keyword that adds rows to a table?
- AADD
- BINSERT
- CDELETE
- DUPDATE
9When you code a DELETE statement for one or more rows, the _________________ clause specifies which row or rows are to be deleted.
- AWHERE
- BHAVING
- CON
- DALTER
10If you code a column list in an INSERT statement that includes a column that’s defined with a default value, you can insert the default value for that column by coding the ____________________ keyword in the VALUES clause of the INSERT statement.
- ANULL
- BDEFAULT
- CAI
- DAUTO
11When you code a column list in an INSERT statement, you can omit columns with default values and columns that allow ____________________________ values.
- ANULL
- BIN T
- CSTRING
- Dmultiple
12What would result from the following statement:
SELECT RIGHT('Williams', 4)
FROM dual;- Awill
- Biams
- Cliam
- Dwilli
13The ___________ function returns the string with any leading spaces removed.
- ACONCAT
- BLTRIM
- CRTRIM
- DLREMOVE
14You use the ______________ function to add a specified number of date parts to a date.
- ADATE_DIFF
- BDATE_FORMAT
- CDATE_PART
- DDATE_ADD
15_______ joins will only return rows that have matching values in both tables.
- AINNER
- BFULL OUTER
- CRIGHT OUTER
- DLEFT OUTER
16If you assign an alias to one table in a join, you have to
- Ause that alias to refer to the table throughout your query
- Bassign them to all the tables
- Cqualify every column name in the query
- Dqualify all of the column names for that table
Informações
- Descrição
- Information Technology Quiz sobre CIT 111, criado por David Aguilar em 13-12-2019.
- Autor
- David Aguilar
- Idioma
- English
- Visualizações
- 0
- Etiquetas
- Avaliação
- Ainda sem avaliações Avalie este quiz