Discussion
Home ‣ Database ‣ Data and Database Administration See What Others Are Saying!
- Question
Which of the following is part of an administrative policy to secure a database?
Options- A. Authentication policies
- B. Limiting particular areas within a building to only authorized people
- C. Ensure appropriate responses rates are in external maintenance agreements
- D. All of the above.
- Correct Answer
- All of the above.
- 1. 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
- 2. 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
- 3. The following are functions of a DBMS except ________ .
Options- A. creating and processing forms
- B. creating databases
- C. processing data
- D. administrating databases Discuss
- 4. The load and index is which of the following?
Options- A. A process to reject data from the data warehouse and to create the necessary indexes
- B. A process to load the data in the data warehouse and to create the necessary indexes
- C. A process to upgrade the quality of data after it is moved into a data warehouse
- D. A process to upgrade the quality of data before it is moved into a data warehouse Discuss
- 5. What is Hypertext Transfer Protocol (HTTP)?
Options- A. The protocol to copy files between computers
- B. The transfer protocol to transfer Web pages to a browser
- C. The database access protocol for SQL statements
- D. The hardware/software protocol that limits access to company data Discuss
- 6. A UNION query is which of the following?
Options- A. Combines the output from no more than two queries and must include the same number of columns.
- B. Combines the output from no more than two queries and does not include the same number of columns.
- C. Combines the output from multiple queries and must include the same number of columns.
- D. Combines the output from multiple queries and does not include the same number of columns. Discuss
- 7. Data scrubbing can help upgrade data quality; it is not a long-term solution to the data quality problem.
Options- A. True
- B. False Discuss
- 8. Which of the following column properties specifies whether or not cells in a column must contain a data value?
Options- A. Null status
- B. Data type
- C. Default value
- D. Data constraints Discuss
- 9. Cascading updates refers to child rows being automatically deleted when a parent row is deleted.
Options- A. True
- B. False Discuss
- 10. With which type of SQL Server recovery model are all database changes logged except those that cause large log entries?
Options- A. Differential recovery
- B. Full recovery
- C. Simple recovery
- D. Bulk-logged recovery Discuss
More questions
Correct Answer: SQL Server only security
Correct Answer: Allow a request from a client to access the database.
Correct Answer: creating and processing forms
Correct Answer: A process to load the data in the data warehouse and to create the necessary indexes
Correct Answer: The transfer protocol to transfer Web pages to a browser
Correct Answer: Combines the output from multiple queries and must include the same number of columns.
Correct Answer: True
Correct Answer: Null status
Correct Answer: False
Correct Answer: Bulk-logged recovery
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.