网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
which one of the following best describes the use of hidden column formula?（）
A
views can be hidden based on a formula
B
hidden columns are not a supported feature
C
table columns can be hidden based on a formula
D
view columns can be displayed or hidden based on a formula
参考答案
参考解析
解析：
暂无解析
更多 “单选题which one of the following best describes the use of hidden column formula?（）A views can be hidden based on a formula B hidden columns are not a supported feature C table columns can be hidden based on a formula D view columns can be displayed or hidden based on a formula ” 相关考题
考题
Examine the following command that is executed for the TRANSPORT table in the SH schema:Which statement describes the significance of this command?()
A. It collects statistics into the pending area in the data dictionaryB. It creates a virtual hidden column in the CUSTOMERS_OBE tableC. It collects statistics with AUTO_SAMPLE_SIZE for ESTIMATE_PERCENTD. It creates a histogram to hold skewed information about the data in the columns
考题
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 of the following is NOT true about XML columns?()
A.Data can be retrieved by SQL.B.Data can be retrieved by XQuery.C.XML columns must be altered to accommodate additional parent and child relationships.D.Access to any portion of an XML document can be direct, without reading the whole document.
考题
Which two statements are true regarding the USING clause in table joins?（）A、It can be used to join a maximum of three tables B、It can be used to restrict the number of columns used in a NATURAL join C、It can be used to access data from tables through equijoins as well as nonequijoins D、It can be used to join tables that have columns with the same name and compatible data types
考题
Which of the following is NOT true about XML columns?（）A、Data can be retrieved by SQL.B、Data can be retrieved by XQuery.C、XML columns must be altered to accommodate additional parent and child relationships.D、Access to any portion of an XML document can be direct, without reading the whole document.
考题
helga is working with a multi-value field that has numeric values in a list. she would like to apply a formula to each item in the list, return the list which one of the following @fuctions can she use to accomplish this with one line of code?（）A、@transform B、@Listprocess C、@processlist D、@listevaluate
考题
lisa is writing a formula to determine the number of elements in a list. she wants to ensure that a value is returned, even if the value her function is evaluating turns out to be a null string . which one of the following can she so to accomplish this ?（）A、use a defaule formula of 1 B、use @elements and add 1 to the total C、use the @count function instead of @elements D、use @texttotime to ensure that all strings arte converted to date-time 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
考题
Derek has created a view in the sales.nsf db. Derek wants the sales value column in the view to be punctuated to display two decimal places . which one of the following should he do?（）A、 use the @function @decimal in the column formula in the view B、 select decimal on the numbers tab in the view properties box C、 select decimal on the numbers tab in the column properties boxD、 use the @function @decimal to format the value in the field on the form that will display in the view
考题
tommy has created a sales view in his sales.nsf database. Tommy wants negative numbers in the sales number column in the view parenthesis. which one of the following should tommy do?（）A、select the parenthesis when negative value in the view properties box B、select the parenthesis when negative value in the column properties box C、use the @function @negative to set this in the column formula in the view D、use a formula to format the value in the field on the form that will be displaying in the view
考题
tony would like to make it easier for users of the video application to enter new doc using the “video form”, he’d like users to be able to create new “video” doc form within the view. Which one of the following should tony so to build this interface?（）A、create a view action that has the following formula：@command（[create]；”video”）B、create a form action that has the following formula：@command（[compose]；”video”）C、create a view action that has the following formula：@command（[compose]；”video”）D、create a database action that has the following formula：@command（[compose]；”video”）
考题
Which two statements are true regarding views?（）A、A subquery that defines a view cannot include the GROUP BY clause B、A view that is created with the subquery having the DISTINCT keyword can be updated C、A view that is created with the subquery having the pseudo column ROWNUM keyword cannot be updated D、A data manipulation language (DML) operation can be performed on a view that is created with the subquery having all the NOT NULL columns of a table
考题
Which three statements about subqueries are true? （）A、A main query can have more than one subquery.B、A subquery can have more than one main query.C、The subquery and main query must retrieve data from the same table.D、The subquery and main query can retrieve data from different tables.E、Only one column or expression can be compared between the subquery and main query.F、Multiple columns or expression can be compared between the subquery and main query.
考题
Which three statements about subqueries are true?（）A、A single row subquery can retrieve only one column and one row.B、A single row subquery can retrieve only one row but many columns.C、A multiple row subquery can retrieve multiple rows and multiple columns.D、A multiple row subquery can be compared by using the "" operator.E、A single row subquery can use the IN operator.F、A multiple row subquery can use the "=" operator.
考题
Which two are true about aggregate functions? （）A、You can use aggregate functions in any clause of a SELECT statement.B、You can use aggregate functions only in the column list of the select clause and in the WHERE clause of a SELECT statement.C、You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.D、You can pass column names, expressions, constants, or functions as parameter to an aggregate function.E、You can use aggregate functions on a table, only by grouping the whole table as one single group.F、You cannot group the rows of a table by more than one column while using aggregate functions.
考题
Which two statements are true regarding the USING and ON clauses in table joins?（）A、Both USING and ON clauses can be used for equijoins and nonequijoins B、Amaximum of one pair of columns can be joined between two tables using the ON clause C、The ON clause can be used to join tables on columns that have different names but compatible data types D、The WHERE clause can be used to apply additional conditions in SELECT statements containing the ON or the USING clause
考题
which one of the following best describes the use of hidden column formula?（）A、views can be hidden based on a formula B、hidden columns are not a supported feature C、table columns can be hidden based on a formula D、view columns can be displayed or hidden based on a formula
考题
单选题Derek has created a view in the sales.nsf db. Derek wants the sales value column in the view to be punctuated to display two decimal places . which one of the following should he do?（）A
use the @function @decimal in the column formula in the view B
select decimal on the numbers tab in the view properties box C
select decimal on the numbers tab in the column properties boxD
use the @function @decimal to format the value in the field on the form that will display in the view
考题
多选题Which three statements about subqueries are true?（）AA single row subquery can retrieve only one column and one row.BA single row subquery can retrieve only one row but many columns.CA multiple row subquery can retrieve multiple rows and multiple columns.DA multiple row subquery can be compared by using the “” operator.EA single row subquery can use the IN operator.FA multiple row subquery can use the “=” operator.
考题
多选题Which two statements are true regarding the USING clause in table joins?（）AIt can be used to join a maximum of three tablesBIt can be used to restrict the number of columns used in a NATURAL joinCIt can be used to access data from tables through equijoins as well as nonequijoinsDIt can be used to join tables that have columns with the same name and compatible data types
考题
多选题Which two statements are true regarding the USING and ON clauses in table joins?（）ABoth USING and ON clauses can be used for equijoins and nonequijoinsBAmaximum of one pair of columns can be joined between two tables using the ON clauseCThe ON clause can be used to join tables on columns that have different names but compatible data typesDThe WHERE clause can be used to apply additional conditions in SELECT statements containing the ON or the USING clause
考题
单选题tony would like to make it easier for users of the video application to enter new doc using the “video form”, he’d like users to be able to create new “video” doc form within the view. Which one of the following should tony so to build this interface?（）A
create a view action that has the following formula：@command（[create]；”video”）B
create a form action that has the following formula：@command（[compose]；”video”）C
create a view action that has the following formula：@command（[compose]；”video”）D
create a database action that has the following formula：@command（[compose]；”video”）
考题
多选题Which two are true about aggregate functions? （）AYou can use aggregate functions in any clause of a SELECT statement.BYou can use aggregate functions only in the column list of the SELECT clause and in the WHERE clause of a SELECT statement.CYou can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.DYou can pass column names, expressions, constants, or functions as parameters to an aggregate function.EYou can use aggregate functions on a table, only by grouping the whole table as one single group.FYou cannot group the rows of a table by more than one column while using aggregate functions.
考题
单选题tommy has created a sales view in his sales.nsf database. Tommy wants negative numbers in the sales number column in the view parenthesis. which one of the following should tommy do?（）A
select the parenthesis when negative value in the view properties box B
select the parenthesis when negative value in the column properties box C
use the @function @negative to set this in the column formula in the view D
use a formula to format the value in the field on the form that will be displaying in the view
考题
多选题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
考题
多选题Which two statements are true regarding views?（）AA subquery that defines a view cannot include the GROUP BY clauseBA view that is created with the subquery having the DISTINCT keyword can be updatedCA view that is created with the subquery having the pseudo column ROWNUM keyword cannot be updatedDA data manipulation language (DML) operation can be performed on a view that is created with the subquery having all the NOT NULL columns of a table
考题
单选题Which of the following is NOT true about XML columns?（）A
Data can be retrieved by SQL.B
Data can be retrieved by XQuery.C
XML columns must be altered to accommodate additional parent and child relationships.D
Access to any portion of an XML document can be direct, without reading the whole document.
考题
单选题which one of the following best describes the use of hidden column formula?（）A
views can be hidden based on a formula B
hidden columns are not a supported feature C
table columns can be hidden based on a formula D
view columns can be displayed or hidden based on a formula
热门标签
最新试卷
