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
Database Redesign(Engineering > Computer Science And Engineering > Database System ) Questions and Answers
Home
Topic
Engineering
Computer Science And Engineering
Database System
Database Redesign
Question 1.
Database redesign is not terribly difficult if the:
database is well-designed.
database is structured.
database has no data.
database is relatively small.
Explanation:-
Answer: Option C. ->
database has no data.
Question 2.
Which SQL-92 standard SQL command can be used to change a table name?
None of these
CHANGE TABLE
RENAME TABLE
ALTER TABLE
Explanation:-
Answer: Option A. ->
None of these
Question 3.
What SQL command can be used to delete columns from a table?
ALTER TABLE TableName DROP COLUMN ColumnName
MODIFY TABLE TableName DROP ColumnName
ALTER TABLE TableName DROP ColumnName
MODIFY TABLE TableName DROP COLUMN ColumnName
Explanation:-
Answer: Option A. ->
ALTER TABLE TableName DROP COLUMN ColumnName
Question 4.
Which of the following SQL statements are helpful in database redesign?
Correlated subqueries only
None of these
Both of the above are helpful
EXISTS/NOT EXISTS expressions only
Explanation:-
Answer: Option C. ->
Both of the above are helpful
Question 5.
The process of reading a database schema and producing a data model from that schema is known as:
database design.
data modeling.
None of these
reverse engineering.
Explanation:-
Answer: Option D. ->
reverse engineering.
Question 6.
Before any changes to database structure are attempted one should first:
All of these
create a complete backup of the operational database only.
test any changes on a test database only.
clearly understand the current structure and contents of the database only.
Explanation:-
Answer: Option A. ->
All of these
Question 7.
A regular subquery can be processed:
from the top down.
from the bottom up.
None of these
by nesting.
Explanation:-
Answer: Option B. ->
from the bottom up.
Question 8.
Which of the following modifications may not succeed?
Both of the above actions should succeed
Changing a column data type from char to date
Neither of the above actions will succeed
Changing a column data type from numeric to char
Explanation:-
Answer: Option B. ->
Changing a column data type from char to date
Question 9.
How can you find rows that do not match some specified condition?
None of these
Double use of NOT EXISTS
NOT EXISTS
EXISTS
Explanation:-
Answer: Option B. ->
Double use of NOT EXISTS
Question 10.
What SQL command can be used to add columns to a table?
ALTER TABLE TableName ADD ColumnName
MODIFY TABLE TableName ADD COLUMN ColumnName
MODIFY TABLE TableName ADD ColumnName
ALTER TABLE TableName ADD COLUMN ColumnName
Explanation:-
Answer: Option A. ->
ALTER TABLE TableName ADD ColumnName
1
2
3
4
Next →
One click Login
Login With Google
Old way of Login
Login With Email