CIS 3050 BANK 3 EXAM QUESTIONS AND ANSWERS
100% CORRECT
A requirement to begin designing physical files and databases is:
A) normalized relations.
B) physical tables created.
C) implementation complete.
D) all datatypes determined. - answer A
A key decision in the physical design process is:
A) ignoring the size of the database.
B) selecting structures.
C) deciding on the monitor.
D) deciding the e-r diagrams. - answer B
Designing physical files requires ________ of where and when data are used in various
ways.
A) maps
B) descriptions
C) keys
D) hints - answer B
Database access frequencies are estimated from:
A) transaction volumes.
B) user logins.
C) security violations.
D) random number generation. - answer A
A detailed coding scheme recognized by system software for representing
organizational data is called a(n):
,A) DBMS code.
B) data type.
C) SQL.
D) DB layout. - answer B
All of the following are objectives when selecting a data type EXCEPT:
A) represent all possible values.
B) improve data integrity.
C) support all data manipulations.
D) use a lot of storage space. - answer D
All of the following are valid datatypes in Oracle 12c EXCEPT:
A) VARCHAR2.
B) BOOLEAN.
C) BLOB.
D) NUMBER. - answer B
The smallest unit of application data recognized by system software is a:
A) field.
B) row.
C) data type.
D) column. - answer A
An appropriate datatype for one wanting a fixed-length type for last name would include:
A) VARCHAR.
B) CHAR.
C) BLOB.
D) DATE. - answer B
An appropriate datatype for adding a sound clip would be:
A) VARCHAR.
, B) CHAR.
C) BLOB.
D) DATE - answer C
Which of the following is an objective of selecting a data type?
A) Represent a small number of possible values
B) Maximize storage space
C) Limit security
D) Improve data integrity - answer D
In which data model would a code table appear?
A) Conceptual
B) Logical
C) Physical
D) Data layout - answer C
An integrity control supported by a DBMS is:
A) substitute estimates.
B) security.
C) range control.
D) GUI guards. - answer C
The value a field will assume unless the user enters an explicit value for an instance of
that field is called a:
A) default value.
B) null value.
C) range control.
100% CORRECT
A requirement to begin designing physical files and databases is:
A) normalized relations.
B) physical tables created.
C) implementation complete.
D) all datatypes determined. - answer A
A key decision in the physical design process is:
A) ignoring the size of the database.
B) selecting structures.
C) deciding on the monitor.
D) deciding the e-r diagrams. - answer B
Designing physical files requires ________ of where and when data are used in various
ways.
A) maps
B) descriptions
C) keys
D) hints - answer B
Database access frequencies are estimated from:
A) transaction volumes.
B) user logins.
C) security violations.
D) random number generation. - answer A
A detailed coding scheme recognized by system software for representing
organizational data is called a(n):
,A) DBMS code.
B) data type.
C) SQL.
D) DB layout. - answer B
All of the following are objectives when selecting a data type EXCEPT:
A) represent all possible values.
B) improve data integrity.
C) support all data manipulations.
D) use a lot of storage space. - answer D
All of the following are valid datatypes in Oracle 12c EXCEPT:
A) VARCHAR2.
B) BOOLEAN.
C) BLOB.
D) NUMBER. - answer B
The smallest unit of application data recognized by system software is a:
A) field.
B) row.
C) data type.
D) column. - answer A
An appropriate datatype for one wanting a fixed-length type for last name would include:
A) VARCHAR.
B) CHAR.
C) BLOB.
D) DATE. - answer B
An appropriate datatype for adding a sound clip would be:
A) VARCHAR.
, B) CHAR.
C) BLOB.
D) DATE - answer C
Which of the following is an objective of selecting a data type?
A) Represent a small number of possible values
B) Maximize storage space
C) Limit security
D) Improve data integrity - answer D
In which data model would a code table appear?
A) Conceptual
B) Logical
C) Physical
D) Data layout - answer C
An integrity control supported by a DBMS is:
A) substitute estimates.
B) security.
C) range control.
D) GUI guards. - answer C
The value a field will assume unless the user enters an explicit value for an instance of
that field is called a:
A) default value.
B) null value.
C) range control.
