03 2018 档案
摘要：--月份 SELECT TO_CHAR(ADD_MONTHS(SYSDATE, - (ROWNUM - 1)), 'yyyy-mm') yyyymmdd FROM DUAL CONNECT BY ROWNUM < MONTHS_BETWEEN(SYSDATE, TO_DATE ('201711', 'yyyymm'))+1 --天 select to_char(sysdate-(ROWNUM-1...
阅读全文
摘要：Which three statements are true regarding the logical structure of the Oracle database? (Choose three.)A. It is possible to have tablespaces of differ
阅读全文
摘要：Which three statements are true about the stages of database startup? (Choose three.) A. Data files and redo log files can be renamed at the MOUNT sta
阅读全文
摘要：Which two database operations can be performed at the MOUNT stage of database startup? (Choose two.)A. renaming of control filesB. multiplexing of con
阅读全文
摘要：You connected to the database using the following connection string: CONNECT hr/hr@test.us.oracle.com:1521/mydb Which three statements are correct reg
阅读全文
摘要：You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on
阅读全文
摘要：You want to administer your PROD database from a remote host machine using a Web-enabled interface. Which Oracle tool would you use to accomplish this
阅读全文
摘要：You are in the middle of a transaction and very crucial data has been modified. Because of a hardware failure, the instance has shut down before synch
阅读全文
摘要：One of the user sessions was terminated abnormally in the middle of a transaction. What does Oracle database do to recover it? A. uses undo data for r
阅读全文
摘要：Initially, for the Automatic Workload Repository (AWR) statistics, the retention period is set to 7 days, the collection interval is set to 30 minutes
阅读全文
摘要：You execute the following set of commands to create a database user and to grant the system privileges in your production environment. SQL> CREATE USE
阅读全文
摘要：Redo log files are not multiplexed in your database. Redo log blocks are corrupted in group 2, and archiving has stopped. All the redo logs are filled
阅读全文
摘要：You are using the following command to clear the log file group:ALTER DATABASE CLEAR LOGFILE GROUP 2;In which case would the command be successful?A.
阅读全文
摘要：You are working on a very large database. You had performed a binary backup of the control file a month ago. After this you added a few tablespaces, a
阅读全文
摘要：QUESTION 238 In the instance of the PROD database, the checkpoint (CKPT) process runs after every minute. A database user updates the rows of the ORDE
阅读全文
摘要：Users in your PROD database complain about the slow response of the transactions. While investigating the reason, you find that the transactions are w
阅读全文
摘要：The customer and order tables are often used in joins, thereby resulting in complex queries. You created views to simplify the writing of queries. The
阅读全文
摘要：You manually create an additional listener process, L1, for databases PROD, PAYDB and FINDB. While starting up the listener process, you get the follo
阅读全文
摘要：In your database, you may be forced to perform a recovery using the RESETLOGS option during which the redo logs would be reset to sequence number 1. Y
阅读全文
摘要：Your database is running in the ARCHIVELOG mode. You placed a tablespace, tbs_1, offline with the immediate option. Which statement is correct in this
阅读全文
摘要：The following are the details of your database: Instance name : test Host name : tech1.us.oracle.com IP address : 145.33.230.186 Enterprise Manager Co
阅读全文
摘要：You find today's performance of your production database to be the best ever. Therefore, you want to be notified in the future whenever the performanc
阅读全文
摘要：Your application demands frequent connection and disconnection from the database. You have three listener processes that are listening for the databas
阅读全文
摘要：Redo log files are multiplexed in your database. The disk in which you have one of the redo log members is highly fragmented. In the process of defrag
阅读全文
摘要：You decided to increase the value for the SHARED_SERVERS parameter by using the following command:SQL> ALTER SYSTEM SET SHARED_SERVERS=3 SCOPE=?;Which
阅读全文
摘要：View the Exhibit to see the structure of EMPLOYEES, DEPARTMENTS and EMP_DEP tables. User A wants to insert rows from EMPLOYEES and DEPARTMENTS table i
阅读全文
摘要：You have three databases, FINDB, PAYDB and ADMINDB, located in Sydney, Tokyo and Singapore respectively. You want to perform administrative tasks whic
阅读全文
摘要：You are using the backup scheduler in Enterprise Manager (EM) to schedule a backup of your database. Which type of script does the backup scheduler ge
阅读全文
摘要：View the Exhibit to see the data in the emp table. You created a PRIMARY KEY constraint on the empno column of the emp table, and the constraint is no
阅读全文
摘要：You are creating a locally managed tablespace to meet the following requirements: All the extents should be of the same size. The data should be sprea
阅读全文
摘要：In your database, you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level. How would y
阅读全文
摘要：Your database is in the MOUNT state and you execute the following command to open it:ALTER DATABASE OPEN;What two actions are performed as a result of
阅读全文
摘要：Anyone who knows just the host name and the listener name can have full control over the listener. They can stop the listener and also obtain detailed
阅读全文
摘要：You are working on a 24x7 (available 24 hours per day, 7 days per week) production database. An operating system (OS) user deletes the alert log file
阅读全文
摘要：Because of a power outage, instance failure has occurred.From what point in the redo log does recovery begin and where does it end?A. current redo log
阅读全文
摘要：It is a holiday and no transactions are being performed on the database. You took a consistent backup of your database without using Recovery Manager
阅读全文
摘要：One of the redo log members in your database is lost. You queried V$logfile for further details. What would be the member's status? A. LOST B. INVALID
阅读全文
摘要：While setting up an Oracle database for one of your critical applications, you want to ensure that the database is backed up at regular intervals with
阅读全文
摘要：User Scott has updated the salary of one of the employees in the EMPLOYEES table and has not committed the transaction. What are the two types of lock
阅读全文
摘要：When you try to start the Database Control by using the emctl start dbconsole command the following error is displayed:TZ set to America/New_yorkOC4J
阅读全文
摘要：You need to rename a data file of a tablespace. How would you perform this? A. bring the database to the NOMOUNT state, rename the data file using the
阅读全文
摘要：You have a listener process, L1, currently listening for the connections to the PROD and ADMIN databases. You create a new database, PAY, using CREATE
阅读全文
摘要：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
阅读全文
摘要：You have a production instance running on your server. UNDO_RETENTION is not long enough to satisfy read-consistency requirements. How do you change t
阅读全文
摘要：In which two cases would you perform only consistent backup? (Choose two.) A. You are working on a database where downtime is not tolerated. B. You ar
阅读全文
摘要：Due to media failure you lost one of the data files belonging to the USERS tablespace, and the tablespace is not available to use. Which statement reg
阅读全文
摘要：On which three can you use Recovery Manager (RMAN) to perform incremental backup? (Choose three.) A. data files B. control files C. tablespaces D. pas
阅读全文
摘要：As a database administrator you spend a lot of time observing and setting various storage parameter values for your application tables in order to gai
阅读全文
摘要：iew the Exhibit to see the structure of the EMPLOYEES and DEPARTMENTS tables.Your organization plans to dissolve the department with department ID 30.
阅读全文
摘要：Your database performance has degraded due to frequent checkpointing. What would you do in this scenario? A. make redo log files smaller B. increase t
阅读全文
摘要：You want the size of the tablespace to increase when it is full.Which option would you use?A. use automatic extent allocationB. disable threshold for
阅读全文
摘要：Your database is in NOARCHIVELOG mode and a logswitch happens every 20 minutes. On Thursday morning, media failure resulted in corruption of a data fi
阅读全文
摘要：You created a new user in your database but missed assigning a default tablespace to that user. The user created a table without specifying the tables
阅读全文
摘要：Your database is running in NOARCHIVELOG mode. You want to put the database in ARCHIVELOG mode. Which two statements regarding archive log destination
阅读全文
摘要：You started a long transaction. Before committing, you executed a query on one of the tables currently being modified. You received the following erro
阅读全文
摘要：You specified extent management as local for a tablespace. How will it affect space management in the tablespace? A. All the extents will be of the sa
阅读全文
摘要：You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state? A. r
阅读全文
摘要：When you try to open your database, you receive the following error: ORA-00205: error in identifying controlfile Where would you find the details requ
阅读全文
摘要：User SCOTT wants to export his objects using Oracle Data Pump and executes the following command: $ expdp scott/tiger directory = EXPORT_DIR dumpfile
阅读全文
摘要：Users complain about the slow response time of queries. While investigating the cause you find that the Oracle Instance is not configured to cache all
阅读全文
摘要：A user complains that he gets the following error message repeatedly after executing some SQL statements. The error message forces the user to log off
阅读全文
摘要：Your Oracle 11g database has 6 tablespaces (view Exhibit) in which:- TEMP is the default temporary tablespace- UNDOTBS1 is the default undo tablespace
阅读全文
摘要：You have created a baseline metric, DISK_IO_BL, for the disk I/O metrics in your PROD database and you have been getting notifications whenever the da
阅读全文
摘要：View Exhibit. Which two options are used to enable the connect-time failover feature? (Choose two.) Exhibit: A. Use only the first address. B. Try one
阅读全文
摘要：One of the users in the PROD database, Adams, complains that his update on the table, TRANS, is taking an unusually long time to complete. You find th
阅读全文
摘要：What advantage would you get if you increase the length of time during which the undo information would be stored in the database? A. roll back of lar
阅读全文
摘要：The database users are connecting to the PROD database from different applications, thereby degrading the database performance. The senior database ad
阅读全文
摘要：Where do you find information about a missing redo log file? A. trace file B. audit trail C. control file D. alert log file E. event viewer Answer: DA
阅读全文
摘要：View Exhibit. Which statement causes more undo generation? Exhibit: A. SELECT * FROM emp; B. DELETE FROM emp WHERE empno=7934; C. UPDATE emp SET comm=
阅读全文
摘要：ALTER SYSTEM SET AUDIT_TRAIL=DB,EXTENDED SCOPE=SPFILE; AUDIT_TRAIL 值含义如下：DB：启用审计，信息记录在 SYS.AUD$中OS：启用审计，审计信息保存在操作系统，Oralce 建议使用该配置Db，extended：启用审计，并且记
阅读全文
摘要：当 retention guarantee 没有设置时，即 undo 数据 不强制保留 UNDO_RETENTION 所设置的时间内，如果是 undo 表空间是自动增长，即在足够的空闲空间下，则可能会保留到 UNDO_RETENTION 所设置的时间。如果 undo 表空间是固定的，则 UNDO_R
阅读全文
摘要：regexp_like (col,'[啊-龥]','i') 所有中文字符都该在[啊-龥]区间里吧匹配中文:[\u4e00-\u9fa5]英文字母:[a-zA-Z]数字:[0-9]匹配中文，英文字母和数字及_:^[\u4e00-\u9fa5_a-zA-Z0-9]+$ 只保留中文
阅读全文
摘要：按照单个字符查询匹配 结果:不太尽人意。换成两个字符匹配后：看起来明了多了。
阅读全文
摘要：先记录下scn select current_scn from v$database; 建表create table test1 as select * from v$transportable_platform;删除表drop table test; shutdown immediate;star
阅读全文
摘要：一、环境配置1.informatica的元数据（账号、密码…）信息保存在Oracle上面2.Linux下在infa/bin里有informatica的启动脚本startup_infa.sh3.修改windows主机的hosts，地址C:\Windows\System32\drivers\etc添加1
阅读全文
浙公网安备 33010602011771号