1Z0-042不定項(xiàng)選擇每日一練(2020.03.29)

單項(xiàng)選擇題
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 table. How does this change affect the index？（）
A.A leaf will be marked as invalid.
B.An update in a leaf row takes place.
C.The index will be updated automatically at commit.
D.A leaf row in the index will be deleted and inserted.
E.The index becomes invalid when you make any updates
單項(xiàng)選擇題
You scheduled a backup by using the Schedule Backup option in Oracle Enterprise Manager. Which statement about the script created by Oracle Enterprise Manager is true？（）
A.It is a SQL script.
B.It is a PL/SQL file.
C.It is an operating system （OS） file.
D.It is a Recovery Manager （RMAN） script
單項(xiàng)選擇題
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 generate？（）
A.SQL script
B.PL/SQL script
C.Operating System （OS） script
D.Enterprise Manager （EM） script
E.Recovery Manager （RMAN） script
多項(xiàng)選擇題
You work as a database administrator for Certkiller .com. While setting up the database for your production environment， you want to create a user according to the requirements in the exhibit. Which three options of the CREATE USER command would you use to achieve this objective？（）
A.Profile
B.Account lock
C.Account unlock
D.Password expire
E.Quota 10MB on Certkiller TBS1
F.Password never expire
G.Defaulttablespace Certkiller TBS1
H.Quota unlimited on Certkiller TBS1
I.TemporarytablespaceTEMP
J.TemporarytablespaceSYSTEM
單項(xiàng)選擇題
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 application user， Adams. After a week you realize that the profile is no longer required and you decide to drop it. What will Adam’s profile be after the USER_PROF profile has been dropped？（）
A.no profiles
B.the default profile
C.same as the profile of SYS user
D.same as the profile of SYSTEM user