当前分类: 1Z0-052
问题:To make audit information more productive, the DBA executes ...
查看答案
问题:Examine the commands executed in the following sequence: 1:...
问题:单选题You executed this command to create a temporary table: SQL CREATE GLOBAL TEMPORARY TABLE report_work_area (startdate DATE, enddate DATE, class CHAR(20))ON COMMIT PRESERVE ROWS; Which statement is true about the rows inserted into the REPORT_WORK_AREA...
问题:单选题You are managing an Oracle Database 11g database with this backup strategy: - Every Sunday night, level 0 backup is performed. - On Monday night and subsequent days, level 1 incremental backup is performed. The backups are not cumulative incremental...
问题:单选题Automatic Shared Memory Management is disabled for your database instance. You realize that there arecases of SQL statements performing poorly because of repeated parsing activity, resulting in degradation ofperformance. What would be your next step t...
问题:单选题You want to import schema objects of the HR user using Oracle Data Pump from the development database,DEVDB, to the production database, PRODDB. A database link devdb.us.oracle.com is created betweenPRODDB and DEVDB. You execute the following command o...
问题:Examine the following statement that is used to modify the p...
问题:单选题The database instance has the following parameter setting: OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE REMOTE_OS_AUTHENT = FALSE REMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0 You have a local operating system user SKD.You create a database user OPS$SKD...
问题:多选题Which three descriptions are correct about the effects of the TRUNCATE command on a table()AThe corresponding indexes for the table are also truncated.BDelete triggers on the table are fired during the execution of the TRUNCATE command.CThe child table...
问题:单选题You want to create a role to meet these requirements: 1:The role is to be protected from unauthorized usage. 2:The password of the role is not to be embedded in the application source code or stored in a table. Which method would you use to restrict...
问题:多选题You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode. Which two statements are true in this scenario()AYou must shut down the database instance to perform the backups.BYou must configure the Flash Reco...
问题:单选题The TRANS_SUMMARY table contains product-wise transaction details that get updated with every transactionin the system. Each row has cumulative transaction details of a single product and every product is identified bya product code, which is the prima...
问题:多选题You execute this command to drop the ITEM table, which has the primary key referred in the ORDERS table:SQL DROP TABLE scott.item CASCADE CONSTRAINTS PURGE; Which two statements are true about theeffect of the command()ANo flashback is possible to bri...
问题:多选题Examine the commands executed in a DBA session:SQL CREATE BIGFILE TABLESPACE MRKT 2 DATAFILE ’/u01/app/oracle/oradata/orcl/mrkt.dbf’ size 10M LOGGING 3 EXTENT MANAGEMENT LOCALSEGMENT SPACE MANAGEMENT AUTO; Tablespace created. SQL ALTER DATABASE DEFAULT...
问题:多选题A database user SMITH tries to query the V$SESSION view and fails to access it as follows: SQL connect smith/smith Connected. SQL SELECT * FROM v$session; SELECT * FROM v$session * ERROR at line 1: ORA-00942: table or view does not exist Which ar...
问题:多选题Which two operations can be performed on an external table()ACreate a view on the table.BCreate an index on the table.CCreate a synonym on the table.DAdd a virtual column to the table.EUpdate the table using the UPDATE statement.FDelete rows in the tab...
问题:单选题In a new installation of Oracle Database 11g, you perform these activities: 1:Organize software and data on different subdirectories to avoid poor performance. 2:Use consistent naming conventions for database files. 3:Separate administrative informa...
问题:Examine the following steps performed on a database instance...
问题:单选题Which statements listed below describe the data dictionary views() 1) These are stored in the SYSTEM tablespace. 2) These are the based on the virtual tables. 3) These are owned by the SYS user. 4) These can be queried by a normal user only if O7_DICTI...
问题:单选题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()A 2,5,1,4,3B 1,2,3,4,5C 5,2,1,3,4D 2...