0 Life Wireless 11:44 PM irantuto.com Multiple Choice To answer the following qu
ID: 3730872 • Letter: 0
Question
0 Life Wireless 11:44 PM irantuto.com Multiple Choice To answer the following questions, neter to the tables in the JustLee Books database. 1 Which of the folowing generates a series of integers that can be stored in a database? a a number generalor b a view c. a sequence d an index 2 Which syntax is corect for nemoving a public symonym DROP SYNONYM symonymname b. DELETE PUUC SYNONYM nymname: DROP PuMIC SYNONYM synonymame: d DELETE SYNONYM synonymname 3 Which of the following commands can you use to modiy an index? ALTER SESSION b ALTER TABLE d. ALTER INDEX the above Which of the following generates an integer in a sequence? NEXTVAL b CURVAL d. CURR VALUE NEXTVAL L CUR VAL - Which of the following is a valid SOL statement? ALS (pubsequencevlu NULL HAP LAZY LARRY publisher Additional Database a·ofthe above e only a and c t. none of the above 6. Suppose the user Juan ereates a sable called MYTABLE with lour columns. The first column has a PRIMARY KEY 0onstraint, the second column has a NOT NULL constraint he thind eolumn has a CHECk costaint, and the fourth column has a FOREIGN KEY constraint Given this information, how many indexes does Oracle 120 create automaticaly table and constraints ae 7. Given the table created in Question &,which of the following commands can Juan use to create a synonym that allows anyone to access the table wihout having to identity is schema in the table reterence? CREATE SYNONYN thetable FOR uan.mytable; FOR "rtableExplanation / Answer
1) c
2) c
3) d
4) a
5)e
6)d
7)b
8) b
9) a
10) b
11) b
12) g
13) c
14) c
15) a
16)b
17) b
18) c
19) a
20)c
Hands on Assignment
(1)
create sequence
customers_customer#_seq
increment by 1
start with 10
nocache
nominvalue
nomaxvalue
nocycle;
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.