The following are components of a database except ________ .
Answer: C
Correct answer: reports
A database holds user data, metadata describing its own structure, indexes and other overhead structures, and application metadata. A report is produced from the database by an application; it is output, not a component of the database itself.
Please log in or register to report this question.
Helping people keep track of things is the purpose of a(n) ________ .
Answer: A
Correct answer: database
The purpose of a database is to keep track of things - and the “things” may be of many kinds, with relationships among them. A table holds one kind of thing, an instance is one particular database, and a relationship connects two tables; none of them is the purpose.
Please log in or register to report this question.
A primary key if combined with a foreign key creates
Answer: A
Correct answer: Parent-Child relationship between the tables that connect them.
A foreign key must match a primary key in another table, which makes that table the parent and this one the child. The result is a one-to-many relationship, and it lets the DBMS enforce referential integrity: no child row may refer to a parent that does not exist.
Please log in or register to report this question.
The XML family of standards is very important in database processing today.
Answer: A
Correct answer: True
XML matters in database processing as the standard way of moving structured data between systems that share no common database: web services, business-to-business exchange, configuration and document storage. Most DBMS products now store and query XML directly, and the family of related standards - XPath, XSLT, XML Schema - goes with it.
Please log in or register to report this question.
Long form of DBA is ______________.
Answer: D
Correct answer: Database Administrator
DBA stands for Database Administrator - the person responsible for a database’s structure, security, backup and recovery, performance and users. The role is distinct from that of the developers who write the applications above it.
Please log in or register to report this question.
Which of the following is considered as DBMS ?
Answer: C
Correct answer: All of these
Oracle, FoxPro and Access are all database management systems - enterprise, legacy PC and desktop respectively. They differ in scale and capability, not in kind.
Please log in or register to report this question.
Which of the following is an advantage of view?
Answer: D
Correct answer: All of the above
A view gives all three. Security: users can be granted access to the view and not to the underlying table, so they see only certain rows or columns. Derived columns: a view can compute values that are not stored. Simplicity: a complex join can be defined once and then queried as though it were a single table.
Please log in or register to report this question.
In a database, data is stored in spreadsheets which have rows and columns.
Answer: B
Correct answer: False
Data is stored in tables (relations), which have rows and columns. A spreadsheet also has rows and columns, but that resemblance is superficial: a table has a defined structure, typed columns, keys, and relationships to other tables, and is managed by a DBMS that enforces all of it.
Please log in or register to report this question.
It is better to use files than a DBMS when there are
Answer: B
Correct answer: Stringent real-time requirements
A DBMS adds layers - query processing, locking, logging - and with them latency that is hard to bound. Where an application must guarantee a response within a few microseconds, direct file access is more predictable. The other two options are arguments for a DBMS, not against: concurrent access and complex relationships are exactly what it exists to manage.
Please log in or register to report this question.
Which of the following products implemented the CODASYL DBTG model?
Answer: A
Correct answer: IDMS
IDMS implemented the CODASYL DBTG network model, the dominant pre-relational approach, in which records are linked by explicit sets and navigated pointer by pointer. It is still in use on mainframes. DB2 is relational; dBase-II and R:base were PC products.
Please log in or register to report this question.
