A.35.15
B.35.95
C.36.15
D.36.95
第1题
A. SELECT last_name, department_name, location_id FROM employees , department ;
B. SELECT employees.last_name, departments.department_name, departments.location_id FROM employees e, departments D WHERE e.department_id = d.department_id;
C. SELECT e.last_name, d.department_name, d.location_id FROM employees e, departments D WHERE manager_id = manager_id;
D. SELECT e.last_name, d.department_name, d.location_id FROM employees e, departments D WHERE e.department_id = d.department_id;
第2题
第3题
A. The transparent encryption of backups uses the encryption wallet
B. The database uses the same encryption key for every encrypted backup
C. The password encryption of backups only uses the password while creating and restoring backup
D. If transparent encryption is configured, you cannot use the SET ENCRYPTION BY PASSWORD command to make password-protected backups.
第4题
A. MANAGER must be a role.
B. It allows the MANAGER to pass the specified privileges on to other users.
C. It allows the MANAGER to create tables that refer to the STUDENT_GRADES table.
D. It allows the MANAGER to apply all DML statements on the STUDENT_GRADES table.
E. It allows the MANAGER the ability to select from, insert into, and update the STUDENT_GRADES table.
F. It allows the MANAGER the ability to select from, delete from, and update the STUDENT_GRADES table.
第6题
A.whenatableisdroppedandyourestoreitfromtheRecycleBin
B.whenauser’sschemaisdroppedandyourecovertheuser’sschema
C.whensomeincorrectdataisinsertedinthetableandyouretrievethetabletoastatethatwasatacertaintimestamp
D.whenarowofatableisupdatedfrequentlyandcommitted,andyouviewalltheversionsoftherowwithinaspecificduration
第7题
A.theportusedbythelistener
B.theprotocolusedbythelistener
C.theservernamewherethelistenerruns
D.thelogfileandtracefiledestinationforthelistener
E.thedatabaseservicestoberegisteredwiththelistener
第8题
A.ThecommandmustbeissuedinMOUNTstate.
B.Thecommandsucceedsonlyifthedatafileisoffline.
C.Thecommandmustbeissuedwhenthedatabaseisinthearchivelogmode.
D.Thecommandsucceedsifnoextentinthetablespaceiscurrentlyallocatedabovethe150MBboundaryofthefile.
第9题
1.YoulogontoEnterpriseManagerasSYSDBA.
2.Youselectthemaintenancescreen.
3.YouchoosePerformRecoveryoptiononthemaintenancescreen.
4.YouchooseWholeDatabaseintheObjectTypedrop-downlistPerformRecovery:Typescreen.5.YouchooseRecovertoCurrentTimefromtheOperationTypeonthePerformRecovery:Typescreen.
6.YouprovidetheHostCredentialsforadatabaseuser.onthePerformRecovery:Typescreen.
7.Youclickthecontinuebutton.
Aninformationscreenappearssayingthatthedatabaseisunavailable.Whatisthisinformationscreen?()
第10题
A. The SELECT statement is syntactically accurate.
B. The SELECT statement does not work because there is no HAVING clause.
C. The SELECT statement does not work because the column specified in the GROUP BY clause is not in the SELECT list.
D. The SELECT statement does not work because the GROUP BY clause should be in the main query and not in the subquery.
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!