多选题Which two statements are true when row archival management is enabled?（）AThe ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session parameter.BThe ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity tracking columns, to indicate that a row is no longer considered active.CThe ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.DThe ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.EThe ORA_ARCHIVE_STATE column is updated automatically by the Oracle Server based on activity tracking columns, to Indicate that a row is no longer considered active.
多选题
Which two statements are true when row archival management is enabled?（）
A
The ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session parameter.
B
The ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity tracking columns, to indicate that a row is no longer considered active.
C
The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.
D
The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.
E
The ORA_ARCHIVE_STATE column is updated automatically by the Oracle Server based on activity tracking columns, to Indicate that a row is no longer considered active.
参考解析
解析：
暂无解析
相关考题：
View the Exhibit and examine the resource consumption details for the current plan in use by the database instance.Which two statements are true based on the output?() A. An attempt to start a new session by the user belonging to DSS_QUERIES fails with an errorB. A user belonging to DSS_QUERIES can log in to a new session but the session will be queuedC. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management .D. The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management, I/O waits, and latch or enqueue contention
Which of the following can be used to ensure that once a row has been inserted in table TABLEX, the column MAINID in that row cannot be updated?() A.Define the column MAINID as NOT UPDATABLEB.Define the column MAINID as a PRIMARY KEYC.Define the column MAINID as a FOREIGN KEYD.Define an UPDATE trigger on table TABLEX
GEM机箱的地址插板从下往上依次作用是（）A、Row，notused，Column，MagazineAddressB、Row，Column，notused，MagazineAddressC、Column，Row，notused，MagazineAddressD、notused，Row，Column，MagazineAddress
Which of the following can be used to ensure that once a row has been inserted in table TABLEX, the column MAINID in that row cannot be updated?（）A、Define the column MAINID as NOT UPDATABLEB、Define the column MAINID as a PRIMARY KEYC、Define the column MAINID as a FOREIGN KEYD、Define an UPDATE trigger on table TABLEX
Which two statements about subqueries are true? （）A、A subquery should retrieve only one row.B、A subquery can retrieve zero or more rows.C、A subquery can be used only in SQL query statements.D、Subqueries CANNOT be nested by more than two levels.E、A subquery CANNOT be used in an SQL query statement that uses group functions.F、When a subquery is used with an inequality comparison operator in the outer SQL statement, the column list in the SELECT clause of the subquery should contain only one column.
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 about a bitmap index？ （）A、It is recommended for the columns that have unique values.B、It can be converted to a B-tree index by using the ALTER INDEX command.C、It has a bitmap segment for each distinct value in the key column， containing a string of bits in which each bit represents the presence or absence of a key column value.D、Updating the key column locks the whole bitmap segment that contains the bit for the key value to be updated.
As a result of performance analysis， you created an index on the prod_name column of the prod_det table， which contains about ten thousand rows. Later， you updated a product name in the table. How does this change affect the index？（）A、A leaf will be marked as invalid.B、An update in a leaf row takes place.C、The index will be updated automatically at commit.D、A leaf row in the index will be deleted and inserted.E、The index becomes invalid when you make any updates.
Which statement describes the effect on an index， when the indexed column for the rows is updatedin the base table（）A、An update in a leaf row takes place.B、The index becomes invalid after the update.C、The leaf block containing the row to be updated is marked as invalid.D、A row in the leaf block of the index for the key value is logically deleted and a new leaf row is inserted
You execute the following piece of code with appropriate privileges: User SCOTT has been granted theCREATE SESSION privilege and the MGR role.Which two statements are true when a session logged in as SCOTT queries the SAL column in the viewand the table?（）A、Data is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR role set.B、Data is redacted for EMP.SAL column only if the SCOTT session has the MGR role set.C、Data is never redacted for the EMP_V.SAL column.D、Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.E、Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set.
Which two statements are true when row archival management is enabled?（）A、The ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session parameter.B、The ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity tracking columns, to indicate that a row is no longer considered active.C、The ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.D、The ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.E、The ORA_ARCHIVE_STATE column is updated automatically by the Oracle Server based on activity tracking columns, to Indicate that a row is no longer considered active.
You execute the following PL/SQL:Which two statements are true?（）A、Fine-Grained Auditing (FGA) is enabled for the PRICE column in the PRODUCTS table for SELECT statements only when a row with PRICE 10000 is accessed.B、FGA is enabled for the PRODUCTS.PRICE column and an audit record is written whenever a row with PRICE 10000 is accessed.C、FGA is enabled for all DML operations by JIM on the PRODUCTS.PRICE column.D、FGA is enabled for the PRICE column of the PRODUCTS table and the SQL statements is captured in the FGA audit trial.
Which two statements are true regarding single row functions?（）A、They accept only a single argument B、They can be nested only to two levels C、Arguments can only be column values or constants D、They always return a single result row for every row of a queried table E、They can return a data type value different from the one that is referenced
多选题Examine the following command: CREATE TABLE (prod_id number(4), Prod_name varchar2 (20), Category_id number(30), Quantity_on_hand number (3) INVISIBLE); Which three statements are true about using an invisible column in the PRODUCTS table?（）AThe %ROWTYPE attribute declarations in PL/SQL to access a row will not display the invisible column in the output.BThe DESCRIBE commands in SQL *Plus will not display the invisible column in the output.CReferential integrity constraint cannot be set on the invisible column.DThe invisible column cannot be made visible and can only be marked as unused.EA primary key constraint can be added on the invisible column.
多选题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 statement describes the effect on an index， when the indexed column for the rows is updatedin the base table（）AAn update in a leaf row takes place.BThe index becomes invalid after the update.CThe leaf block containing the row to be updated is marked as invalid.DA row in the leaf block of the index for the key value is logically deleted and a new leaf row is inserted
多选题You execute the following piece of code with appropriate privileges: User SCOTT has been granted theCREATE SESSION privilege and the MGR role.Which two statements are true when a session logged in as SCOTT queries the SAL column in the viewand the table?（）AData is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR role set.BData is redacted for EMP.SAL column only if the SCOTT session has the MGR role set.CData is never redacted for the EMP_V.SAL column.DData is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.EData is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set.
多选题Which two statements are true about a bitmap index？ （）AIt is recommended for the columns that have unique values.BIt can be converted to a B-tree index by using the ALTER INDEX command.CIt has a bitmap segment for each distinct value in the key column， containing a string of bits in which each bit represents the presence or absence of a key column value.DUpdating the key column locks the whole bitmap segment that contains the bit for the key value to be updated.
多选题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.
多选题Which two statements are true about constraints? （）AThe UNIQUE constraint does not permit a null value for the column.BA UNIQUE index gets created for columns with PRIMARY KEY and UNIQUE constraints.CThe PRIMARY KEY and FOREIGN KEY constraints create a UNIQUE index.DThe NOT NULL constraint ensures that null values are not permitted for the column.
多选题You execute the following PL/SQL:Which two statements are true?（）AFine-Grained Auditing (FGA) is enabled for the PRICE column in the PRODUCTS table for SELECT statements only when a row with PRICE 10000 is accessed.BFGA is enabled for the PRODUCTS.PRICE column and an audit record is written whenever a row with PRICE 10000 is accessed.CFGA is enabled for all DML operations by JIM on the PRODUCTS.PRICE column.DFGA is enabled for the PRICE column of the PRODUCTS table and the SQL statements is captured in the FGA audit trial.
多选题Which two statements are true when row archival management is enabled?（）AThe ORA_ARCHIVE_STATE column visibility is controlled by the ROW ARCHIVAL VISIBILITY session parameter.BThe ORA_ARCHIVE_STATE column is updated manually or by a program that could reference activity tracking columns, to indicate that a row is no longer considered active.CThe ROW ARCHIVAL VISIBILITY session parameter defaults to active rows only.DThe ORA_ARCHIVE_STATE column is visible if referenced in the select list of a query.EThe ORA_ARCHIVE_STATE column is updated automatically by the Oracle Server based on activity tracking columns, to Indicate that a row is no longer considered active.
多选题Which two statements are true regarding the execution of the correlated subqueries？（）AThe nested query executes after the outer query returns the row.BThe nested query executes first and then the outer query executes.CThe outer query executes only once for the result returned by the inner query.DEach row returned by the outer query is evaluated for the results returned by the inner query.
多选题Which four are attributes of single row functions? （）Acannot be nestedBmanipulate data itemsCact on each row returnedDreturn one result per rowEaccept only one argument and return only one valueFaccept arguments which can be a column or an expression
多选题Which two statements about subqueries are true? （）AA subquery should retrieve only one row.BA subquery can retrieve zero or more rows.CA subquery can be used only in SQL query statements.DSubqueries CANNOT be nested by more than two levels.EA subquery CANNOT be used in an SQL query statement that uses group functions.FWhen a subquery is used with an inequality comparison operator in the outer SQL statement, the column list in the SELECT clause of the subquery should contain only one column.
单选题As a result of performance analysis， you created an index on the prod_name column of the prod_det table， which contains about ten thousand rows. Later， you updated a product name in the table. How does this change affect the index？（）AA leaf will be marked as invalid.BAn update in a leaf row takes place.CThe index will be updated automatically at commit.DA leaf row in the index will be deleted and inserted.EThe index becomes invalid when you make any updates.
多选题Which two statements are true regarding single row functions?（）AThey accept only a single argumentBThey can be nested only to two levelsCArguments can only be column values or constantsDThey always return a single result row for every row of a queried tableEThey can return a data type value different from the one that is referenced