Q&A Hero

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

Q: Which of the following is a type of cursor concurrency that causes SQL Server to place an update lock on a row when the row is read? A) SCROLL_LOCK B) Optimistic C) Serializable D) Read only

Q: Which of the following is the most restrictive transaction isolation level option supported by SQL Server? A) Repeatable Read B) Read Committed C) Serializable D) Read Uncommitted

Q: Which of the following is the default transaction isolation level for SQL Server? A) Repeatable Read B) Read Committed C) Serializable D) Read Uncommitted

Q: Which of the following is not a transaction isolation level supported by SQL Server? A) Pessimistic B) Read Committed C) Serializable D) Read Uncommitted

Q: Which of the following is not a lock granularity supported by SQL Server? A) Row B) Attribute C) Table D) Page

Q: For triggers on insert and update actions, the new column values are stored in ________. A) a table named new:TableName B) a table named old:TableName C) a pseudotable name inserted D) a pseudotable named deleted

Q: SQL Server system function names start with the symbol ________. A) @@ B) # C) ## D) @

Q: A view may not be assigned to a(n) ________. A) BEFORE trigger B) INSTEAD OF trigger C) CONCURRENT trigger D) AFTER trigger

Q: Which of the following is not a type of trigger supported by SQL Server? A) BEFORE B) INSTEAD OF C) CONCURRENT D) Both A and C are correct

Q: SQL Server user variables and parameters start with the symbol ________. A) @@ B) # C) ## D) @

Q: A stored procedure can be stored in a text file and run with the Microsoft SQL Server Management Studio. If we are running the code that creates this procedure for the third time, it must start with ________. A) RUN PROCEDURE B) CREATE PROCEDURE C) ALTER PROCEDURE D) MODIFY PROCEDURE

Q: Which of the following is known to be true if the command EXECabcCust @Cost = 5 is used in SQL to invoke a stored procedure in Microsoft SQL Server? A) The name of the stored procedure is abcCust. B) The name of the stored procedure is abc. C) The parameter Cost is given a value of 5. D) Both A and C are correct.

Q: The language available in SQL Server that adds programming constructs to the SQL language is known as ________. A) PL/SQL B) C++ C) INTERACT-SQL D) TRANSACT-SQL

Q: Which of the following is true about the SQL Server Import and Export Wizard? A) The spreadsheet data must already be normalized in order to be imported. B) There may be problems importing Excel 2013 data and we may need to install Excel 2007 compatibility software. C) The Import and Export Wizard sometimes creates blank rows at the end of the imported table. D) Both B and C are correct.

Q: Which type of index in SQL Server is faster for data retrieval? A) Clustered B) Nonclustered C) Baseline D) There is no advantage to any particular index for data retrieval, only for data updating.

Q: Which of the following is true of clustered indexes? A) They are normally slower than nonclustered indexes for retrieving data. B) Only one is allowed per table. C) They are normally slower than nonclustered indexes for updating data. D) They do not have data in the bottom level.

Q: Which type(s) of index in SQL Server has/have a bottom level that does not contain data but has pointers to the data? A) Clustered B) Nonclustered C) Unique D) Both A and B are correct

Q: Which of the following is true about indexes in SQL Server? A) SQL Server automatically creates indexes for columns appearing in WHERE clauses in queries. B) SQL Server pads all indexes. C) SQL Server supports filling up to a limit of 70 percent. D) SQL Server automatically creates indexes for foreign keys.

Q: When creating a T-SQL statement, you should ________. A) predefine it graphically in Enterprise Manager B) limit it to one table C) limit it to two tables D) end it with the semicolon normally used to terminate SQL statements