Discussion
Home ‣ Computer Science ‣ Database Systems Comments
- Question
In SQL, which command is used to select only one copy of each set of duplicable rows
Options- A. SELECT DISTINCT
- B. SELECT UNIQUE
- C. SELECT DIFFERENT
- D. All of the above
- E. None of the above
- Correct Answer
- SELECT DISTINCT
- 1. A _____ means that one record in a particular record type can be related to many records in another record type and vice-versa.
Options- A. One-to-one relationship
- B. One-to-many relationship
- C. Many-to-one relationship
- D. Many-to-many relationship
- E. None of the above Discuss
- 2. A good query system
Options- A. can accept English language commands
- B. allows non-programmers to access information stored in a database
- C. can be accessed only by data processing professionals
- D. both (a) and (b)
- E. None of the above Discuss
- 3. Related fields in a data base are grouped to form
Options- A. data file
- B. data record
- C. menu
- D. bank
- E. None of the above Discuss
- 4. Queries to a database
Options- A. are written in English
- B. can use aggregate functions like SUM and COUNT
- C. both (a) and (b)
- D. All of the above
- E. None of the above Discuss
- 5. What is the abbreviation used for a software package that permits the users to create, retrieve and maintain records in a database?
Options- A. DASD
- B. FMS
- C. EMMS
- D. DBMS
- E. None of the above Discuss
- 6. If a piece of data is stored in two places in the database, then
Options- A. storage space is wasted
- B. changing the data is one spot will cause data inconsistency
- C. it can be more easily accessed
- D. both (a) and (b)
- E. None of the above Discuss
- 7. A command that lets you change one or more fields in a record is
Options- A. Insert
- B. Modify
- C. Look-up
- D. All of the above
- E. None of the above Discuss
- 8. A relational database management (RDBM) package manages data in more than one file at once. How does it organize these file? As
Options- A. tables
- B. relations
- C. tuple
- D. both (a) and (b)
- E. None of the above Discuss
- 9. Embedded pointer provide
Options- A. a secondary access path
- B. a physical record key
- C. an inverted index
- D. All of the above
- E. None of the above Discuss
- 10. A list in alphabetical order
Options- A. is in descending order
- B. is in ascending order
- C. is the result of a sort operation
- D. both (b) and (c)
- E. None of the above Discuss
Database Systems problems
Search Results
Correct Answer: Many-to-many relationship
Correct Answer: allows non-programmers to access information stored in a database
Correct Answer: data record
Correct Answer: can use aggregate functions like SUM and COUNT
Correct Answer: DBMS
Correct Answer: both (a) and (b)
Correct Answer: Modify
Correct Answer: both (a) and (b)
Correct Answer: a secondary access path
Correct Answer: both (b) and (c)
Comments
There are no comments.More in Computer Science:
Programming
Copyright ©CuriousTab. All rights reserved.