Which of the following values cannot be stored in a character column defined as the primary key of a table?
Which of the following values cannot be stored in a character column defined as the primary key of a table? A. null B. ‘0’ C. ‘null’ D. “
Which of the following values cannot be stored in a character column defined as the primary key of a table? A. null B. ‘0’ C. ‘null’ D. “
Which of the following statements about external tables is true? A. They can have constraints or triggers. B. They cannot be written to with DML commands. C. They can have indexes. D. They cannot be used in joins, views, and…
Which of the following can be used to populate a table? Each correct answer represents a complete solution. (Choose all that apply.) A. Data Pump B. SQL*Loader C. INSERT statement D. MERGE statement
You are a Database Administrator of MySQL database. Few days back, your server crashed. Now, it is up and online. You need to check the integrity of various tables used in the database. You need to issue the CHECK TABLE…
Which of the following are the main approaches in the database design? Each correct answer represents a complete solution. (Choose three.) A. Top-down approach B. Bottom-up approach C. Middle approach D. Inside-out approach
Your Company is designing and developing a number of databases for a stock exchange. One of the databases will contain highly sensitive data for which high level of security will be required. Although high processing speed is one of the…
Which of the following database terms is described in the statement below? It prevents the current database operation from reading or writing a data item while the data item is being accessed by another operation. A. Lock B. Encryption C.…
You manage a database named Customers, which includes a table named Orders. The Orders table is frequently queried, but only orders with a sales total of more than $1000.00 are required in the query. You want to create an index…
John works as a Database Administrator for DataOneWorld Inc. The company has a SQL Server database. John wants to insert records in a table where the database is structured in a fixed format. Which of the following data models will…
Consider the case of a fruit juice company. The company manufactures fruit juices and supplies them to wholesalers. The Database Designer creates a table named Production. The code is given below: Which of the above-mentioned lines has an error? A.…