Home
10th Grade
11th And 12th
11th Grade
12th Grade
3rd Grade
4th Grade
5th Grade
6th Grade
7th Grade
8th Grade
9th Grade
Advance Accountancy
Auditing
Computer Aptitude
Direct And Indirect Taxation
Exams
General Hindi
Indian Finance System
Information Technology And Application In Business
Macro Economics
Town Planning
Aerospace And Aeronautical
Analytical Instrumentation
Banking Awareness
Banking Exam
Biochemistry
Bioinformatics
Biology
Biotechnology
Business Statistics
C Program
C Programming
C++ Programming
Career Aptitude Test
Cell Biology
Central Superior Service (css)
Chemical Engineering
Chemistry
Civil Engineering
Commerce
Computer
Computer Fundamentals
Computer Science
Cost Accounting
Css
Database
Drug And Pharmaceutical Biotechnology
Ecat And Mcat Entry Test
Economics
Electrical Engineering
Electrical Engineering Questions
Electrical Measurement And Instrumentation
Engineering
English
English Literature
Environment Management
Environmental Biotechnology
Enzyme Technology
Financial Management And Financial Markets
Gate
General Knowledge
Graduate Assessment Test (gat)
Health And Physical
Heat Transfer
Html
Human Anatomy And Physiology
Human And Cultural Diversity
Human Resource Management
Ias
Indian Economy
Indian Economy
Indian General Awareness
Indian Geography
Indian Geography
Indian History
Indian History
Indian Polity
Instrumentation Transducers
International Relations
Java Program
Javascript
Judiciary And Law
Life Sciences
Management
Marketing And Marketing Management
Mass Transfer
Mechanical Engineering
Mechanics Of Materials
Medical Subjects
Microbiology
Networking
Php
Placement Tests
Professional Communication
Quantitative Aptitude
Reasoning Aptitude
Renewable Energy
Science
Sociology
Sql
Surveying
Total Quality Management
Uidai Aadhaar Supervisor Certification
Virology
Notificatin
Exam
Blog
Contact Us
Physical Database Design(Engineering > Computer Science And Engineering > Database System ) Questions and Answers
Home
Topic
Engineering
Computer Science And Engineering
Database System
Physical Database Design
Question 1.
If a denormalization situation exists with a one-to-one binary relationship, which of the following is true?
All fields are stored in four relations.
All fields are stored in two relations.
All fields are stored in three relations.
All fields are stored in one relation.
Explanation:-
Answer: Option D. ->
All fields are stored in one relation.
Question 2.
Selecting a data type involves which of the following?
Maximize storage space
Improve data integrity
Represent most values
All of these
Explanation:-
Answer: Option B. ->
Improve data integrity
Question 3.
What is the best data type definition for Oracle when a field is alphanumeric and has a length that can vary?
VARCHAR2
CHAR
LONG
NUMBER
Explanation:-
Answer: Option A. ->
VARCHAR2
Question 4.
If a denormalization situation exists with a many-to-many or associative binary relationship, which of the following is true?
All fields are stored in four relations.
All fields are stored in two relations.
All fields are stored in one relation.
All fields are stored in three relations.
Explanation:-
Answer: Option B. ->
All fields are stored in two relations.
Question 5.
Which of the following is an advantage of partitioning?
Security
Inconsistent access speed
Extra space
Complexity
Explanation:-
Answer: Option A. ->
Security
Question 6.
What is the best data type definition for Oracle when a field is alphanumeric and has a fixed length?
CHAR
LONG
NUMBER
VARCHAR2
Explanation:-
Answer: Option A. ->
CHAR
Question 7.
Which of the following is not a factor to consider when switching from small to large block size?
Random row access speed
The length of all of the fields in a table row
The number of columns
Block contention
Explanation:-
Answer: Option C. ->
The number of columns
Question 8.
The blocking factor is:
the number of physical records per page.
a group of fields stored in adjacent memory.
attributes grouped together by the same secondary key.
attributes grouped together by the same primary key.
Explanation:-
Answer: Option A. ->
the number of physical records per page.
Question 9.
Which of the following improves a query's processing time?
Use compatible data types.
Combine a table with itself.
Write complex queries.
Query one query within another.
Explanation:-
Answer: Option A. ->
Use compatible data types.
Question 10.
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 use of null values in some fields.
All of these
Limit the set of permissible values that a field may assume.
Explanation:-
Answer: Option C. ->
All of these
1
2
3
Next →
One click Login
Login With Google
Old way of Login
Login With Email