Interview Questions And Answers 
-
What is a “primary key”?
Read Answers(5) | 4,473 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,169 Views |
(5 votes, avg: 4.2)
Loading ... -
What is a “join”?
Read Answers(2) | 4,535 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,253 Views |
(6 votes, avg: 3.5)
Loading ... -
What is the basic form of a SQL statement to read data out of a table?
Read Answers(5) | 4,789 Views |
(8 votes, avg: 3.13)
Loading ... -
What are two methods of retrieving SQL?
Read Answer(1) | 6,110 Views |
(16 votes, avg: 2.88)
Loading ... -
What cursor type do you use to retrieve multiple recordsets?
Read Answers(2) | 5,108 Views |
(16 votes, avg: 3.44)
Loading ...
Our Sponsors
Our Sponsors