niusouti.com

Which of the following datatypes store time－zone information in the database?()A. TIMESTAMPB. DATEC. TIMESTAMP WITH TIME ZONED. TIMESTAMP WITH LOCAL TIME ZONEE. DATETIME

题目
Which of the following datatypes store time－zone information in the database?()

A. TIMESTAMP

B. DATE

C. TIMESTAMP WITH TIME ZONE

D. TIMESTAMP WITH LOCAL TIME ZONE

E. DATETIME

相似考题

1.You are a database administrator in the Los Angeles branch office of a specialty foods supplier. A mainframe. database at the headquarters contains all company data. Each branch office contains a SQL Server 2000 computer that imports regional data from the mainframe. database.The server in Los Angeles contains a Data Transformation Services (DTS) package that uses OLE DB to connect to the company's mainframe. database. The DTS package extracts and transforms data about buyers and products for that region. The DTS package then writes the data to the SQL Server database in Los Angeles.You need to configure a SQL Server computer for the new branch office in Sydney. You want to copy the Los Angeles package and modify it so that it writes data to the SQL Server database in Sydney.You use the DTS Designer to modify the DTS package so that it imports regional data from the mainframe. database to the server in Sydney. The modified DTS package runs successfully on the server in Los Angeles. You save this DTS package to the server in Sydney, but the server in Sydney cannot connect to the mainframe. database.You want to enable the server in Sydney to connect to the mainframe. database. What should you do?A．Change the connection properties in the DTS package so that the package uses new login credentials to connect to the mainframe. database.B．Modify the workflow in the DTS package so that the server in Sydney is included.C．On the server in Sydney, install an OLE DB provider for the mainframe. database.D．On the server in Sydney, delete and then re-create the DTS package.

2.Youhavecreatedascriptintherecoverycatalogcalledbackup_database.Whichofthefollowingcommandswouldsuccessfullyexecutethatscript?()A.run{openscriptbackup_database；runscriptbackup_database}B.run{engagescriptbackup_database；}C.run{runscriptbackup_database；}D.Run{executescriptbackup_database；}E.Thenamebackup_databaseisaninvalidnameforanRMANscript.TryingtorunitfromRMAN wouldresultinanerror.

3.YouareusingOracleEnterpriseManagertoestimatethesizeofatabletobecreated.Youhavetypeddataregardingthecolumnnames，datatypes，sizesofthecolumns，andtheprojectednumberofrowsinthetable.WhichadditionalinformationdoestheOracleEnterpriseManagerreturn？（）A.spaceallocatedinthetablespaceB.spacerequiredforthebitmapindexonacolumnofthetableC.spaceremaininginthetablespaceaftercreatingthetableD.estimatedvalueofthePCTFREEstorageparameter

4.You’re going to have a quiz ( )by another two in the ( )month.A. followed,followedB. followed,followingC. following,followedD. following,following

更多“Which of the following datatypes store time－zone information in the database?() ”相关问题

  • 第1题：

    下列赋值语句中正确的是

    A．STORE 1 TO X,Y

    B．STORE 1,2 TO X

    C．STORE 1 TO X Y

    D．STORE 1、2 TO X


    正确答案：A
    解析：利用STORE命令给变量赋值，可以一次性给多个变量赋以相同的变量值，且各个变量名之间应该用逗号隔开，但不能将多个变量值赋给一个变量或多个变量。

  • 第2题：

    Anadministratorisplanningaclusterrunningapplicationsin3separateresourcegroups.RGA-Database1RGB-WebServerRGC-Database2Database1andDatabase2mustbeonlinebeforetheWebServer.AllresourcegroupshaveaStartupPolicyofOnlineonHomeNodeOnly.Whichofthefollowingwillensurethattheresourcegroupsareprocessedinthecorrectorder？（）

    A.SettheSerialAcquisitionOrder

    B.SettheParallelAcquisitionOrder

    C.ConfigureOnlineontheSameNodeDependency

    D.ConfigureOnlineonDifferentNodesDependency


    参考答案：A

  • 第3题：

    下列赋值语句中正确的是

    A.STORE1ToX，Y
    B.STORE1，2ToX
    C.STORE1ToXY
    D.STORE1、2ToX

    答案：A
    解析：

  • 第4题：

    Marrywantstocreateanewapplicationonhislaptopthatdoesnothaveanydesignelementsinit.Whichoneofthefollowingshouldhedotobeginhisprocess?()

    A.selectfile->Database->newandgiveitafilenameof“blank.nsf”

    B.selectfile->Database->new,chooselocalastheserver,andchosetheblanktemplate

    C.selectfile->Database->new,chooselocalastheserver,andchosethedefault.ntftemplate

    D.selectfile->Database->new,giveitafilenameof“blank.nsf”,andchosetheblanktemplate


    参考答案：B

  • 第5题：

    Object-oriented DBMS integrated a variety of(16) data types -such as business procedures, graphics, pictures, voice and annotated text.

    A．object

    B．theoretical

    C．shorten

    D．real - world


    正确答案：D
    解析：面向对象数据库管理系统综合了多种现实世界的数据类型，比如商业过程，图形，图片，声音和有注释的文本。

  • 第6题：

    在系统数据库 （） 中存在一个存储所有触发器信息的系统表。

    A．schema

    B．information_schema

    C．Information_table

    D．Information


    information_schema

相关内容