Database Management System (DBMS)

311. Which Microsoft SQL server makes selection of the most appropriate index every table even if there are many predicates in the query:

1. Microsoft SQL server6.0
2. Microsoft SQL server6.5
3. Microsoft SQL server7.0
4. Microsoft SQL server7.5

View answer

312. Which is implement it to the index intersection in index joins:

1. SQL server6.0
2. SQL server6.5
3. SQL server7.0
4. SQL server7.5

View answer

313. Which server can joins the indexes when only multiple indexes combined can cover the query:

1. SQL
2. DBMS
3. RDBMS
4. All of these

View answer

314. How many types of disk I/O:

1. 1
2. 2
3. 3
4. 4

View answer

315. In which is types of I/O disk:

1. Random I/O
2. Sequential I/O
3. Both
4. None

View answer

316. Choosing for large and non-indexed tables, specifically for intermediate results can be termed as ___________:

1. Hashing
2. Parallelism
3. Disk
4. Deadlock

View answer

317. SMP stands for:

1. System multi-processing
2. Server multi-processing
3. Symmetric multi-processing
4. Securing multi-processing

View answer

318. Which in the database which is a software component in the RDBMS that carries out analysis of SQL statement for finding the best way for its execution:

1. Query execution
2. Query process
3. Query optimizer
4. Query transaction

View answer

319. Which can be defined as the method in which the selected plan is executed at the query optimization stages:

1. Query execution
2. Query process
3. Query optimizer
4. Query transaction

View answer

320. Which refers to technique of maintaining, managing and manipulating data store within the computer system by using SQL queries:

1. Query execution
2. Query processing
3. Query optimizer
4. Query transaction

View answer