网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
多选题
On which two database objects can the VERSIONS clause of the Flashback Versions Query be used?()
A

fixed tables

B

heap tables

C

external tables

D

temporary tables

E

Index-Organized Tables (IOTs)


参考答案

参考解析
解析: 暂无解析
更多 “多选题On which two database objects can the VERSIONS clause of the Flashback Versions Query be used?()Afixed tablesBheap tablesCexternal tablesDtemporary tablesEIndex-Organized Tables (IOTs)” 相关考题
考题 On which two database objects can the VERSIONS clause of the Flashback Versions Query be used?() A. fixed tablesB. heap tablesC. external tablesD. temporary tablesE. Index-Organized Tables (IOTs)

考题 For which two database objects can the VERSIONS clause of the Flashback Versions Query be used?()(Choose two.) A. viewsB. fixed tablesC. heap tablesD. external tablesE. temporary tablesF. index-organized tables (IOT)

考题 Which of the following database objects can be used to raise an error if a table is updated?() A.PackageB.TriggerC.Stored ProcedureD.Informational Constraint

考题 Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following command in the root container: Which two statements are true?()A、Schema objects owned by the C# # A_ADMIN common user can be shared across all PDBs.B、The C # # A_ADMIN user will be able to use the TEMP_TS temporary tablespace only in root.C、The command will, create a common user whose description is contained in the root and each pdb.D、The schema for the common user C # # A_ADMIN can be different in each container.E、The command will create a user in the root container only because the container clause is not used

考题 Which of the following statements is true regarding the VERSIONS BETWEEN clause?()  A、 The VERSIONS BETWEEN clause may be used in DML statements.B、 The VERSIONS BETWEEN clause may be used in DDL statements.C、 The VERSIONS BETWEEN clause may not be used to query past DDL changes to tables.D、 The VERSIONS BETWEEN clause may not be used to query past DML statements to tables.

考题 Which two statements about views are true? ()A、A view can be created as read only.B、A view can be created as a join on two or more tables.C、A view cannot have an ORDER BY clause in the SELECT statement.D、A view cannot be created with a GROUP BY clause in the SELECT statement.E、A view must have aliases defined for the column names in the SELECT statement.

考题 Which of the following database objects can be used to raise an error if a table is updated?()A、PackageB、TriggerC、Stored ProcedureD、Informational Constraint

考题 You are maintaining your OLTP database in Oracle10g. You are performing the Flashback Transaction Query to find the undo SQL statements that can be used to undo the changes made to the database in the specific time period. Which pseudocolumn will you use to perform the Flashback Transaction Query?()A、 VERSIONS_STARTSCNB、 VERSIONS_STARTTIMEC、 VERSIONS_XIDD、 VERSIONS_OPERATION

考题 Examine the command: SQL ALTER USER skd ACCOUNT LOCK; Which two statements are true after the command is executed()A、The SKD user cannot log in to the database instance.B、The objects owned by the SKD user are not accessible to any user.C、The other users can access the objects owned by the SKD user, on which they have access.D、The password for the SKD user expires and the user is forced to change the password at the next log in

考题 Which two statements are correct regarding the Flashback Versions Query feature?()A、 You can use this feature to identify the committed versions of the rows, but not the uncommitted versions.B、 You can use this feature to identify the versions of V$ views.C、 You can use this feature to identify the inserts, deletes, and updates performed on a particular row but not the data definition language (DDL) operations performed on the table.D、 You can use this feature for a table only if row movement is enabled for the table.E、 You can use this feature to identify the versions of external and fixed tables.

考题 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

考题 Which two statements are true about WHERE and HAVING clauses? ()A、A WHERE clause can be used to restrict both rows and groups.B、A WHERE clause can be used to restrict rows only.C、A HAVING clause can be used to restrict both rows and groups.D、A HAVING clause can be used to restrict groups only.E、A WHERE clause CANNOT be used in a query if the query uses a HAVING clause.F、A HAVING clause CANNOT be used in subqueries.

考题 On which two database objects can the VERSIONS clause of the Flashback Versions Query be used?()A、 fixed tablesB、 heap tablesC、 external tablesD、 temporary tablesE、 Index-Organized Tables (IOTs)

考题 For which two database objects can the VERSIONS clause of the Flashback Versions Query be used?()(Choose two.)A、viewsB、fixed tablesC、heap tablesD、external tablesE、temporary tablesF、index-organized tables (IOT)

考题 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 two database operations can be performed at the MOUNT stage of database startup?()A、renaming of data filesB、dropping the database userC、renaming of control filesD、multiplexing of control filesE、configuring the database in ARCHIVELOG mode

考题 单选题You are maintaining your OLTP database in Oracle10g. You are performing the Flashback Transaction Query to find the undo SQL statements that can be used to undo the changes made to the database in the specific time period. Which pseudocolumn will you use to perform the Flashback Transaction Query?()A  VERSIONS_STARTSCNB  VERSIONS_STARTTIMEC  VERSIONS_XIDD  VERSIONS_OPERATION

考题 多选题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

考题 多选题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

考题 多选题A RequestDispatcher can be obtained from which two objects? ()AServletConfigBServletContextCHttpServletRequestDHttpServletResponse

考题 多选题Examine the command: SQL ALTER USER skd ACCOUNT LOCK; Which two statements are true after the command is executed()AThe SKD user cannot log in to the database instance.BThe objects owned by the SKD user are not accessible to any user.CThe other users can access the objects owned by the SKD user, on which they have access.DThe password for the SKD user expires and the user is forced to change the password at the next log in

考题 多选题Which two firewall user authentication objects can be referenced in a security policy?()Aaccess profileBclient groupCclientDdefault profile

考题 多选题On which two database objects can the VERSIONS clause of the Flashback Versions Query be used?()Afixed tablesBheap tablesCexternal tablesDtemporary tablesEIndex-Organized Tables (IOTs)

考题 多选题Which two database operations can be performed at the MOUNT stage of database startup?()Arenaming of data filesBdropping the database userCrenaming of control filesDmultiplexing of control filesEconfiguring the database in ARCHIVELOG mode

考题 单选题Which of the following statements is true regarding the VERSIONS BETWEEN clause?()A  The VERSIONS BETWEEN clause may be used in DML statements.B  The VERSIONS BETWEEN clause may be used in DDL statements.C  The VERSIONS BETWEEN clause may not be used to query past DDL changes to tables.D  The VERSIONS BETWEEN clause may not be used to query past DML statements to tables.

考题 多选题For which two database objects can the VERSIONS clause of the Flashback Versions Query be used?()(Choose two.)AviewsBfixed tablesCheap tablesDexternal tablesEtemporary tablesFindex-organized tables (IOT)

考题 多选题Which two statements are true about WHERE and HAVING clauses? ()AA WHERE clause can be used to restrict both rows and groups.BA WHERE clause can be used to restrict rows only.CA HAVING clause can be used to restrict both rows and groups.DA HAVING clause can be used to restrict groups only.EA WHERE clause CANNOT be used in a query of the query uses a HAVING clause.FA HAVING clause CANNOT be used in subqueries.

考题 多选题Examine the command: SQL ALTER USER skd ACCOUNT LOCK; Which two statements are true after the command is executed()AThe SKD user cannot log in to the database instance.BThe objects owned by the SKD user are not accessible to any user.CThe other users can access the objects owned by the SKD user, on which they have access.DThe password for the SKD user expires and the user is forced to change the password at the next log in.