ITPub博客

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

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

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

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

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

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

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

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

Which three statements are true concerning logical and physical database structures? (Choose three.)A. All tablespaces may have one or more data filesB. The extents of a segment must always reside i

In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1.The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains:LISTENER_1=(ADDRESS=(PROTOCOL=TCP

You have been tasked to create a table for a banking application.One of the columns must meet three requirements:Be stored in a format supporting date arithmetic without using conversion functionsSt

5.A database is configured to use automatic undo management with temporary undo enabled.An UPDATE is executed on a temporary table.Where is the UNDO stored?A. in the undo tablespaceB. in the SYSAUX

4.Which two statements are true about date/time functions in a session where NLS_DATE_FORMAT is set to DD-MON-YYYY HH24:MI:SS? (Choose two.)A. CURRENT_TIMESTAMP returns the same date and time as SYSDA

3.Which three statements are true about advanced connection options supported by Oracle Net for connection to Oracle Database instances? (Choose three.)A. Connect Time Failover requires the use of Tra

Oracle OCP 19c 认证1Z0-082考试题库(第2题)2.Which statement is true about the INTERSECT operator used in compound queries?A. Multiple INTERSECT operators are not possible in the same SQL statementB. It pro

1. You execute this command:CREATE BIGFILE TABLESPACE big_tbsDATAFILE '/u01/oracle/data/big_f1.dbf'SIZE 20G;Sufficient storage is available in filesystem /u01.Which two statements are true abo