0

programming languages Online Quiz - 341

Description: programming languages Online Quiz - 341
Number of Questions: 20
Created by:
Tags: programming languages
Attempted 0/20 Correct 0 Score 0
  1. to use the Windows user logon when connection to the TestKing1 database.

  2. to use the SQL Server used login when connection to the TestKing1 database.

  3. to use the same application logon ID and password for every connection to the TestKing1 database.

  4. to use the guest login ID and password for every connection to the TestKing1 database.


Correct Option: C
  1. Modify the machine configuration file on your client computers.

  2. Modify the application configuration file for Customers.

  3. Modify the Publisher Policy file containing a reference to Customers.

  4. Modify the reference patch for Customers.


Correct Option: C

You use Visual Studio .NET to develop a component named ABCComponent. You plan to develop several client applications that use ABCComponent. You need to deploy ABCComponent with each of these applications. You will create a distribution package to be included with each application. Which type of project should you create?

  1. CAB project.

  2. merge module project.

  3. setup project.

  4. Web setup project.


Correct Option: B
  1. ALTER TABLE students ADD PRIMARY KEY student_id;

  2. ALTER TABLE students ADD CONSTRAINT PRIMARY KEY(student_id);

  3. ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY student_id;

  4. ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY (student_id);

  5. ALTER TABLE Students MODIFY CONSTRAINT stud_id_pk PRIMARY KEY (student_id);


Correct Option: D

Which two statements about views are true? (Choose two)

  1. A view can be created as read only.

  2. A view can be created as a join on two or more tables

  3. A view cannot have a n ORDER BY clause in the SELECT statement.

  4. A view cannot be created with a GROUP BY clause in the SELECT statement.


Correct Option: A,B
  1. TIMESTAMP

  2. INTERVAL MONTH TO DAY

  3. INTERVAL DAY TO SECOND

  4. INTERVAL YEAR TO MONTH

  5. TIMESTAMP WITH DATABASE TIMEZONE


Correct Option: A,C,D
  1. No data found

  2. Internal error

  3. TNS:could not resolve service name"

  4. None of the above


Correct Option: A
  1. Oracle not available (the database is down)

  2. Invalid Username/Password

  3. Snapshot too old (Rollback has been overwritten)

  4. Unique constraint violated


Correct Option: B
  1. PL/SQL Error

  2. No data found

  3. Insufficient privileges

  4. Unique constraint violated. (Invalid data has been rejected)


Correct Option: D

ORA-00001 Means?

  1. PL/SQL Error

  2. No data found

  3. Insufficient privileges

  4. Unique constraint violated. (Invalid data has been rejected)


Correct Option: D

From the following code fragments select the most appropriate way of throwing exceptions ?Assume that variable i is properly defined , in scope and has appropriate value

  1. if ( i > 10) { throws new IndexOutOfBoundsException("Index is out of bound!"); }

  2. if ( i > 10) { throw new IndexOutOfBoundsException("The value of index i=" + " is out of bound!" ); }

  3. if ( i > 10) { throw "Index is out of bound!"; }

  4. None of the ABove


Correct Option: B
  1. Not connected to ORACLE

  2. Table or view does not exist

  3. Internal error (contact support)

  4. None Of The Above


Correct Option: A

ORA-03114 Means?

  1. Not connected to ORACLE

  2. Table or view does not exist

  3. Internal error (contact support)

  4. None Of The Above


Correct Option: A
  1. TNS:name lookup failure"

  2. TNS:could not resolve service name"

  3. TNS:protocol adapter error"

  4. Package error raised with DBMS_SYS_ERROR.RAISE_SYSTEM_ERROR


Correct Option: B
- Hide questions