Which two statements about sequences are true? （）A、You use a NEXTVAL pseudo column to look at the next possible value that would be generated from a sequence, without actually retrieving the value.B、You use a CURRVAL pseudo column to look at the current value just generated from a sequence, without affecting the further values to be generated from the sequence.C、You use a NEXTVAL pseudo column to obtain the next possible value from a sequence by actually retrieving the value from the sequence.D、You use a CURRVAL pseudo column to generate a value from a sequence that would be used for a specified database column.E、If a sequence starting from a value 100 and incremented by 1 is used by more than one application, then all of these applications could have a value of 105 assigned to their column whose value is being generated by the sequence.F、You use a REUSE clause when creating a sequence to restart the sequence once it generates the maximum value defined for the sequence.
Which two statements about sequences are true? （）
- A、You use a NEXTVAL pseudo column to look at the next possible value that would be generated from a sequence, without actually retrieving the value.
- B、You use a CURRVAL pseudo column to look at the current value just generated from a sequence, without affecting the further values to be generated from the sequence.
- C、You use a NEXTVAL pseudo column to obtain the next possible value from a sequence by actually retrieving the value from the sequence.
- D、You use a CURRVAL pseudo column to generate a value from a sequence that would be used for a specified database column.
- E、If a sequence starting from a value 100 and incremented by 1 is used by more than one application, then all of these applications could have a value of 105 assigned to their column whose value is being generated by the sequence.
- F、You use a REUSE clause when creating a sequence to restart the sequence once it generates the maximum value defined for the sequence.
相关考题：
Which two statements about sequences are true? () A. You use a NEXTVAL pseudo column to look at the next possible value that would be generated from a sequence, without actually retrieving the value.B. You use a CURRVAL pseudo column to look at the current value just generated from a sequence, without affecting the further values to be generated from the sequence.C. You use a NEXTVAL pseudo column to obtain the next possible value from a sequence by actually retrieving the value from the sequence.D. You use a CURRVAL pseudo column to generate a value from a sequence that would be used for a specified database column.E. If a sequence starting from a value 100 and incremented by 1 is used by more then one application, then all of these applications could have a value of 105 assigned to their column whose value is being generated by the sequence.F. You use REUSE clause when creating a sequence to restart the sequence once it generates the maximum value defined for the sequence.
Examine the following commands for redefining a table with Virtual Private Database (VPD) policies:Which two statements are true about redefining the table?() A. All the triggers for the table are disabled without changing any of the column names or column types in the table.B. The primary key constraint on the EMPLOYEES table is disabled during redefinition.C. VPD policies are copied from the original table to the new table during online redefinition.D. You must copy the VPD policies manually from the original table to the new table during online redefinition.
Given the following ALTER SEQUENCE statement: ALTER SEQUENCE myseq RESTART WITH 0 INCREMENT BY 1 NO MAXVALUE CACHE 5 ORDER Assuming that the sequence had reached a value of 100 prior to the RESTART, which of the following is true?（）A、The next value will be 0 and the sequence will never use the values 101 to 105.B、The next value will be 101 to ensure uniqueness between existing and newly generated sequence values.C、Previously cached values are retained by DB2, and after the restart, will be used for values 101 to 105.D、The next value will be 0 and DB2 will not ensure uniqueness between existing and newly generated values.
Which two statements about configuration an unconnected Catalyst Express 500 switch from setup mode using a PC are true？（）A、You may use Cisco Network Assistant to set up the initial configurationB、You must use CLI for initial configurationC、You may use either CLI or CAN for configurationD、You may make a direct connection to the PC from any point on the switchE、You may only make a direct connection from the port with the flashing green LED to the PC
Which two statements are correct when you use the reject parameter as the next-hop value for a static route?（）A、The packet is dropped and the packet's source is marked with the no-readvertise parameter.B、The system sends the packet back to the source.C、The packet is dropped from the network.D、The system sends an ICMP message back to the source of the packet.
The sales report needs to display the sales person with the highest order total. Which build report builder component would you use to create a place holder column to display the value?（）A、Report wizard. B、Layout model. C、Data model. D、Life previewer.
You create a data block based on a relation table containing a REF column. You select the REF column for your form module. Which statement about the REF column is true?（）A、It is created as a nondisplay item. B、The Lock Record property is set to Yes. C、It cannot be referenced in item level triggers. D、It is placed on the canvas with the highest sequence number.
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 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 are true regarding the use of outer joins?（）A、You cannot use IN operator in a condition that involves an outerjoin.B、You use (+) on both sides of the WHERE condition to perform an outerjoin.C、You use (*) on both sides of the WHERE condition to perform an outerjoin.D、You use an outerjoin to see only the rows that do not meet the join condition.E、In the WHERE condition, you use (+) following the name of the column in the table without matching rows, to perform an outerjoin.F、You cannot link a condition that is involved in an outerjoin to another condition by using the OR operator.
Which two statements are true about constraints? （）A、The UNIQUE constraint does not permit a null value for the column.B、A UNIQUE index gets created for columns with PRIMARY KEY and UNIQUE constraints.C、The PRIMARY KEY and FOREIGN KEY constraints create a UNIQUE index.D、The NOT NULL constraint ensures that null values are not permitted for the column.
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.
Which two statements are true regarding the ORDER BY clause? （）A、It is executed first in the query execution B、It must be the last clause in the SELECT statement C、It cannot be used in a SELECT statement containing a HAVING clauseD、You cannot specify a column name followed by an expression in this clause E、You can specify a combination of numeric positions and column names in this clause
You are maintaining your database in Oracle10g. You have set the value of the STATISTICS_LEVEL initialization parameter to TYPICAL and the value of the FAST_START_MTTR_TARGET parameter to 900 seconds. To increase the performance of the database， you want to determine the log file size that should equal the minimum size of all the online redo log files. Which column will enable you to perform the desired task？（）A、 the WRITES_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY viewB、 the column of the V$INSTANCE_RECOVERY viewC、 the OPTIMAL_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY viewD、 the LOG_FILE_SIZE_REDO_BLKS column of the V$INSTANCE_RECOVERY view
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2(30) JOB_ID NUMBER/ SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table You created a sequence called EMP_ID_SEQ in orderto populate sequential values for the EMPLOYEE_ID column of the EMPLOYEES table. Which two statements regarding the EMP_ID_SEQ sequence are true? （）A、You cannot use the EMP_ID_SEQ sequence to populate the JOB_ID column.B、The EMP_ID_SEQ sequence is invalidated when you modify the EMPLOYEE_ID column.C、The EMP_ID_SEQ sequence is not affected by modifications to the EMPLOYEES table.D、Any other column of NUMBER data type in your schema can use the EMP_ID_SEQ sequence.E、The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEES table.F、The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEE_ID column.
Which two statements are true about the use of the procedures listed in the vsysaux_occupants.move_procedure column?（）A、The procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace.B、The procedure may be used for some components to relocate component data from the SYSAUX tablespace to another tablespace.C、All the components may be moved into SYSAUX tablespace.D、All the components may be moved from the SYSAUX tablespace.
Which two statements about sequences are true? （）A、You use a NEXTVAL pseudo column to look at the next possible value that would be generated from a sequence, without actually retrieving the value.B、You use a CURRVAL pseudo column to look at the current value just generated from a sequence, without affecting the further values to be generated from the sequence.C、You use a NEXTVAL pseudo column to obtain the next possible value from a sequence by actually retrieving the value from the sequence.D、You use a CURRVAL pseudo column to generate a value from a sequence that would be used for a specified database column.E、If a sequence starting from a value 100 and incremented by 1 is used by more then one application, then all of these applications could have a value of 105 assigned to their column whose value is being generated by the sequence.F、You use REUSE clause when creating a sequence to restart the sequence once it generates the maximum value defined for the sequence.
You want to access employee details contained in flat files as part of the EMPLOYEE table. You plan to add anew column to the EMPLOYEE table to achieve this. Which data type would you use for the new column（）A、CLOBB、BLOBC、BFILED、LONG RAW
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2(30) JOB_ID NUMBER SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table You created a sequence called EMP_ID_SEQ in order to populate sequential values for the EMPLOYEE_ID column of the EMPLOYEES table. Which two statements regarding the EMP_ID_SEQ sequence are true? （）A、You cannot use the EMP_ID_SEQ sequence to populate the JOB_ID column.B、The EMP_ID_SEQ sequence is invalidated when you modify the EMPLOYEE_ID column.C、The EMP_ID_SEQ sequence is not affected by modifications to the EMPLOYEES table.D、Any other column of NUMBER data type in your schema can use the EMP_ID_SEQ sequence.E、The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEES table.F、The EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEE_ID column.
You are modifying a table named Product in a SQL Server 2005 database. You want to add a new column named FriendlyName to the Product table. A friendly name for each product will be stored in this column. The table currently contains data. The sales department has not yet created a friendly name for each product. FriendlyName is a required value for each product. You want to add this new column by using the least amount of effort. What should you do？（）A、Define the new column as NULL.Update the FriendlyName column to the same value as the productName column. Alter the FriendlyName column to be NOT NULL.B、Define the new column as NOT NULL with a default value of ’Undefined.’C、Define the new column as NULL. Use application logic to enforce the data constraint.D、Define the new column as NULL with a default value of ’Undefined.’
TestKing.com Web site includes a page that customers use to send feedback about the company and its products. You use a SQL Server 2005 database to store the comments in the Comments column of a table named Feedback. You need to implement full-text searching so that you can run reports on the comments. Which two actions should you perform？（）A、Create a nonclustered index on the Comments column.B、Execute the USE Master Transact-SQL statement.C、Create a full-text catalog.D、Create a full-text index on the Comments column.
多选题Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2(30) JOB_ID NUMBER SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table You created a sequence called EMP_ID_SEQ in order to populate sequential values for the EMPLOYEE_ID column of the EMPLOYEES table. Which two statements regarding the EMP_ID_SEQ sequence are true? （）AYou cannot use the EMP_ID_SEQ sequence to populate the JOB_ID column.BThe EMP_ID_SEQ sequence is invalidated when you modify the EMPLOYEE_ID column.CThe EMP_ID_SEQ sequence is not affected by modifications to the EMPLOYEES table.DAny other column of NUMBER data type in your schema can use the EMP_ID_SEQ sequence.EThe EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEES table.FThe EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEE_ID column.
多选题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.
多选题Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2(30) JOB_ID NUMBER SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER Foreign key to DEPARTMENT_ID column of the DEPARTMENTS table You created a sequence called EMP_ID_SEQ in order to populate sequential values for the EMPLOYEE_ID column of the EMPLOYEES table. Which two statements regarding the EMP_ID_SEQ sequence are true? （）AYou cannot use the EMP_ID_SEQ sequence to populate the JOB_ID column.BThe EMP_ID_SEQ sequence is invalidated when you modify the EMPLOYEE_ID column.CThe EMP_ID_SEQ sequence is not affected by modifications to the EMPLOYEES table.DAny other column of NUMBER data type in your schema can use the EMP_ID_SEQ sequence.EThe EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEES table.FThe EMP_ID_SEQ sequence is dropped automatically when you drop the EMPLOYEE_ID column.
单选题You create a data block based on a relation table containing a REF column. You select the REF column for your form module. Which statement about the REF column is true?（）AIt is created as a nondisplay item. BThe Lock Record property is set to Yes. CIt cannot be referenced in item level triggers. DIt is placed on the canvas with the highest sequence number.
多选题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 two statements about sequences are true?（）AYou use a NEXTVAL pseudo column to look at the next possible value that would be generated from a sequence, without actually retrieving the value.BYou use a CURRVAL pseudo column to look at the current value just generated from a sequence, without affecting the further values to be generated from the sequence.CYou use a NEXTVAL pseudo column to obtain the next possible value from a sequence by actually retrieving the value from the sequence.DYou use a CURRVAL pseudo column to generate a value from a sequence that would be used for a specified database column.EIf a sequence starting from a value 100 and incremented by 1 is used by more then one application, then all of these applications could have a value of 105 assigned to their column whose value is being generated by the sequence.FYou use REUSE clause when creating a sequence to restart the sequence once it generates the maximum value defined for the sequence.