QUESTION 1 Before you can use a new RDBMS, you must complete two tasks; create t
ID: 3879919 • Letter: Q
Question
QUESTION 1
Before you can use a new RDBMS, you must complete two tasks; create the database structure and create the tables.
True
False
2 points
QUESTION 2
Match the following terms with the appropriate commands.
PK
VARCHAR
CHAR
Number
Numeric data
Primary Key
Fixed-length character data
Variable-length character data
2 points
QUESTION 3
The GROUP BY clause can be used in place of a JOIN clause in a SQL query?
True
False
2 points
QUESTION 4
The WHERE clause applies to columns and expressions for individual rows.
True
False
2 points
QUESTION 5
The following query is written correctly?
Select Code, Name, Cost
From Inventory
Group By Code
Having (SUM(60 * 60) > 500)
Order By (SUM(60 * 60) > 500) ASC;
Hint: This will aggregate the results.
True
False
2 points
QUESTION 6
Authentication is the process the DBMS uses to verify registered users accessing the database.
True
False
2 points
QUESTION 7
The _____ constrain ensures that a column does NOT accept NULLS.
NOT NULL
NULL
ZERO
None of the above
2 points
QUESTION 8
The _____ constraint is used to validate data when an attribute value is entered.
LOOK
CHECK
LOCATE
FIND
2 points
QUESTION 9
Is this query correct?
Select Name
From Customers
Where LastName = 'Jones'
True
False
2 points
QUESTION 10
A foreign key attribute in one table must have values that match the _____ in another table.
Secondary Key
Primary Key
Main Key
None of the above
- A. B. C. D.PK
- A. B. C. D.VARCHAR
- A. B. C. D.CHAR
- A. B. C. D.Number
A.Numeric data
B.Primary Key
C.Fixed-length character data
D.Variable-length character data
Explanation / Answer
Answer 1: True
explanation: To use RDBMS we need to create structure and then create tables and then we can use it.
Anser 2:
PK -Primary Key
VARCHAR - Variable-length character data
CHAR- Fixed-length character data
Number - Numeric data
Answer 3: True
explanation: yes we can use group by clause in join queries.
Answer 4: false
explanation: because WHERE clause is used for column or expression for an individual row.
Answer 6: true
explanation: yes authentication is used for the registered user in DBMS.
Answer 7: NOT NULL
explanation: Not null is the constraint to ensure column does not accept null values.
Answer 8: Check
explanation: The Check constraint is used to validate data when an attribute value is entered.
Answer 9: True
explanation: yes the query is correct but it may be wrong if the table doesn't have a column name as NAME.
Answer 10: Primary Key
yes, A foreign key attribute in one table must have values that match the primary key in another table.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.