0
Alien head

programming languages Online Quiz - 47

Description: programming languages Online Quiz - 47
Number of Questions: 20
Created by:
Tags: programming languages
Attempted 0/20 Correct 0 Score 0

Which of the following is not allowed while creating a table using CRRATE TABLE in SQL?

  1. Table name can be an oracle reserved word

  2. Table names must begin with a letter

  3. Table names can contain in it numbers also

  4. None of the Above


Correct Option: A

Which of the following SQL statement create a sequence SE with starting value as 30 and in increments of 20?

  1. GENERATE SEQUENCE SE START WITH 30 ADD BY 20;

  2. CREATE SEQUENCE SE START WITH 30 ADD BY 20;

  3. CREATE SEQUENCE SE START WITH 30 INCREMENT BY 20;

  4. GENERATE SEQUENCE SE INITIATE WITH 30 INCREMENT BY 20;


Correct Option: C

Consider an emp table having columns empno, empname, salary Which of the following queries sort emp table by empname and then by salary in descending order

  1. select empno, empname, salary from emp order by empname, salary desc;

  2. select empno from emp sort by empname, sal in desc;

  3. select empno, empname, salary from emp sort in empname, salary desc;

  4. select # from emp sort by empname and salary in desc;


Correct Option: A

Which of the following commands denote DML commands

  1. INSERT

  2. CREATE

  3. ALTER

  4. Both A. and B.


Correct Option: A

The tables can be combined together in SQL using the concept of

  1. Normalization

  2. Indexing

  3. Sequence

  4. Join


Correct Option: D

The transformation functions used are

  1. CONVERT

  2. TRANSLATE

  3. DECODE

  4. Both B. and C.


Correct Option: D

SQL is a language for

  1. developing system programs

  2. relational database management system

  3. business applications only

  4. both A. and B.


Correct Option: B

The SQL command used to comment multiple lines is

  1. /* */


  2. rem

  3. None of the Above


Correct Option: A

SQL support which of the following data model

  1. Hierarchical Database Model

  2. Relational Database Model

  3. Network Database Model

  4. File Management Model


Correct Option: B

Casting from reference type to value or vice versa is called as

  1. Casting of variables

  2. Boxing/Unboxing

  3. Structure & Class conversion

  4. Stack & Heap Conversion


Correct Option: B

Every .NET compliant compiler generates IL:

  1. True

  2. False


Correct Option: B

A DataSet can hold any number of tables

  1. True

  2. False


Correct Option: B

OPTION exists in VB.NET

  1. True

  2. False


Correct Option: B

Web.Config file is of the type

  1. .vb

  2. XML

  3. Resource

  4. Aspx


Correct Option: B

Select the keyword used to compare the object variable?

  1. And

  2. OR

  3. IS

  4. OF


Correct Option: C

How does VB.NET instantiates the .NET object

  1. Using NEW keyword

  2. Using CREATEOBJECT keyword

  3. Using GETOBJECT keyword

  4. Both A & B


Correct Option: A

What is the output of the following code in Test class Class Myclass Dim Num as Integer Private Sub New (i as integer) Num=i End sub End class Class Test Sub Main() Dim c as Myclass C=New Myclass (10) End sub End Class

  1. Num variable of Myclass is initialized to 10

  2. Run Time Error

  3. Compiler Error

  4. StackOverflow Exception


Correct Option: C

You can create Command Line applications using VB.Net

  1. True

  2. False


Correct Option: B

A ‘Queue’ Collection provides ‘first-in-first-out’ functionality:

  1. True

  2. False


Correct Option: B

Assembly manifest contains

  1. Assembly’s Identity

  2. Assembly’s Reference List

  3. Both A & B

  4. None of the above


Correct Option: C
+ View questions