A.$ mysqladmin – u root – p – h localhost test – restore /tmp/t1.sql
B.Mysql> INSERT INTO t1 VALUES FROM ‘/tmp/t1.sql‘
C.$ mysql – u root – p – h localhost test < /tmp/t1.sql
D.Mysql> LOAD DATA INFILE ‘/tmp/t1.sql‘ INTO TABLE t1
E.$ mysqlinport – u root – p – h localhost test /tmp/t1.sql
第1题
A.AccesspathanalysisisnotperformedfortheSQLstatements.
B.SQLstructureanalysisisnotperformedfortheSQLstatements.
C.SQLProfilerecommendationsarenotgeneratedfortheSQLstatements.
D.ThestalenessandabsenceofthestatisticsarenotcheckedfortheobjectsinthequerysuppliedtotheSQLTuningAdvisor.
第2题
A.Thecorrespondingindexesforthetablearealsotruncated.
B.DeletetriggersonthetablearefiredduringtheexecutionoftheTRUNCATEcommand.
C.ThechildtableistruncatedwhentheTRUNCATEcommandisappliedontheparenttable.
D.Thehigh-watermark(HWM)issettopointtothefirstusabledatablockinthetablesegment.
E.NoundoorverylittleundodataisgeneratedduringtheexecutionoftheTRUNCATEcommand
第3题
A.FILE
B.PARFILE
C.LOGFILE
D.FEEDBACK
第4题
A.CREATESYNONYMordFORorders;ThiscommandisissuedbyOE
B.CREATEPUBLICSYNONYMordFORorders;ThiscommandisissuedbyOE
C.CREATESYNONYMordFORoe.orders;Thiscommandisissuedbythedatabaseadministrator
D.CREATEPUBLICSYNONYMordFORoe.orders;Thiscommandisissuedbythedatabaseadministrator
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!