2, 5, 1, 4, 3
1, 2, 3, 4, 5
5, 2, 1, 3, 4
2, 1, 5, 4, 3
第1题:
Note the following structures in your database server: 1.Extents 2.OS Blocks 3.Tablespace 4.Segments 5.Oracle Data Block Which option has the correct arrangement of these structures from the smallest to the largest()
第2题:
You executed the following command in the lsnrctl utility to stop the listener: lsnrctl> STOP L1 What is the effect of this command if L1 is the only listener configured for your database?()
第3题:
Your network contains a database server named Server1 that runs Windows Server 2003 Service Pack 2 (SP2).Server1 has the following hardware configurations:·A single processor that supports hyper-threading·Dual processor motherboard·Two hard disks·2 GB of RAMThe first disk contains all the files for the operating system and applications. The second disk is empty.Hyper-threading is disabled in the BIOS.Users report a slow response when they query the database on Server1.You monitor Server1 for one day and receive the performance statistics shown in the following table.You need to improve database performance.What should you do? ()
A. Upgrade the RAM to 4 gb.
B. Install a second processor.
C. Enable hyper-threading in the bios.
D. Move the database to the second disk.
第4题:
Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query: SQL> SELECT * FROM sales; Which process would retrieve the result from the database and return it to the client program?()
第5题:
A user has an application server LPAR with a physical Ethernet adapter. They want to have a database LPAR also connected to the application LPAR via virtual Ethernet. Their security policies require a firewall between the application LPAR and database LPAR. Which of the following virtual Ethernet configurations satisfies the customer’s requirements?()
第6题:
ote the following structures in your database server: 1:Extents 2:OS Blocks 3:Tablespace 4:Segments 5:Oracle Data Block Which option has the correct arrangement of these structures from the smallest to the largest()
第7题:
Which of the following has an integrated database?()
第8题:
Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query:SQL> SELECT * FROM sales;Which process would retrieve the result from the database and return it to the client program?()
A. User process
B. Server process
C. System Monitor (SMON)
D. Process Monitor (PMON)
E. Checkpoint process (CKPT)
第9题:
Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt: RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF; RMAN> BACKUP DATABASE; Which files from the database will be backed up as a result of this BACKUP command?()
第10题:
You executed the following query in your database: FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output?()