Archives: Quiz

Microsoft Access is a personal database that combines a DBMS with an application generator. A complex network is a collection of records and the 1:N relationships between them. Answer: FALSE[/cpmembership] Unlike SQL views, XML views are not limited to one […]

SQL statements end with a colon. Outer joins can be either up joins or down joins. Answer: FALSE Report delivery is more difficult for data mining than it is for reporting systems. Answer: FALSE Because EXISTS and NOT EXISTS are […]

Typically, there are at least four different copies of the database schema used in the redesign process. The Read Only transaction isolation level is unique to Oracle Database. Answer: TRUE Attributes preceded by a + are protected. Answer: FALSE SOAP […]

What are XML Web Services? To deal with historical data values, dimensional databases use a(n) ________. Answer: time dimension Distinguish between statement-level consistency and transaction-level consistency. Answer: Statement-level consistency requires that a statement apply to a set of rows that […]

A(n) ________ is a set of one or more computer programs that serves as an intermediary between the user and the DBMS. Compare and contrast subqueries and joins. Answer: Subqueries and joins are both used to process data for queries […]

Business Intelligence (BI) ________ uses sophisticated statistical and mathematical techniques to perform what-if analyses, to make predictions, and to facilitate decision making. Michael Porter includes procurement in his list of ________ activities. Answer: support Using SQL commands, multiple tables can […]

Explain two methods for defining a primary key using SQL. To run an SQL script, click the ________ button on the Query Toolbar. Answer: Execute Problematic data are called ________. Answer: A primary key may be defined by either the […]

XML Schemas consist of ________. What are the advantages and disadvantages of personal DBMS products hiding the complexity of database systems? Answer: The advantage of hiding the complexity of database systems is that it makes database systems easier for novices […]

Conditions in an SQL INSERT command and after the SQL ________ keyword require single quotes around values for Char and VarChar columns, but not around values for Integer and Numeric columns. The relationship between two attributes that denotes that if […]

SQL Server 2014 uses ________ authentication by default. Explain how to run an SQL query in Microsoft Access. Answer: To run an SQL query in Microsoft Access, start on the Create command tab. Click the Query Design button, which will […]

What are “referential integrity constraints”? Give an example. To represent a many-to-many relationship in the relational model, a(n) ________ table is used. Answer: intersection To normalize a relation, the determinant of every functional dependency should be a(n) ________. Answer: A […]

MySQL Community Server 5.6 requires that the .NET Framework version 4.5.1 be installed. Excel 2013 allows us to connect directly to an Access 2013 database when building a PivotTable. Answer: TRUE If you need to create a primary key that […]

Information systems are used to support business processes. SQL views can be used to layer built-in SQL functions. Answer: TRUE When running the NetBeans IDE for the first time, use a file workspace named NetBeansProjects. Answer: TRUE A relational database […]

Microsoft Access can run QBE queries, but not SQL queries. Users should create a MySQL Workspace folder to hold documents created with the MySQL Workbench. Answer: TRUE Microsoft Access forms can only contain data from one table. Answer: FALSE[/cpmembership] Microsoft […]

The Java JDK is installed directly from the Java download page at www.oracle.com. Microsoft Access 2013 command buttons are created using the Command Button Wizard. Answer: TRUE In the MySQL Workbench, a 1:N non-identifying relationship between two tables that already […]

The Oracle Database FORMAT_DATE function can be used to make sure that Oracle Database interprets date data correctly. NoSQL really stands for “Not only SQL.” Answer: TRUE The default file extension for text files created for or within SQL Developer […]

The SQL Server DBMS supports the SQL BEFORE trigger. The default Web page for the IIS Web server is index.html. Answer: FALSE In Microsoft Visio 2013, a group of template objects is called a stencil. Answer: TRUE Column family databases […]

Microsoft Access uses the same pure N:M relationships that occur in data modeling. Users log into SQL Server 2014 Express using the Connect to Server dialog box. Answer: TRUE An important reason for using SQL Server 2014 Express is that […]

Normalization is the process of removing all functional dependencies from a relation. There is usually only one instance of an entity in an entity class. Answer: FALSE Microsoft Access 2013 databases are stored using the file extension .accdb. Answer: TRUE […]

In Microsoft Visio 2013, when the Entity object is placed in a diagram, it is labeled as a table. To create a new SQL query, click the New Query button. Answer: TRUE Unlike application code, stored procedures are never distributed […]

Standard SQL does not allow built-in functions to be used in a WHERE clause. The DBMS is used to create the database itself. Answer: TRUE An entity class is described by the structure of the entities in that class. Answer: […]

SQL statements can be run individually or as part of a related group of SQL statements known as a script. In SQL, the LIKE keyword can be combined with the NOT keyword to form the NOT LIKE condition for selecting […]

Sequences are most often used to provide values for surrogate keys. Oracle Database XE 11.2 uses Application Express to create new workspaces. Answer: TRUE For a column to be defined as the primary key using table constraints, the column must […]

To create a 1:1 relationship in Microsoft Access, the Indexed property of the foreign key column must be set to Yes (No Duplicates). During the design phase of developing a database system, the users are asked about the need for […]

Laboratory studies offer highly reliable data characterized by: a) External efficacy b) Control validity c) Internal conformity d) Internal validity By engaging in this study strategy, a student identifies main ideas, then diagrams connections between them. a) Outlining b) PQ4R […]

Which schedule allows for a constant number of behaviors required for reinforcement? a) Fixed ratio b) Variable ratio c) Fixed interval d) Variable interval Which of the following educational services is most restrictive? a) Self-contained special education b) Itinerant services […]

Asking a student to understand the plight of a Jewish family while under Nazi occupation is an example of a) prejudice reduction. b) equity pedagogy. c) knowledge construction. d) content integration. Someone who supports full inclusion would advocate: a) mainstreaming […]

Eddie is a seventh grader who knows how to break complex problems into simpler steps, how and when to skim, and how and when to read for deep understanding. What key concept of constructivist theories of learning best describes Eddie? […]

A student who frequently taps a pencil loudly during seatwork stops the tapping behavior. The teacher praises the quiet behavior. Which intervention strategy is being used? a) nonverbal cues b) praise of incompatible, correct behavior c) simple verbal reminder d) […]

Consequences that weaken behavior are called: a) secondary consequences. b) negative reinforcers. c) anticipatory consequences. d) punishers. According to behavioral learning theory, a person’s motivation to engage in a particular activity is a function of: a) the perceived difficulty of […]

The first phase in observational learning defined as paying attention to a model is: a) attention phase. b) retention phase. c) motivational phase. d) reproduction. Ms. LeBeau is planning to have a whole-class discussion on the effects of television violence […]

During norm-referenced testing, the content coverage most likely consists of: a) focus on a limited number of learning tasks. b) focus on a broad area of coverage. c) focus on a single topic. d) Lack of focus on pertinent topics […]

Which of the following is a problem that might arise in using relative grading standards? a) Although the students did not learn very much, they nearly all got A’s because the teacher’s newly developed tests were so easy. b) Students […]

In comparing cooperative learning to traditional teaching methods, most research consistently favors cooperative learning, provided that two essential conditions are met. According to our text, there should be some group recognition and there must also be: a) group assessment. b) […]

At his locker, Rick is describing his exciting weekend to Tony, using very colorful and inappropriate language. Tony gestures down the hall to let Rick know that Sherri is approaching. Rick continues his story but instantly cleans up his language, […]

Which of the following is a recommended use of testing in conjunction with backward planning? a) Be sure that each objective used in developing the unit test is covered by the same number of items. b) If you construct a […]

According to our text, to determine the severity of cognitive impairment, educational professionals should: a) interview the student’s parents only, and in private. b) consider other test scores and cultural background. c) also take into account the student’s age and […]

Which of the following is true regarding norm-referenced achievement tests? a) They provide little information on which to rank students according to their knowledge of a given subject. b) They evaluate students on all the content areas they have covered. […]

In discussing the ethics of behavior modification techniques, your text author suggests that these methods: a) should only be used under supervision of a clinical or school psychologist. b) are ethical, but not powerful enough to use with disruptive students. […]

In the Learning Together a model of cooperative learning, students work in: a) homogeneous groups. b) randomly-assigned groups. c) heterogeneous groups. d) self selected groups. The trend to use social comparison information to evaluate the self appears to correspond with […]

Vera’s old mechanical bathroom scale used to tell her weights that always agreed with the scale at the doctor’s office. Then one day the dial on her old scale was damaged and the numbers got scrambled. The scale still operates […]

Business performance management comprises a ________ set of processes that link strategy to execution with the goal of optimizing business performance. In mathematical programming, of available solutions, the ________ solution is the best; i.e., the degree of goal attainment associated […]

The term ________ refers to what is perceived to be the second generation of Web development and Web design, being characterized as facilitating communication, information sharing, interoperability, user-centered design, and collaboration on the World Wide Web. Intra-organizational networked decision support […]

Group communication and ________ involves decision makers who are likely to be in different locations. Because of its successful application to retail business problems, association rule mining is commonly called ________. Answer: market-basket analysis List six common data mining mistakes. […]

What are three components that may be included in an expert system in addition to the three major components found in virtually all expert systems? ________ express belief in an event (or a fact or a hypothesis) based on the […]

The knowledge-based management subsystem can be interconnected with the organization’s knowledge repository (part of a knowledge management system [KMS]), which is sometimes called the ________. What are the three steps in the process-based approach to the use of support vector […]

Dashboards present visual displays of important information that are consolidated and arranged on a single ________. In the text mining system developed by Ghani et al., treating products as sets of ________ rather than as atomic entities can potentially boost […]

Why are some portions of tape backup workloads being redirected to Hadoop clusters today? How would you describe information extraction in text mining? Answer: Information extraction is the identification of key phrases and relationships within text by looking for predefined […]

When IBM Research began looking for a major research challenge to rival the scientific and popular interest of Deep Blue, the computer chess-playing champion, what was the company’s goal? ________ is an umbrella term that combines architectures, tools, databases, analytical […]

What are the differences between stream analytics and perpetual analytics? When would you use one or the other? Name Simon’s four phases of decision making and mention how they are impacted by the web. Answer: – Intelligence – Access to […]