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?
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller RealGrades. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $16.49. You're not tied to anything after your purchase.
