单选题While designing the database for one of your online transaction processing （OLTP） applications， you want to achieve the following： a） high availability of data b） faster primary key access to the table data c） compact storage for the table Which ty

题目

单选题

While designing the database for one of your online transaction processing （OLTP） applications， you want to achieve the following： a） high availability of data b） faster primary key access to the table data c） compact storage for the table Which type of tables would you use to achieve these objectives？（）

heap tables

object tables

partitioned tables

index-organized tables （IOTs）

更多“While designing the database for one of your online transact”相关问题

第1题

In which scenario is a Database Administrator NOT required to perform an incomplete recovery？（）A、 when all the online redo log groups are multiplexed and one of the members of a group is missingB、 when all the online redo log groups are not multiplexed and one log group is missingC、 when all the control files are missingD、 when some important tables are deleted from the database and purged from the Recycle Bin

点击查看答案
第2题

The online redo log group configuration for your database is as follows： What will happen if the online redo log file ’ora02/oradata/redo02b.log’is corrupted while working on the database？（） A、 The database will hang.B、 The database will be crashed.C、 The database will be shut down.D、 The LGWR process writes redo log entries to the other redo log member of the Group2 group

点击查看答案
第3题

Your database is in ARCHIVELOG mode. You have two online redo log groups each of which contains one redo member. When you attempt to start the database， you receive the following errors： ORA-00313： open failed for members of log group 1 of thread 1 ORA-00312： online log 1 thread 1： ’D:///REDO01.LOG’ You discover that the online redo log file of the current redo group is corrupted. Which statement should you use to resolve this issue？（）A、 SQL>ALTER DATABASE DROP LOGFILE GROUP 1；B、 SQL>ALTER DATABASE CLEAR LOGFILE GROUP 1；C、 SQL>ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1；D、 SQL>ALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’；

点击查看答案
第4题

You are designing the loan application process for the customer terminals. You need to design a Transact-SQL stored procedure that fulfills the business and technical requirements. Which type of Transact-SQL stored procedure should you use?（）A、one that uses an internal SQL Server Web service endpointB、one that runs a SQL Server Integration Services （SSIS） packageC、one that uses Service BrokerD、one that runs a user-defined function

点击查看答案
第5题

单选题Your database is in ARCHIVELOG mode. You have two online redo log groups，each of which contains one redo member. When you attempt to start the database， you receive the following errors：（）AALTER DATABASE DROP LOGFILE GROUP 1BALTER DATABASE CLEAR LOGFILE GROUP 1CALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1DALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’

点击查看答案
第6题

单选题There is a problem with one of the disks used for your database and your system administrator informs you that the disk needs to be replaced. The replacement disk will not be available until tomorrow. There was only one data file on this disk； it belongs to the USERS tablespace in your PROD database. Your PROD database runs in ARCHIVELOG mode and nightly online backups are taken. The users need to be able to access the data in the USERS tablespace before the replacement disk arrives. You have already taken the USERS tablespace offline and have restored the data file from last night’s backup to a new disk. Which additional steps are required in order to make the USERS tablespace available？（）A Only bring the tablespace back online.B Only recover the tablespace and then bring the tablespace back online.C Shut down the database， recover the data file and then start up the database.D Issue the ALTER DATABASE RENAME FILE command， recover the tablespace， and then bring the tablespace online.E Recover the tablespace， issue the ALTER DATABASE RENAME FILE command， and then bring the tablespace online.

点击查看答案
第7题

单选题You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?（）A One tablespace has only one datafileB Many tablespaces can share one datafileC One tablespace can have many datafilesD One datafile can contain many tablespaces

点击查看答案

While designing the database for one of your online transact

题目

更多“While designing the database for one of your online transact”相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容