SQL Server 2000 There is only one way to create and modify tables in SQL Server. Write SQL code using either the CREATE or ALTER statements. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 What mode of authentication does SQL Server NOT provide? Both SQL Server and Windows-only security Windows-only security Mixed security SQL Server only security Both SQL Server and Windows-only security Windows-only security Mixed security SQL Server only security ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 With which type of SQL Server recovery model, is no logging done? Simple recovery Full recovery Bulk-logged recovery Differential recovery Simple recovery Full recovery Bulk-logged recovery Differential recovery ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 With this type of index, the data are stored in the bottom level of the index and in the same order as that index. Nonclustered Primary Secondary Clustered Nonclustered Primary Secondary Clustered ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 The .NET languages are the most popular languages for writing stored procedures in SQL Server 2000. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL Server 2000 By default, SQL Server will create one data file and one log file for each newly created database. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS