We can not execute a stored procedure on either local or remote SQL Server.

Stored procedures are compiled the first time they’re run but are not stored in a system table of the current database.

'Select Into'Statement retrieves rows and columns from one source table to a target table.

__is an interface you can use to write both SQL and PL/SQL scripts

___is the language used to put data into the database, retrieve data from the database, control transactions, and administer your database

__is the procedural programming language of Oracle, and with it you can write custom programs and procedural code for execution inside the database

____setting that indicates the number of records that must be returned in the query results for SQL*Plus to show the message

PAUSE command is useful, when you execute a query that is longer than a page in size, the output will stop until you hit the Enter key.

Main functions in parsing process are____

___is the act of breaking the submitted statement down into its component parts, determining what type of statement it is (query, DML, or DDL), and performing various checks on it

Select the steps involved in executing statements in Oracle

View has no physical existence until it is called upon in a query

What is a catalog??

How many default instances can you install on a single SQL Server server?

Which authentication mode lets you use both SQL Server logins and Windows logins?

Which SQL Server 2005 services require that you install them with their own account? (Choose all that apply.)

The term “in-place upgrade” refers to which type of upgrade?

Which upgrade data-movement method requires that users not be accessing the database you want to upgrade?

Which of the following statements can you use to create a filegroup?

Which of the following are valid filegroup types? (Choose all that apply.)