You are designing an application for Certkiller .com and you have been asked to design a database table to facilitate monthly bill generation. The bill would include details of customer calls, listed in chronological order.Which method would you follow to achieve this objective without increasing the overhead of sorting the rows?()
第1题:
You are designing an application for a telecom company and you have been asked to design a database table to facilitate monthly bill generation. The bill would include details of customer calls, listed in chronological order. Which method would you follow to achieve this objective without increasing the overhead of sorting the rows?()
第2题:
You work as a database administrator for Supportcenter.cn. You have been asked to use a centralized administrative tool to administer your database servers and application servers. In order to achieve the objective, which component would you configure on each database server?()
第3题:
You work as an application developer at Certkiller .com. Certkiller .com uses an application that calculates monthly payments based upon client input.You are currently debugging this application using the Microsoft Visual Studio 2005 IDE.The application contains the following code:public double CalculateMonthlyPayment (Single rate, double principal) {//Implementation code}You have discovered that unexpected results are being returned by the application. You would like to pause execution and display a message box containing an error message in the event of a negative or zero rate value is Passed to the CalculateMonthlyPayment method.You need to ensure that this only occurs during debugging mode.What should you do?()
A.
B.
C.
D.
第4题:
You work as a database administrator for Certkiller .com. In the Certkiller PRODUCTION database you have granted RESUMABLE system privilege to the CONNECT role.Resumablespace operation has been enabled for all user session. You want users NOT to be aware of any kind of space-related problems while performing transactions. Instead, you want the problem to be resolved by a database trigger automatically. Which combination of triggering time and event would you use to achieve this objective?()
第5题:
By mistake, you ran the batch job (for updating the BILL_DETAILS table) twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify: a) a list of changes made along with the transaction identifier of each change b) the necessary SQL statements to undo the erroneous changes Which option would you choose?()
第6题:
You work as a database administrator for Certkiller .com. You are using three database, Certkiller DB01, Certkiller DB02, and Certkiller DB03, on different host machines in your development environment. The database serverconfiguration, such as IP address and listener port number, change frequently due to development requirements, and you havethe task of notifying the developers of the changes. Which connection method would you use to overcome this overhead?()
第7题:
You work as a database administrator for Certkiller .com. You want to administer your database servers,which are running on different host machines,using the Web-enabled grid control interface. You have configured the agent on the host machines. You have started the Oracle Database 10g Grid Control utility on your machine. Which two additional components would you configure to achieve this objective?()
第8题:
Certkiller .com has asked you to create a file management application to monitor the hosts file.Certkiller .com has instructed you to change the hosts file if it has been changed.You, therefore, need to display the size and whether the hosts file is set to read-only.What should you do?()
A.
B.
C.
D.
第9题:
You work as a database administrator for Certkiller .com. In your transaction application, you have scheduled a job to update the optimizer statistics at05:00 pm every Friday. The job has successfully completed. Which three pieces of information would you check to confirm that the statistics have been collected?()
第10题:
You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups, and there have been five log switches. You lost one non-system-critical data file from your database. Which method would you use to recover the data file?()