网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
You are currently located in Singapore and have connected to a remote database in Chicago. You issue the following command:SQL> SELECT ROUND (SYSDATE-promo_begin_date, 0) FROM promotions WHERE (SYSDATE-promo_begin_date)/365 >2;PROMOTIONS is the public synonym for the public database link for the PROMOTIONS table. What is the outcome?（）
A
an error because the ROUND function specified is invalid
B
an error because the WHERE condition specified is invalid
C
number of days since the promo started based on the current Chicago date and time
D
number of days since the promo started based on the current Singapore date and time
参考答案
参考解析
解析：
暂无解析
更多 “单选题You are currently located in Singapore and have connected to a remote database in Chicago. You issue the following command:SQL SELECT ROUND (SYSDATE-promo_begin_date, 0) FROM promotions WHERE (SYSDATE-promo_begin_date)/365 2;PROMOTIONS is the public synonym for the public database link for the PROMOTIONS table. What is the outcome?（）A an error because the ROUND function specified is invalid B an error because the WHERE condition specified is invalid C number of days since the promo started based on the current Chicago date and time D number of days since the promo started based on the current Singapore date and time ” 相关考题
考题
Upon starting your database, you receive the following error:You can choose from the following steps:1.Restore the database datafiles.2.Issue the alter database clear unarchived logfile group 1 command.3.Issue the alter database open command.4.Issue the alter database open resetlogs command.5.Recover the database using point-in-time recovery.6.Issue the Startup Mount command to mount the database.7.Back up the database.Which is the correct order of these steps in this case?（）A. 1,6,5,4,7B. 6,5,4C. 6,2,3,7D. 1,6,3E. The database cannot be recovered
考题
YouarecurrentlylocatedinSingaporeandhaveconnectedtoaremotedatabaseinChicago.Youissuethefollowingcommand:SQL>SELECTROUND(SYSDATE-promo_begin_date,0)FROMpromotionsWHERE(SYSDATE-promo_begin_date)/365>2;PROMOTIONSisthepublicsynonymforthepublicdatabaselinkforthePROMOTIONStable.Whatistheoutcome?（）A.anerrorbecausetheROUNDfunctionspecifiedisinvalidB.anerrorbecausetheWHEREconditionspecifiedisinvalidC.numberofdayssincethepromostartedbasedonthecurrentChicagodateandtimeD.numberofdayssincethepromostartedbasedonthecurrentSingaporedateandtime
考题
You are a network technician at TestKing, Inc. You are currently troubleshooting a routing issue on the Testking1 router. You issue the show ip route command. The output from the command is displayed in the following exhibit:Which one of the following routes WILL NOT be entered into its neighboring routers routing table?（）A. R 192.168.11.0/24 [120/7] via 192.168.9.1, 00:00:03, Serial1B. C 192.168.1.0/24 is directly connected, Ethernet0C. R 192.168.8.0/24 [120/1] via 192.168.2.2, 00:00:10, Serial0D. R 192.168.5.0/24 [120/15] via 192.168.2.2, 00:00:10, Serial0E. None of the above
考题
Your application must access data that is located on two SQL Server 2005 computers. One of these servers is named SQL1 and the other is SQL2. You have permissions to create a stored procedure on SQL1 to support your application. However，on SQL2 you only have permissions to select data. You write the stored procedure on SQL1. The stored procedure accesses SQL2 by using the OPENQUERY Transact-SQL statement. However,the query fails when executed.You need to troubleshoot the cause of the error. What should you do？（）A、Join the two servers by using the four-part syntax of server.database.schema.table.B、Reference SQL2 by using an alias.C、Add SQL2 as a remote server to SQL1.D、Add SQL2 as a linked server to SQL1.
考题
How would you grant the RVPC user access to specific RMAN database records in the RMAN virtual private catalog？（） A、 Issue the grant command from the SYS user （or equivalent） of the target database.B、 Issue the grant command from the SYS user （or equivalent） of the recovery-catalog database.C、 Issue the grant command from the recovery catalog-owning schema user account in the recovery catalog.D、 Issue the grant command from RMAN when connected to the recovery catalog-owning schema.E、 Issue the grant command from RMAN when connected to the target database.
考题
From SQL*Plus, you issue this SELECT statement: SELECT* FROM order; You use this statement to retrieve data from a data table for （）.A、UpdatingB、ViewingC、DeletingD、InsertingE、Truncating
考题
Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt： RMAN CONFIGURE CONTROLFILE AUTOBACKUP ON； After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）A、 when you change the name of a datafileB、 when you drop a table from the databaseC、 when you take an export of the databaseD、 when you back up the database using OS utilitiesE、 when you issue an ALTER SYSTEM SWITCH LOGFILE statementF、 when you issue a BACKUP command from inside the RMAN run block
考题
You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA. While observing the server settings， you find that the following parameter has been set in the parameter file of the database： REMOTE_OS_AUTHENT = TRUE What could have been the reason to set this parameter as TRUE？（）A、to enable operating system authentication for a remote clientB、to restrict the scope of administration to identical operating systemsC、to allow the start up and shut down of the database from a remote clientD、to enable the administration of the operating system from a remote clientE、to disable the administration of the operating system from a remote client
考题
You are maintaining the PROD database for NetFx Corporation. You have configured controlfile autobackup in your database. At 6：00 P.M. on Monday， you issue the following command： RMANBACKUP DATABASE； At 8：00 A.M. on Tuesday， you are unable to start the database because all the control files are missing. You decide to restore the control files from the backup by using the RMAN RESTORE CONTROLFILE FROM AUTOBACKUP； command. Which operation should you perform before using the RMAN RESTORE CONTROLFILE FROM AUTOBACKUP； command？（）A、 Start the database in the MOUNT stage.B、 Back up the control file to trace.C、 Set the DBIDD、 Issue the RECOVER DATABASE command.
考题
You are currently located in Singapore and have connected to a remote database in Chicago. You issue the following command:SQL SELECT ROUND (SYSDATE-promo_begin_date, 0) FROM promotions WHERE (SYSDATE-promo_begin_date)/365 2;PROMOTIONS is the public synonym for the public database link for the PROMOTIONS table. What is the outcome?（） A、an error because the ROUND function specified is invalid B、an error because the WHERE condition specified is invalid C、number of days since the promo started based on the current Chicago date and time D、number of days since the promo started based on the current Singapore date and time
考题
You are maintaining the database of a company. The listener process， listener1， is configured for remote access. You have issued the following command： LSNRCTLSTATUS listener1 Which information will NOT be displayed when you issue the above command？（） A、 whether the password is set in the listener or a file or notB、 the number of client connections the service handler has refusedC、 the information will be displayed whether the instance can accept connections or notD、 the protocol addresses on which the listener is configured to listen
考题
You have control-file autobackups enabled. When starting your database from SQL*Plus， you receive the following error message： SQL startup ORA-01078： failure in processing system parameters LRM-00109： could not open parameter file ， C:///ORACLE/PRODUCT/11.1.0/DB_1/DATABASE/INITORCL.ORA Using RMAN， how would you respond to this error？（） A、 Issue the startup nomount command and then issue the restore parameter file command from the RMAN prompt.B、 Issue the startup nomount command and then issue the restore spfile command from the RMAN prompt.C、 Issue the startup nomount command and then issue the restore spfile from autobackup command from the RMAN prompt.D、 Issue the startup nomount command and then issue the restore spfile from backup command from the RMAN prompt.E、 Issue the restore spfile from autobackup command from the RMAN prompt.
考题
You have lost all your database control files. To recover them， you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact. Which of the following is true regarding your recovery？（） A、 You will need to open the database with the resetlogs command.B、 All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.C、 You will use the resetlogs version of the create controlfile command.D、 You will use the noresetlogs version of the create controlfile command.E、 You will use the trace file to create a backup control file， and then you will recover the database with the recover database using backup controlfile command
考题
You need to design the consolidation strategy for the Promotions and Partners databases. You want to choose a strategy that results in the best database performance while maintaining the permissions of end users in each database.What consolidation strategy should you choose？（）A、Place each database in a separate instance running on SQL2.B、Place each database in a separate instance running on SQL3.C、Place both databases in a single instance running on SQL2.D、Place both databases in a single instance running on SQL3.
考题
You manage a database named DB1， which is located on a SQL Server 2005 computer. You receive a warning that the drive on which the DB1 log file is located is near capacity.Although the transaction log is backed up every five minutes， you observe that it is steadily growing. You think that an uncommitted transaction might be the cause and you want to investigate. You need to identify both the server process ID and the start time of the oldest active transaction in DB1. What should you do？（）A、Connect to the DB1 database. Execute DBCC OPENTRAN. View the SPID and Starttime rows.B、Connect to the master database. Execute DBCC OPENTRAN. View the SPID andStart time rows.C、In SQL Server Management Studio,open the Activity Monitor. Select the Process Info page and apply the following filter settings, Database=DB1 Open Transactions=YesView the Process ID and Last Batch columns.D、Open a query window. Connect to the master database.Execute the following statement.SELECT TOP 1 spid.last batch FROM sys.sysprocesses WHERE dbid = db id（’DB1’）AND open tran0 ORDER BY last batch
考题
单选题You are maintaining the PROD database for NetFx Corporation. You have configured controlfile autobackup in your database. At 6：00 P.M. on Monday， you issue the following command： RMANBACKUP DATABASE； At 8：00 A.M. on Tuesday， you are unable to start the database because all the control files are missing. You decide to restore the control files from the backup by using the RMAN RESTORE CONTROLFILE FROM AUTOBACKUP； command. Which operation should you perform before using the RMAN RESTORE CONTROLFILE FROM AUTOBACKUP； command？（）A
Start the database in the MOUNT stage.B
Back up the control file to trace.C
Set the DBIDD
Issue the RECOVER DATABASE command.
考题
单选题You are a database administrator for your company. The company uses a vendor company’s application that is based on a proprietary database. You query data from the application database and import the data into a SQL Server 2005 database. The application vendor provides you with a new OLE DB driver to be used when querying the application database. Company policy prohibits connections between the SQL Server database and the application database， except when querying this data. You need to provide a way to query data from the application database. What should you？（）A
Configure a Linked Server connection to the application database.B
Write a query that uses an OPENDATASOURCE command.C
Write a query that uses an OPENQUERY command.D
Configure a Remote Server connection to the application database.
考题
多选题Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt： RMAN CONFIGURE CONTROLFILE AUTOBACKUP ON； After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）Awhen you change the name of a datafileBwhen you drop a table from the databaseCwhen you take an export of the databaseDwhen you back up the database using OS utilitiesEwhen you issue an ALTER SYSTEM SWITCH LOGFILE statementFwhen you issue a BACKUP command from inside the RMAN run block
考题
单选题You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA. While observing the server settings， you find that the following parameter has been set in the parameter file of the database： REMOTE_OS_AUTHENT = TRUE What could have been the reason to set this parameter as TRUE？（）A
to enable operating system authentication for a remote clientB
to restrict the scope of administration to identical operating systemsC
to allow the start up and shut down of the database from a remote clientD
to enable the administration of the operating system from a remote clientE
to disable the administration of the operating system from a remote client
考题
单选题You are currently located in Singapore and have connected to a remote database in Chicago. You issue the following command:SQL SELECT ROUND (SYSDATE-promo_begin_date, 0) FROM promotions WHERE (SYSDATE-promo_begin_date)/365 2;PROMOTIONS is the public synonym for the public database link for the PROMOTIONS table. What is the outcome?（）A
an error because the ROUND function specified is invalid B
an error because the WHERE condition specified is invalid C
number of days since the promo started based on the current Chicago date and time D
number of days since the promo started based on the current Singapore date and time
考题
单选题You are maintaining the database of a company. The listener process， listener1， is configured for remote access. You have issued the following command： LSNRCTLSTATUS listener1 Which information will NOT be displayed when you issue the above command？（）A
whether the password is set in the listener or a file or notB
the number of client connections the service handler has refusedC
the information will be displayed whether the instance can accept connections or notD
the protocol addresses on which the listener is configured to listen
考题
单选题You have control-file autobackups enabled. When starting your database from SQL*Plus， you receive the following error message： SQL startup ORA-01078： failure in processing system parameters LRM-00109： could not open parameter file ， C:///ORACLE/PRODUCT/11.1.0/DB_1/DATABASE/INITORCL.ORA Using RMAN， how would you respond to this error？（）A
Issue the startup nomount command and then issue the restore parameter file command from the RMAN prompt.B
Issue the startup nomount command and then issue the restore spfile command from the RMAN prompt.C
Issue the startup nomount command and then issue the restore spfile from autobackup command from the RMAN prompt.D
Issue the startup nomount command and then issue the restore spfile from backup command from the RMAN prompt.E
Issue the restore spfile from autobackup command from the RMAN prompt.
考题
单选题Your application must access data that is located on two SQL Server 2005 computers. One of these servers is named SQL1 and the other is SQL2. You have permissions to create a stored procedure on SQL1 to support your application. However，on SQL2 you only have permissions to select data. You write the stored procedure on SQL1. The stored procedure accesses SQL2 by using the OPENQUERY Transact-SQL statement. However,the query fails when executed.You need to troubleshoot the cause of the error. What should you do？（）A
Join the two servers by using the four-part syntax of server.database.schema.table.B
Reference SQL2 by using an alias.C
Add SQL2 as a remote server to SQL1.D
Add SQL2 as a linked server to SQL1.
考题
单选题You manage a database named DB1， which is located on a SQL Server 2005 computer. You receive a warning that the drive on which the DB1 log file is located is near capacity.Although the transaction log is backed up every five minutes， you observe that it is steadily growing. You think that an uncommitted transaction might be the cause and you want to investigate. You need to identify both the server process ID and the start time of the oldest active transaction in DB1. What should you do？（）A
Connect to the DB1 database. Execute DBCC OPENTRAN. View the SPID and Starttime rows.B
Connect to the master database. Execute DBCC OPENTRAN. View the SPID andStart time rows.C
In SQL Server Management Studio,open the Activity Monitor. Select the Process Info page and apply the following filter settings, Database=DB1 Open Transactions=YesView the Process ID and Last Batch columns.D
Open a query window. Connect to the master database.Execute the following statement.SELECT TOP 1 spid.last batch FROM sys.sysprocesses WHERE dbid = db id（’DB1’）AND open tran0 ORDER BY last batch
考题
多选题From SQL*Plus, you issue this SELECT statement: SELECT* FROM order; You use this statement to retrieve data from a data table for （）.AUpdatingBViewingCDeletingDInsertingETruncating
考题
单选题How would you grant the RVPC user access to specific RMAN database records in the RMAN virtual private catalog？（）A
Issue the grant command from the SYS user （or equivalent） of the target database.B
Issue the grant command from the SYS user （or equivalent） of the recovery-catalog database.C
Issue the grant command from the recovery catalog-owning schema user account in the recovery catalog.D
Issue the grant command from RMAN when connected to the recovery catalog-owning schema.E
Issue the grant command from RMAN when connected to the target database.
考题
单选题You need to design the consolidation strategy for the Promotions and Partners databases. You want to choose a strategy that results in the best database performance while maintaining the permissions of end users in each database.What consolidation strategy should you choose？（）A
Place each database in a separate instance running on SQL2.B
Place each database in a separate instance running on SQL3.C
Place both databases in a single instance running on SQL2.D
Place both databases in a single instance running on SQL3.
考题
单选题You have lost all your database control files. To recover them， you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact. Which of the following is true regarding your recovery？（）A
You will need to open the database with the resetlogs command.B
All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.C
You will use the resetlogs version of the create controlfile command.D
You will use the noresetlogs version of the create controlfile command.E
You will use the trace file to create a backup control file， and then you will recover the database with the recover database using backup controlfile command
热门标签
最新试卷