databases Online Quiz - 130
|Description: databases Online Quiz - 130|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
Stored procedures are compiled the first time they’re run but are not stored in a system table of the current database.
___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
View has no physical existence until it is called upon in a query
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?
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?