问题:多选题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 Console HTTP Port number:5500 You started the database instance and you want to manage your database remote...
查看答案
问题:单选题In the instance of the PROD database, the checkpoint (CKPT) process runs after every minute. A database user updates the rows of the ORDERS table. Because of the configuration, the CKPT process gets initiated before the user commits the transaction. Wh...
问题:单选题You observe that in your PROD database, customer information is being modified by some unauthorized users. You want to keep track of all of the transactions happening on the table using PL/SQL. Which type of PL/SQL subprogram or construct would you use...
问题:单选题You work as a database administrator for Certkiller .com. As a result of performance analysis, you created an index on theprod_namecolumn of the Certkiller prodtable, which contains about ten thousand rows. Later, you updated a product name in the tab...
问题:多选题In which two cases would you perform only consistent backup?()AYou are working on a database where downtime is not tolerated.BYou are working on a database where downtime can be tolerated.CYou are working on a database that operates in ARCHIVELOG mode....
问题:单选题In your database, UNDO_RETENTION has been set to 600 sec and UNDO tablespace is configured for RETENTION GUARANTEE. Which statement regarding RETENTION GUARANTEE is true? ()A Undo data is retained until the next full database backup.B No committed undo...
问题:多选题Which two statements about bigfile tablespaces are true? ()AThe bigfile tablespace have only one data file.BThe segment space management is automatic.CThe extent management is dictionary managed.DThe database can have only one bigfile tablespace.EThe b...
问题:单选题The SAVE_AMT column in the ACCOUNTS table contains the balance details of customers in a bank. As part of the year/x7fend tax and interest calculation process, all the rows in the table need to be accessed. The bank authorities want to track access to ...
问题:You work as a database administrator for Certkiller .com. Us...
问题:单选题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 (RMAN). How would you make use of this consistent backup in RMAN?()A cannot be used in RMANB by starti...
问题:多选题Which two statements about Flashback Query are true?()AIt is generated by using the redo log files.BIt helps in row-level recovery from user errors.CIt can be performed to recover ALTER TABLE statementsDIt fails when undo data pertaining to the transac...
问题:单选题In your database, the users SYS and SYSTEM have been assigned the profiles, ADMIN_PROF1 and ADMIN_PROF2, respectively. The rest of the database administrators are assigned the profile ADMIN_PROF3. You create a profile, USER_PROF, and assign it to the a...
问题:单选题You work as a database administrator for Supportcenter.cn. In your organization, you have four databases, SupportCenter DB01, SupportCenter DB02, SupportCenter DB03, and SupportCenter DB04, which are located in Berlin, Frankfurt,Rammstein, and Munich r...
问题:多选题You are working on a test database where instance recovery takes a considerable amount of time.How can reduce the recovery time?()ABy multiplexing the control filesBBy multiplexing the redo log filesCBy decreasing the size of redo log filesDBy configur...
问题:单选题Your tnsnames.ora file has the following entry for the service alias ORCL: ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 10.156.24.216) (PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl.oracle.com) ) ) The...
问题:单选题You find that the database performance degrades while you backup the PROD database using Recovery Manager (RMAN). The PROD database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You sus...
问题:单选题Where do you find information about a missing redo log file?()A trace fileB audit trailC control fileD alert log fileE event viewer...
问题:单选题You have to shut down the database instance with the ABORT option because of a hardware failure. Which statement is true about the subsequent opening of the database?()A The database would open normally.B The database would not open, and it would stop ...
问题:单选题The ST_INFO master table has millions of rows that are updated very rarely. It has a STATE_CODE column that contains the value for 25 states. The table is frequently queried on the STATE_CODE column. Which type of index would you suggest to improve the...
问题:单选题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 information about the listener, database, and the configuration of the application. How would you avo...