CuriousTab
Search
CuriousTab
Home
Aptitude
Computer
C Programming
C# Programming
C++ Programming
Database
Java Programming
Networking
Engineering
Biochemical Engineering
Biochemistry
Biotechnology
Chemical Engineering
Civil Engineering
Computer Science
Digital Electronics
Electrical Engineering
Electronics
Electronics and Communication Engineering
Mechanical Engineering
Microbiology
Technical Drawing
GK
Current Affairs
General Knowledge
Reasoning
Data Interpretation
Logical Reasoning
Non Verbal Reasoning
Verbal Ability
Verbal Reasoning
Exams
AIEEE
Bank Exams
CAT
GATE
IIT JEE
TOEFL
Jobs
Analyst
Bank PO
Database Administrator
IT Trainer
Network Engineer
Project Manager
Software Architect
Discussion
Home
‣
Computer Science
‣
Database Systems
Comments
Question
Which of the following is a serious problem of file management systems?
Options
A. difficult to update
B. lack of data independence
C. data redundancy
D. program dependence
E. All of the above
Correct Answer
All of the above
Database Systems problems
Search Results
1. What name is given to the collection of facts, items of information or data which are related in some way?
Options
A. Database
B. Directory information
C. Information tree
D. Information provider
E. None of the above
Show Answer
Scratch Pad
Discuss
Correct Answer: Database
2. Which command(s) is(are) used to redefine a column of the table in SQL?
Options
A. ALTER TABLE
B. DEFINE TABLE
C. MODIFY TABLE
D. All of the above
E. None of the above
Show Answer
Scratch Pad
Discuss
Correct Answer: ALTER TABLE
3. In SQL, the CREATE VIEW command is used
Options
A. to recompile view
B. to define a view of one or more tables or views
C. to recompile a table
D. to create a trigger
E. None of the above
Show Answer
Scratch Pad
Discuss
Correct Answer: to define a view of one or more tables or views
4. The model for a _____ resembles the hierarchical model in many respects.
Options
A. Network database
B. Relational database
C. Distributed database
D. Hierarchical database
E. None of the above
Show Answer
Scratch Pad
Discuss
Correct Answer: Network database
5. The way a particular application views the data from the data base that the application uses is a :
Options
A. module
B. relational model
C. schema
D. subschema
E. None of the above
Show Answer
Scratch Pad
Discuss
Correct Answer: subschema
6. In SQL, which of the following is not a data Manipulation Language Commands?
Options
A. DELETE
B. SELECT
C. UPDATE
D. CREATE
E. None of the above
Show Answer
Scratch Pad
Discuss
Correct Answer: CREATE
7. When performing a look-up operation using a form
Options
A. you enter the search value into the form
B. you look at each form sequentially until you see the one you want
C. you type the key in an entry line, and the correct form is displayed
D. All of the above
E. None of the above
Show Answer
Scratch Pad
Discuss
Correct Answer: you enter the search value into the form
8. Which command(s) is(are) used to enable/disable/drop an integrity constraint in SQL?
Options
A. DEFINE TABLE
B. MODIFY TABLE
C. ALTER TABLE
D. All of the above
E. None of the above
Show Answer
Scratch Pad
Discuss
Correct Answer: ALTER TABLE
9. The data-base environment has all of the following components except:
Options
A. users
B. separate files
C. data base
D. data-base administrator
E. None of the above
Show Answer
Scratch Pad
Discuss
Correct Answer: separate files
10. Internal auditors should review data system design before they are
Options
A. developed
B. implemented
C. modified
D. All of the above
E. None of the above
Show Answer
Scratch Pad
Discuss
Correct Answer: All of the above
Comments
There are no comments.
Enter a new Comment
Save
More in Computer Science:
Artificial Intelligence
Automation System
Computer Fundamentals
Computer Hardware
Database Systems
Digital Computer Electronics
Disk Operating System (DOS)
Electronic Principles
Language Processors
Linux
Management Information Systems
Networking
Object Oriented Programming Using C++
Operating Systems Concepts
System Analysis and Design
Unix
Windows 2000 Server
Windows NT