Q&A Hero

Management

Q: To log into Oracle Database XE 11.2, use your personal account information.
Q: Oracle Database XE 11.2 is a Web-based Oracle Database administration utility.
Q: An important reason for using Oracle Database Express Edition 11g Release 2 is that it has full SQL capabilities.
Q: Describe why SQL Server 2014 is sensitive to certain words being used in SQL commands or scripts, and what to do about it.
Q: Describe how to create and run an SQL query in SQL Server 2014 Express.
Q: Describe how to create and run an SQL script in SQL Server 2014 Express.
Q: What is an SQL script, and why are SQL scripts useful?
Q: Describe how to create a new database in SQL Server 2014 Express.
Q: The name of the Microsoft SQL Server 2014 ODBC Client as it appears the ODBC Data Source Administrator is ________.
Q: The ODBC Driver 11 for SQL Server is installed ________ when SQL Server 2014 is installed.
Q: SQL query results are displayed in a tabbed ________ window.
Q: To create a new SQL query, click the ________ button.
Q: Users can click the ________ button to enable or disable the SQL editor windows set of outlining and auto-completion features.
Q: To run an SQL script, click the ________ button on the Query Toolbar.
Q: SQL statements can be run individually or as part of a related group of SQL statements known as a(n) ________.
Q: A new SQL Server database is created using the ________ dialog box.
Q: Database objects are displayed in the ________ window in the SQL Server Management Studio.
Q: SQL Server 2014 uses ________ authentication by default.
Q: Users log into SQL Server 2014 Express using the ________ dialog box.
Q: An important reason for using SQL Server 2014 Express is that it has ________.
Q: SQL Server 2014 Express requires that ________ be installed.
Q: The name of the SQL Server 2014 ODBC client as it appears in the ODBC Data Source Administrator is: A) SQL Server ODBC Client 2014. B) ODBC Driver 11 for SQL Server. C) SQL Server Native Client 2008. D) SQL Server Native Client 2008 R2. E) SQL Server Native Client 11.0.
Q: When SQL Server 2014 is installed, the SQL Server 2014 ODBC client is: A) installed automatically as part of the installation. B) installed manually as a separate part of the installation process. C) not installed, and must be downloaded and installed manually. D) not installed because there is no ODBC client for SQL Server 2014. E) Either A or B
Q: SQL query results are displayed: A) in a tabbed Resultset window. B) in a tabbed Results window. C) in a tabbed Document window. D) in a tabbed Messages window. E) in a tabbed Finished window.
Q: To run an SQL script or SQL command in SQL Server 2014: A) click the Execute button on the SQL Editor Toolbar. B) click the Execute button on the Browser Toolbar. C) click the Run button on the Query Toolbar. D) click the Run button on the Browser Toolbar. E) click the Results button on the Query Toolbar.
Q: SQL statements can be run individually or as part of a related group of SQL statements known as a: A) Result. B) Resultset. C) Script. D) Scriptset. E) Commandset.
Q: A new SQL Server database is created using: A) the New Database dialog box. B) the Create Database command. C) the Create New Schema dialog box. D) the Create Schema command. E) the New Object dialog box.
Q: SQL Server DBMS objects are displayed: A) in the Navigation Pane. B) in the Object Explorer. C) in the tabbed database window. D) in the tabbed document window. E) in the command tab.
Q: Logging into the SQL Server 2014 Express DBMS is done using: A) the Connect to Server command. B) the Connect to Server dialog box. C) the Connect to SQL Server Instance command. D) the Connect to SQL Server Instance dialog box. E) None of the above is correct.
Q: Microsoft SQL Server 2014 Express Advanced includes: A) SQL Server 2014 Management Studio. B) SQL Server 2014 Reporting Services. C) Windows Installer 4.5. D) Both A and B E) All of the above
Q: SQL Server 2014 Express requires the prior or concurrent installation of: A) the .NET Framework version 2.0. B) the .NET Framework version 3.0. C) the .NET Framework version 4.0. D) the .NET Framework version 4.5.1. E) None of the above " the .NET Framework is not required.
Q: SQL query results are displayed in a tabbed Resultset window.
Q: To create a new SQL query, click the New Query button.
Q: To run an SQL script, click the Execute button on the Query Toolbar.
Q: SQL statements can be run individually or as part of a related group of SQL statements known as a script.
Q: A new SQL Server database is created using the New Database dialog box.
Q: Database objects are displayed in the Object Explorer window in the SQL Server Management Studio.
Q: SQL Server 2014 uses DBMS authentication by default.
Q: Users log into SQL Server 2014 Express using the Connect to Server dialog box.
Q: To start working with SQL Server 2014 Express in Windows 8.1, use the command Start | All Programs | Microsoft SQL Server 2014 | SQL Server management Studio Express.
Q: An important reason for using SQL Server 2014 Express is that it has full SQL capabilities.
Q: The Microsoft SQL Server 2014 Management Studio is included with Microsoft SQL Server 2014 Express Advanced.
Q: SQL Server 2014 Express requires that the .NET Framework version 2.0 be installed.
Q: Describe how to create an OLAP report for a Microsoft Access 2013 database in Microsoft Excel 2013.
Q: What is a Microsoft Excel PivotTable?
Q: What are objects, and how are they related to the object-oriented DBMS (OODBMS)?
Q: What is a distributed database?
Q: What is a conformed dimension?
Q: What is a star schema?
Q: What is a slowly changing dimension?
Q: Compare the characteristics of an operational database and a dimensional database.
Q: What is a data warehouse?
Q: Why is operational data sometimes unusable for Business Intelligence use?
Q: What is a reporting system?
Q: What are Business Intelligence (BI) systems?
Q: To format an Excel 2013 PivotTable report, we use the ________ command tab.
Q: To control the placement of columns and rows in an Excel 2013 PivotTable, we use the ________.
Q: Excel 2013 allows us to ________ to an Access 2013 database when building a PivotTable.
Q: When creating an OLAP report based on Access 2013 data, it is often a good idea to create a(n) ________ query to organize the data needed for the OLAP report.
Q: To create an OLAP report for an Access 2013 database, use the ________ tool in Excel 2013.
Q: Hadoop is a(n) ________.
Q: Apache Cassandra is an example of a(n) ________ non-relational DBMS.
Q: Objects have ________, which are computer programs that perform some task.
Q: Distributed databases can be distributed by partitioning and ________.
Q: OLAP reports can be created using the Excel 2013 ________ tool.
Q: The term ________ refers to the capability of seeing the data in smaller and smaller units.
Q: ________ provides the ability to sum, count, average and perform other simple arithmetic operations on groups of data.
Q: To deal with historical data values, dimensional databases use a(n) ________.
Q: To deal with data values that change over time, dimensional databases use a(n) ________.
Q: In the snowflake schema, the ________ tables are normalized.
Q: A variant of the star schema is the ________.
Q: A dimensional database uses a(n) ________.
Q: A(n) ________ is a collection of data that addresses a particular component or functional area of a business.
Q: Data warehouses are populated with data prepared by ________ programs.
Q: Data warehouse data is often stored in a(n) ________.
Q: Problematic data are called ________.
Q: Business Intelligence (BI) ________ uses sophisticated statistical and mathematical techniques to perform what-if analyses, to make predictions, and to facilitate decision making.
Q: Business Intelligence (BI) ________ are used to filter data, sort data, group data and make simple calculations based on the data.
Q: Business Intelligence (BI) systems obtain data in ________ different ways.
Q: Business Intelligence (BI) systems fall into two broad categories: ________ and ________.
1 2 3 … 1,015

Subjects

Accounting Anthropology Archaeology Art History Banking Biology & Life Science Business Business Communication Business Development Business Ethics Business Law Chemistry Communication Computer Science Counseling Criminal Law Curriculum & Instruction Design Earth Science Economic Education Engineering Finance History & Theory Humanities Human Resource International Business Investments & Securities Journalism Law Management Marketing Medicine Medicine & Health Science Nursing Philosophy Physic Psychology Real Estate Science Social Science Sociology Special Education Speech Visual Arts