TEST 2
Which of the following conditions will you use in a WHERE clause to select all last names that start with J?
WHERE LastName LIKE 'J%'
Which syntax should you use to create the object
CREATE TABLE Campers ( ID INT Name VARCHAR(25) Cabin INT)
CREATE VIEW cambridge_data AS SELECT NoControl, FUllName FROM cambridge ORDER BY FullName
A SQL Server Database Error because the ORDER BY clause is not valid in the creation of a view.
UPS is the best method to prevent the loss of data.
Backup
If the database fails on Saturday morning, what should you do first? How many differential backups must you restore?
Backup the transaction log 1
A clustered index improves the performance of which types of queries?
Queries that return large result sets
which of the following range conditions would generate a syntax error?
Salary between (10000 AND 50000) AND (60000 and 90000)
SELECT CHARINDEX('GM','The best TTS solutions are provided by GMetrix', -1)
40
What will be the result of the following statement? select str(938.56, 6, 1)
938.6
Which is a major difference between a stored procedure and a function?
Function must be compiled every time it is called
You need to insert a new product
INSERT INTO Cookies (Name, CookieID) VALUES ('Snickerdoodle', 77)
What is the best data type to store the birthdays of the greatest scientists, starting with Leonardo Da Vinci's birthday of April 15, 1452
INT
Float is the best data type to calculate a percentage value
No change is needed
SELECT GETDATE() + 3
05/04/2011 09:23 am
Which of the following could not be used as a primary key?
A table containing only one FOREIGN key
Minus is a reserved keyword in SQL Server 2008 and therefore cannot be used as an object name or as a column name in a table, unless delimited.
ADD
What is the right way to get an accurate count of the number of records in table1
All of the above
REMOVE erases data from a table
DELETE
Which Transact-SQL command removes a table from the database
DROP TABLE
Which three are fixed server roles?
Diskadmin, Setupadmin, Securityadmin
A user needs the ALLOW permission to run a stored procedure
EXECUTE
Which of the following is NOT stored in the sysobjects system table
Indexes
What are the entities that can be viewed in the SQL Server Utility
Instances of SQL Server, Data-Tier apps, Database Files, Volumes
What is collation
It refers to a set of rules that determine how data is sorted and compared
you need to create a query that will display
SELECT * FROM clients WHERE state - 'New MExico' AND city = 'Rosewell'
What is the statement to use to suppress the '(1 row(s) affected.' after executing query statements
SET NOCOUNT ON
You have a column that will only contain values from 0 to 1024. What is the most economical data type to use for the column?
SMALLINT
Which Transact-SQL command removes all rows from a table without logging the individual row deletions?
TRUNCATE TABLE
SELECT REPLACE('The best TTS solutions is provided by GMetrix','s','z')
The Bezt TTz Zolutionz is provided by GMetrix
SELECT CAST(-1 AS SMALLDATETIME)
The system will generate an error
When should you use an UPDATE statement
To modify a set of existing table rows
Primary key constraint
Yes, no, yes, yes
Which three are true statements about Foreign Keys? (Choose 3)
a combination, defining a foreign key, enforces referential integrity
What is a subquery?
a select statement
Which of the following can be used to improve query performance?
all of the above
A table provides structure to store data--YES A databse retrieves data from different tables and views--YES A database cannot parse out redundant data-- NO A table can be created in a graphical interface or by using syntax--YES
nah ni99a
ALTER TABLE COMMANDS yes, yes, yes, no
nah ni99a
D8CC CHECKDB- Ensures that tables in the database and the indexes are correctly linked. DBCC CHECKALLOC- Checks that all pages in a database are correctly allocated. DBCC CHECKFILEGROUP- Checks the all tables file group for any damage. DBCC CHECKLINK- is not a supported command
nah ni99a
The first normal form requires that the database exclude which one of the following?
repeating groups
the username that failed to logon was ___ what is the reason the logon failed?
test user 1 Too early