Discussion
Home ‣ Database ‣ Introduction to SQL See What Others Are Saying!
- Question
The Microsoft Access wildcards are ____ and ____ .
Options- A. asterisk (*); percent sign (%)
- B. percent sign (%); underscore (_)
- C. underscore(_); question mark (?)
- D. question mark (?); asterisk (*)
- Correct Answer
- question mark (?); asterisk (*)
- 1. Which of the following is true concerning QBE?
Options- A. An official standard has been defined for QBE.
- B. QBE cannot be used for client/server systems.
- C. QBE does not give the programmer a visual programming environment.
- D. Complete applications can be written using QBE. Discuss
- 2. For every relationship, how many possible sets of minimum cardinalities are there?
Options- A. Two
- B. Three
- C. Four
- D. Six Discuss
- 3. Which SQL phrase is not supported by Oracle?
Options- A. ON DELETE CASCADE
- B. ON UPDATE CASCADE
- C. CREATE SEQUENCE [SequenceName]
- D. DROP SEQUENCE [SequenceName] Discuss
- 4. An entity is something that can be identified in the user's work environment; something that the users want to track.
Options- A. True
- B. False Discuss
- 5. When using ODBC, which of the following processes ODBC requests and submits specific SQL statements to a given type of data source?
Options- A. Data source
- B. Driver
- C. Driver manager
- D. DBMS Discuss
- 6. A reason for using an SQL view to hide columns is:
Options- A. to simplify a result only.
- B. to prevent the display of sensitive data only.
- C. to accomplish both of the above.
- D. None of the above are reasons for using an SQL view. Discuss
- 7. Eliminating modification anomalies is a(n) ________ of normalization.
Options- A. advantage
- B. disadvantage
- C. either an advantage or disadvantage
- D. neither an advantage nor disadvantage Discuss
- 8. What mode of authentication does SQL Server NOT provide?
Options- A. Windows-only security
- B. Both SQL Server and Windows-only security
- C. Mixed security
- D. SQL Server only security Discuss
- 9. A server-side extension is needed to do what?
Options- A. Allow a request from a client to access the database.
- B. Allow a request from a client to access a HTML-formatted page.
- C. Allow a request from a client to access Web pages.
- D. All of the above. Discuss
- 10. The following are functions of a DBMS except ________ .
Options- A. creating and processing forms
- B. creating databases
- C. processing data
- D. administrating databases Discuss
More questions
Correct Answer: Complete applications can be written using QBE.
Correct Answer: Four
Correct Answer: ON UPDATE CASCADE
Correct Answer: True
Correct Answer: Driver
Correct Answer: to accomplish both of the above.
Correct Answer: advantage
Correct Answer: SQL Server only security
Correct Answer: Allow a request from a client to access the database.
Correct Answer: creating and processing forms
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.