Which three statements about performance analysis by SQL Performance Analyzer are true? ()
You are a database administrator for your company. The company uses a SQL Server 2005 database. A full backup of the database is made each night. Transaction log backups are made each morning and each afternoon. You notice that the database transaction log file grows very large throughout the day. You need to minimize the size of the transaction log file. You also need to minimize data loss in the event of a failure. What should you do?()
A SQL Azure database generates an error when a row is inserted into any table in the database. No error is generated when a row is deleted. You need to recommend an approach for locating the source of the errors. What should you recommend?()
You are planning the migration of a Microsoft SQL Server 2008 database to SQL Azure. You need to recommend an approach for ensuring that database connectivity does not degrade. Which two actions should you recommend?()
SQL中REVOKEGRANTOPTIONFOR…表示()。
Upon starting your database, you receive the following error: SQL> startup ORACLE instance started. Total System Global Area 171581440 bytes Fixed Size 1298640 bytes Variable Size 146804528 bytes Database Buffers 20971520 bytes Redo Buffers 2506752 bytes Database mounted. ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: ’/oracle01/oradata/orcl/redo01.log’ ORA-00312: online log 1 thread 1: ’/oracle01/oradata/orcl/redo01a.log’ You can choose from the following steps: a. Restore the database datafiles. b. Issue the alter database clear unarchived logfile group 1 command. c. Issue the alter database open command. d. Issue the alter database open resetlogs command. e. Recover the database using point-in-time recovery. f. Issue the Startup Mount command to mount the database. g. Back up the database. Which is the correct order of these steps in this case?()
You design a Business Intelligence (BI) solution by using SQL Server 2008. You create a SQL Server 2008 Integration Services (SSIS) package to perform an extract, transform, and load (ETL) process to load data to a DimCustomer dimension table that contains 1 million rows. Your data flow uses the following components: A SQL Destination data flow task to insert new customers An OLE DB Command transform that updates existing customers On average, 25 percent of existing customer records is updated each night. You need to reduce the amount of time required to update customer records. What should you do?()
Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?()
Evaluate these two SQL statements:SELECT last_name, salary, hire_dateFROM EMPLOYEES ORDRE BY salary DESC; SELECT last_name, salary, hire_dateFROM EMPOLYEES ORDER BY 2 DESC; What is true about them?()
Which component of the SGA stores parsed SQL statements is used for process sharing?()