Which of the following is an interface that allows a user to create, edit, and manipulate data on Oracle Database management System?
1. SQL
2. SQL* plus
3. ASCII
4. Database - correct answer 2. SQL* plus
Which of the following symbols is used for...
Which of the following are used to enforce business rules?
1. Syntax
2. Functions
3. Constraints
4. Foreign rules - correct answer 3. Constraints
If a PRIMARY KEY constraint named myTable_PK exists for the Col1# and Col2# columns of the myTable
table, which of the following commands will disable the constraint?
1. Alter table myTable disable primary key constraint;
2. Alter table myTable disable constraint myTable_PK;
,3. Alter table myTable remove primary key constraint;
4. Alter table myTable modify primary key constraint disable; - correct answer
2. Alter table myTable disable constraint myTable_PK;
Which of the following commands will increase the size of the col1 column of the myTable from 12 to
20?
1. Alter table myTable modify (col1 VARCHAR2(+8));
2. Alter table myTable modify (col1 VARCHAR2(20));
3. Alter table myTable modify (col1 (+8));
4. Alter table myTable modify (col1 (20)); - correct answer 2. Alter table
myTable modify (col1 VARCHAR2(20));
Assuming the myTable table has three columns, col1, col2, col3, in this order, which one of the following
commands store a Null value in col3 of the myTable table?
3. Insert into myTable (col1, col2, col3) values ('A','B', null);
4. Update myTable set col1= col3; - correct answer 3. Insert into myTable (col1,
col2, col3) values ('A','B', null);
Examine the structure of the ORDERITEMS and the BOOKS tables given below:
SQL> desc ORDERITEMS
Name Null? Type
-------------- -------- -----------------
ORDER# NOT NULL NUMBER(4)
ITEM# NOT NULL NUMBER(2)
ISBN VARCHAR2(10)
,QUANTITY NOT NULL NUMBER(3)
PAIDEACH NOT NULL NUMBER(5,2)
SQL> desc BOOKS
Name Null? Type
--------------- -------- --------------
ISBN NOT NULL VARCHAR2(10)
TITLE VARCHAR2(30)
PUBDATE DATE
PUBID NUMBER(2)
COST NUMBER(5,2)
RETAIL NUMBER(5,2)
DISCOUNT NUMBER(4,2)
CATEGORY VARCHAR2(12)
Which of the following commands will make certain that the ISBN entered in the ORDERITEMS table
actually exists in the ISBN column of the BOOKS table?
1. ALTER TABLE orderitems ADD FOREIGN KEY isbn REFERENCES books table (isbn);
2. ALTER TABLE orderitems MODIFY FOREIGN KEY (isbn) REFERENCES books(isbn);
3. ALTER TABLE orderitems CREATE FOREIGN KEY (isbn) REFERENCES books(isbn);
4. ALTER TABLE o - correct answer 4. ALTER TABLE orderitems ADD FOREIGN
KEY (isbn) REFERENCES books(isbn);
Create sequence seq1
Increment by 10
Maxvalue 200
Cycle
Nocache;
, When you execute the sequence it generate numbers upto a maximum of 200. After issuing the
following SQL statement:
Select seq1.nextval from dual;
What is displayed by the select statement?
1. 1
2. 10
3. 100
4. An error - correct answer 1. 1
Based on the Justlee books database (Annexure A), which of the following SELECT statements display a
list of customer names from the CUSTOMERS table?
1. Select customer names from customers;
2. Select names from customers;
3. Select firstname, lastname from customers;
4. Select first_name, last_name from customers; - correct answer 3. Select
firstname, lastname from customers;
Which of the following will display the new retail price of each book of the Justlee books database
(Annexure A), as 10% less the original retail price?
1. Select title, retail - 10% from books
2. Select retail - 10/100 from books
3. Select retail - 0.1*retail from books
4. Select retail, retail*1.10 from books - correct answer 2. Select retail - 10/100
from books
1.1 Which of the following is true about the SQL query given below?
Voordelen van het kopen van samenvattingen bij Stuvia op een rij:
√ Verzekerd van kwaliteit door reviews
Stuvia-klanten hebben meer dan 700.000 samenvattingen beoordeeld. Zo weet je zeker dat je de beste documenten koopt!
Snel en makkelijk kopen
Je betaalt supersnel en eenmalig met iDeal, Bancontact of creditcard voor de samenvatting. Zonder lidmaatschap.
Focus op de essentie
Samenvattingen worden geschreven voor en door anderen. Daarom zijn de samenvattingen altijd betrouwbaar en actueel. Zo kom je snel tot de kern!
Veelgestelde vragen
Wat krijg ik als ik dit document koop?
Je krijgt een PDF, die direct beschikbaar is na je aankoop. Het gekochte document is altijd, overal en oneindig toegankelijk via je profiel.
Tevredenheidsgarantie: hoe werkt dat?
Onze tevredenheidsgarantie zorgt ervoor dat je altijd een studiedocument vindt dat goed bij je past. Je vult een formulier in en onze klantenservice regelt de rest.
Van wie koop ik deze samenvatting?
Stuvia is een marktplaats, je koop dit document dus niet van ons, maar van verkoper RealGrades. Stuvia faciliteert de betaling aan de verkoper.
Zit ik meteen vast aan een abonnement?
Nee, je koopt alleen deze samenvatting voor €16,11. Je zit daarna nergens aan vast.
