Q&A Hero

Q: When an organization employs both a DA and a DBA, the DA's job has a technical orientation, whereas the DBA's job has a managerial orientation. a. True b. False

Q: The DBA is responsible for ensuring that the data are distributed to the right persons, at the right time, and in the right format. a. True b. False

Q: The DBA or security officer must secure an insurance policy to provide financial protection in the event of a database failure. a. True b. False

Q: In the context of database administration, standards are written instructions that describe a series of steps to be followed during the performance of a given activity. a. True b. False

Q: The storage locations for multiple backups must include sites inside and outside the organization. a. True b. False

Q: Backups must be clearly identified through detailed descriptions and date information, assuring that the correct backup is used to recover the database. a. True b. False

Q: Concurrent backups take place while the user is working on the database. a. True b. False

Q: Incremental backups produce a backup of all data. a. True b. False

Q: A full backup, or database dump, produces a complete copy of the entire database. a. True b. False

Q: Disaster management includes all the end-user activities designed to secure data availability before a physical disaster or a database integrity failure. a. True b. False

Q: The security, privacy, and integrity of data in a database are of minimal concern to DBAs who manage current DBMS installations. a. True b. False

Q: The DBA interacts with the end user by providing data and information support services to the organization's departments. a. True b. False

Q: The introduction of a DBMS represents a big change and challenge, and is likely to have a profound impact throughout the organization. a. True b. False

Q: Having a computerized DBMS guarantees that the data will be properly used to provide the best solutions required by managers. a. True b. False

Q: An enterprise database can be defined as the company's data representation that provides support for all present and expected future operations. a. True b. False

Q: The DBMS must provide tools that give each level of management a useful view of the data and support the required level of decision-making. a. True b. False

Q: The testing and evaluation of a database application cover all aspects of the systemfrom the simple collection and creation of data to its use and retirement. What is covered by the evaluation process?

Q: Describe the need for convenient and safe backup storage.

Q: Explain conflict and problem resolution as part of the DBA's enduser support services.

Q: Explain user requirements gathering as part of the DBA's end-user support services.

Q: Describe the DBA's managerial role.

Q: A(n) _____ physically stores the database's data.

Q: A security ______________is a weakness in a system component that could be exploited to allow unauthorized access or cause service disruptions.

Q: Within the data security framework,__________ is concerned with keeping data consistent and free of errors or anomalies.

Q: Explain the features provided by web application servers.

Q: What is JavaScript? How does it work?

Q: What is a server-side extension? Explain.

Q: What are the main types of objects in the OLE-DB model? Explain.

Q: What are the components in the basic ODBC architecture?

Q: A DBMS that supports________ exchanges can integrate with external systems such as the web, mobile data, and legacy systems, thus enabling the creation of new types of systems.

Q: A(n)______________ provides limited additional semantic value to XML, such as data type support or data validation rules.

Q: XML tags must be well formed, that is, each opening tag must have a corresponding _____________tag.

Q: XML is derived from the___________ , an international standard for the publication and distribution of highly complex technical documents.

Q: ____________, or transactions done over the Internet, enables all types of organizations to sell products and services to a global market.

Q: To prevent the server from performing all data validation,____________ data input validation is one of the most basic requirements for web applications.

Q: A web_______________ server is a middleware application that expands the functionality of web servers by linking them to a wide range of services.

Q: Regardless of the type of web server interface used, a web-to-database____________ program must be able to connect with a database.

Q: APIs are faster than_______________ scripts because the code resides in memory and there is no need to run an external program for each request.

Q: ______________webpages are at the heart of current generation websites.

Q: ______________is an application programming interface that allows a Java program to interact with a wide range of data sources (relational databases, tabular data sources, spreadsheets, and text files).

Q: The Microsoft____________ framework is a component-based platform for developing distributed, heterogeneous, interoperable applications aimed at manipulating any type of data over any network under any operating system and any programming language.

Q: _____________provides a unified interface to access data from any programming language that uses the underlying OLE- DB objects.

Q: A(n) _____ is a program written in a programming language that is not compiled, but is interpreted and executed at run time.

Q: In the OLE-DB model, the ___________acts like a data consumer of the data provider and as a data provider for the data consumer (end-user application).

Q: In the context of OLE-DB, a_____________ is an object (application or process) that requests and uses data.

Q: A(n)__________ is a unique name by which the data source will be known to ODBC, and therefore, to applications.

Q: Open Database Connectivity (ODBC), a superset of the SQL Access Group Call Level Interface (CLI), is implemented by___________ .

Q: ODBC, OLE-DB, and ADO.NET form the backbone of the_____________ architecture.

Q: In the___________ category, the cloud service provider offers the capability to build and deploy consumer-created applications using the provider's cloud infrastructure.a. Application as a Service (AaaS)b. Infrastructure as a Service (IaaS)c. Software as a Service (SaaS)d. Platform as a Service (PaaS)

Q: _________________is a type of cloud infrastructure that is built by a third-party organization to sell cloud services to the general public.a. Communityb. Publicc. Exclusived. Private

Q: Using________________ , you can extract data from an XML document and convert it into a text file.a. XMLDb. XSLTc. DTDd. XML schema

Q: The _____ is an advanced data definition language that is used to describe the structure of XML data documents. a. XHTML b. HTML schema c. DTD d. XML schema

Q: A(n)___________ file provides the composition of the database's logical model and defines the syntax rules for an XML document.a. XMLDb. XHTMLc. DTDd. meta

Q: Every XML document has a_____________ .a. root elementb. base tagc. schemad. DTD

Q: Which of the following is a characteristic of the XML metalanguage?a. It is concerned with the way data are displayed.b. It allows the definition of new tags.c. You can use the // symbol for entering a comment in the XML document.d. It can be used as a replacement of HTML.

Q: ______________is a web application server that provides the ability to connect web servers to multiple data sources.a. MS Accessb. ColdFusion/JRunc. FoxProd. dBase

Q: ________________code is embedded inside an HTML page and is activated by triggering events such as clicking on a link.a. XMLb. SQLc. Visual Basicd. VBScript

Q: Which of the following is true of a web application server?a. It is Microsoft's implementation of a superset of the SQL Access Group CLI standard for database access.b. It is automatically invoked by the browser when needed.c. It runs on the client machine, freeing server resources.d. It provides security and authentication of users through user IDs and passwords.

Q: _____ is a scripting language that allows web authors to design interactive sites. a. Visual Basic b. HTML c. JavaScript d. Java

Q: Among client-side extensions,______________ is a Microsoft specification for writing programs that run inside the Internet Explorer browser.a. COBOLb. ActiveXc. JavaScriptd. Visor.Net

Q: Which of the following is a client-side extension? a. ActiveX b. ODBC c. SQL*Net d. TCP/IP

Q: You must use plug-ins and other client-side extensions: a. to create an open communication line between a server and its clients. b. to eliminate the need for running external programs for each client request. c. to improve processing capabilities of a browser. d. to create dynamic web search pages.

Q: The web browser's job is to interpret the HTML code that it receives from a web server and to: a. develop web-based applications. b. display it in a standard formatted way. c. perform immediate data entry validation. d. extract details, such as order data, from it.

Q: Each time an end user clicks a hyperlink, the browser generates a(n)__________ page request that is sent to the designated web server using the TCP/IP Internet protocol.a. HTMLb. XMLc. HTTP GETd. API

Q: What is a disadvantage of using an API web-server interface? a. It is slower than CGI scripts. b. It is inefficient because it uses DLLs. c. An external program needs to run for each user request. d. An API error can bring down the entire web server.

Q: A(n)__________ can use a shared connection to the database instead of creating a new one every time.a. DLLb. APIc. web browserd. HTTP GET request

Q: The main disadvantage of using CGI scripts is that: a. they cause a resource bottleneck since they have to execute separately for each user request. b. they are specific to the web server and to the operating system, thus being platform dependent. c. an error in one script can damage and bring down the web server completely. d. they do not have the capability to process forms or prepare outputs based on form data.

Q: Which of the following is a well-defined web-server interface? a. Common Gateway Interface b. Tiny Internet Interface c. Windows NT d. Command Line Interface

Q: Which of the following is the last step in the exchange between a web browser and a database? a. The HTML output is displayed on the client computer's web browser. b. The middleware receives the query result and creates the HTML-formatted page. c. The web browser requests a page from a web server. d. The web-to-database middleware uses ODBC to connect to the database.

Q: Which of the following is the first step in the exchange between a web browser and a database? a. The HTML output is displayed on the client computer's web browser. b. The middleware receives the query result and creates the HTML-formatted page. c. The client's web browser requests a page from a web server. d. The web-to-database middleware uses ODBC to connect to the database.

Q: Another name for a database server-side extension program is ________________.a. a web serverb. a web application middlewarec. web-to-database middlewared. a database application server

Q: One of the advantages of ______________over other middleware is that it requires no configuration on the client side.a. ODBCb. JDBCc. OLE-DBd. ADO.NET

Q: _______________is an object-oriented programming language developed by Sun Microsystems that runs on top of web browser software.a. Visual Basicb. Javac. JavaScriptd. VBScript

Q: The___________ is the most specialized object in the ADO.NET framework.a. Commandb. DataReaderc. DataAdapterd. DataSet

Q: In the ADO.NET framework, the__________ object is the in-memory representation of the data in the database.a. Commandb. DataReaderc. DataAdapterd. DataSet

Q: In the ADO.NET framework, the__________ object contains the actual SQL code or a stored procedure call to be run by the database.a. Commandb. DataReaderc. DataAdapterd. DataSet

Q: Based on Microsoft's Component Object Model (COM),__________ is database middleware that adds objectoriented functionality for access to relational and nonrelational data.a. MS-DBb. OLE-DBc. COM-DBd. ODBC

Q: The ODBC API standard defines three levels of compliance:__________, Level-1, and Level-2, which provide increasing levels of functionality.a. Elementaryb. Basicc. Cored. Level-0

Q: In the ODBC architecture, a(n)__________ is in charge of managing all database connections.a. ODBC APIb. DLLc. ODBC driverd. driver manager

Q: __________________is a higher-level, object-oriented application interface used to access remote database servers.a. UDAb. ODBCc. DAOd. RDO