Physical Database Design - General Questions Online Exam Quiz
Physical Database Design - General Questions GK Quiz. Question and Answers related to Physical Database Design - General Questions. MCQ (Multiple Choice Questions with answers about Physical Database Design - General Questions
If a denormalization situation exists with a one-to-one binary relationship, which of the following is true?
Options
A : All fields are stored in one relation.
B : All fields are stored in two relations.
C : All fields are stored in three relations.
D : All fields are stored in four relations.
Selecting a data type involves which of the following?
Options
A : Maximize storage space
B : Represent most values
C : Improve data integrity
D : All of the above.
What is the best data type definition for Oracle when a field is alphanumeric and has a length that can vary?
Options
A : VARCHAR2
B : CHAR
C : LONG
D : NUMBER
If a denormalization situation exists with a many-to-many or associative binary relationship, which of the following is true?
Options
A : All fields are stored in one relation.
B : All fields are stored in two relations.
C : All fields are stored in three relations.
D : All fields are stored in four relations.
Which of the following is an advantage of partitioning?
Options
A : Complexity
B : Inconsistent access speed
C : Extra space
D : Security
The blocking factor is:
Options
A : a group of fields stored in adjacent memory.
B : the number of physical records per page.
C : attributes grouped together by the same primary key.
D : attributes grouped together by the same secondary key.
Which of the following improves a query's processing time?
Options
A : Write complex queries.
B : Combine a table with itself.
C : Query one query within another.
D : Use compatible data types.
Which of the following are integrity controls that a DBMS may support?
Options
A : Assume a default value in a field unless a user enters a value for that field.
B : Limit the set of permissible values that a field may assume.
C : Limit the use of null values in some fields.
D : All of the above.
Which of the following is not a factor to consider when switching from small to large block size?
Options
A : The length of all of the fields in a table row.
B : The number of columns
C : Block contention
D : Random row access speed
What is the best data type definition for Oracle when a field is alphanumeric and has a fixed length?
Options
A : VARCHAR2
B : CHAR
C : LONG
D : NUMBER
Advanced SQL - General Questions more Online Exam Quiz
Managing Multiuser Databases - General Questions
Modeling Data in the Organization - General Questions
Object-Oriented Database - General Questions
Object-Oriented Data Modeling - General Questions
ODBC, OLE DB, ADO, and ASP - General Questions
SQL for Database Construction - General Questions
The Client-Server Database - General Questions
The Database Development Process - General Questions