Database Management System (DBMS)

321. Which is the method of processing the plan selected throughout query optimization:

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

View answer

322. Which refers to a property of computer to run several operation simultaneously and possible as computers await response of each other:

1. Concurrency
2. Deadlock
3. Backup
4. Recovery

View answer

323. Which is refers to a stalemate situation due to which no further progress is possible as computer await response of each other:

1. Concurrency
2. Deadlock
3. Backup
4. Recovery

View answer

324. Which is a duplicate copy of a file program that is stored on a different storage media than the original location:

1. Concurrency
2. Deadlock
3. Backup
4. Recovery

View answer

325. Which is duplication of computer operations and routine backups to combat any unforeseen problems:

1. Concurrency
2. Deadlock
3. Backup
4. Recovery

View answer

326. Optimization that is basically related to the rewriter module is termed as ___________:

1. Semantic query optimization
2. Global query optimization
3. Both
4. None

View answer

327. Optimization basically related to the Rewrite module is termed as ___________:

1. Semantic query optimization
2. Global query optimization
3. Both
4. None

View answer

328. Database security helps organizations to protect data from ___________:

1. Internal users
2. External users
3. Non-external users
4. Non internal users

View answer

329. Copying files to secondary or specific devices is known as ___________:

1. Retrieve
2. Backup
3. Recovery
4. Deadlock

View answer

330. How many types of recovery control techniques:

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

View answer