Oracle认证考试单项选择题每日一练(2020.02.21)

单项选择题
You are using CTIDS in replication. You need to skip a transaction with the CTID of aaa-bbb-cccddd-eee : 3 on a slave. Which command would you execute from a Mysql prompt?（）
A.STOP SLAVE; SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE
B.STOP SLAVE; BEGIN; SET GTID_IGNORE="aaa-bbb-ccc-ddd-eee: 3"; COMMIT; START SLAVE
C.STOP SLAVE; SETGTID_NEXT="aaa-bbb-ccc-ddd-eee: 3"; BEGIN; COMMIT; SET GTID_NEXT="AUTOMATIC"; START SLAVE
D.STOP SLAVE; RESET SLAVE; BEGIN; SKIP NEXT GTID; COMMIT; START SLAVE
单项选择题
The following databases are registered in the base recovery catalog: PROD1, PROD2, and PROD3. The database user CATOWNER owns the base recovery catalog. You want a new user VPC1 to have access to only the PROD1 database and create a virtual private catalog.Given below are some of the commands required to achieve this:1.SQL> GRANT recovery_catalog_owner TO vpc1;2.RMAN> CONNECT CATALOG vpc1/password@catdb;3.RMAN> GRANT CATALOG FOR DATABASE prod1 TO vpc1;4.RMAN> CONNECT CATALOG catowner/password@catdb;5.RMAN> CREATE VIRTUAL CATALOG;What is the correct sequence in which the commands have to be executed?（）
A. 1, 4, 5, 2, 3
B. 1, 4, 3, 2, 5
C. 4, 5, 2, 3, 1
D. 2, 3, 4, 5, 1
E. 1, 4, 2, 3, 5
单项选择题
Click the Exhibit button to examine the structures of the EMPLOYEES, DEPARTMENTS, and TAX tables.For which situation would you use a nonequijoin query?（）
A.to find the tax percentage for each of the employees
B.to list the name, job_id, and manager name for all the employees
C.to find the name, salary, and the department name of employees who are not working with Smith
D.to find the number of employees working for the Administrative department and earning less than 4000
E.to display name, salary, manager ID, and department name of all the employees, even if the employees do not have a department ID assigned
单项选择题
While designing the database for one of your online transaction processing （OLTP） applications， you want to achieve the following： a） high availability of data b） faster primary key access to the table data c） compact storage for the table Which type of tables would you use to achieve these objectives？（）
A. heap tables
B. object tables
C. partitioned tables
D. index-organized tables （IOTs）
单项选择题
In which scenario do you use the Flashback Database feature？（）
A. when a table is dropped and you restore it from the Recycle Bin
B. when a user’s schema is dropped and you recover the user’s schema
C. when some incorrect data is inserted in the table and you retrieve the table to a state that was at a certain timestamp
D. when a row of a table is updated frequently and committed， and you view all the versions of the row within a specific duration