Practice Test: Question Set - 05
1. In SQL, which command is used to add new rows to a table?
- (A) ALTER TABLE
- (B) ADD ROW
- (C) INSERT
- (D) APPEND
2. Which command is used to remove an index from the database in SQL?
- (A) DELETE INDEX
- (B) DROP INDEX
- (C) REMOVE INDEX
- (D) ROLL BACK
INDEX
3. A _______ means that one record in a particular record type can be related to many records in another record type and vice-versa.
- (A) One-to-one
relationship
- (B) One-to-many
relationship
- (C) Many-to-one
relationship
- (D) Many-to-many
relationship
4. What is the name given to the database management system which is able to handle full text data, image data, audio and video?
- (A) Full media
- (B) Graphics
media
- (C) Multimedia
- (D) Hypertext
5. In SQL, which command is used to make permanent changes made by statements issue since the beginning of a transaction?
- (A) ZIP
- (B) PACK
- (C) COMMIT
- (D) SAVE
6. In the DBM approach, application programs perform the
- (A) Storage function
- (B) Processing
functions
- (C) Access
control
- (D) None of the
above
7. The _________ command is used to allocates an extent for the table in SQL
- (A) MODIFY
ALLOCATES
- (B) MODIFY TABLE
- (C) ALTER TABLE
- (D) REDEFINE
TABLE
8. The designer of a form includes
- (A) Filed
designators
- (B) Prompts
- (C) Data
- (D) Both (a) and
(b)
9. An-owner-member set in the CODASYL specifications may have
- (A) Only one
owner but many owner occurrences
- (B) Only
one member but many member occurrence
- (C) More than
one member but only one occurrence per member
- (D) All of the
above
10. In SQL, which command is used to create a database user?
- (A) ADD USER TO
DATABASE
- (B) MK USER
- (C) CREATE USER
- (D) All of the
above
11. Which of the following is not a level of data abstraction?
- (A) Physical
Level
- (B) Critical
Level
- (C) Logical
Level
- (D) View Level
12. Which of the following is Database Language?
- (A) Data Definition
Language
- (B) Data
Manipulation Language
- (C) Query
Language
- (D) All of the
above
13. In mathematical term Table is referred as
- (A) Relation
- (B) Attribute
- (C) Tuple
- (D) Domain
14. Which of the following in not Outer join?
- (A) Left outer
join
- (B) Right outer
join
- (C) Full outer
join
- (D) All of the
above
15. Which of the following is not binary operation?
- (A) Union
- (B) Project
- (C) Set
Difference
- (D) Cartesian
Product
Next Tests:
Blogger Comment
Facebook Comment