单选题 In the SALES database, DEFERRED_SEGMENT_CREATION is TRUE.
Examine this command:
SQL> CREATE TABLE T1(c1 INT PRIMARY KEY, c2 CLOB);
Which segment or segments, if any, are created as a result of executing the command?
A、T1, an index segment for the primary key, a LOB segment, and a lobindex segment
B、no segments are created
C、T1 only
D、T1 and an index segment created for the primary key only
E、T1, an index segment for the primary key, and a LOB segment only
单选题 You execute this query:
SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), ‘MON’), ‘dd “Monday for” fmMonthrrrr’) What is the result?
A、It executes successfully but does not return any result
B、It returns the date for the first Monday of the next month
C、It generates an error
D、It returns the date for the last Monday of the current month
多选题 Which three statements are true about external tables in Oracle 18c and later releases? (Choosethree.)
A、External table files can be used for other external tables in a different database
B、The ORACLE_LOADER access driver can be used to unload data from a database into an external table
C、The ORACLE_DATAPUMP access driver can be used to unload data from a database into an external table
D、They cannot be partitioned
E、The ORACLE_DATAPUMP access driver can be used to load data into a database from an external table
F、They support UPDATEs but not INSERTs and DELETEs
多选题 Which two tasks can you perform using DBCA for databases? (Choose two.)
A、 Configure a nonstandard block size for a new database
B、Register a new database with an available Enterprise Manager Management server
C、Change the standard block size of an existing database
D、Configure incremental backups for a new database
E、Enable flashback database for an existing database
多选题 Examine the description of the BOOKS table:
The table has 100 rows.
Examine this sequence of statements issued in a new session:
Name Null? Type
-----------------------------------
TRANSACTION NOT NULL VARCHAR2(6)
TRANSACTION_DATE DATE
AMOUNT NUMBER(10,2)
CUSTOMER_ID VARCHAR2(6)
INSERT INTO books VALUES (‘ADV112’, ‘Adventures of Tom Sawyer’, NULL, NULL); SAVEPOINT a;
DELETE FROM books;
ROLLBACK TO SAVEPOINT a;
ROLLBACK;
Which two statements are true? (Choose two.)
A、The second ROLLBACK command does nothing
B、The second ROLLBACK command replays the delete
C、The first ROLLBACK command restores the 101 rows that were deleted, leaving the inserted row still to be committed
D、The second ROLLBACK command undoes the insert
E、The first ROLLBACK command restores the 101 rows that were deleted and commits the inserted row
单选题 You plan to create a database by using the Database Configuration Assistant (DBCA), with t he following specifications:
Applications will connect to the database via a middle tier. The number of concurrent user connections will be high.
The database will have mixed workload, with t he execution of complex BI queries scheduled at night.
Which DBCA option must you choose to create the database?
A、a General Purpose database template with default memory allocation
B、a Data Warehouse database template, with t he dedicated server mode option and AMM enabled
C、a General Purpose database template, with t he shared server mode option and Automatic Memory Management (AMM) enabled
D、a default database configuration
多选题 Which three statements are true about the Oracle join and ANSI join syntax? (Choose three.)
A、The Oracle join syntax supports creation of a Cartesian product of two tables
B、The Oracle join syntax performs better than the SQL:1999 compliant ANSI join syntax
C、The SQL:1999 compliant ANSI join syntax supports natural joins
D、The SQL:1999 compliant ANSI join syntax supports creation of a Cartesian product of two tables
E、The Oracle join syntax only supports right outer joins
F、The Oracle join syntax supports natural joins
G、The Oracle join syntax performs less well than the SQL:1999 compliant ANSI join syntax
单选题 Choose the best 答案.
Which statement is true about database links?
A、A public database link can be created only by sys.
B、A database link created in a database allows a connection from that databases instance to the target databases instance, but not vice versa.
C、A public database link can be used by a user connected to the local database instance to connect to any schema in the remote database instance.
D、Private database link creation requires the same user to exist in both the local and the remote databases.
E、A database link can be created only between two Oracle databases.
2022-08-20
共295道
