Archives

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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 […]

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: […]