80 |
CREATE TABLE is used |
Books-online: CREATE TABLE statement |
81 |
How will you delete a column? |
|
62 |
How shall a column be referenced in INSERT? (Choose 2) |
???? |
|
18 |
How to use the INSERT statement with an identity column? |
|
Indexes & Using Views, Defaults, and Rules
125 |
What is the reason for creating an Index? |
|
41 |
There is one organization, which deals with bank transaction. All account heads are stored in ACCT_HEAD, while all transactions are stored in DAILY_TRAN. There is heavy traffic involved in sales. Since it involves an online update the ACCT_HEAD is . |
???? |
|
42 |
Data and leaf pages are one and same in case of: |
|
43 |
There is file Reservation which involved in on-line reservation, cancellation and booking . There is already an non-clustered index existing. Due to heavy transaction it is taking a very long time to insert the data. What is the best way to solve? |
???? |
|
93 |
The advantage of composite index is |
???? |
|
48 |
______ page is unaffected by fillfactor. |
|
115 |
What type of lock is created when an Index is created? |
|
44 |
The 2 ways to force an index reference to the option is? |
|
29 |
What happens to the data in a table when a clustered index is created? |
|
31 ??? |
You are working with
as application that contains customer table and sales items table, most of the traffic in
sales items involves searching customer records and there are 100 to 10000 rows per
record. Although a high number of rows are often in or A scenario question where 100-1000 rows get entered at a time, with NO changes after info entered. The table is sales items for and order. You are inserting rows into sales items. Create index on sales items. |
???? |
|
33 |
A composite index of 200 bytes width is created. The first logical column in the index has very few unique data, whereas the second column has many. How can you change the index so that the performance increases? |
|
34 |
How does SQL Server implement PK constraint in a CREATE TABLE ? |
|
18 |
How to encrypt a view? |
. WITH ENCRYPTION AS select_statement [WITH CHECK OPTION] |
127 |
How can you hide the view definitions? |
|
5 |
How data is store in a view? |
|
32 |
Which statements are true about binding and unbinding defaults? |
|
24 |
What is true about DEFAULTS? |
|
6 |
You create a default on a column. How do you use this with data modification statements? (select several) |
|
65 |
Where all Defaults can be used? |
|
27 |
What is TRUE about RULE? |
|
10 |
Will Rules be bound automatically to all tables with user-defined datatype after Rule has been bind to the datatype? |
|
97 |
A rule is bound to a datatype, so |
|
99 |
I have created a view on a table, dropping the table will result in |
|
3 |
Which object is dropped when a table is dropped? |
|
83 |
If a table is dropped, which is getting dropped automatically? |
|
1 |
Rules and triggers are enforced on: |
|
Triggers & Programmability
30 |
How can you access the data being modified during the execution of a trigger? |
|
130 |
How can you use triggers to maintain data integrity? |
|
64 |
Where are the modified data stored when a update trigger is executed? |
|
12 |
Where is the location inserted and deleted tables? |
|
102 |
Triggers get executed in response to a ________ getting modified |
|
103 |
How does SQL server allow you to take a corrective action? |
|
104 |
Whenever corrective action needs to be taken and business rules is to be used |
|
35 |
How do you ensure business rules take corrective action? |
|
38 |
Triggers are best used for? |
|
23 |
When does a trigger fire? |
|
28 |
Triggers are created for data integrity and operate at: |
|
8 |
How is EXECUTE statement used other than executing stored procedure? |
|
39 |
The c1 cursor is based on customer table. Which UPDATE statement should you use to update the current row in c1? |
|
40 |
Using FETCH NEXT statement you are retrieving a row. Now delete the row returned by the FETCH statement. |
|
63 |
How are user defined stored procedure created and stored as database objects? |
???? |
|
95 |
How can I achieve maximum security when I have a stored procedure? |
|
111 |
Stored procedures are a collection of |
|
112 |
Sending error message to client with column name in message |
|
113 |
If @objname references
a table name, what happens with the folllowing statment: exec ('exec sp_spaceused ' + @objname + ", @updateusage = true') |
|
Replication & Application Development and Open Data Services
98 |
Collection point for all public data is |
|
4 |
In a Central Subscriber scenario, how is data integrity maintained? |
|
113 |
How does subscription server maintain data integrity? |
|
12 |
How do you maintain data integrity for replication when there are multiple publication servers and a single subscription server scenario? (choose two) |
|
72 |
How does the publisher maintain the data integrity? |
?? |
|
129 |
You are working on an environment that has heavy online transaction processing. How should you manage the distribution process to ensure the workload is reduced? |
|
131 |
You are copying data from a mainframe through bcp. It has to be sent to 20 SQL servers on the network. What has to be done? |
|
132 |
When does synchronization happen? |
?? |
|
131 |
You are in the middle
of a replication process, and the transaction log on the publisher becomes full. What
should be done? |
?? |
|
106 |
You have 2 hours in hand to update the transaction. What will you do? |
?? |
|
70 |
Mail feature of SQL Server is implemented by using |
|
112 | You access the SQL server with an application using DMF. Which one of the following are you allowed to access? |
????? |
|
71 |
What is ODBC? |
|
105 |
Multiple servers are managed by SQL server using |
|
88 |
How can OLE automation objects be used? |
????? |
|
61 |
What shall be included to take advantage of OLE? |
???? |
|
68 |
DMO object is used for? |
|
7 |
How do you use SQL-DMO to schedule tasks and alerts? |
???? |
|
123 |
What is DMO (Distributed Management Object)? |
|
87 |
DMO objects to enable affecting tasks & events |
|
128 |
You want to take advantage of DMO objects what will you do? |
????? |
|