Q&A Hero

Q: The default transaction isolation level in MySQL is REPEATABLE READ.

Q: MySQL concurrency options include four transaction isolation levels: READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, and SERIALIZABLE.

Q: Triggers that have been created in MySQL are displayed as objects in the Object Browser of the MySQL Workbench.

Q: MySQL uses the "Safe Updates"Forbid UPDATE and DELETE statements with no key in WHERE clause or no LIMIT clausecheckbox to control the behavior of UPDATE and DELETE statements run from the MySQL Workbench.

Q: MySQL uses MySQL OLD transition variables with triggers to access old data updated or deleted from a table row.

Q: MySQL uses MySQL NEW transition variables with triggers to access new data inserted into a table row.

Q: MySQL uses the MySQL TODAYS_DATE() function to provide the value of the current date.

Q: MySQL uses the MySQL CALL statement to run a stored procedure.

Q: MySQL uses the MySQL LAST_INSERT_ID() function to provide the value of the most recently created surrogate key.

Q: MySQL supports INSTEAD OF triggers.

Q: MySQL supports AFTER triggers.

Q: MySQL supports BEFORE triggers.

Q: The MySQL END statement is used to complete the basic SQL block structure.

Q: The MySQL LOOP statement is used to repeat a set of SQL statements as long as some condition is true.

Q: The MySQL IF statement is used to test for a condition and then direct which blocks of code should be run depending on the outcome of the test.

Q: The MySQL block structure defines variables with the BEGIN keyword.

Q: The MySQL statement BEGIN is used to define a set of MySQL procedure statements.

Q: To execute an SQL query, click the "Execute the selected portion of the script or everything, if there is no selection" button.

Q: MySQL indexes can be created by using the GUI MySQL Table Editor or an SQL statement.

Q: In MySQL, surrogate keys that use a sequence maintained by MySQL should be given a data type of IDENTITY.

Q: To display an existing SQL script, click the "Open an SQL script file (in new query tab)" button.

Q: To run an SQL script, click the "Execute SQL Script (or selected portion)" button on the MySQL Workbench.

Q: SQL statements can be run individually or as part of a related group of SQL statements known as a script.

Q: The MySQL Table Editor is accessible from the MySQL Workbench.

Q: MySQL Workbench is the MySQL GUI database administration utility.

Q: MySQL Workbench is the MySQL GUI application development utility.

Q: The MySQL Command Line Client is the MySQL command line utility.

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

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

Q: Schema is the MySQL synonym for database.

Q: MySQL Community Edition uses only operating system authentication.

Q: Users log into MySQL Workbench using the Connect to Database and Connect to MySQL Server dialog boxes.

Q: To start working with MySQL Community Edition in Windows, use the command Start | All Programs | MySQL | MySQL Workbench CE 6.2. (or the version number you have installed).

Q: It is recommended that MySQL be used with the InnoDB storage engine.

Q: The spreadsheet data must first be highlighted (selected) in order to be imported using the MySQL for Excel Add-In.

Q: For use with this book, it is recommended that MySQL be configured as a developer machine.

Q: MySQL is configured using the MySQL Server Instance Configuration Wizard.

Q: The MySQL Workbench is included in the MySQL Server Community Edition installation.

Q: Microsoft Windows users should install MySQL Community Edition using the MySQL Installer for Windows.

Q: MySQL is an open source DBMS that only runs on Unix and Linux operating systems.

Q: In Oracle Database, indexes are created using the ALTER command.

Q: The Oracle Database FORMAT_DATE function can be used to make sure that Oracle Database interprets date data correctly.

Q: With Oracle Database, data must be entered at the Oracle Database command prompt.

Q: With Oracle Database, using a sequence does not guarantee valid surrogate key values.

Q: The CurrVal method provides the current value in a sequence.

Q: The NextVal method provides the next value in a sequence.

Q: Sequences are most often used to provide values for surrogate keys.

Q: When using Oracle Database, a sequence is an object that generates a sequential series of unique numbers.

Q: Oracle Database supports the ON UPDATE CASCADE constraint.

Q: The default file extension for text files created for SQL Developer is .sql.

Q: The Oracle Database GUI tool used for application development is the Oracle SQL Developer.

Q: Among its many functions, SQL*Plus is also a programming language.

Q: In Oracle Database security, a Role can have many system privileges.

Q: In Oracle Database security, a System Privilege is the right to execute general tasks such as performing some action on the database data.

Q: An Oracle Database tablespace is a logical subdivision of an Oracle database instance that is used to group related tables, views, and other similar objects.

Q: Each Oracle Database tablespace has one or more datafiles associated with it.

Q: Instead of creating a new database instance in Oracle Database, it is preferable to create a new tablespace.

Q: The Oracle Enterprise Manager Database Express 12c is a Web-based Oracle Database administration utility.

Q: When creating a new database in Oracle Database, two new account passwords are automatically created in the database.

Q: The Oracle Database Configuration Assistant is the easiest Oracle Database tool to use when you are creating an Oracle database.

Q: Oracle Database provides only one method for creating an Oracle Database database.

Q: Briefly explain the different types of files used by the Oracle Database recovery facilities.

Q: Briefly describe how Oracle Database implements serializable transaction isolation. Include an example.

Q: Explain the Oracle Database PL/SQL cursor statements.

Q: Explain the Oracle Database PL/SQL control-of-flow statements.

Q: Explain the Oracle Database PL/SQL Block Structure.

Q: Explain sequences and their relationship to surrogate keys. Include an example.

Q: What is the Oracle Enterprise Manager Database Express?

Q: What is the Database Configuration Assistant (DBCA)?

Q: What is SQL Developer?

Q: What is SQL*Plus?

Q: For which of the following types of failure would Oracle Database use Offline ReDo files as part of a recovery effort? A) Instance failure B) Application failure C) Media failure D) Logic failure

Q: For which of the following types of failure would Oracle Database use OnLine ReDo files as part of a recovery effort? A) Instance failure B) Application failure C) Media failure D) Logic failure

Q: Which of the following Oracle Database ReDo files are stored on disk and contain the rollback segments from recent database changes? A) OnLine ReDo files B) Active ReDo files C) OffLine ReDo files D) Archive ReDo files

Q: Which of the following is true of Oracle Database when the isolation level is set to Serializable? A) It will update any row having an SCN greater than the Transaction SCN. B) It will delete any row having an SCN greater than the Transaction SCN. C) It will read any row having an SCN greater than the Transaction SCN. D) It will wait for a blocking transaction to release an exclusive lock.

Q: In Oracle Database, to achieve transaction level consistency, which level of transaction isolation must be used? A) Read Committed B) Serializable C) Repeatable Read D) Read-only

Q: Which of the following is the default transaction isolation level offered by Oracle Database? A) Read Committed B) Serializable C) Repeatable Read D) Read Only

Q: Which of the following is not a transaction isolation level supported by Oracle Database? A) Read Committed B) Serializable C) Repeatable Read D) Read Only

Q: Which type of trigger is commonly used to update views? A) BEFORE triggers B) AFTER triggers C) SELECT triggers D) INSTEAD OF triggers

Q: In Oracle Database, which of the following prefixes is only available to triggers? A) :current B) := same C) :new D) := current