Quiz
CIT 111
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 (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
Information
- Description
- Information Technology Quiz on CIT 111, created by David Aguilar on 13/12/2019.
- Author
- David Aguilar
- Language
- English
- Views
- 0
- Tags
- Rating
- No ratings yet Rate this quiz