Q&A Hero

Q: Which of the following is not an SQL trigger? A) BEFORE UPDATE B) INSTEAD OF UPDATE C) BEFORE INSERT D) INSTEAD OF CONSTRAINT E) AFTER DELETE

Q: A stored program that is attached to a table or view is called ________. A) a CHECK constraint B) a view C) embedded SQL D) a trigger E) a stored procedure

Q: Based on the tables below, which of the following SQL commands would create an SQL view named CustomerSalesRep that could be used to display CustNo, CustName, RepName? GENERAL SALES DATABASE: SALESREP SalesRepNo RepName HireDate 654 Jones 01/02/1999 734 Smith 02/03/2000 345 Chen 01/25/1998 434 Johnson 11/23/1998 CUSTOMER CustNo CustName Balance SalesRepNo 9870 Winston 500 345 8590 Gonzales 350 434 7840 Harris 800 654 4870 Miles 100 345 A) SELECT CustNo, CustName, RepName FROM SALESREP, CUSTOMER; B) SELECT CustNo, CustName, RepName FROM SALESREP, CUSTOMER WHERE CustNo=*; C) SELECT CustNo, CustName, RepName FROM SALESREP, CUSTOMER WHERE SALEREP, SalesRepNo = CUSTOMER, SalesRepNo; D) CREATE VIEW CustomerSalesRep AS SELECT CustNo, CustName, RepName FROM SALESREP, CUSTOMER WHERE CustNo=*; E) CREATE VIEW CustomerSalesRep AS SELECT CustNo, CustName, RepName FROM SALESREP, CUSTOMER WHERE SALEREP, SalesRepNo = CUSTOMER, SalesRepNo;

Q: SQL views are used: A) to hide columns or rows. B) to display the results of computations. C) to hide complicated SQL syntax. D) to layer built-in functions. E) All of the above

Q: The SQL statement used to delete a view from a database is: A) ALTER EXISTING VIEW ViewName AS. B) ALTER VIEW ViewName AS. C) DELETE VIEW ViewName. D) DROP EXISTING VIEW ViewName. E) DROP VIEW ViewName.

Q: The SQL statement used to modify a view is: A) ALTER EXISTING VIEW ViewName AS. B) ALTER VIEW ViewName AS. C) DROP EXISTING VIEW ViewName. D) DROP VIEW ViewName. E) MODIFY VIEW ViewName AS.

Q: When an SQL SELECT statement is used to retrieve data from a view instance, the maximum number of columns that can be specified in the SELECT is the same as the number of columns: A) in the table underlying the view. B) in the VIEW specification. C) in the ORDER BY clause. D) in the HAVING clause. E) that have aliases.

Q: Although it cannot be used in creating an SQL VIEW, the SQL SELECT statements retrieving view instances can include: A) SQL keyword ORDER BY. B) SQL keyword LIKE. C) SQL keyword BETWEEN. D) SQL keyword NULL. E) SQL keyword NOT NULL.

Q: SQL view instances are retrieved using the: A) SQL CREATE statement. B) SQL DELETE statement. C) SQL INSERT statement. D) SQL SELECT statement. E) SQL UPDATE statement.

Q: SQL statements used to construct views cannot contain: A) the SELECT clause. B) the FROM clause. C) the WHERE clause. D) the ORDER BY clause. E) the LIKE keyword.

Q: SQL views are constructed from: A) CREATE statements. B) INSERT statements. C) UPDATE statements. D) SELECT statements. E) VIEW statements.

Q: An SQL virtual table is called a(n): A) CHECK constraint. B) view. C) embedded SQL statement. D) trigger. E) stored procedure.

Q: Microsoft Access queries cannot use previously stored view equivalent Access queries.

Q: Since an SQL view is essentially a stored query, Microsoft Access queries can be used to implement SQL view equivalents.

Q: Microsoft Access supports standard SQL view statements.

Q: Because SQL stored procedures allow and encourage code sharing among developers, stored procedures give database application developers the advantages of less work, standardized processing, and specialization among developers.

Q: Unlike application code, stored procedures are never distributed to the client computers.

Q: Stored procedures have the advantage of greater security, decreased network traffic, SQL optimized by the DBMS compiler, and code sharing.

Q: A stored program that is stored within the database and compiled when used is called a trigger.

Q: SQL triggers are used for providing default values, validity checking, updating views, and performing referential integrity actions.

Q: SQL triggers can be used when the DBMS receives an UPDATE request.

Q: The SQL Server DBMS supports the SQL BEFORE trigger.

Q: The Oracle DBMS supports the SQL BEFORE trigger.

Q: SQL triggers can be used when the DBMS receives an INSERT request.

Q: SQL triggers can be used with SQL operations INSERT, UPDATE, and DELETE.

Q: SQL triggers use the SQL keywords BEFORE, INSTEAD OF, and AFTER.

Q: A stored program that is attached to a table or view is called a stored procedure.

Q: SQL views can be used to layer built-in SQL functions.

Q: SQL views can be used to hide complicated SQL syntax.

Q: SQL views can be used to display the results of computed columns.

Q: SQL views can be used to hide columns.

Q: SQL views can be used to hide rows.

Q: The SQL statement DROP VIEW ViewName is used to delete a view from a database.

Q: The SQL statement ALTER EXISTING VIEW ViewName AS is used to modify a view.

Q: When an SQL SELECT statement is used to retrieve data from a view instance, the maximum number of columns that can be specified in the SELECT is the same as the number of columns in the table underlying the view.

Q: The SQL keyword ORDER BY can be used with SELECT statements that are retrieving data from view instances to sort the results of the SELECT.

Q: The SQL command SELECT is used to retrieve data from view instances.

Q: The SQL command CREATE VIEW is used to create view structures.

Q: SQL statements used to construct views cannot contain the WHERE clause.

Q: SQL views are constructed from SELECT statements.

Q: SQL views contain their own data.

Q: An SQL virtual table is called a view.

Q: To create a new SQL query, click the New Query button.

Q: A new MySQL database is created using the New Database dialog box.

Q: Database objects are displayed in the Object Browser window in the MySQL Workbench.

Q: MySQL Community Server 5.6 uses DBMS authentication.

Q: Users log into MySQL Community Server 5.6 using the Connect to MySQL Server dialog box.

Q: To start working with MySQL Server Community Edition in Windows 8.1, use the command Start | All Programs | MySQL | MySQL Workbench 6.1 CE.

Q: An important reason for using MySQL Community Server 5.6 is that it has full SQL capabilities.

Q: The MySQL Workbench is included in the MySQL Community Server 5.6 installation when the MySQL Installer for Windows is used.

Q: MySQL Community Server 5.6 requires that the .NET Framework version 4.5.1 be installed.

Q: Describe how to create relationships in a MySQL Workbench database design.

Q: Describe how to set table properties in a MySQL Workbench database design.

Q: Describe how to add a table object to a MySQL Workbench database design.

Q: Describe how to create a new database design in the MySQL Workbench.

Q: Describe the MySQL Connector/ODBC and how to install it.

Q: Describe how to create and run an SQL query in MySQL 5.6 Community Server Edition.

Q: Describe how to create and run an SQL script in MySQL 5.6 Community Server Edition.

Q: Describe how to create a new database in MySQL 5.6 Community Server Edition.

Q: The MySQL Workbench EER diagrams are actually ________ E-R diagrams.

Q: To create a new MySQL query, use the ________ command.

Q: To run an SQL script, click the ________ button on the MySQL Workbench toolbar.

Q: A new MySQL Server database is known as a new ________.

Q: Database objects are displayed in the ________ window in the MySQL Workbench.

Q: MySQL 5.6 Server Community Edition uses ________ authentication.

Q: Users log into MySQL 5.6 Community Server Edition using the ________ dialog box.

Q: An important reason for using MySQL 5.6 Community Server Edition is that it has ________.

Q: Downloading and installing the MySQL connector/ODBC means that the ________ (name and version) driver will be available in the ODBC Data Source Administrator.

Q: In addition to downloading MySQL Community Server and the MySQL Workbench, it is recommended that the ________ also be downloaded.

Q: MySQL Workbench version ________ was generally available when this text was written.

Q: MySQL ________ (version) Community Server Edition was generally available when this text was written.

Q: In the MySQL Workbench, a 1:N identifying relationship between two tables that already contain the needed primary and foreign keys is created using:A) the 1:N Identifying Relationship button.B) the 1:N Non-identifying Relationship button.C) the N:M Identifying Relationship button.D) the Place a Relationship Using Existing Columns button.E) None of the above is correct.

Q: In the MySQL Workbench, a 1:N identifying relationship between two tables that do not contain the needed primary and foreign keys is created using: A) the 1:N Identifying Relationship button. B) the 1:N Non-identifying Relationship button. C) the N:M Identifying Relationship button. D) the Place a Relationship Using Existing Columns button. E) None of the above is correct.

Q: In the MySQL Workbench, a 1:N non-identifying relationship between two tables that do not contain the needed primary and foreign keys is created using: A) the 1:N Identifying Relationship button. B) the 1:N Non-identifying Relationship button. C) the N:M Identifying Relationship button. D) the Place a Relationship Using Existing Columns button. E) None of the above is correct.

Q: In the MySQL Workbench, a 1:N non-identifying relationship between two tables that already contain the needed primary and foreign keys is created using: A) the 1:N Identifying Relationship button. B) the 1:N Non-identifying Relationship button. C) the N:M Identifying Relationship button. D) the Place a Relationship Using Existing Columns button. E) None of the above is correct.

Q: In the MySQL Table Editor, the abbreviation for AUTO_INCREMENT is: A) PK B) NN C) UQ D) BIN E) AI

Q: In the MySQL Table Editor, the abbreviation for Primary Key is: A) PK B) NN C) UQ D) BIN E) AI

Q: In the MySQL Table Editor, the abbreviation for NOT NULL is: A) PK B) NN C) UQ D) BIN E) AI

Q: To place a table in a MySQL database design, start by clicking the: A) Table button. B) Entity button. C) Place a New Table button. D) Place a New Entity button. E) None of the above

Q: To create a new MySQL Workbench EER model, you can use: A) the New Model button on the Home page. B) the File | New Model command. C) the Start new EER command. D) A or B E) All of the above