Q121
Open questionIn SQL, the _____ command is used to recompile a view
Select an option to see the answer and solution.
Computer Science · all questionsDatabase Systems
Database Systems
practice.
Practice every MCQ with options. Use Show answers when you want the correct option and solution.
148
Questions
7/8
Page
Pick an option on a question to see the right answer and solution.
Q122
Open questionA list in alphabetical order
Select an option to see the answer and solution.
Q123
Open questionIf a piece of data is stored in two places in the database, then
Select an option to see the answer and solution.
Q124
Open questionA data dictionary is a special file that contains
Select an option to see the answer and solution.
Q125
Open questionA file that is organized in uniform format is formally referred to as a _____ or a database file.
Select an option to see the answer and solution.
Q126
Open questionA form can be used to
Select an option to see the answer and solution.
Q127
Open questionWhich language has recently become the de-facto standard for interfacing application programs with relational database system?
Select an option to see the answer and solution.
Q128
Open questionIn SQL, the CREATE TABLE is used
Select an option to see the answer and solution.
Q129
Open questionWhich of the following is not true of the traditional approach to information processing?
Select an option to see the answer and solution.
Q130
Open questionBatch processing is appropriate if
Select an option to see the answer and solution.
Q131
Open questionWhat is the abbreviation used for a software package that permits the users to create, retrieve and maintain records in a database?
Select an option to see the answer and solution.
Q132
Open questionWhich of the following is not an advantage of the data-base approach?
Select an option to see the answer and solution.
Q133
Open questionA data dictionary doesn't provide information about:
Select an option to see the answer and solution.
Q134
Open questionData encryption techniques are particularly useful for
Select an option to see the answer and solution.
Q135
Open questionIt is more accurate to define a _____ as a variety of different record types that are treated as a single unit
Select an option to see the answer and solution.
Q136
Open questionA logical schema
Select an option to see the answer and solution.
Q137
Open questionQueries to a database
Select an option to see the answer and solution.
Q138
Open questionIn order to use a record management system
Select an option to see the answer and solution.
Q139
Open questionIn SQL, which command is used to select only one copy of each set of duplicable rows
Select an option to see the answer and solution.
Q140
Open questionThe physical location of a record is determined by a mathematical formula that transforms a file key into a record location in
Select an option to see the answer and solution.