Index O

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X]

OBJECT ID  
OBJECT NAME  
object permissions   2nd   3rd   4th   5th   6th  
objectives
       altering database objects to support partitioned views  
       client/server configuration  
       controlling data access with views  
       data
               filtering with T-SQL  
               modifying and querying   2nd   3rd  
               summarizing  
       data manipulation
               managing  
               managing through views  
       database objects, creating and altering   2nd   3rd   4th  
       databases, creating and altering   2nd  
       designing a computing environment   2nd  
       domain integrity design  
       enforcing procedural business logic using transactions   2nd  
       entity definition  
       entity key design  
       environment restrictions   2nd  
       extracting data in XML format  
       filtering data  
       grouping data  
       heterogeneous data manipulation  
       importing and exporting data  
       importing data with OPENXML  
       indexing   2nd   3rd  
               creating indexes  
               implementing strategies  
               indexed views  
               maintaining  
       monitoring and tuning SQL Server databases   2nd   3rd   4th  
       normalization of databases  
       objects
               securing  
       optimizing
               SQL Server configurations  
       OS configurations
               optimizing  
       programming environment and coding language   2nd  
       programming objects
               troubleshooting  
       programming SQL Server 2000   2nd  
       query executions  
       replication methodologies   2nd  
       result sets
               managing with cursors and Transact -SQL  
       retrieving data  
       SQL Profiler
               monitoring activity  
       SQL Server features and characteristics   2nd  
       stored procedures   2nd   3rd   4th  
               enforcing procedural business logic  
               error handling  
               filtering data  
               managing data manipulation  
               passing and returning parameters  
       summarizing data  
       tools, utilities, SQL interface, and procedures   2nd  
       traces
               playback and diagnosis  
       triggers   2nd   3rd   4th   5th  
               managing data manipulation  
               security  
               troubleshooting  
       troubleshooting failed object creating  
       troubleshooting SQL Server objects  
        user -defined functions   2nd   3rd   4th  
               data manipulation  
               error handling  
               filtering data  
               passing and returing parameters  
               procedural business logic  
       View objectives   2nd   3rd   4th  
       views
               creating  
OBJECTPROPERTY  
objects
       database   2nd   3rd  
               creating and altering  
               tables   2nd   3rd   4th   5th   6th   7th   8th   9th   10th   11th   12th  
       placement in filegroups   2nd   3rd   4th  
       securing  
               C2 security  
               security audits   2nd  
               statement and object permissions   2nd   3rd  
       system
               hiding  
       troubleshooting  
ODBC Structured Query Language (OSQL)
       executing T-SQL programs   2nd   3rd  
       scheduling  
OFFLINE database configuration option  
OLE-DB providers   2nd  
OLTP (online transaction processing)  
ON DELETE clause  
ON UPDATE clause  
one- tier systems  
one-to-many relationship  
one-to-many relationships  
one-to-one relationship  
one-to-one relationships  
ONLINE database configuration option  
online transaction processing (OLTP)  
OPEN  
OPEN statement  
opening
       Query Analzyer  
OPENQUERY  
OPENQUERY function  
OPENROWSET   2nd  
OPENROWSET function   2nd   3rd   4th  
       creating linked servers   2nd   3rd   4th   5th   6th   7th  
       linked server usage   2nd  
OPENXML function   2nd   3rd  
       preparing XML documents   2nd  
       usage   2nd   3rd   4th   5th   6th  
operating system
       service properties, database recoverability   2nd   3rd  
operators   2nd   3rd  
       bitwise operators   2nd  
       filtering data   2nd  
               arithmetic operators   2nd  
               BETWEEN   2nd   3rd  
               comparison operators   2nd   3rd   4th   5th  
               IN   2nd   3rd  
               logical operators   2nd   3rd  
       unary operators   2nd  
OPTIMISTIC   2nd  
optimizing
       OS configurations   2nd  
               application log   2nd  
               counter values   2nd   3rd   4th  
               Event Viewer   2nd   3rd  
               query governor cost limit   2nd  
               System Monitor   2nd   3rd   4th  
       performance
               using views  
       SQL Server configurations  
               Current Activity window.   [See Current Activity window]
               stored procedures.   [See stored procedures]
options
       data integrity options  
options.   [See parameters]
OR  
ORDER
       data retrieval   2nd   3rd  
order
       of triggers  
               first and last   2nd  
               recursive triggers  
               type order   2nd  
ORDER BY  
order of operations
       filtering data  
ordered list questions
       MCP exams  
ordering
       data
               into lists   2nd  
       null values  
OS configurations
       optimizing   2nd  
               application log   2nd  
               counter values   2nd   3rd   4th  
               Event Viewer   2nd   3rd  
               query governor cost limit   2nd  
               with System Monitor   2nd   3rd   4th  
OSQL (ODBC Structured Query Language)
       executing T-SQL programs   2nd   3rd  
       scheduling  
OSQL utility  
outer joins   2nd  
       filtering out NULL values   2nd  
       types of   2nd   3rd   4th  
ownership chains
       broken ownership chains   2nd   3rd   4th   5th  
       views   2nd   3rd