Design

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

Q: Which of the following can Oracle Database not support? A) Triggers that are fired when a user logs in to the database B) Triggers that are fired before each row change in a table C) Triggers that are fired once when changes are made to rows in a table D) Triggers that are fired after each row change in a table

Q: Which of the following is true about stored procedures in Oracle Database? A) They cannot invoke other procedures. B) They must include the data type and length of parameters. C) They can raise exceptions. D) They do not contain variables.

Q: Which of the following is not true of stored procedures in Oracle Database? A) They are programs. B) They can have parameters. C) They can be invoked remotely. D) They can be written in C++.

Q: Which of the following Oracle Database PL/SQL statements is not used to create a block of code that repeats while some condition is true? A) FOR B) WHILE C) BEGIN D) LOOP

Q: The Oracle Database PL/SQL statement used to complete the basic PL/SQL block structure is ________. A) DECLARE B) BEGIN C) IF...ELSE...END IF D) END;

Q: The Oracle Database PL/SQL statement used to repeat a set of PL/SQL statements as long as some condition is true is ________. A) DECLARE B) BEGIN C) IF...ELSE...END IF D) LOOP

Q: The Oracle database PL/SQL statement used to test for a condition and then direct when blocks of code should be run depending on the outcome of the test is ________. A) DECLARE B) BEGIN C) IF...THEN...ELSE...END IF D) LOOP

Q: The Oracle Database PL/SQL statement used to define a set of PL/SQL statements is ________. A) DECLARE B) BEGIN C) IF...THEN...ELSE...END IF D) LOOP

Q: The Oracle Database PL/SQL block structure begins with ________. A) DECLARE B) BEGIN C) IF...THEN...ELSE...END IF D) LOOP

Q: The Oracle Database variant of SQL with additional procedural language components is ________. A) T-SQL B) PL/SQL C) My/SQL D) MS/SQL

Q: Copying spreadsheet data into a database is part of a larger data warehousing process known as ________. A) import/export B) spreadsheet conversion C) extract, transform, and load D) data verification

Q: During the data import process in Oracle, if some of the spreadsheet cells in a column of the source data are empty, ________. A) you must put some data in them before importing B) you must not specify this column as a foreign key later C) you must ensure the data type for this column is numeric D) you must check the "Nullable" box in the wizard

Q: One limitation of the Oracle Data Import Wizard is that it ________. A) does not allow addition of a new primary key column B) does not allow data to be imported into an existing table C) does not allow import of "date" type data D) only allows import of data from Microsoft Excel, no other formats

Q: The Oracle tool used to copy data into a database table from a spreadsheet is called the ________. A) Spreadsheet Wizard B) Data Import Wizard C) Database Configuration Assistant D) Enterprise Manager Database Express

Q: The GUI tool for creating a new index is the Oracle SQL Developer ________. A) Edit Table table editor B) Edit Index index editor C) Edit Schema schema editor D) Physical Design editor

Q: Which of the following tasks cannot be done using the Oracle SQL Developer GUI features? A) See the structure of a table B) Add and remove columns from a table C) Insert and delete data from a table D) Create a new tablespace

Q: Which of the following is a GUI tool for application development with Oracle Database? A) The Oracle Enterprise Manager Database Express B) The Oracle SQL*Plus command utility program C) The Oracle SQL Developer D) The Oracle Database Configuration Assistant

Q: Which of the following statements would cause Oracle Database to include a new column named C5, which is a two-digit whole number, to a table named T2? A) UPDATE TABLE T2 ADD COLUMN C5 NUMBER (2); B) ALTER TABLE T2 ADD C5 NUMBER (2); C) UPDATE TABLE T2 INSERT C5 NUMBER (2,0); D) ALTER TABLE T2 INSERT COLUMN C5 NUMBER (2,0);

Q: If the SQL statement SELECT C1, C2, C3 FROM T4 WHERE C2 = 'Smith'; is frequently executed, which column(s) should be considered for indexing based only on the statement itself? A) C1 only B) C2 only C) C3 only D) C1 and C2

1 2 3 … 68 Next »

Subjects