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
Information can be transferred between the DBMS and a
Options
A. spreadsheet program
B. word processor program
C. graphics program
D. All of the above
E. None of the above
Correct Answer
All of the above
Database Systems problems
Search Results
1. Goals for the design of the logical schema include
Options
A. avoiding data inconsistency
B. being able to construct queries easily
C. being able to access data efficiently
D. All of the above
E. None of the above
Show Answer
Scratch Pad
Discuss
Correct Answer: All of the above
2. In SQL, which command(s) is(are) used to change a table's storage characteristics?
Options
A. ALTER TABLE
B. MODIFY TABLE
C. CHANGE TABLE
D. All of the above
E. None of the above
Show Answer
Scratch Pad
Discuss
Correct Answer: ALTER TABLE
3. Database management systems are intended to:
Options
A. eliminate data redundancy
B. establish relationships among records in different files
C. manage file access
D. maintain data integrity
E. All of the above
Show Answer
Scratch Pad
Discuss
Correct Answer: All of the above
4. Data integrity control
Options
A. is used to set upper and lower limits on numeric data
B. requires the use of passwords to prohibit unauthorized access to the file
C. has the data dictionary keep the date and time of last access last back-up, and most recent modification for all files
D. All of the above
E. None of the above
Show Answer
Scratch Pad
Discuss
Correct Answer: has the data dictionary keep the date and time of last access last back-up, and most recent modification for all files
5. Subschema can be used to
Options
A. create very different, personalized views of the same data
B. present information in different formats
C. hide sensitive information by omitting fields from the sub¬schema's description
D. All of the above
E. None of the above
Show Answer
Scratch Pad
Discuss
Correct Answer: All of the above
6. In SQL, which command(s) is(are) used to issue multiple CREATE TABLE, CREATE VIEW, and GRANT statements in a single transaction?
Options
A. CREATE PACKAGE
B. CREATE SCHEMA
C. CREATE CLUSTER
D. All of the above
E. None of the above ;
Show Answer
Scratch Pad
Discuss
Correct Answer: CREATE SCHEMA
7. In which way is a managerial information system (MIS) superior to electronic data processing (EDP)?
Options
A. It is batch oriented
B. It is most cost effective
C. It provides summary reports without details
D. All of the above
E. None of the above
Show Answer
Scratch Pad
Discuss
Correct Answer: It provides summary reports without details
8. A turnaround document can be a (n)
Options
A. punched card
B. OCR document
C. both (a) and (b)
D. neither (a) nor (b)
E. None of the above
Show Answer
Scratch Pad
Discuss
Correct Answer: both (a) and (b)
9. The vice-president of information has primary responsibility for
Options
A. recognizing information needs
B. preparing an MIS study proposal
C. setting MIS objectives
D. establishing MIS constraints
E. None of the above
Show Answer
Scratch Pad
Discuss
Correct Answer: preparing an MIS study proposal
10. The manager attempts to slow down the flow of
Options
A. machines
B. material
C. money
D. All of the above
E. None of the above
Show Answer
Scratch Pad
Discuss
Correct Answer: machines
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