JDBC and SQL Syntax Quiz PDF: Questions and Answers - 111

MCQ 551: Fetching data from the large objects is very much like fetching data

1. From a file
2. From multiple files
3. From storage medias
4. From output streams

MCQ 552: The rows have a number of columns such as the name of the catalog, schema and

1. Table
2. Column
3. Type of column
4. All of the above

MCQ 553: Incremental view maintenance is needed to efficiently update

1. Materialized views
2. Rational views
3. Relational views
4. Query views

MCQ 554: The left outer join preserves tuples only in the relation named before

1. Right outer join operation
2. Right inner join operation
3. Left inner join operation
4. Left outer join operation

MCQ 555: American National Standards Institute (ANSI) and the International Organization for Standardization (ISO) published an SQL standard, named SQL-86, in

1. 1984
2. 1985
3. 1986
4. 1987