1. RUNSTATS Command can be used to get the statistics about given choices
a) Table
b) Database
c) Row
d) Index, all of the above was also given.
2. Whats the command to combine the Full copy and Incremental copy given 4 different copy commnds to choose.
a) Copy
b) Load
c) Merge copy and one more option was given.
1. Is it possible for the application programmers to change the value of Current SQLID register value.
Choces true or false.
2. Given an Co-related Sub Query with stmt like
Update table2 set val1= val1 + 50
Where val1 in (select * from table1);
Asked to chose the number of rows updated by giving choices.
3. When a Distributed Data Facility is Planned then which of the skill is not required
a) DBA
b) Strategist
c) Business Analyst
d) LAN administrator.
4. Question was given on Whats Index key, is used for ?
Giving 4 choices, find it difficult to answer.
5. Whats 1NF?
Choices was given on 2NF and 3NF defintions and none of the above.
6. One Question was based on refrences keyword .
7. One question was given on Column name on Group by and Order by clause and its select statements regarding the column names. This question most of them will know the answer, its an important Question I Say. Set of statements were given to choose the right one.
8. Question was on Isolation levels.
Phantom Penomenan can occur in
a) CS
b) RR
c) RS
d) UR
e) All of the above.
9. Which statement is used to give a privileges to the user?
10. Which of the fallowing is a valid column name.
a) EMPLOYEE_name.
b) Employee-name.
c) 10Employee Name.
d) And one more wrong option.
11. Again there was a question on column names and their constrants of table with stmts
a) all the column names must be unique in a table
b) all the columns can be defined with unique constraint
c) Unique constraints can be defined on a same set of columns.
d) bit tricky we need to chose the right answer.
