All the questions
Multiple choice questions (3 pointt en 1. Which of the objects created on your table T you expect to affect performance of some queries on the a) View b) Trigger e) Synonym d) All of the above 2. User1 needs privileges on your table T in order to use: Procedure P that implements some operations on T a) b) View V created on T Synonym S for T c) d) All of the above 3. On your distributed database for the Car Rental Company case you need to retrieve data about clients whose ts with A. In the database that issues such requests you have a traditional global view Client ALL on the fragments of Client. Which of the following queries you will choose to retrieve the needed data (assume that all data are stored in the upper case) a) SELECT * FROM Client-ALL WHERE make LIKE 'A%"; b) SELECT FROM (SELECT FROM Client UNION SELECT FROM Client@remote) WHERE make LIKEA SELECT . FROM Client wHERE make LIKEA%" UNION SELECTFROM Client@remote wHERE make uKE Any of the above It is based on empirical rules C) d) 4. Cost-Based Optimization can make better decisions about the query-processing strategy because: a) b) It is based on database statistics c) None of the above 5. Performance is improved when large tables are a) Located on the same disk as the log files b) Located across several disks c) Located on the same disk as indexes All of the above d) 6. An application needs to work with data selected from several tables. What is the best way (in terms of performance) to implement this: The application contains several SELECT statements to the tables The application contains the call of a procedure that implements the needed processing of data tables The application contains several SELECT statements to the views on the tables a) b) c) d) All of the above You create the index on the column C of the table T(A, B, C). You expect to improve performance following queries: 7. a) INSERT INTO T VALUES (a, b, c) SELECT * FROM T WHERE C b) c) UPDATE T SET C y WHEREA x d) A and B e) B and f) None of the above