A subquery can only return one row of data unless you use this keyword. UNION IN
ID: 3607404 • Letter: A
Question
A subquery can only return one row of data unless you use this keyword.
UNION
IN
NATURAL JOIN
SELECT
Which of the following is true of columns?
They must be of a static size
They must be created as NOT NULL
They must be referenced
They must be named
A primary key is defined by which attributes?
Unique and constrained
Constrained and named
Unique and not null
Unique and named
QUESTION 52
When normalising from second to third normal form, we would typically have:
none of the above
more data stored
less data stored
more relations
less relations
Which of the following is a good motivation to use a document database?
All the relationship types in the ERD are recursive
There is a large volume of data, and therefore it needs to be distributed
There is only one entity type, and no relationship types
Many attributes are long text descriptions, and several attributes are optional
When considering a DBMS for a company that performs thousands of money transactions per month, which of the following is most important?
ACID
24x7 support
SQL-92
The DBMS server
UNION
IN
NATURAL JOIN
SELECT
Which of the following is true of columns?
They must be of a static size
They must be created as NOT NULL
They must be referenced
They must be named
A primary key is defined by which attributes?
Unique and constrained
Constrained and named
Unique and not null
Unique and named
QUESTION 52
When normalising from second to third normal form, we would typically have:
none of the above
more data stored
less data stored
more relations
less relations
Which of the following is a good motivation to use a document database?
All the relationship types in the ERD are recursive
There is a large volume of data, and therefore it needs to be distributed
There is only one entity type, and no relationship types
Many attributes are long text descriptions, and several attributes are optional
When considering a DBMS for a company that performs thousands of money transactions per month, which of the following is most important?
ACID
24x7 support
SQL-92
The DBMS server
Explanation / Answer
1 Answer) IN
2 Answer) They must be named
3 Answer) Unique and not null
4 Answer) more relations
5 Answer) There is a large volume of data, and therefore it needs to be distributed
6 Answer) ACID
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.