Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Expert Performance Indexing In SQL Server

Authors: Jason Strate, Grant Fritchey

2nd Edition

1484211189, 9781484211182

More Books

Students also viewed these Databases questions