單項選擇題

You are creating a database by using Database Configuration Assistant (DBCA). You have chosen the File System option as the storage mechanism. What would be the result of choosing this option?（）

A. Disk mirroring and striping would be done automatically
B. The database files would be managed by the operating system's file system
C. DBCA would not save the database files by using Optimal File Architecture (OFA)
D. The data files are automatically spread across all available storage devices to optimize performance and resource utilization

你可能感興趣的試題

單項選擇題

In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas.
Which method must you use to recover the lost data?（）

A. Complete Recovery with online redo log
B. Complete Recovery with archived redo log
C. Tablespace Point-in-Time Recovery (TSPITR)
D. Incomplete Recovery with system change number (SCN)

多項選擇題

Which three functions are performed by the SQL Tuning Advisor? （）

A. Building the SQL profile
B. Recommending optimization of materialized views
C. Checking query objects for missing and stale statistics
D. Recommending bitmap, function-based, and B-tree indexes
E. Recommending restructuring SQL queries that are using bad plans

无码高清视频|成人自拍视频|欧美成人午夜无码A片秀色直播|草美女视频网站|美女被操网站在线观看

You are creating a database by using Database Configuration Assistant (DBCA). You have chosen the File System option as the storage mechanism. What would be the result of choosing this option?（）

你可能感興趣的試題

Which three functions are performed by the SQL Tuning Advisor? （）