Interview Questions And Answers 
-
What is a “primary key”?
Read Answers(5) | 4,943 Views |
(12 votes, avg: 3.67)
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) | 2,488 Views |
(6 votes, avg: 3.83)
Loading ... -
What is a “join”?
Read Answers(2) | 5,060 Views |
(5 votes, avg: 3.8)
Loading ... -
What action do you have to perform before retrieving data from the next result set of a stored procedure?
Read Answer(1) | 5,755 Views |
(8 votes, avg: 2.88)
Loading ... -
What is the basic form of a SQL statement to read data out of a table?
Read Answers(5) | 6,040 Views |
(9 votes, avg: 3.22)
Loading ... -
What are two methods of retrieving SQL?
Read Answer(1) | 6,869 Views |
(17 votes, avg: 2.82)
Loading ... -
What cursor type do you use to retrieve multiple recordsets?
Read Answers(2) | 5,907 Views |
(16 votes, avg: 3.44)
Loading ...
Our Sponsors
Our Sponsors