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
相关考题：
Certkiller.com is currently using a performance counter named HitCounter.You are required to increment each time a user accesses the UI classes within the application.To do this, you start by creating performance counters using the following code:GRAFIK - wird nicht fr Antwort ben?tigt !!!You have to adjust the HitCounter performance counter when a hit occurs.What should you do?（）A.B.C.D.
You are required to retrieve and display the names of all processes that are currently running in memory.What should you do?() A.B.C.D.
Currently 94% of Web users use either Internet Explorer or Firefox, but recently some new(71) have been developed that are beginning to attract attention. The browser Opera is becoming very(72) because of its speed, it is currently the world's fastest browser, and because it is much smaller(73) existing browsers (it can almost fit on a single diskette). It can also(74) the last Web page you visited, so the next time you surf, you can start where you left off. And like the big two, you can get it for free; the catch is that you have to watch blinking ads in one comer, or pay ＄40 for the ad-free (75) of Opera.A．readersB．machinesC．techniquesD．browsers
You work as an application developer at Certkiller .com. You are currently in the process of creating a new application for Certkiller .com. You are required to read compressed data files that has been sent by Certkiller .com‘s sales offices.These data files are less than 4 GB in size, but was compressed without cyclic redundancy. You want to write a method that receives the compressed files and return the uncompressed data as a byte array.What should you do?（）A.B.C.D.
You are currently in the process of creating an application that reads binary information from a file.You need to ensure that the only the first kilobyte of data is retrieved.What should you do?() A.B.C.D.
Currently 94% of Web users use either Internet Explorer or Firefox, but recently some new （71） have been developed that are beginning to attract attention. The browser Opera is becoming very（72）because of its speed, it is currently the world’s fastest browser, and because it is much smaller（73） existing browsers (it can almost fit on a single diskette). It can also （74）the last Web page you visited, so the next time you surf, you can start where you left off. And like the big two, you can get it for free; the catch is that you have to watch blinking ads in one corner, or pay $40 for the ad-free （75） of Opera.A.think B.readC.write D.remember
You are designing a plan to migrate an existing application to Windows Azure. The application currently resides on a server that has 768 MB of memory and multiple cores. You need to recommend the smallest compute instance size that is equivalent to the existing server. Which size should you recommend？（）A、 SmallB、 MediumC、 LargeD、 ExtraSmall
Which command would you use to determine what database backups are currently available for restore？（） A、 list database backupB、 report database backupC、 list backup of databaseD、 list summary backupE、 report backup of database
Your database is in ARCHIVELOG mode. You lost an index tablespace due to a disk failure while the database was open. You have neither a backup of the lost index tablespace nor the scripts containing the CREATE INDEX statements to recreate the indexes. Currently， several users are executing long-running queries on the database. What will happen to the ongoing activity in the database？（）A、 The queries that are currently executing will abort and an error message will be returned to the user.B、 The queries that are currently executing will execute normally but future queries will not executed.C、 Data Manipulation Language （DML） statements cannot be performed on the tables on which the indexes are based.D、 The currently executing and future queries will execute normally， but will be slower
You work as a network exchange administrator at Company.com.the Company.com network currently consists of a single active directory forest containing a single domain named Company.com.The Company.com organization makes use of microsoft exchange server 2010 as their messaging solution.The Company.com organization currently makes use of a computer named -ex01 which hosts a single mailbox database named kingdatabase.during the course of the business week you receive instruction from Company.com to have the transaction log files of kingdatabase moved.What should you do？（）A、You should consider having the Set-ExchangeServer cmdlet used.B、You should consider having the Set-MailboxDatabase cmdlet used.C、You should consider having the Move-DatabasePath cmdlet used.D、You should consider having the Move-Mailbox cmdlet used.
You have a DHCP server that runs windows server 2008. You restore the DHCP database by using a recent backup. You need to prevent DHCP clients from receiveing IP addresses that are currently in use on the network. What should you do?（）A、Add the DHCP serve option 44.B、Set the conflict detetion value to 0.C、Set the conflict detection value to 2.
Windows NT 4.0 is currently on the system you are using, and you want to install Windows 2000 Professional. Windows NT 4.0 is currently on an NFTS partition. For some reason you have decided that you are not going to upgrade, but rather, you are going to run this in a dual boot fashion. What do you need to do? （）A、Can’t be done.B、You need to put Windows 2000 on a separate partition from Windows NT 4.0C、You need to put Windows 2000 on the same partition as Windows NT 4.0.D、You need to upgrade Windows NT 4.0 to SP4.
You are designing a plan to migrate an existing application to Windows Azure. The application currently resides on a server that has 20 GB of hard disk space. You need to recommend the smallest compute instance size that provides local storage equivalent to that of the existing server. Which size should you recommend？（）A、 ExtraSmallB、 ExtraLargeC、 SmallD、 Large
You have a DHCP server that runs Windows Server 2008. You restore the DHCP database by using a recent backup. You need to prevent DHCP clients from receiveing IP addresses that are currently in use on the network. What should you do？（）A、Add the DHCP server option 15B、Add the DHCP server option 44C、Set the Conflict Detection value to 0D、Set the Conflict Detection value to 2
单选题You work as an application developer at Certkiller .com. You are currently in the process of developing a business logic component that requires long calculations. You have identified numerous tasks within this application that can be done asynchronously. You notice that these tasks are mutually dependent and require complex synchronization techniques so that it can manage efficiently. You decide to use Microsoft .NET 2.0 to take advantage of its new thread management features. You need to create and start the application threads. What should you do？（）A AB BC CD D
单选题Your database is in ARCHIVELOG mode. You lost an index tablespace due to a disk failure while the database was open. You have neither a backup of the lost index tablespace nor the scripts containing the CREATE INDEX statements to recreate the indexes. Currently， several users are executing long-running queries on the database. What will happen to the ongoing activity in the database？（）A The queries that are currently executing will abort and an error message will be returned to the user.B The queries that are currently executing will execute normally but future queries will not executed.C Data Manipulation Language （DML） statements cannot be performed on the tables on which the indexes are based.D The currently executing and future queries will execute normally， but will be slower
单选题You are designing a plan to migrate an existing application to Windows Azure. The application currently resides on a server that has 20 GB of hard disk space. You need to recommend the smallest compute instance size that provides local storage equivalent to that of the existing server. Which size should you recommend？（）A ExtraSmallB ExtraLargeC SmallD Large
问答题Practice 1Directions: For this part, you are allowed 30 minutes to write an essay commenting on the remark “Currently, a new concept, low-carbon life, is gaining popularity.” You can cite examples to illustrate your point. You should write at least 150 words but no more than 200 words.
单选题In one of your online transaction processing （OLTP） applications， users are manipulating and querying a database table simultaneously. From the Segment Advisor， you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries. Which option would you use with the ALTER TABLE command to achieve this objective？（）AREBUILDBCASCADECTRUNCATEDROW MOVEMENTESHRINK SPACE COMPACTFSHRINK SPACE CASCADE
单选题Windows NT 4.0 is currently on the system you are using, and you want to install Windows 2000 Professional. Windows NT 4.0 is currently on an NFTS partition. For some reason you have decided that you are not going to upgrade, but rather, you are going to run this in a dual boot fashion. What do you need to do? （）ACan’t be done.BYou need to put Windows 2000 on a separate partition from Windows NT 4.0CYou need to put Windows 2000 on the same partition as Windows NT 4.0.DYou need to upgrade Windows NT 4.0 to SP4.
单选题You have a computer that runs Windows 7. You need to identify the disk, memory, CPU, and networkresources that an application is currently using. Which tool should you use?（）AComponent ServicesBPerformance Information and ToolsCReliability MonitorDResource Monitor
单选题Which view will you use to view information regarding the jobs that are currently running in a database？（）ADBA_SCHEDULER_RUNNING_JOBSBDBA_SCHEDULER_JOB_RUN_DETAILSCDBA_SCHEDULER_JOBSDDBA_SCHEDULER_JOB_LOG