| Author |
Topic |
|
hungleon88
Starting Member
16 Posts |
 Posted - 2008-08-23 : 05:47:08
|
| Bold Line is the choose1)Data rows of an Indexed view are stored in the _______ levels page of the clustered index.a)Childb)Leafc)Noodd)Root2)An trigger _____ is excuted when a new record is inserted in a table.a)Afterb)Deletec)Insertd)Update3)The purpose of a _____ column is uniquely indentify each record within a table.a)Primary Keyb)Foreign Keyc)Unique Keyd)Default Key4)Which of the following node contains data or index pages that point to data pages?a)Root Nodeb)Intermediate Nodesc)Leaf Nodesd)Branch Nodes5)Once a ______ clustered index is created on a view, multiple _____ indexes also can be created on it.a)Unique, Non-Clusteredb)Unique, Regularc)Non-Clustered, Uniqued)Non-Clustered, Regular6)Which of the following code creates a view named Passenger_Details with the SCHEMABIDING option?a)Create view Passenger_Details As Select SeatNo,PassengerName…b)Create view Passenger_Details with Schemabiding As…c)Create view Passenger_Details As Schemabiding…d)Create view Passenger_Details Schemabiding As…7)View definitions can be modified using the ____ statement while view data can be modified using the ___ statement.a)Alter View, Alterb)Alter, Alter Viewc)Alter View, Updated)Update, Alter View8)Stored procedures that run on remote SQL Server are known as___ strored procedures while___ are created in individual user databases.a)Extended, Temporaryb)Temporary, Extendedc)Local, Remoted)Remote, Local9)Which of the following statements about DML triggers order are correct?a)Multiple UPDATE triggers can be created for each triggering action on a tableb)Only one INSTEAD OF trigger can be created for each triggering action on a tablec)A triggering action can have multiple AFTER triggers with the same named)The sp_settriggerorder stored procedure can be used to define DML AFTER trigger order10)Which of the following code creates a computed column Area whose values are calculated from the values entered in the Length and Breadth fields?a)CREATE TABLE Calc_Area ( Length int, Breadth int, Area AS Length*Breadth)b)CREATE TABLE Calc_Area ( Length int, Breadth int) Area AS Length*Breadth)c)CREATE TABLE Calc_Area WITH Length int, Breadth int( Area AS Length*Breadth)d)CREATE TABLE Calc_Area Length int, Breadth int, Length*Breadth11)Which of the following code creates an index, IX_City on the City column of the Employee_Details table with FILLFACTOR values set to 70?a)CREATE INDEX IX_City ON Employee_Details(City) FILLFACTOR = 60b)CREATE INDEX IX_City ON Employee_Details(City) WITH (FILLFACTOR = 60)c)CREATE INDEX IX_City ON City WITH Employee_Details (FILLFACTOR = 60)d)CREATE INDEX IX_City ON City WITH FILLFACTOR = 6012)Unique Index can be created using either the ___ statement or using___.a)CREATE UNIQUE INDEX, SQL Server Management Studiob)ALTER UNIQUE INDEX, CREATE UNIQUE INDEXc)ALTER UNIQUE INDEX, SQL Server Management Studiod)CREATE INDEX UNIQUE, SQL Server Management Studio13)Which of the following statements about the different categories of system stored procedures are correct?a)Catalog stored procedures are used to access information from the system catalogb)Cursor procedures are used to implement the functionality of the cursorc)Databases Mail stored procedures are used in the managerment of distributed queries via maild)Security stored procedures are used to manage the security of the database14)Which of the following statements about triggers are correct?a)A trigger executes when an attempt is made to modify data in the table protected by itb)DML triggers execute when data is modified using the INSERT, UPADTE, or DELETE statementsc)DLL triggers execute when data is modified using the CREATE, ALTER, or DROP statementsd)Logon trigger execute stored procedures when a session is estapblished with a LOGIN event15)Which of the following statements about an DDL and DML triggers are correct?a)DDL trigger execute on INSERT, UPDATE, and DELETE statements while DML on CREATE, ALTER, and DROP statementsb)DDL triggers are used to check and control database operation while DML triggers are used enforce business rulesc)DDL triggers operate only after the table or viewis modify while DML triggers execute either during or after modificationd)DDL triggers are defined either at the databse or the server level while DML triggers are defined at the database level16)Which of the following statements about the different types of triggers are correct? a)The INSERT trigger ensures that the values being entered conforms to the constraints defined on that tableb)The UPDATE trigger copies the original record in the Deleted table and the new record into the Inserted tablec)The DELETE trigger help the user to delete a particular record in a tableor entires table themselvesd)An AFTER trigger is executed when the constraint check in the table is completed17)Which of the following code illustrates the procedure to begin the dialog conversation in SQL Service Broker?a)BEGIN DIALOG CONVERSATION FROM SERVICE service1 TO SERVICE ‘service2’…b)BEGIN DIALOG CONVERSATION @dialog_handle TO SERVICE ‘service2’ ON CONTRACT sendcontract…c)BEGIN DIALOG CONVERSATION SERVICE service1 ON CONTRACT sendcontract…d)BEGIN DIALOG CONVERSATION @dialog_handle FROM SERVICE service1 TO SERVICE ‘service2’…18)Stored procedures return information to the calling procedure using the ___ keyword.a)@@ERRORb)@@ERROR_LINEc)OUTPUTd)RETURN19)Which of the following code display all the information about the indexes created on the Customer_Details table?a)sp_helpindex’Customer_Details’b)EXEC sp_helpindex’Customer_Details’c)EXEC sp_help_index Customer_Detailsd)Sp_helpindex ‘Customer_Details’20)Which of the following is not a valid rule while maintaining data integrity?a)No two records in a table can have exactly same values in all columnsb)Any type of data can be insertedc)Data validity has to be maintained when data is modifiedd)Change to data values in a column should be appropriately refected in related table21) ______ are constraints that control the data values being entered ina)Triggerb)Rulesc)Validityd)Verification22)A column with__________ allows a null value to be inserted once .a)Primary key constraintb)Indentity Propertyc)Unique constraintd)Check constraint23 ).Which of the following stores data in an unsorted order ?a) Heapb) B_Treec) Clustered Indexd)IAM_ page24)Which of the following statements about Views are correct ?a)The Check Option ensures updates in the view satisfy all view conditions.b)The Check Option is only associated with the Alter View statements.c) The Check Option is used to enforce referential integrity among tables .d)The Check Option option ensures that the Where clause is not violated .25) _______Stored procedures executed outside the SQL Server…a)Catalog b)Distributedc)Extended d)Temporary 26)Which of the following statements about system stored procedures are correct ?a)System stored procedures are sets of Transact_SQL statements executed as a single unit b)System stored procedures are physically stored in the System database and have the sp_' .c)System stored procedures are used in database administrative and informational activities .d)System stored procedures access to the database object metadata information. |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-08-23 : 05:48:28
|
| Duplicatehttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=109371 |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
hungleon88
Starting Member
16 Posts |
Posted - 2008-08-23 : 06:42:38
|
| i really dont want to spam T_T, please help me check this?? everything right?? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-23 : 07:13:43
|
| Have you had time to check this with books online or search google on this? |
|
|
|
hungleon88
Starting Member
16 Posts |
Posted - 2008-08-23 : 15:26:52
|
| No, i just need you guys help me check whats i choose.i choose but dont really know that right or wrong. that's all.If you dont really want to help, thanks for reply |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-08-24 : 13:33:06
|
quote:
Originally posted by hungleon88
No, i just need you guys help me check whats i choose.i choose but dont really know that right or wrong. that's all.If you dont really want to help, thanks for reply
Its not that we dont want to help. But we just wanted to see if you've tried it yourself. We dont want to spoonfeed you the answers. What you've posted are just theoretical questions whose description can be found in books online. Only when you refer and find the answer you will get an idea of what they mean.Which part you had difficulty in refering to? |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2008-08-24 : 16:24:40
|
| Test or homework?--Gail ShawSQL Server MVP |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2008-08-24 : 17:22:42
|
quote:
Originally posted by GilaMonster
Test or homework?--Gail ShawSQL Server MVP
Must be a test  |
|
|
|
hungleon88
Starting Member
16 Posts |
Posted - 2008-08-25 : 10:00:51
|
| okieeee, thanksssssssss for replyyyyyyyyyyyy, i will check this by myselffffff!!!! |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-08-25 : 10:05:13
|
That's the attitude. Now you learn!
E 12°55'05.25"N 56°04'39.16" |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-08-25 : 10:07:00
|
Regarding 18)What kind of information?
E 12°55'05.25"N 56°04'39.16" |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2008-08-25 : 10:50:24
|
quote:
19)Which of the following code display all the information about the indexes created on the Customer_Details table?a)sp_helpindex’Customer_Details’b)EXEC sp_helpindex’Customer_Details’c)EXEC sp_help_index Customer_Detailsd)Sp_helpindex ‘Customer_Details’
This is why I never take any MCP exams...this question is so stupid I don't even know whether to laugh or cry.- Lumbago |
|
|
|
|
Please help me check these question!!!!
Help ! somebody press the [BREAK] key please . . !