1) When creating a database, in order to optimize performance, select option where to put high-usage tables in their own: a) data caches b) data spaces c) table caches d) d) table spaces 2) In ________________ of Oracle, the database administrator creates a user account in the database for each user who needs access. a) Database Authentication b) Operating System Authentication c) Internal Authentication d) External Authentication 3) A line of PL/SQL text contains groups of characters known as a) Lexical Units b) Literals c) Textual Units d) Identifiers 4) State the system variable which tells how far into the rest of each incomplete plan the optimizer should look to evaluate whether it should be expanded further.   a) optimizer_prune_level b) optimizer_search_depth c) optimizer_search d) optimizer_prune 5) State which option has made PL/SQL code run faster without requiring any additional work on the part of the programmer. a) SQL Server b) My SQL c) Oracle d) SQL Lite 6) Select the option which is a sequence of zero or more characters enclosed by single quotes. a) Integers literal b) String units c) String literal d) String label 7) Which state of the database no longer reflects a real state of the world that the database is supposed to capture? a) Consistent State b) Parallel State c) Durable State d) Inconsistent State 8) The process of replacement of a nested query by a query with a join is called: a) Correlation b) Decorrelation c) Materialization d) De-Materialization 9) Ensuring Isolation Property is the responsibility of a) Recovery-Management Component of DBMS b) Concurrency-Control Component of DBMS c) Transaction-Management Component of DBMS d) Buffer Management Component of DBMS 10) The lowest level operator to access data in query processing is: a) File Scan b) File Manipulation c) File Handling d) File Organization

Query Processing and Optimization - DBMS (Group 18)

由
列印
嵌入

排行榜

視覺風格

選項

切換範本

恢復自動保存: ?