-
编辑 删除
ocp 19c考题，科目082考试题(16)-about dropping and unused columns
16.Which three statements are true about dropping and unused columns in an Oracle database?(Choose three.)A. A primary key column referenced by another column as a foreign key can be dropped if us
-
编辑 删除
ocp 19c考题，科目082考试题(15)-move datafile to
15.Examine this command:ALTER DATABASEMOVE DATAFILE '/u01/sales1.dbf'TO /u01/sales01.dbf'REUSE;Which two statements are true? (Choose two.)A. DML may be performed on tables with one or mor
-
编辑 删除
ocp 19c考题，科目082考试题(14)-starting with the letter D
14、choose oneExamine the description of the CUSTOMERS table:name null? type------------------------CUST_ID NOT NULL VARCHAR2(6)FIRST_NAME VARCHAR2(50)LAST_NAME NOT NULL VARCHAR2(50)ADDRESS VARCHAR2(50
-
编辑 删除
ocp 19c考题，科目082考试题(13)-variable prompt
13.You want to write a query that prompts for two column names and the WHERE condition each time it is executed in a session but only prompts for the table name the first time it is executed.The v
-
编辑 删除
ocp 19c考题，科目082考试题(12)-about self-join
12.Which three statements are true about a self-join? (Choose three.)A. The ON clause must be usedB. The query must use two different aliases for the tableC. It must be an equi joinD. It must be an in
-
编辑 删除
oracle ocp 19c考题11，科目082考试题 - about SET VERIFY ON command
11.Which two statements are true about the SET VERIFY ON command? (Choose two.)A. It can be used only in SQL*PlusB. It displays values for variables used only in the WHERE clause of a queryC. It c
-
编辑 删除
oracle ocp 19c考题10，科目082考试题 - shared server dispatchers
10.Which three functions are performed by dispatchers in a shared server configuration? (Choose three.)A. writing inbound request to the common request queue from all shared server connectionsB. c
-
编辑 删除
oracle ocp 19c考题9，科目082考试题-关于SAVEPOINT
9.Which two statements are true regarding a SAVEPOINT? (Choose two.)A. Rolling back to a SAVEPOINT can undo a CREATE INDEX statementB. Rolling back to a SAVEPOINT can undo a TRUNCATE statementC. Only
