IBM(000-730)单项选择题每日一练(2019.01.14)

单项选择题
Which of the following are types of routine objects?（）
A.Package and function
B.Function and userexit
C.Procedure and package
D.Function and procedure
单项选择题
Which of the following statements is used to prevent user TOM from adding and deleting data in table TAB1?（）
A.REVOKE ADD, DELETE FROM USER tom ON TABLE tab1
B.REVOKE ADD, DELETE ON TABLE tab1 FROM USER tom
C.REVOKE INSERT, DELETE FROM USER tom ON TABLE tab1
D.REVOKE INSERT, DELETE ON TABLE tab1 FROM USER tom
单项选择题
Given the following tables: CONTINENTS ID NAME COUNTRIES1 Antarctica 02 Africa 533 Asia 474 Australia 145 Europe 436 North America 237 South America 12REGION ID LOCATION 1 East 2 WestHow many rows would be returned using the following statement? SELECT location FROM continents, region（）
A.2
B.7
C.9
D.14
单项选择题
Which of the following can be used to ensure that once a row has been inserted in table TABLEX, the column MAINID in that row cannot be updated?（）
A.Define the column MAINID as NOT UPDATABLE
B.Define the column MAINID as a PRIMARY KEY
C.Define the column MAINID as a FOREIGN KEY
D.Define an UPDATE trigger on table TABLEX
单项选择题
A number of applications issue the following SQL statement:SELECT d.deptno, e.empno, e.salary FROM department d INNER JOIN employee e ON d.deptno = e.deptnoA database administrator wishes to store this query within the database. Which of the following database objects can be used to accomplish this?（）
A.Alias
B.View
C.Schema
D.Trigger