Examinethecommand:ALTERDATABASEADDSUPPLEMENTALLOGDATA(PRIMARYKEY)COLUMNS;Whatdoesthecommandaccomplish?() A.Createsanadditionalcopyofthedatabaseonlineredologfiles.B.StorestheprimarykeycolumnvaluesofeachrowinvolvedinaDMLoperationintheonlineredologfiles.C.StorestheprimarykeycolumnvaluesofeachrowinvolvedinaDMLoperationinthesupplementallogfiles.D.StorestheoldandnewprimarykeycolumnvaluesofeachrowinvolvedinaDMLoperationonlywhentheprimarykeyismodifiedintheonlineredologfiles.
Examinethecommand:ALTERDATABASEADDSUPPLEMENTALLOGDATA(PRIMARYKEY)COLUMNS;Whatdoesthecommandaccomplish?()
A.Createsanadditionalcopyofthedatabaseonlineredologfiles.
B.StorestheprimarykeycolumnvaluesofeachrowinvolvedinaDMLoperationintheonlineredologfiles.
C.StorestheprimarykeycolumnvaluesofeachrowinvolvedinaDMLoperationinthesupplementallogfiles.
D.StorestheoldandnewprimarykeycolumnvaluesofeachrowinvolvedinaDMLoperationonlywhentheprimarykeyismodifiedintheonlineredologfiles.
相关考题：
以下关于PRIMARYKEY和UNIQUE的描述中,错误的是() A、UNIQUE约束只能定义在表的单个列上B、一个表上可以定义多个UNIQUE，只能定义一个PRIMARYKEYC、在空值列上允许定义UNIQUE，不能定义PRIMARYKEYD、PRIMARYKEY和UNIQUE都可以约束属性值的唯一性
Which of the following is not among the basic features of a relational database?A．It does not matter what order the rows are in.B．It does not matter what order the columns are in.C．Different columns should have different column names.D．Different columns should have different data types.
The income statement is prepared from (). A.the income statement columns of the work sheetB.the adjusted trial balanceC.either the adjusted trial balance or the income statement columns of the work sheetD.both the adjusted trial balance and the income statement columns of the work sheet
Examinethecommandthatisusedtocreateatable：SQLCREATETABLEorders（oidNUMBER（6）PRIMARYKEY，odateDATE，ccodeNUMBER（6），oamtNUMBER（10，2））TABLESPACEusers；Whichtwostatementsaretrueabouttheeffectoftheabovecommand（）A.ACHECKconstraintiscreatedontheOIDcolumn.B.ANOTNULLconstraintiscreatedontheOIDcolumn.C.TheORDERStableistheonlyobjectcreatedintheUSERStablespace.D.TheORDERStableandauniqueindexarecreatedintheUSERStablespace.E.TheORDERStableiscreatedintheUSERStablespaceandauniqueindexiscreatedontheOIDcolumnintheSYSTEMtablespace.
Which view should a user query to display the columns associated with the constraints on a table owned by the user? () A. USER_CONSTRAINTSB. USER_OBJECTSC. ALL_CONSTRAINTSD. USER_CONS_COLUMNSE. USER_COLUMNS
Examinethecommand:SQL>ALTERUSERskdACCOUNTLOCK;Whichtwostatementsaretrueafterthecommandisexecuted() A.TheSKDusercannotlogintothedatabaseinstance.B.TheobjectsownedbytheSKDuserarenotaccessibletoanyuser.C.TheotheruserscanaccesstheobjectsownedbytheSKDuser，onwhichtheyhaveaccess.D.ThepasswordfortheSKDuserexpiresandtheuserisforcedtochangethepasswordatthenextlogin
You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns.Which two conditions must be true?() A.Each extra column in the copy with more columns must not have a default valueB.Columns that are common to both versions of the table must be defined in the same order on the master and the slaveC.The slave database cannot have more columns than the master. Only the master database can have more columnsD.Columns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either serverE.The master database cannot have more columns than the slave. Only the slave deatbase can have more columns
A user utilizing an alias to update a subset of columns in a table must have UPDATE privileges on which of the following DB2 objects?() A.TableB.ColumnsC.Table and AliasD.Columns and Alias
Examinethecommand:SQLDBMS_STATS.SET_TABLE_PREFS(’SH’,’CUSTOMERS’,’PUBLISH’,’false’);Whichstatementdescribestheeffectoftheabovecommand() A.AutomaticstatisticscollectionisstoppedfortheCUSTOMERStable.B.StatisticsfortheCUSTOMERStablearelockedandcannotbeoverwritten.C.ExistingstatisticsfortheCUSTOMERStablebecomeunusableforthequeryoptimizer.D.Subsequently，statisticsgatheredontheCUSTOMERStablearestoredaspendingstatistics
您需要在EMPLOYEE表上创建组合主键约束条件。以下哪个说法是正确的（）A、PRIMARYKEY约束条件必须在表级定义B、必须为组合主键中的每个列定义PRIMARYKEY约束条件C、必须为组合主键中的第一个列定义PRIMARYKEY约束条件D、必须在表级为组合主键中的每个列定义PRIMARYKEY约束条件
In which scenario would an index be most useful?（）A、The indexed column is declared as NOT NULL.B、The indexed columns are used in the FROM clause.C、The indexed columns are part of an expression.D、The indexed column contains a wide range of values.
You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns. Which two conditions must be true?（）A、Each extra column in the copy with more columns must not have a default valueB、Columns that are common to both versions of the table must be defined in the same order on the master and the slaveC、The slave database cannot have more columns than the master. Only the master database can have more columnsD、Columns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either serverE、The master database cannot have more columns than the slave. Only the slave deatbase can have more columns
Which view should a user query to display the columns associated with the constraints on a table owned by the user?（）A、USER_CONSTRAINTSB、USER_OBJECTSC、ALL_CONSTRAINTSD、USER_CONS_COLUMNSE、USER_COLUMNS
在数据表设计时，UNIQUE与PRIMAR YKEY两者的区别是（）A、UNIQUE要求数据表中至少存在一行数据，必须在建表后创建，而PRIMARY KEY无该限制B、UNIQUE允许空值存在，而PRIMARYKEY不允许C、创建UNIQUE后，该数据行允许被修改，而PRIMARYKEY则不允许D、UNIQUE列不能创建外键，而PRIMARYKEY可以创建外键
在SQL语言中对PRIMARYKEY的作用描述不正确的是（）A、PRIMARYKEY用于定义主码B、PRIMARYKEY用于定义外部码C、PRIMARYKEY用于定义处部码的参照表D、PRIMARYKEY用于确定主码类型
A user utilizing an alias to update a subset of columns in a table must have UPDATE privileges on which of the following DB2 objects?（）A、TableB、ColumnsC、Table and AliasD、Columns and Alias
多选题You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns. Which two conditions must be true?（）AEach extra column in the copy with more columns must not have a default valueBColumns that are common to both versions of the table must be defined in the same order on the master and the slaveCThe slave database cannot have more columns than the master. Only the master database can have more columnsDColumns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either serverEThe master database cannot have more columns than the slave. Only the slave deatbase can have more columns
单选题您需要在EMPLOYEE表上创建组合主键约束条件。以下哪个说法是正确的（）APRIMARYKEY约束条件必须在表级定义B必须为组合主键中的每个列定义PRIMARYKEY约束条件C必须为组合主键中的第一个列定义PRIMARYKEY约束条件D必须在表级为组合主键中的每个列定义PRIMARYKEY约束条件
单选题你要操纵Oracle数据，下列哪个不是SQL命令？（）Aselect*fromdualBsetdefineCupdateempsetename=6543whereename=‘SMITHERS’Dcreatetableemployees（empidvarchar2（10）primarykey）
多选题In which three cases would you use the USING clause?（）AYou want to create a nonequijoin.BThe tables to be joined have multiple NULL columns.CThe tables to be joined have columns of the same name and different data types.DThe tables to be joined have columns with the same name and compatible data types.EYou want to use a NATURAL join, but you want to restrict the number of columns in the join condition.
单选题在数据表设计时，UNIQUE与PRIMAR YKEY两者的区别是（）AUNIQUE要求数据表中至少存在一行数据，必须在建表后创建，而PRIMARY KEY无该限制BUNIQUE允许空值存在，而PRIMARYKEY不允许C创建UNIQUE后，该数据行允许被修改，而PRIMARYKEY则不允许DUNIQUE列不能创建外键，而PRIMARYKEY可以创建外键
单选题以下关于约束条件的哪个说法是的（）A对一个列只能应用一个约束条件B只能在列级指定PRIMARYKEY约束条件C只能在列级指定NOTNULL约束条件DUNIQUE约束条件与PRIMARYKEY约束条件是相同的
单选题What is true of using group functions on columns that contain NULL values?（）AGroup functions on columns ignore NULL values.BGroup functions on columns returning dates include NULL values.CGroup functions on columns returning numbers include NULL values.DGroup functions on columns cannot be accurately used on columns that contain NULL values.EGroup functions on columns include NULL values in calculations if you use the keyword INC_NULLS.
单选题你开发了一个基于Windows的应用程序TestKingInvoice。该应用程序能够让用户输入和编辑客户订单信息。TestKingInvoice包含一个orderEntryDataSet的DataSet对象和名为orderDataTable以及orderDetailDataTable的DataTable对象。orderDetailDataTable需要两列创建一个唯一的主键。你要为orderDetailDataTable创建一个主键。你该怎么做？（）A设置DataTable.PrimaryKey的属性为字符串，以列出作为主键的列的名称。B设置DataTable.PrimaryKey的属性到引用到列的DataColumn对象的数组来为列创建主键。C通过DataTable.Columns集合和设置列的DataType属性来设置主键。D在列上创建唯一性约束来创建主键。