Q&A Hero

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

Q: If T3 is a table with three columns C1, C2, and C3, where C1 is integer data, C2 is character data, and C3 is date data, which of the following would be the proper statement to have Oracle Database enter the date 02/10/03 into a row in table T3 while making sure that it is formatted correctly as shown? A) SET INTO T3 VALUES (101, 'Smith', '02/10/13'); B) SET INTO T3 VALUES (101, 'Smith', TO_DATE ('02/10/13', 'DD/MM/YY')); C) INSERT INTO T3 VALUES (101, 'Smith', '02/10/2013'); D) INSERT INTO T3 VALUES (101, 'Smith', TO_DATE ('02/10/13', 'DD/MM/YY'));

Q: Which method returns the next value in a sequence? A) CountVal B) Next C) UpVal D) NextVal

Q: When creating tables, Oracle Database automatically converts the SQL standard data type "int" into ________. A) number (38,0) B) integer (32) C) number (5,0) D) integer (16)

Q: Which of the following commands does Oracle Database not support? A) CREATE TABLE B) CREATE CONSTRAINT C) ON DELETE CASCADE D) ON UPDATE CASCADE

Q: Which of the following Oracle Database structures is a logical subdivision of an Oracle Database database instance that is used to group related tables, views, and other similar objects? A) Namespace B) Filespace C) Tablespace D) Dataspace

Q: Which of the following is a tool for managing an existing Oracle Database database? A) The Oracle Enterprise Manager Database Express B) The Oracle SQL*Plus command utility program C) The Oracle SQL Developer D) The Oracle DBA Manager

Q: Which of the following is an account name for which you are asked to enter a password when Oracle Database creates a new database? A) ORACLE B) SYS C) INTERNAL D) DBA

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

Q: In Oracle Database backup and recovery facilities, a consistent backup is one in which all uncommitted changes have been removed from the datafiles.

Q: The type of failure that occurs when Oracle Database is unable to write to a physical file is called a media failure.

Q: The type of failure that occurs when Oracle Database itself fails due to an operating system or computer hardware failure is called an instance failure.

Q: In Oracle Database recovery facilities, OnLine ReDo files are backup log files maintained separately and not necessarily on disk media.

Q: In Oracle Database recovery facilities, OnLine ReDo files are maintained on disk and contain the rollback segments from recent database changes.

Q: In Oracle Database recovery facilities, control files are small files that describe the name, contents, and locations of various files used by Oracle Database.

Q: Oracle Database does not require the use of Archive ReDo files for instance recovery.

Q: In the event of an application failure, Oracle Database uses the in-memory rollback segments and OnLine ReDo files to recover.

Q: Control files, as used by Oracle Database's backup and recovery features, contain records of database changes.

Q: With Oracle Database, you can change the default transaction isolation for all transactions in a session by using the SET TRANSACTION ISOLATION LEVEL statement.

Q: The default isolation level in Oracle Database is Read Committed, which provides statement level isolation.

Q: Oracle Database only reads committed changes, and therefore dirty reads are not possible.

Q: The Read Only transaction isolation level is unique to Oracle Database.

Q: Oracle Database uses a System Change Number (SCN) to identify before images in rollback segments to prevent dirty reads.

Q: The prefix :old is used to make previous values of columns available to update and delete triggers.

Q: The prefix :new is used to make final values of columns available to insert and update triggers.

Q: SOONER and LATER triggers are placed on tables.

Q: INSTEAD OF triggers are placed on views.

Q: In Oracle Database, triggers that are fired once for each row that is changed in a table are called row triggers.

Q: Oracle Database triggers BEFORE and AFTER are placed on tables, while the INSTEAD OF trigger is placed on views.

Q: All Oracle Database triggers work at the row level.

Q: Oracle Database triggers are PL/SQL or Java procedures that are invoked when specified database activity occurs.

Q: You can include single line comments in an Oracle Database stored procedure by starting each comment line with the /* symbol.

Q: If you include a slash as the last line in an Oracle stored procedure, the procedure will be compiled and stored when you run the block of code.

Q: With Oracle Database, stored procedures cannot use a cursor variable, so another method must be used to access a table on a row by row basis.

Q: The PL/SQL keyword RETURN is used to exit a block of code and terminate whatever code structure is running.

Q: The PL/SQL keyword STOP HERE is used to complete the basic PL/SQL block structure.

Q: The PL/SQL keywords FOR, WHILE, and LOOP are used to create blocks of code that repeat until an ending condition is reached.

Q: The PL/SQL keyword ISTHERE is used to test for the existence of a condition.

Q: The PL/SQL keyword BEGIN is used to define a group of PL/SQL statements.

Q: The PL/SQL keyword DECLARE is used to begin the basic PL/SQL block structure.

Q: With Oracle Database, stored procedures can be invoked remotely.

Q: You can use the Edit Table table editor to create an index in Oracle Database.

Q: The Oracle SQL Developer has no facility for executing SQL statements.

Q: The Oracle Database Enterprise Manager Database Express provides graphical facilities for managing databases.

Q: The Oracle Database GUI is the Oracle SQL Browser.

Q: Oracle Database uses the SQL ALTERTABLE command to change the structure of a table.

Q: Briefly explain the process for importing spreadsheet data into a SQL Server table, and indicate some of the pitfalls or potential problems.

Q: Briefly explain the different SQL Server recovery models.

Q: Briefly explain the different SQL Server backup types.

Q: Briefly describe how a developer defines the type of locking behavior to be used with SQL Server.

Q: Explain how to work around the SQL Server IDENTITY constraint when non-sequential data must be entered.

Q: Explain the SQL Server IDENTITY constraint.

Q: Explain SQL Server indexes.

Q: What is the SQL CLR?

Q: Discuss the Microsoft PowerShell utility.

Q: Explain two ways of creating tables in SQL Server.

Q: Describe the database files that are automatically created when a new database is created in SQL Server.

Q: Which of the following is a type of recovery model supported in SQL Server in which all database changes are logged? A) Bulk logged B) Full C) Simple D) Complete

Q: Which type of backup in SQL Server will create a backup of the entire database? A) Full backup B) Transaction backup C) Database backup D) Complete backup

Q: Specifying locking hints in which parameter in an SQL clause can modify locking behavior in SQL Server? A) SELECT B) WITH C) LOCK D) HINT

Q: The default cursor concurrency setting for a keyset cursor in SQL Server is ________. A) Pessimistic B) Optimistic C) Serializable D) Read only

Q: The default cursor concurrency setting for a static cursor in SQL Server is ________. A) SCROLL_LOCK B) Optimistic C) Serializable D) Read only