Discussion
Home ‣ Computer Science ‣ Database Systems Comments
- Question
In SQL, which command(s) is(are) used to recompile a stored function?
Options- A. SET FUNCTION
- B. SET STORED FUNCTION
- C. ALTER FUNCTION
- D. All of the above
- E. None of the above
- Correct Answer
- ALTER FUNCTION
- 1. In SQL, which of the following is not a data definition language commands?
Options- A. RENAME
- B. REVOKE
- C. GRANT
- D. UPDATE
- E. None of the above Discuss
- 2. A _____ DBMS distributes data processing tasks between the workstation and a network server.
Options- A. Network
- B. Relational
- C. Client Server
- D. Hierarchical
- E. None of the above. Discuss
- 3. Which of the following is not an advantage of the data-base approach?
Options- A. elimination of the data redundancy
- B. ability to associate related data
- C. increased security
- D. program/data independence
- E. All of the above are advantages Discuss
- 4. Which language has recently become the de-facto standard for interfacing application programs with relational database system?
Options- A. Oracle
- B. SQL
- C. dBASE
- D. 4GL
- E. None of the above Discuss
- 5. The master list of an indexed file
Options- A. is sorted in ascending order
- B. contains only a list of keys and record numbers
- C. has a number assigned to each record
- D. both (b) and (c)
- E. None of the above Discuss
- 6. In SQL, the command(s) is(are) used to create an index for a table or cluster
Options- A. CREATE INDEX
- B. MODIFY INDEX
- C. SET INDEX TO FILE
- D. All of the above
- E. None of the above Discuss
- 7. In order to use a DBMS, it is important to understand
Options- A. the physical schema
- B. all sub-schemas that the system supports
- C. one subschema
- D. both (a) and (b)
- E. None of the above Discuss
- 8. Report generators are used to
Options- A. store data input by a user
- B. retrieve information from files
- C. answer queries
- D. both (b) and (c)
- E. None of the above Discuss
- 9. Administrate supervision of database activities is the responsibility of the
Options- A. Database administrator
- B. DP Manager
- C. DB Manager
- D. DP administration
- E. None of the above Discuss
- 10. There are certain packages that allow people to define data items, place these items in particular records, combine the records into designated files and then manipulate and retrieve the stored data. What are they called?
Options- A. Data storage system
- B. Database management system (DBMS)
- C. Batch processing system
- D. Data communication package
- E. None of the above Discuss
Database Systems problems
Search Results
Correct Answer: UPDATE
Correct Answer: Client Server
Correct Answer: All of the above are advantages
Correct Answer: SQL
Correct Answer: has a number assigned to each record
Correct Answer: CREATE INDEX
Correct Answer: one subschema
Correct Answer: both (b) and (c)
Correct Answer: Database administrator
Correct Answer: Database management system (DBMS)
Comments
There are no comments.More in Computer Science:
Programming
Copyright ©CuriousTab. All rights reserved.