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
A network schema
Options
A. restricts the structure to a one-to-many relationship
B. permits many-to-many relationŽships
C. stores data in tables
D. All of the above
E. None of the above
Correct Answer
permits many-to-many relationŽships
Database Systems problems
Search Results
1. The highest level in the hierarchy of data organization is called
Options
A. data bank
B. database
C. data file
D. data record
E. None of the above
Show Answer
Scratch Pad
Discuss
Correct Answer: database
2. In SQL, which command is used to make permanent changes made by statements issue since the beginning of a transaction?
Options
A. ZIP
B. PACK
C. COMMIT
D. SAVE
E. None of the above
Show Answer
Scratch Pad
Discuss
Correct Answer: COMMIT
3. In SQL, which command is used to add new rows to a table?
Options
A. ALTER TABLE
B. ADD ROW
C. INSERT
D. APPEND
E. None of the above
Show Answer
Scratch Pad
Discuss
Correct Answer: INSERT
4. In a _____ a parent record type can be linked to one or more "child" record types, but a child record type can have only one parent.
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: Hierarchical database
5. Sort/report generators
Options
A. are faster than index/report generators
B. require more disk space than index/report generators
C. do not need to sort before generating a report
D. both (a) and (b)
E. None of the above
Show Answer
Scratch Pad
Discuss
Correct Answer: require more disk space than index/report generators
6. If you want to group the records in the abc database, you could use the Jobcode as the _____.
Options
A. Delete
B. Update
C. Sort Key
D. Index
E. None of the above
Show Answer
Scratch Pad
Discuss
Correct Answer: Sort Key
7. In SQL, which command(s) is(are) used to enable/disable all triggers on a table?
Options
A. ALTER TRIGGERS
B. ALTER TABLE
C. MODIFY TRIGGERS IN TABLE
D. All of the above
E. None of the above
Show Answer
Scratch Pad
Discuss
Correct Answer: ALTER TABLE
8. What is the name given to the database management system which is able to handle full text data, image data, audio and video?
Options
A. Full media
B. Graphics media
C. Multimedia
D. Hypertext
E. None of the above
Show Answer
Scratch Pad
Discuss
Correct Answer: Multimedia
9. A number of related records that are treated as a unit is called
Options
A. file
B. field
C. data
D. batch
E. None of the above
Show Answer
Scratch Pad
Discuss
Correct Answer: file
10. The Management Information system (MIS) structure with one main computer system is called a
Options
A. hierarchical MIS structure
B. distributed MIS structure
C. centralized MIS structure
D. decentralized MIS structure
E. None of the above
Show Answer
Scratch Pad
Discuss
Correct Answer: centralized MIS structure
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