databases Online Quiz - 36
|Description: databases Online Quiz - 36|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
You want to track date and time of the last write access (INSERT, UPDATE) per row. How can you achieve that?
What is the result of the following statement: select cast(floor(cast(@MyDateTime as float)) as datetime)
Which classes from the .NET Framework can be used in SQLCLR assemblies with permission set SAFE?
How long does it approximately take to create a snapshot of a 100GB database on a state-of-the-art Quadcore server using RAID 5?
What was a problem with navigational data access languages?
Which is a major problem with SQL?
Which of the following is an important feature of relational databases and SQL?
Which of the following is an important consideration when tuning an SQL statement?
Which of the following database design features is most important to SQL performance?
Index will not be used if ... Choose all that apply.
Which of the following conditions will you use in a WHERE clause to select all last names that start with S?
What is the best data type to store the birthdays of the US Presidents, starting with George Washington's birthday of February 22, 1732?
Which of the following is NOT a valid description of the public role?
What's the maximum value can an INT data type hold?
What will be the result of the following SELECT statement SELECT 2000/02/25 + 4
What's the earliest date that can be stored in a DATETIME data type?
Which of the following fixed database roles can add or remove user IDs?
Which of the following data types has the least data type precedence?
What's the maximum number of parameters can a SQL Server 2000 stored procedure have?
Which part of the following function definition will generate an error?CREATE FUNCTION dbo.Tomorrow ()RETURNS DATETIMEASBEGIN DECLARE @TodaysDate DATETIME SET @TodaysDate = GETDATE() SET @TodaysDate = DATEADD(DD, DATEDIFF(DD, 0, @TodaysDate), 0) RETURN DATEADD(DD, 1, @TodaysDate)ENDGO