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

 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.

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 aofthe 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 "rtable

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!