DATABASE MANAGEMENT SYSTEM (DBMS) - Computer Science Online Tests

DBMS: Basics

Question 1: If every non-key attribute is functionally dependent on the primary key, then the relation will be in ...

51 Comments. 940 views since Aug 18, 2008

DBMS: Basics Test 2

Question 1: Which of the following is not the characteristics of a relational database model ? ...

5 Comments. 332 views since Aug 18, 2008

Database Management system

Question 1: What is a DATABLOCK? ...

6 Comments. 245 views since Sep 16, 2008

DBMS: Basic Test 3

Question 1: A translator which reads an entire programme written in high level language and converts it into machine language code is: ...

1 Comments. 182 views since Aug 30, 2008

Oracle Database: Test 1

Question 1: You intend to use only password authentication and have used the password file utility to create a password file as follows: $orapwd file=$ORACLE_HOME/dbs/orapwDB01 password=orapass entries=5 The REMOTE_LOGIN_PASSWORDFILE initialization parameter is set to NONE. You created a user and granted only the SYSDBA privilege to that user as follows: CREATE USER dba_user IDENTIFIED BY dba_pass; GRANT sysdba TO dba_user; The user attempts to connect to the database as follows: connect dba_user/dba_pass as sysdba; Why does the connection fail ? ...

0 Comments. 64 views since Oct 31, 2008

Oracle Skills Practice Test : Beginner

Question 1: Which data dictionary view(s) do you need to query to find the following information about a user? • Whether the user’s account has expired • The user’s default table space name • The user’s profile name ...

2 Comments. 59 views since Sep 30, 2008

Microsoft SQL Server

Question 1: Which of the following programming languages can the DTS data transformation GUI use to direclty transform data? ...

0 Comments. 39 views since Sep 11, 2008

MS Access

Question 1: In which toolbar we will find the short command ...

0 Comments. 21 views since Aug 30, 2008