<<= Back Next =>>
You Are On Multi Choice Question Bank SET 925

46251. SQL Server 2000 stored procedures can:




46252. With this type of SQL Server cursor concurrency no lock is obtained until the user updates the data.





46253. An SQL Server 2000 language that adds programming elements like parameters, variables, IF, WHILE loops, and so forth, to the basic capabilities of SQL is called:





46254. With this type of index, the data are stored in the bottom level of the index and in the same order as that index.





46255. In SQL Server 2000, which of the following makes a copy of the changes that have been made to the database since the last complete backup?





46256. With this type of index, the bottom level of an index does not contain data, but rather it contains pointers to data.





46257. With which type of SQL Server recovery model are all database changes logged?





46258. SQL Server automatically creates an index on:





46259. Which of the following is not a factor in determining the concurrency control behavior of SQL Server?





46260. SQL Server program code that is executed after an SQL command has been processed is called a(n):





46261. Which of the following refers to the SQL Server transaction isolation level which places and holds locks on all rows that are read?





46262. There is only one way to create and modify tables in SQL Server. Write SQL code using either the CREATE or ALTER statements.



46263. SQL Server automatically creates an index on all primary and foreign keys.



46264. An SQL Server reserved word must be placed in brackets. If the word is not in brackets, SQL Server will try to interpret it as the name of one of its special words.



46265. With SQL Server, parameters and variables in T-SQL start with the "%" sign.



46266. Nonclustered indexes are faster than clustered indexes for retrieval.



46267. SQL Server supports INSTEAD OF, AFTER and BEFORE triggers.



46268. SQL Server supports two kinds of indexes: clustered and nonclustered.



46269. SQL Server indexes are special data structures used to improve performance.



46270. SQL Server supports a language called Transact-SQL (also called T-SQL).



46271. The .NET languages are the most popular languages for writing stored procedures in SQL Server 2000.



46272. READ COMMITTED is the default isolation level.



46273. A differential backup makes a copy of the entire database.



46274. SQL Server supports three recovery modes: simple, full and Bulk.



46275. SERIALIZABLE is the strictest isolation level.



46276. With SQL Server pessimistic locking, no lock is obtained until the user updates the data.



46277. Better security occurs if Windows-only authentication is selected.



46278. SQL Server AFTER Triggers may be assigned views.



46279. 'dbo' stands for database object.



46280. With SQL Server optimistic locking, an update lock is placed on the row when the row is read.



46281. By default, SQL Server will create one data file and one log file for each newly created database.



46282. With which type of SQL Server recovery model are all database changes logged except those that cause large log entries?





46283. Using SQL Server 2000, which of the following symbols is used to indicate parameters in stored procedures?





46284. What mode of authentication does SQL Server NOT provide?





46285. The strictest transaction isolation level provided by SQL Server is called:





46286. SQL Server program code that is executed instead of an SQL command that needs to be processed is called a(n):





46287. The type of body movement of a vehicle in which the vehicle turn on its own longitudinal axis is:





46288. Which gear will not revolve when the vehicle is moving on straight path?





46289. The rear axle thrust acting on rear axle casing is transferred to frame by:





46290. Compared with spiral bevel gear,a hypoid gear has the advantage of:





46291. The pollutant that forms at higher combustion temperatures is:





46292. Which of the following occurs when a transaction rereads data it has previously read and finds modification or deletions caused by a committed transaction?





46293. The advantage of optimistic locking is that:





46294. Which of the following refers to a cursor type that when the cursor is opened, a primary key value is saved for each row in the recordset; when the application accesses a row, the key is used to fetch the current values of the row?





46295. Which of the following refers to a cursor type where changes of any type and from any source are visible?





46296. Which of the following disallows both dirty reads and nonrepeatable reads, but allows phantom reads?





46297. Dirty read, nonrepeatable, and phantom reads are not possible in this instance.





46298. A transaction in which either all of the database actions occur or none of them do is called:





46299. A cursor type in which the application can only move forward through the recordset is called:





46300. Which of the following occurs when one transaction reads a changed record that has not been committed to the database?





<<= Back Next =>>
Terms And Service:We do not guarantee the accuracy of available data ..We Provide Information On Public Data.. Please consult an expert before using this data for commercial or personal use | Powered By:Omega Web Solutions
© 2002-2017 Omega Education PVT LTD...Privacy | Terms And Conditions
Question ANSWER With Solution