MCQGeeks
0 : 0 : 1
CBSE
JEE
NTSE
NEET
English
UK Quiz
Quiz
Driving Test
Practice
Games
Quiz
Database
Physical Database Design
Quiz 1
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Q.1
Two basic constructs to link one piece of data with another piece of data: sequential storage and pointers.
True
False
Q.2
Some advantages of partitioning include: efficiency, security, and load balancing.
True
False
Q.3
A pointer is a detailed coding scheme recognized by system software for representing organizational data.
True
False
Q.4
Denormalization and clustering can work well to minimize data access time for small records.
True
False
Q.5
Hashing algorithm converts a primary key value into a record address.
True
False
Q.6
Distributing the columns of a table into several separate physical records is known as horizontal partitioning.
True
False
Q.7
The primary goal of physical database design is data processing efficiency.
True
False
Q.8
A bitmap index is an index on columns from two or more tables that come from the same domain of values.
True
False
Q.9
A secondary key is which of the following?
Nonunique key
Primary key
Useful for denormalization decisions
Determines the tablespace required
Q.10
The fastest read/write time and most efficient data storage of any disk array type is:
RAID-0
RAID-1
RAID-2
RAID-3
Q.11
A rule of thumb for choosing indexes for a relational database includes which of the following?
Indexes are more useful on smaller tables.
Indexes are more useful for columns that do not appear frequently in the WHERE clause in queries.
Do not specify a unique index for the primary key of each table.
Be careful indexing attributes that have null values.
Q.12
Sequential retrieval on a primary key for sequential file storage has which of the following features?
Very fast
Moderately fast
Slow
Impractical
Q.13
A multidimensional database model is used most often in which of the following models?
Data warehouse
Relational
Hierarchical
Network
Q.14
The blocking factor is:
a group of fields stored in adjacent memory.
the number of physical records per page.
attributes grouped together by the same primary key.
attributes grouped together by the same secondary key.
Q.15
Which of the following improves a query's processing time?
Write complex queries.
Combine a table with itself.
Query one query within another.
Use compatible data types.
Q.16
Which of the following are integrity controls that a DBMS may support?
Assume a default value in a field unless a user enters a value for that field.
Limit the set of permissible values that a field may assume.
Limit the use of null values in some fields.
All of the above.
Q.17
Which of the following is not a factor to consider when switching from small to large block size?
The length of all of the fields in a table row
The number of columns
Block contention
Random row access speed
Q.18
What is the best data type definition for Oracle when a field is alphanumeric and has a fixed length?
VARCHAR2
CHAR
LONG
NUMBER
Q.19
An extent is a contiguous section of disk storage space.
True
False
Q.20
The three newest database architectures in use today are relational, multidimensional and hierarchical.
True
False
0 h : 0 m : 1 s
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Report Question
×
What's an issue?
Question is wrong
Answer is wrong
Other Reason
Want to elaborate a bit more? (optional)
Support mcqgeeks.com by disabling your adblocker.
×
Please disable the adBlock and continue.
Thank you.
Reload page