Flashcards
SIT772 - Practice Exam questions
Cards in this deck (97)
- 1Given a table the Primary Key is used to determine a(n)... within the table. a) attribute b) tuple c) column d) natural identifierc) column
- 2Which statement best describes the difference between data and information? a) No difference b) Data are processed facts and information are raw facts c) Data are human readable and information is not d) Data are raw facts and information is the result of processing raw data.d) Data are raw facts and information is the result of processing raw data.
- 3Suppose we have two data sets {A, B, C} ; {B, C, D}. Which set the intersection can describe? a) {A, B, C, D} b) {B, C} c) {D} d) all of the aboveb) {B, C}
- 4Given a table, the primary key can include... number of attributes within the table. a) One and only one b) One or Two Only c) Unlimited d) All abovec) Unlimited
- 5A Foreign Key is... a) An attribute that relates to the Primary Key in another table b) An attribute that is underlined c) An attribute that depends on another attribute d) An attribute that uniquely identifies each row in a table.a) An attribute that relates to the Primary Key in another table
- 6A logically connected set of one or more fields that describe a person, place or thing is a(n): a) data b) a record c) a file d) a databaseb) a record
- 7If an attribute or a combination of attributes determines all other attributes, the attribute or the combination is called a... a) Key b) composite key c) superkey d) Candidate Keya) Key
- 8A relation is not in 2NF if: a) It has multiple Candidate Keys b) There exist some attributes that partially depend on the primary key c) There are repeating groups in the table d) Either B or Cd) Either B or C
- 9In an ER diagram, an Entity Set is indicated by.. a) Oval Shape b) Rectangle Shape c) Diamond Shape d) Any aboveb) Rectangle Shape
- 10Each table must have a ___ key. a) Primary b) Secondary c) Foreign d) Logicala) Primary
- 11What is the main difference between Boolean and Vector Models in IR? a) Vector Model always generates better results than Boolean b) Vector model can achieve partial match while Boolean cannot c) Vector model is more efficient than Boolean Model d) All aboveb) Vector model can achieve partial match while Boolean cannot
- 12Which SQL statement is used to DELETE a row from a TABLE? a) DELETE Table_name WHERE; b) DELETE FROM Table_name WHERE; c) DELETE TABLE Table_name WHERE; d) DELETE FROM TABLE Table_name WHERE;b) DELETE FROM Table_name WHERE;
- 13What tasks the ALTER command used for? a) To add a new column b) To modify a column data type c) To remove a column d) All aboved) All above
- 14Suppose one table STUDENT (ID, NAME, AGE). Which SQL statement is used to the age for a student in the table? a) ALTER TABLE STUDENT MODIFY age=20 WHERE id=1; b) ALTER TABLE STUDENT ADD age=20 where id=1; c) UPDATE STUDENT SET age=20 WHERE id=1; d) UPDATE TABLE STUDENT MODIFY age=20 WHERE id=1;c) UPDATE STUDENT SET age=20 WHERE id=1;
- 15What is the difference between Secondary Key, Primary Key and Foreign Key?..
- 16What are relational database, table and records?..
- 17What is Connectivity and Cardinality?...
- 18Describe 1NF, 2NF, 3NF...
- 19How do you indicate a PK in an ERD?...
- 20Why do we want to use a RDBMS?..
- 21How do we calculate Recall and Precision?...
- 22IR What is inverted index? Merged Inverted List Index Within Document Term Frequency Dictionary File and Related Posting File..
- 23IR Why we need evaluation metrics..
- 24IR How to calculate IDF and Cosine Similarity..
- 25IR How to calculate TF..
- 26Use Zipf's Law to estimate the growth of vocabprovide steps
- 27Which statement best describes the difference between data and information? a) Data are human readable and information is not. b) Data are raw facts and information is the result of processing raw data. c) There is no difference. d) Data are processed facts and information are raw facts.b) Data are raw facts and information is the result of processing raw data.
- 28A computer file is a resource for _____ data. a) storing b) displaying c) manipulating d) all of the abovea) storing
- 29A computer application can _____ a computer file. a) only store data into b) only retrieve data from c) store data in and retrieve data from d) all of the abovec) store data in and retrieve data from
- 30A PRIMARY KEY should be defined as _____ a) NULL b) NOT NULL c) Either of the above d) None of the aboveb) NOT NULL
- 31A FOREIGN KEY is ____ a) an attribute that is underlined b) an attribute that uniquely identifies each row in a table c) an attribute that depends on another attribute d) an attribute that relates to the primary key in another tabled) an attribute that relates to the primary key in another table
- 32Relationship PARTICIPATION _______ a) can be 1:1, 1:M or M:N b) may be unary, binary or ternary c) is either optional or mandatory d) may be recursivec) is either optional or mandatory
- 33In a relational database, all data are ____ via relations. a) normalised. b) stored. c) accessed. d) stored and accessed.d) stored and accessed.
- 34Association among several entities is called a(an) _____. a) Extraction. b) Relationship. c) Combination. d) Association.b) Relationship.
- 35Considering BINARY RELATIONSHIPS, possible CARDINALITY ratios are_____ . a) 1:1 b) 1:N c) M:N d) all of aboved) all of above
- 36Which forms simplifies and ensures that there is minimal data aggregates and repetitive groups: a) 1NF b) 2NF c) 3NFc) 3NF
- 37In the ____ normal form, a composite attribute is converted to individual attributes. a) First b) Second c) Thirda) First
- 38A table on the many side of a one to many or many to many relationship must: a) Be in second normal form (2NF) b) Be in third normal form (3NF) c) Have a single attribute key d) Have a composite keyd) Have a composite key
- 39Tables in second normal form (2NF): a) Eliminate all hidden dependencies b) Eliminate the possibility of a insertion anomalies c) Have a composite key d) Have all non-key fields depend on the whole primary keya) Eliminate all hidden dependencies
- 40Which keyword is used to provide a condition on a query? a) WHERE b) WHEN c) FROM d) All the abovea) WHERE
- 41Which is the correct file extension for a file which stores SQL commands? a) .sequel b) .txt c) .sql d) .datc) .sql
- 42In SQL, what’s the correct symbol which signifies the end of a statement? a) : b) ; c) END d) }b) ;
- 43In a WHERE statement, which symbol is used to check for equivalence? a) = b) == c) equal d) ?a) =
- 44To execute an SQL*Plus command, you type a) Execute b) RUN c) \ d) None of the aboveb) RUN
- 45To see the whole command stored in the buffer, you use the following a) SEE b) BUFFER c) LIST d) SHOWc) LIST
- 46What is the SQL command you use to add a row into the database? a) ADD b) CREATE c) VALUES d) INSERTd) INSERT
- 47When can the NULL entry be accepted during adding a new row into a database? a) Only if the corresponding attribute is defined as NOT NULL b) Only if the corresponding attribute is optional c) Only if the corresponding attribute is a required attribute d) Only if you do not yet know the value of the attributesb) Only if the corresponding attribute is optional
- 48The result of a SQL SELECT statement is a ____ . a) report b) form c) table d) filec) table
- 49When retrieving data using a SELECT statement, you can use logical operators in the ____ clause. a) FROM b) VALUES c) WHERE d) All of the abovec) WHERE
- 50Which of the following is correct? a) SQL indexes can be created on the basis of any selected attribute b) SQL indexes can be created on the basis of any unique attribute c) SQL indexes can be created on the basis of any NULL attribute d) SQL indexes can be created on the basis of any numeric attributea) SQL indexes can be created on the basis of any selected attribute
- 51Changes made to table contents are not physically saved on disk until the following occurs: a) Database is closed b) Program is closed c) COMMIT command is used d) Any of the aboved) Any of the above
- 52What best describes the RENAME command? a) The RENAME command is not a valid command b) The RENAME command is used to rename a database c) The RENAME command is used to rename an SQL file d) The RENAME command is used to change the name of the database object, such as tables and viewsd) The RENAME command is used to change the name of the database object, such as tables and views
- 53To modify a database column, we need to use a what command? a) ALTER b) MODIFY c) CHANGE d) You can not modify a database column once it is createda) ALTER
- 54Which is not a valid SQL command? a) DROP b) WHERE c) ALTER d) SPECIFYd) SPECIFY
- 55What is a substitution variable used for in SQL? a) Substitution variables are used to store columns b) Substitution variables are used to store rows c) Substitution variables are used to store elements of command text d) Substitution variables are used to store tablesc) Substitution variables are used to store elements of command text
- 56Which is the correct statement? a) The JOIN operation selects all records that match either left or right table records b) The JOIN operation selects records that have matching values in both tables c) The JOIN operation selects records from the first table with matching right table records d) The JOIN operation selects records from the the second table with matching left table recordsb) The JOIN operation selects records that have matching values in both tables
- 57Which is the correct statement? a) The EXCEPT (MINUS) statement in SQL combines rows from two queries and returns only the rows that appear in the second set but not in the first. b) The EXCEPT (MINUS) statement in SQL combines rows from two queries and returns only the rows that appear in both queries. c) The EXCEPT (MINUS) statement in SQL combines rows from two queries and returns only the rows that appear in the first set but not in the second. d) The EXCEPT (MINUS) statement in SQL combines rows from two queries and returns only the columns that appear in the first set but not in the secondc) The EXCEPT (MINUS) statement in SQL combines rows from two queries and returns only the rows that appear in the first set but not in the second.
- 58The “property of closure” for relational algebra operators means a) The use of relational algebra operators on existing relations produces new relations. b) The use of relational algebra operators on existing relations produces closed relations. c) The use of relational algebra operators on existing relations produces existing relations. d) The use of relational algebra operators on existing relations produces old relationsa) The use of relational algebra operators on existing relations produces new relations.
- 59The SQL keyword BETWEEN is used: a) to limit the columns displayed b) for ranges c) to match any value within a value list d) None of the aboveb) for ranges
- 60Which one of the following sorts rows in SQL? a) SORT BY b) ALIGN BY c) ORDER BY d) GROUP BYc) ORDER BY
- 61To remove duplicate rows from the results of an SQL SELECT statement, the ____ qualifier specified must be included. a) ONLY b) UNIQUE c) SINGLE d) DISTINCTd) DISTINCT
- 62Stemming in information retrieval is the process of reducing _______ words to their word stem, base or root form a) original b) inflected c) translated d) changedb) inflected
- 63Stop words are usually filtered out from search queries because they return vast amount of ____ information. a) unnecessary b) necessary c) important d) neutrala) unnecessary
- 64The use of an inverted list index greatly improves search efficiency but the penalty paid for this efficiency is the need to a) store a data structure that is larger than the size of the text itself. b) update that index as the data set changes. c) have a list of stopwords that are not searchable. d) All the above.d) All the above.
- 65An Information Retrieval system has the following capabilities to deal with information: a) Storage b) Retrieval c) Maintenance d) All of the aboved) All of the above
- 66An Information Retrieval system such as Google a) stores unstructured data into a database for retrieval. b) organises information into the same format for retrieval. c) finds useful information from unstructured data. d) transforms unstructured data into structured data.c) finds useful information from unstructured data.
- 67Indexing in an IR system is to a) index a database and store the indexation into an index file. b) profile the unstructured data and then store the profile into a repository. c) find keywords from unstructured data and store these keywords into an index file. d) standardise the unstructured data and store selected index terms into a repository.b) profile the unstructured data and then store the profile into a repository.
- 68An inverted index follows the direction of a) from words->to->documents. b) from documents->to->words. c) from index->to->words. d) from words->to->pages.a) from words->to->documents.
- 69Which of the following is NOT true for Boolean search? a) Using AND narrows a search by combining terms. b) Using OR broadens a search to include results that contain either of the words you’re looking for c) Using NOT will narrow a search by exclusion d) None of the aboved) None of the above
- 70Zipf’s Law states that given a large sample of words used, the frequency of any word is ____ proportional to its rank in the frequency table. a) inversely b) frequently c) definitely d) probablya) inversely
- 71A Venn diagram shows all possible ____ relations between a finite collection of different sets. a) real b) mutual c) logical d) physicalc) logical
- 72A Venn diagram with three circles can be used to represent the following situations: a) all b) none c) at least one d) All of the aboved) All of the above
- 73The Boolean model of information retrieval uses the following Boolean operators: a) ‘AND’, ‘OR’, ‘XOR’ b) ‘AND’, ‘OR’, ‘NOT’ c) ‘AND’, ‘OR’ d) ‘AND’, ‘NOT’b) ‘AND’, ‘OR’, ‘NOT’
- 74Which of the following statement is NOT true? a) The Boolean model is a simple retrieval model based on set theory and Boolean algebra. b) The Boolean model retrieves documents if and only if they satisfy a Boolean expression. c) The documents returned from a Boolean model retrieval are in a particular order. d) In the Boolean retrieval model we can pose any query in the form of a Boolean expression of terms.c) The documents returned from a Boolean model retrieval are in a particular order.
- 75Which one of the following are normally used for additional criteria for ranking in search engines? a) Popularity – what are the current topics of the day? b) Click-through results – statistics about which pages users click-on after getting ranked results can inform ranking algorithms to improve later rankings. c) Context – keep track of the user’s interests, location, situation d) All of the aboved) All of the above
- 76Which one of the following is NOT true for the Vector model? a) Query and Document similarity is based on the length of their vectors. b) Query and Document similarity is based on length and direction of their vectors. c) A vector distance measure between the query and documents is used to rank retrieved documents. d) Vector model implementation needs within-document frequencies in the inverted list.a) Query and Document similarity is based on the length of their vectors.
- 77Which one of the following is true for the Vector model? a) A vector has direction and weight. b) Most vectors are sparse. c) Terms of the vector space are full words, not stems. d) TF-IDF weights terms highly if they are frequent in relevant documents and in the collection as a whole.b) Most vectors are sparse.
- 78‘Noise’ in Information Retrieval is due to ___. a) Precision. b) Recall. c) Redundant information. d) Relevant information.c) Redundant information.
- 79Which one of the following is NOT true for Precision and Recall? a) TN is True Negatives, the number of irrelevant documents returned. b) TP is True Positives, the number of relevant documents correctly returned. c) FP is False Positives, the number of irrelevant documents returned. d) FN is False Negatives, the number of relevant documents incorrectly rejected.a) TN is True Negatives, the number of irrelevant documents returned.
- 80Which one of the following are normally used for additional criteria for ranking in search engines? a) Popularity – what are the current topics of the day? b) Click-through results – statistics about which pages users click-on after getting ranked results can inform ranking algorithms to improve later rankings. c) Context – keep track of the user’s interests, location, situation. d) All of the aboved) All of the above
- 81Cosine similarity gives a useful measure of how similar two documents are likely to be in terms of their _____ matter. a) size b) language c) format d) subject.d) subject.
- 82Find the Cosine similarity between documents d1 = (5, 0, 3, 0, 2, 0, 0, 2, 0, 0) and d2 = (3, 0, 2, 0, 1, 1, 0, 1, 0, 1) a) cos(d1, d2 ) = 0.9 b) cos(d1, d2 ) = 0.72 c) cos(d1, d2 ) = 0.96 d) cos(d1, d2 ) = 0.94.d) cos(d1, d2 ) = 0.94
- 83The Tf-idf weight is a statistical measure used to evaluate how _____ a word is to a document in a collection or corpus. a) important b) long c) simple d) expensivea) important
- 84Consider a document containing 100 words wherein the word cat appears 3 times, also assume we have 10 million documents and the word cat appears in 1000 of these. What is the Tf-idf weight of cat is a) 39 b) 42 c) 30 d) 36a) 39
- 85Which one of the following sentences is NOT true? a) Cosine similarity sorts documents, so the IR can response with ranking. b) TF-IDF is a good way to weight documents. c) TF-IDF can be successfully used for stop-words filtering in various subject fields. d) Cosine similarity is particularly used in real number space, where the outcome is neatly bounded in [-1,1].c) TF-IDF can be successfully used for stop-words filtering in various subject fields.
- 86Which one of the following sentences is NOT true? a) The vector representation of documents loses word order. b) The vector representation of documents contains mostly zeros. c) The larger the angle, the larger the cosine. And the higher the similarity. d) Cosine Similarity is a way to measure overlap of documents.c) The larger the angle, the larger the cosine. And the higher the similarity.
- 87Evolution module will use _____ judgment to measure the effectiveness of the ranked list. a) relevance b) correctness c) meaningful d) efficiencya) relevance
- 88We use recall to measure the proportion that all relevant documents have been ____ . a) re-called b) measured c) retrieved d) searchedc) retrieved
- 89We use precision to measure the proportions that all documents retrieved are ____ documents. a) correct b) relevant c) ranked d) systemb) relevant
- 90In numerical analysis, interpolation is a method of constructing new data points within the range of a discrete set of ___ data points. a) famous b) known c) selected d) keyb) known
- 91The E evaluation measure is to allow the user to specify a) whether the user is more interested in efficiency. b) whether the user is more interested in evaluation. c) whether the user is more interested in effectiveness. d) whether the user is more interested in recall or in precision.d) whether the user is more interested in recall or in precision.
- 92The harmonic mean of 1, 2, and 4 is a) 12/5 b) 11/5 c) 12/7 d) 11/7c) 12/7
- 93Which one of the following statements is NOT correct? a) NoSQL databases are document-oriented. b) NoSQL database fits better for the hierarchical data storage. c) NoSQL databases have predefined schema for unstructured data. d) NoSQL databases are not good fit for complex queries.c) NoSQL databases have predefined schema for unstructured data.
- 94Which one of the following statements is NOT correct? a) The DDBMS is the software that realises the mechanisms and policies for manipulating distributed data. b) Global conceptual schema supports the enterprise view of the data and describes the logical structure of the data at all the sites. c) A DDBS provides transparent management of distributed and replicated data. d)A DDBS can be simply defined as a collection of data storages distributed over a computer network.d)A DDBS can be simply defined as a collection of data storages distributed over a computer network.
- 95Which one of the following statements is NOT correct? a) Documents in a document database cannot be nested. b) Document databases pair each key with a document. c) Documents in a document database have self-describing, hierarchical tree data structures. d) Document databases are generally useful for content management systems.a) Documents in a document database cannot be nested.
- 96Graph databases allow you to a) store photos in databases. b) store entities and relationships between these entities. c) store images and relationships between images in databases. d) store graphs and relationships between graphs in databases.b) store entities and relationships between these entities.
- 97Which one of the following is not a correct operation in MongoDB? a) find: selects documents in a collection b) insert: inserts one or more documents c) revise: revise one or more documents d) delete: deletes one or more documentsc) revise: revise one or more documents
Information
- Description
- SIT772 Flashcards on SIT772 - Practice Exam questions, created by Amber Saxon on 07/02/2020.
- Created by
- Amber Saxon
- Views
- 4
- Rating