Interview Questions And Answers 
-
What is a “primary key”?
Read Answers(5) | 3,540 Views |
(11 votes, avg: 3.64)
Loading ... -
The question is not correct.
“What structure can you have the database make to speed up table reads ?”
It is not cleare what exectly the term
“structure” means in this case.
Follow the rules of DB tuning we have to:
1] properly use indexes ( different types of indexes)
2] properly locate different DB objects
across different tablespaces, files and so on.
3] create a special space (tablespace) to locate some of the data with special datatype
( for example CLOB, LOB and …)
4]…
5]…
.
So the question is not correct and answer cannot be short and sharp.Read Answer(1) | 1,620 Views |
(4 votes, avg: 4.25)
Loading ... -
What is a “join”?
Read Answers(2) | 3,389 Views |
(4 votes, avg: 4.5)
Loading ... -
What action do you have to perform before retrieving data from the next result set of a stored procedure?
Read Answer(1) | 4,203 Views |
(5 votes, avg: 3.4)
Loading ... -
What is the basic form of a SQL statement to read data out of a table?
Read Answers(5) | 3,537 Views |
(8 votes, avg: 3.13)
Loading ... -
What are two methods of retrieving SQL?
Read Answer(1) | 4,374 Views |
(14 votes, avg: 3.07)
Loading ... -
What cursor type do you use to retrieve multiple recordsets?
Read Answers(2) | 3,725 Views |
(14 votes, avg: 3.21)
Loading ...
Our Sponsors
Our Sponsors