How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Alex Your Own Question

Alex
Alex, Computer Software Engineer
Category: Programming
Satisfied Customers: 2718
Experience:  10+ Years of development experience in c#, vb, java, SQL Server, Oracle.
50749495
Type Your Programming Question Here...
Alex is online now
A new question is answered every 9 seconds

DATABASE DESIGN Question 1 A database language must enable

Resolved Question:

DATABASE DESIGN
Question 1
A database language must enable the user to perform complex queries designed to transform the raw data into useful information.
A. True
B. False
Question 2
The SQL commands may be issued on a single line, but command sequences are best structured when the SQL command's components are shown on separate and indented lines.
A. True
B. False
Question 3
Microsoft Access users can use Access QBE (query by example) query generator.
A. True
B. False
Question 4
The SQL command that lets you save your work to disk is ____.
A INSERT
B SELECT
C COMMIT
D UPDATE
Question 5
The SQL command that lets you list the table contents is ____.
INSERT
A. SELECT
B. COMMIT
C. UPDATE
Question 6
Which query will output the table contents when the value of V_CODE is equal to 21344?
A.SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
FROM PRODUCT
WHERE V_CODE 21344;
B SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
FROM PRODUCT
WHERE V_CODE 21344;
Question
What is the SQL syntax requirement to list the table contents for either V_CODE = 21344 or V_CODE = 24288?
A SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
FROM PRODUCT
WHERE V_CODE = 21344
OR V_CODE 24288
C SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
FROM PRODUCT
WHERE V_CODE = 21344
OR V_CODE > 24288
D SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE
FROM PRODUCT
WHERE V_CODE = 21344
OR V_CODE = 24288
Question 8
To delete a row from the PRODUCT table, use the ____ command.
A. KILL
B DELETE
C COMMIT
D. ERASE
Question 9
ANSI-standard SQL allows the use of special operators in conjunction with the WHERE clause. A special operator used to check for similar character strings is ____.
A. BETWEEN
B. IS NULL
C. LIKE
D. IN
Question 10
To make data entries in an existing row's columns, SQL employs the ____ command.
A. ENTER
B. UPDATE
C. MODIFY
D. ADD
Question 11
A table can be deleted from the database by using the ____ command.
A. DROP
B. DELETE
C. MODIFY
D. ERASE
Question 12
____ is used to tally the number of specific "values" of an attribute.
A. SUM
B. TOTAL
C. COUNT
D. ADD
Question 13
In Oracle, the ____ command is used to change the display for a column, for example to place a $ in front of a numeric value.
A. DISPLAY
B. FORMAT
C. CHAR
D. CONVERT
fill in the blank
Question 14
A query command to list all the rows in which the inventory stock dates occur on or after January 20, 2006 will look like this:

SELECT P_DESCRIPT, P_QOH, P_MIN, P_PRICE, P_INDATE
FROM PRODUCT
WHERE P_INDICATE >= '20-JAN-2006'

This command was written for a(n) ____________________ database.
Question 15
A specialty field in mathematics, known as ____________________ algebra, is dedicated to the use of logical devices.
Submitted: 5 years ago.
Category: Programming
Expert:  Alex replied 5 years ago.

You can download the answer here:

 

http://wikisend.com/download/432964/design.txt

 

Please Accept the answer if satisfied as I am only compensated when you Accept the answer. Thanks!

Alex and other Programming Specialists are ready to help you